db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: How to disable detailed logging/buffer dumps?
Date Wed, 10 Mar 2021 15:30:01 GMT
These look like network trace messages. Has someone set the following 
system property:

   derby.drda.traceAll=true

See the section on drda properties in the Admin Guide: 
https://db.apache.org/derby/docs/10.15/adminguide/tadminconfigsettingnetwrokserverproperties.html

On 3/9/21 10:50 PM, Vamsavardhana Reddy wrote:
> Hi,
>
> Off late we started seeing detailed logging/buffer dumps like the below in
> the derby logs.  Any idea how to disable this level of logging or how this
> logging could have got enabled?
>
> ---------
> [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06]
> createStatement () called
> [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06]
> createStatement () returned Statement@f4937dd3
> [derby][Time:1614982562801][Thread:pool-10-thread-1][Statement@f4937dd3]
> executeQuery (select 1 from sysibm.sysdummy1) called
> [derby][Time:1614982562801][Thread:pool-10-thread-1][Connection@100f5a06]
> isClosed () returned false
> [derby]
> [net][time:1614982562801][thread:pool-10-thread-1][tracepoint:1][Request.flush]
> [derby]        SEND BUFFER: PRPSQLSTT              (ASCII)
> (EBCDIC)
> [derby]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
>   0123456789ABCDEF
> [derby] 0000   0079D05100010073  200D00652113002D  .y.Q...s ..e!..-
>   .`}.............
> [derby] 0010   2F7573722F69726F  6E686964652F7661  /usr/ironhide/va
>   .......?>....../
> [derby] 0020   722F64622F6F7263  6D6F6E2F64657262  r/db/orcmon/derb
>   .....?.._?>.....
> [derby] 0030   793B637265617465  3D7472756500124E  y;create=true..N
>   `..../.........+
> [derby] 0040   554C4C4944202020  2020202020202020  ULLID
> .<<.............
> [derby] 0050   2000125359534C48  3030302020202020   ..SYSLH000
> ......<.........
> [derby] 0060   2020202020535953  4C564C3031000B00       SYSLVL01...
>   ........<.<.....
> [derby] 0070   052116F100052146  04                .!....!F.
> ...1.....
> [derby]
> [derby]        SEND BUFFER:                        (ASCII)
> (EBCDIC)
> [derby] 0000   001AD05300010014  2450000000000A57  ...S....$P.....W
>   ..}......&......
> [derby] 0010   49544820484F4C44  20FF002ED0430001  ITH HOLD ....C..
>   .....|<.....}...
> [derby] 0020   0028241400000000  1E73656C65637420  .($......select
> ...........%....
> [derby] 0030   312066726F6D2073  797369626D2E7379  1 from sysibm.sy
>   ....?_..`..._..`
> [derby] 0040   7364756D6D7931FF  007CD00100020076  sdummy1..|.....v
>   ...__`...@}.....
> [derby] 0050   200C00652113002D  2F7573722F69726F   ..e!..-/usr/iro
>   ...............?
> [derby] 0060   6E686964652F7661  722F64622F6F7263  nhide/var/db/orc
>   >....../.....?..
> [derby] 0070   6D6F6E2F64657262  793B637265617465  mon/derby;create
>   _?>.....`..../..
> [derby] 0080   3D7472756500124E  554C4C4944202020  =true..NULLID
> .......+.<<.....
> [derby] 0090   2020202020202020  2000125359534C48           ..SYSLH
>   ..............<.
> [derby] 00A0   3030302020202020  2020202020535953  000          SYS
>   ................
> [derby] 00B0   4C564C3031000B00  08211400007FFF00  LVL01....!......
>   <.<.........."..
> [derby] 00C0   05215D01                            .!].              ..).
>
> [derby]
> [derby]
> [net][time:1614982562801][thread:pool-10-thread-1][tracepoint:2][Reply.fill]
> [derby]        RECEIVE BUFFER: SQLDARD             (ASCII)
> (EBCDIC)
> [derby]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
>   0123456789ABCDEF
> [derby] 0000   0099D04300010093  2411000000000020  ...C....$......
> .r}....l........
> [derby] 0010   2020202043535331  3030383100000000      CSS10081....
>   ................
> [derby] 0020   0000000000000000  0000000000000000  ................
>   ................
> [derby] 0030   0000000000202020  2020202020202020  .....
> ................
> [derby] 0040   000000000000FF00  0001000000000000  ................
>   ................
> [derby] 0050   0000000000000000  00000001000A0000  ................
>   ................
> [derby] 0060   0000000000000004  01F0000000000000  ................
>   .........0......
> [derby] 0070   0131000000000000  00000000FF000000  .1..............
>   ................
> [derby] 0080   0000000000000000  0000000000000000  ................
>   ................
> [derby] 0090   0000000000013100  00                ......1..
> .........
> [derby]
> [derby]        RECEIVE BUFFER: OPNQRYRM            (ASCII)
> (EBCDIC)
> [derby] 0000   002CD05200020026  2205000611490000  .,.R...&"....I..
>   ..}.............
> [derby] 0010   0006210224170005  211FF1000C215B00  ..!.$...!....![.
>   ..........1...$.
> [derby] 0020   000000000000E600  05215001          .........!P.
>   ......W...&.
> [derby]
> [derby]        RECEIVE BUFFER: QRYDSC              (ASCII)
> (EBCDIC)
> [derby] 0000   001FD05300020019  241A0676D0020004  ...S....$..v....
>   ..}.........}...
> [derby] 0010   0971E0540001D000  010671F0E00000    .q.T......q....
> ..\...}....0\..
> [derby]
> [derby]        RECEIVE BUFFER: QRYDTA              (ASCII)
> (EBCDIC)
> [derby] 0000   004ED00300020048  241BFF0000000001  .N.....H$.......
>   .+}.............
> [derby] 0010   0000000064303230  3030435353313030  ....d02000CSS100
>   ................
> [derby] 0020   3831000000000000  0000010000000000  81..............
>   ................
> [derby] 0030   0000000000000000  0000002020202020  ...........
> ................
> [derby] 0040   2020202020200000  00000000FFFF            ........
>   ..............
> [derby]
> [derby][ResultSetMetaData@1abd872d] BEGIN TRACE_RESULT_SET_META_DATA
> [derby][ResultSetMetaData@1abd872d] Result set meta data for statement
> Statement@f4937dd3
> [derby][ResultSetMetaData@1abd872d] Number of result set columns: 1
> [derby][ResultSetMetaData@1abd872d] Column 1: { label=1, name=1, type
> name=INTEGER, type=4, nullable=0, precision=10, scale=0, schema name=,
> table name=, writable=false, sqlPrecision=10, sqlScale=0, sqlLength=4,
> sqlType=496, sqlCcsid=0, sqlName=1, sqlLabel=null, sqlUnnamed=0,
> sqlComment=null, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0,
> sqlxCorname=null, sqlxName=1, sqlxBasename=null, sqlxUpdatable=0,
> sqlxSchema=null, sqlxRdbnam=, internal type=4,  }
> [derby][ResultSetMetaData@1abd872d] { sqldHold=1, sqldReturn=0,
> sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=,
> sqldSchema=null }
> [derby][ResultSetMetaData@1abd872d] END TRACE_RESULT_SET_META_DATA
> [derby][Time:1614982562801][Thread:pool-10-thread-1][Statement@f4937dd3]
> executeQuery () returned ResultSet@2908d4ea
> [derby][Time:1614982562801][Thread:pool-10-thread-1][ResultSet@2908d4ea]
> close () called
> ----
>
> Thanks,
>


Mime
View raw message