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,
