db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Wooldridge <brett.wooldri...@gmail.com>
Subject Derby 10.5.1.1 regression
Date Thu, 30 Jul 2009 07:15:04 GMT
I have obtained a server-side trace of the failure.  I included a statement
preceding the failure because it might be relevant.  There is an 'insert'
into the table upon which the subsequent 'select' fails.  Both occur on the
same connection, but are separated by an XA commit managed by Bitronix JTA.
The 'insert' and subsequent 'select' occur on two separate client threads --
sequentially.  The 'insert' succeeds, signals another thread via event
mechanism, which subsequently issues the 'select' -- coincidentally (but
typically due to low system activity) on the same connection obtained from a
connection pool.

       (2009.7.30 5:47:28) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: PRPSQLSTT           (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0058D05100010052  200D00442113A989  .X.Q...R ..D!...
..}...........zi
0010   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0030   4040E2E8E2D3D5F0  F0F0404040404040  @@........@@@@@@    SYSLN000

0040   404040405359534C  564C303100030005  @@@@SYSLVL01....
...<.<......
0050   2116F10005214604  0097D04300010091  !....!F....C....
..1......p}....j
0060   2414000000008769  6E7365727420696E  $......insert in
......g.>......>
0070   746F20746F6F6C5F  64657461696C7320  to tool_details
.?..??%..../.%..
0080   2864657461696C73  2C20646576696365  (details, device
..../.%.........
0090   5F69642C20656E64  5F74696D652C2065  _id, end_time, e
......>...._....
00A0   72726F722C206578  65637574696F6E5F  rror, execution_
..?..........?>.
00B0   69642C2067726964  5F646174612C2073  id, grid_data, s
.........././...
00C0   746172745F74696D  652C206964292076  tart_time, id) v
./....._........
00D0   616C75657320283F  2C203F2C203F2C20  alues (?, ?, ?,
/%..............
00E0   3F2C203F2C203F2C  203F2C203F29FF00  ?, ?, ?, ?, ?)..
................
00F0   53D0010002004D20  0800442113A98997  S.....M ..D!....
.}....(......zip
0100   A389854040404040  40404040404040D5  ...@@@@@@@@@@@@.  tie
N
0110   E4D3D3C9C4404040  4040404040404040  .....@@@@@@@@@@@  ULLID

0120   40E2E8E2D3D5F0F0  F040404040404040  @........@@@@@@@   SYSLN000

0130   4040405359534C56  4C30310003000521  @@@SYSLVL01....!
...<.<.......
0140   4605                                F.                ..



       (2009.7.30 5:47:28) Reply flush DRDAConnThread_7 5

       SEND BUFFER: SQLDARD                (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   005CD04300010056  2411000000000020  .\.C...V$......
.*}.............
0010   2020202043535331  3030353000000000      CSS10050....
................
0020   0000000000000000  0000000000000000  ................
................
0030   0000000000202020  2020202020202020  .....
................
0040   000000000000FF00  0002000000000000  ................
................
0050   0000000000000000  000000000234D003  .............4..
..............}.
0060   0002022E24110000  0000002020202020  ....$......
................
0070   4353533130303530  0000000000000000  CSS10050........
................
0080   0000000000000000  0000000000000000  ................
................
0090   0020202020202020  2020202000000000  .           ....
................
00A0   0000FF0000020000  0000000000000000  ................
................
00B0   0000000000000008  001F000000000000  ................
................
00C0   7FFFFFFF019904B8  0000000000000000  ................
"....r..........
00D0   00000000000000FF  0000000000000000  ................
................
00E0   0100000000000000  0000000000000000  ................
................
00F0   000000000A000000  0000000000000401  ................
................
0100   F100000000000000  0000000000000000  ................
1...............
0110   0000FF0000000000  0000000100000000  ................
................
0120   0000000000000000  000000000000001A  ................
................
0130   0006000000000000  001A018900000000  ................
...........i....
0140   0000000000000000  0000000000FF0000  ................
................
0150   0000000000000100  0000000000000000  ................
................
0160   0000000000000000  00001F0000000000  ................
................
0170   0000007FA001C104  B800000000000000  ................
..."..A.........
0180   0000000000000000  FF00000000000000  ................
................
0190   0001000000000000  0000000000000000  ................
................
01A0   00000000000A0000  0000000000000004  ................
................
01B0   01F1000000000000  0000000000000000  ................
.1..............
01C0   000000FF00000000  0000000001000000  ................
................
01D0   0000000000000000  0000000000000000  ................
................
01E0   1F0000000000007F  FFFFFF019904B800  ................
......."....r...
01F0   0000000000000000  000000000000FF00  ................
................
0200   0000000000000001  0000000000000000  ................
................
0210   0000000000000000  0000001A00060000  ................
................
0220   00000000001A0189  0000000000000000  ................
.......i........
0230   0000000000000000  00FF000000000000  ................
................
0240   0000010000000000  0000000000000000  ................
................
0250   0000000000000A00  0000000000000000  ................
................
0260   0401F10000000000  0000000000000000  ................
..1.............
0270   00000000FF000000  0000000000010000  ................
................
0280   0000000000000000  0000000000000000  ................
................


       (2009.7.30 5:47:28) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: EXCSQLSTT           (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0053D0510001004D  200B00442113A989  .S.Q...M ..D!...
..}....(......zi
0010   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0030   4040E2E8E2D3D5F0  F0F0404040404040  @@........@@@@@@    SYSLN000

0040   404040405359534C  564C303100030005  @@@@SYSLVL01....
...<.<......
0050   2105F10080D05300  01007A2412002500  !.....S...z$..%.
..1..}....:.....
0060   101B76D0CD800203  000425001A3F7FFF  ..v.......%..?..
...}..........".
0070   030004CD80022500  1A0300040671E4D0  ......%......q..
..............U}
0080   00010051147A0000  0000000000000500  ...Q.z..........
.....:..........
0090   323030392D30372D  33302D30352E3437  2009-07-30-05.47
................
00A0   2E32382E33343330  3030FF0000000009  .28.343000......
................
00B0   0000C50032303039  2D30372D33302D30  ....2009-07-30-0
..E.............
00C0   352E34372E32352E  3433373030300000  5.47.25.437000..
................
00D0   00000F0195D00300  01018F146C000022  ............l.."
....n}......%...
00E0   005500500022002C  0022005500500022  .U.P.".,.".U.P."
...&.........&..
00F0   002C002200450074  006800650072006E  .,.".E.t.h.e.r.n
...............>
0100   0065007400300022  002C002200310030  .e.t.0.".,.".1.0
................
0110   002E0030002E0030  002E003200300031  ...0...0...2.0.1
................
0120   0022002C00220030  0030003600300037  .".,.".0.0.6.0.7
................
0130   0030003100350036  0034003100330022  .0.1.5.6.4.1.3."
................
0140   002C002200310030  0030003000300030  .,.".1.0.0.0.0.0
................
0150   003000300022002C  0022003100300022  .0.0.".,.".1.0."
................
0160   000A002200550050  0022002C00220055  ...".U.P.".,.".U
.......&........
0170   00500022002C0022  004E0075006C006C  .P.".,.".N.u.l.l
.&.......+...%.%
0180   00300022002C0022  0022002C00220022  .0.".,.".".,."."
................
0190   002C002200340032  0039003400390036  .,.".4.2.9.4.9.6
................
01A0   0037003200390035  0022002C00220031  .7.2.9.5.".,.".1
................
01B0   0030003000300030  0022000A00220044  .0.0.0.0."...".D
................
01C0   004F0057004E0022  002C00220044004F  .O.W.N.".,.".D.O
.|...+.........|
01D0   0057004E0022002C  0022005300650072  .W.N.".,.".S.e.r
...+............
01E0   00690061006C0031  0022002C00220022  .i.a.l.1.".,."."
.../.%..........
01F0   002C00220022002C  0022003100350034  .,.".".,.".1.5.4
................
0200   0034003000300030  0022002C00220032  .4.0.0.0.".,.".2
................
0210   0022000A00220055  00500022002C0022  ."...".U.P.".,."
.........&......
0220   0044004F0057004E  0022002C00220053  .D.O.W.N.".,.".S
...|...+........
0230   0065007200690061  006C00300022002C  .e.r.i.a.l.0.".,
......./.%......
0240   00220022002C0022  0022002C00220031  .".".,.".".,.".1
................
0250   0035003400340030  003000300022002C  .5.4.4.0.0.0.".,
................
0260   002200320022000A                    .".2."..          ........



       (2009.7.30 5:47:28) Reply flush DRDAConnThread_7 5

       SEND BUFFER: SQLCARD                (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0047D00300010041  2408000000000020  .G.....A$......
..}.............
0010   2020202043535331  3030353000000000      CSS10050....
................
0020   0000000000000000  0100000000000000  ................
................
0030   0000000000202020  2020202020202020  .....
................
0040   000000000000FF                      .......           .......



       (2009.7.30 5:47:28) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: SYNCCTL             (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   004DD00100010047  1055000511870B00  .M.....G.U......
.(}..........g..
0010   36180142746E7800  000013000000136E  6..Btnx........n
.....>.........>
0020   65746C642D310000  0122CA32E2D70000  etld-1...".2....
..%.........SP..
0030   00B46E65746C642D  3100000122CA32E3  ..netld-1...".2.
..>..%.........T
0040   06000000C1000819  0304000000        .............     ....A........



       (2009.7.30 5:47:28) Reply flush DRDAConnThread_7 5

       SEND BUFFER:                        (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0012D0020001000C  1248000819040000  .........H......
..}.............
0010   0000                                ..                ..



       (2009.7.30 5:47:28) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: SYNCCTL             (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   004DD00100010047  1055000511870300  .M.....G.U......
.(}..........g..
0010   36180142746E7800  000013000000136E  6..Btnx........n
.....>.........>
0020   65746C642D310000  0122CA32E2D70000  etld-1...".2....
..%.........SP..
0030   00B46E65746C642D  3100000122CA32E3  ..netld-1...".2.
..>..%.........T
0040   06000000C1000819  0340000000        .........@...     ....A.... ...



       (2009.7.30 5:47:28) Reply flush DRDAConnThread_7 5

       SEND BUFFER:                        (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0012D0020001000C  1248000819040000  .........H......
..}.............
0010   0000                                ..                ..



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: PRPSQLSTT           (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0058D05100010052  200D00442113A989  .X.Q...R ..D!...
..}...........zi
0010   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0030   4040E2E8E2D3C8F0  F0F0404040404040  @@........@@@@@@    SYSLH000

0040   404040405359534C  564C303100010005  @@@@SYSLVL01....
...<.<......
0050   2116F10005214604  001AD05300010014  !....!F....S....
..1.......}.....
0060   2450000000000A57  49544820484F4C44  $P.....WITH HOLD
.&...........|<.
0070   20FF0018D0430001  0012241400000000   ....C....$.....
....}...........
0080   0856414C55455320  31FF0053D0010002  .VALUES 1..S....
...<........}...
0090   004D200800442113  A98997A389854040  .M ..D!.......@@  .(......ziptie

00A0   4040404040404040  4040D5E4D3D3C9C4  @@@@@@@@@@......
NULLID
00B0   4040404040404040  40404040E2E8E2D3  @@@@@@@@@@@@....
SYSL
00C0   C8F0F0F040404040  4040404040405359  ....@@@@@@@@@@SY  H000
..
00D0   534C564C30310001  0005214605        SLVL01....!F.     .<.<.........



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER: SQLDARD                (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0099D04300010093  2411000000000020  ...C....$......
.r}....l........
0010   2020202043535331  3030353000000000      CSS10050....
................
0020   0000000000000000  0000000000000000  ................
................
0030   0000000000202020  2020202020202020  .....
................
0040   000000000000FF00  0001000000000000  ................
................
0050   0000000000000000  00000001000A0000  ................
................
0060   0000000000000004  01F0000000000000  ................
.........0......
0070   0131000000000000  00000000FF000000  .1..............
................
0080   0000000000000000  0000000000000000  ................
................
0090   0000000000013100  00005CD003000200  ......1...\.....
..........*}....
00A0   5624110000000000  2020202020435353  V$......     CSS
................
00B0   3130303530000000  0000000000000000  10050...........
................
00C0   0000000000000000  0000000000002020  ..............
................
00D0   2020202020202020  20000000000000FF           .......
................
00E0   0000010000000000  0000000000000000  ................
................
00F0   0000000000                          .....             .....



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: OPNQRY              (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   005BD00100010055  200C00442113A989  .[.....U ..D!...
.$}...........zi
0010   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0030   4040E2E8E2D3C8F0  F0F0404040404040  @@........@@@@@@    SYSLH000

0040   404040405359534C  564C303100010008  @@@@SYSLVL01....
...<.<......
0050   211400007FFF0005  215D01            !.......!].       ...."....).



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER: OPNQRYRM               (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   002CD05200010026  2205000611490000  .,.R...&"....I..
..}.............
0010   0006210224170005  211FF1000C215B00  ..!.$...!....![.
..........1...$.
0020   0000000000001A00  05215001001FD053  .........!P....S
..........&...}.
0030   00010019241A0676  D00200040971E054  ....$..v.....q.T
........}.....\.
0040   0001D000010671F0  E00000004ED00300  ......q.....N...
..}....0\...+}..
0050   010048241BFF0000  0000010000000064  ..H$...........d
................
0060   3032303030435353  3130303530000000  02000CSS10050...
................
0070   0000000000010000  0000000000000000  ................
................
0080   0000000000002020  2020202020202020  ......
................
0090   20000000000000FF  FF                 ........         .........



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: SYNCCTL             (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   001FD00100010019  1055000511870300  .........U......
..}..........g..
0010   081801FFFFFFFF00  08190310000000    ...............   ...............



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER:                        (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0012D0020001000C  1248000819040000  .........H......
..}.............
0010   0000                                ..                ..



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: SYNCCTL             (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   001FD00100010019  1055000511870300  .........U......
..}..........g..
0010   081801FFFFFFFF00  08190310000000    ...............   ...............



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER:                        (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0012D0020001000C  1248000819040000  .........H......
..}.............
0010   0000                                ..                ..



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: SYNCCTL             (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   004DD00100010047  1055000511870900  .M.....G.U......
.(}..........g..
0010   36180142746E7800  000013000000136E  6..Btnx........n
.....>.........>
0020   65746C642D310000  0122CA32E71D0000  etld-1...".2....
..%.........X...
0030   00D96E65746C642D  3100000122CA32E7  ..netld-1...".2.
.R>..%.........X
0040   1D000000E1000819  0300000000        .............     .............



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER:                        (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0012D0020001000C  1248000819040000  .........H......
..}.............
0010   0000                                ..                ..



       (2009.7.30 5:47:29) Request fill DRDAConnThread_7 5

       RECEIVE BUFFER: PRPSQLSTT           (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0058D05100010052  200D00442113A989  .X.Q...R ..D!...
..}...........zi
0010   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0030   4040E2E8E2D3D5F0  F0F0404040404040  @@........@@@@@@    SYSLN000

0040   404040405359534C  564C303100030005  @@@@SYSLVL01....
...<.<......
0050   2116F10005214604  00E8D043000100E2  !....!F....C....
..1......Y}....S
0060   241400000000D873  656C656374207468  $......select th
......Q..%......
0070   69735F2E69642061  732079305F2C2074  is_.id as y0_, t
......./..`.....
0080   6869735F2E657865  637574696F6E5F69  his_.execution_i
............?>..
0090   642061732079315F  2C20746869735F2E  d as y1_, this_.
../..`..........
00A0   6465766963655F69  642061732079325F  device_id as y2_
........../..`..
00B0   2C20746869735F2E  6572726F72206173  , this_.error as
...........?../.
00C0   2079335F2C207468  69735F2E67726964   y3_, this_.grid
.`..............
00D0   5F64617461206173  2079345F2C207468  _data as y4_, th
../././..`......
00E0   69735F2E73746172  745F74696D652061  is_.start_time a
....../....._../
00F0   732079355F2C2074  6869735F2E656E64  s y5_, this_.end
..`...........>.
0100   5F74696D65206173  2079365F2066726F  _time as y6_ fro
..._../..`.....?
0110   6D20746F6F6C5F64  657461696C732074  m tool_details t
_..??%..../.%...
0120   6869735F20776865  726520746869735F  his_ where this_
................
0130   2E65786563757469  6F6E5F69643D3FFF  .execution_id=?.
........?>......
0140   0053D0010002004D  200800442113A989  .S.....M ..D!...
..}....(......zi
0150   97A3898540404040  4040404040404040  ....@@@@@@@@@@@@  ptie

0160   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID

0170   4040E2E8E2D3D5F0  F0F0404040404040  @@........@@@@@@    SYSLN000

0180   404040405359534C  564C303100030005  @@@@SYSLVL01....
...<.<......
0190   214605                              !F.               ...



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER: SQLERRRM               (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0010D0520001000A  2213000611490008  ...R...."....I..
..}.............
0010   00CFD053000100C9  240800FFFFFFFF58  ...S....$......X
..}....I........
0020   434C333043535331  3030353000000000  CL30CSS10050....
.<..............
0030   0000000000000000  0000000000000000  ................
................
0040   0000000000202020  2020202020202020  .....
................
0050   000000886A617661  2E73716C2E537472  ....java.sql.Str
...h|/./...%....
0060   696E671458434C33  302E53141414584A  ing.XCL30.S...XJ
.>....<.........
0070   3030313A6A617661  2E696F2E454F4645  001:java.io.EOFE
....|/./..?..|..
0080   7863657074696F6E  1453747265616D20  xception.Stream
......?>...../_.
0090   68617320616C7265  616479206265656E  has already been
./../%../.`....>
00A0   207265616420616E  6420656E642D6F66   read and end-of
.../../>...>..?.
00B0   2D66696C65207265  616368656420616E  -file reached an
...%..../...../>
00C0   642063616E6E6F74  2062652072652D75  d cannot be re-u
.../>>?.........
00D0   7365642E14584A30  30312E550000FF00  sed..XJ001.U....
................
00E0   16D0020001001012  5000061149000800  ........P...I...
.}......&.......
00F0   06000C2414                          ...$.             .....



       (2009.7.30 5:47:29) Reply flush DRDAConnThread_7 5

       SEND BUFFER: AGNPRMRM               (ASCII)           (EBCDIC)
       0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF
0123456789ABCDEF
0000   0010D0020001000A  1232000611490040  .........2...I.@  ..}............

Mime
View raw message