db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vamsavardhana Reddy <c1vams...@gmail.com>
Subject How to disable detailed logging/buffer dumps?
Date Wed, 10 Mar 2021 06:50:58 GMT
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