Preparedstatement error: Execution failed due to a distribution protocol error
that caused deallocation of the conversation. A PROTOCOL Data Stream Syntax
Error was detected. Reason: 0x3
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-2219
URL: https://issues.apache.org/jira/browse/DERBY-2219
Project: Derby
Issue Type: Test
Components: JDBC
Affects Versions: 10.1.3.1
Environment: AIX 64
Reporter: hai feng li
Priority: Critical
I use cloudscape JDBC to develope an application for some pressure test. When I
call preparedstatement, it through error, but if I reconnect the jdbc
connection, this SQL can be successfully executed. I do not know the reason.
Because the jdbc log is too big, so I copy piece of JDBC log for analyzation.
If you want to get the whole log, please contact me with email: [EMAIL
PROTECTED] Thank you!
======================= JDBC LOG ===============================
[derby][Time:1168278886300][Thread:[EMAIL PROTECTED] prepareStatement (INSERT
INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? ,
? , ? , ? ), 1003, 1007) called
[derby][Time:1168278886300][Thread:Finalizer [EMAIL PROTECTED] finalize ()
called
[derby] [net][time:1168278886300][thread:main][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 006FD05100010069 200D005B21130023 .o.Q...i ..[!..#
.?}........$....
[derby] 0010 84826D93945EA399 818385C68993857E ..m..^.........~
db_lm;traceFile=
[derby] 0020 6188969485618989 8485A5F86183A24B a....a......a..K
/home/iidev8/cs.
[derby] 0030 96A4A30012D5E4D3 D3C9C44040404040 ...........@@@@@
out..NULLID
[derby] 0040 4040404040404000 12E2E8E2D3C8F0F0 @@@@@@@.........
..SYSLH00
[derby] 0050 F040404040404040 4040405359534C56 .@@@@@@@@@@SYSLV 0
...<.
[derby] 0060 4C30310004000521 16F10005214604 L01....!....!F.
<........1.....
[derby]
[derby] SEND BUFFER: (ASCII) (EBCDIC)
[derby] 0000 001AD05300010014 2450000000000A57 ...S....$P.....W
..}......&......
[derby] 0010 49544820484F4C44 20FF007BD0430001 ITH HOLD ..{.C..
.....|<....#}...
[derby] 0020 0075241400000000 6B494E5345525420 .u$.....kINSERT
........,.+.....
[derby] 0030 494E544F20225553 52222E2254424943 INTO "USR"."TBIC
.+.|............
[derby] 0040 3030543622202820 224335222C202022 00T6" ( "C5", "
................
[derby] 0050 4331222C20202243 32222C2020224333 C1", "C2", "C3
................
[derby] 0060 222C202022433422 292056414C554553 ", "C4") VALUES
............<...
[derby] 0070 2028203F2020202C 20203F2020202C20 ( ? , ? ,
................
[derby] 0080 203F2020202C2020 3F2020202C20203F ? , ? , ?
................
[derby] 0090 20202029FF006AD0 0100020064200800 )..j.....d ..
......|}........
[derby] 00A0 5B2113002384826D 93945EA399818385 [!..#..m..^.....
$....db_lm;trace
[derby] 00B0 C68993857E618896 94856189898485A5 ....~a....a.....
File=/home/iidev
[derby] 00C0 F86183A24B96A4A3 0012D5E4D3D3C9C4 .a..K...........
8/cs.out..NULLID
[derby] 00D0 4040404040404040 404040400012E2E8 @@@@@@@@@@@@....
..SY
[derby] 00E0 E2D3C8F0F0F04040 4040404040404040 ......@@@@@@@@@@ SLH000
[derby] 00F0 5359534C564C3031 00040005214605 SYSLVL01....!F.
...<.<.........
[derby]
[derby] [net][time:1168278886300][thread:main][tracepoint:2][Reply.fill]
[derby] RECEIVE BUFFER: (ASCII) (EBCDIC)
[derby] 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF
0123456789ABCDEF
[derby] 0000 0300040500023E00 0705000205000205 ......>.........
................
[derby] 0010 0002050002330015 3E00223E000F3E00 .....3..>.">..>.
................
[derby] 0020 0F3E000F3E00043E 00043E00043E000F .>..>..>..>..>..
................
[derby] 0030 3E000F3E000F0500 020971E0540001D0 >..>......q.T...
...........\...}
[derby] 0040 00010671F0E00000 03BAD003000103B4 ...q............
....0\....}.....
[derby] 0050 241BFF0000000100 0001000001000000 $...............
................
[derby] 0060 0000000000000000 0100000100000100 ................
................
[derby] 0070 0000000000000000 0000000000010000 ................
................
[derby] 0080 E3414C4941532C42 4947494E542C424F .ALIAS,BIGINT,BO
T.<........+...|
[derby] 0090 4F4C45414E2C4341 4C4C2C434C415353 OLEAN,CALL,CLASS
|<..+...<<..<...
[derby] 00A0 2C434F50592C4442 324A5F4445425547 ,COPY,DB2J_DEBUG
..|&............
[derby] 00B0 2C45584543555445 2C4558504C41494E ,EXECUTE,EXPLAIN
...........&<..+
[derby] 00C0 2C46494C452C4649 4C5445522C474554 ,FILE,FILTER,GET
...<....<.......
[derby] 00D0 43555252454E5443 4F4E4E454354494F CURRENTCONNECTIO
.....+..|++....|
[derby] 00E0 4E2C494E4445582C 494E5354414E4345 N,INDEX,INSTANCE
+..+.....+...+..
[derby] 00F0 4F462C4D4554484F 442C4E45572C4F46 OF,METHOD,NEW,OF
|..(...|..+...|.
[derby] 0100 462C50524F504552 544945532C505542 F,PROPERTIES,PUB
..&.|&.......&..
[derby] 0110 4C49434154494F4E 2C5245434F4D5049 LICATION,RECOMPI
<.....|+....|(&.
[derby] 0120 4C452C5245465245 53482C52454E414D LE,REFRESH,RENAM
<............+.(
[derby] 0130 452C52554E54494D 4553544154495354 E,RUNTIMESTATIST
....+..(........
[derby] 0140 4943532C53544154 454D454E542C5354 ICS,STATEMENT,ST
.........(.+....
[derby] 0150 4154495354494353 2C54494D494E472C ATISTICS,TIMING,
...........(.+..
[derby] 0160 5741495400000841 42532C5351525400 WAIT...ABS,SQRT.
................
[derby] 0170 002F4C454E475448 2C4C4F5745522C4C ./LENGTH,LOWER,L
..<.+....<|....<
[derby] 0180 5452494D2C525452 494D2C5355425354 TRIM,RTRIM,SUBST
...(.....(......
[derby] 0190 522C535542535452 494E472C55505045 R,SUBSTRING,UPPE
.........+...&&.
[derby] 01A0 5200005443555252 454E545F55534552 R..TCURRENT_USER
.........+......
[derby] 01B0 2C67657443757272 656E74436F6E6E65 ,getCurrentConne
.........>..?>>.
[derby] 01C0 6374696F6E2C7275 6E54696D65537461 ction,runTimeSta
...?>...>.._.../
[derby] 01D0 746973746963732C 53455353494F4E5F tistics,SESSION_
.............|+.
[derby] 01E0 555345522C555345 522C43555252454E USER,USER,CURREN
...............+
[derby] 01F0 5420534348454D41 0000434355524441 T SCHEMA..CCURDA
......(.........
[derby] 0200 54452C4355525449 4D452C4355525245 TE,CURTIME,CURRE
........(.......
[derby] 0210 4E545F444154452C 43555252454E545F NT_DATE,CURRENT_
+............+..
[derby] 0220 54494D452C435552 52454E545F54494D TIME,CURRENT_TIM
..(.......+....(
[derby] 0230 455354414D502C45 5854524143540000 ESTAMP,EXTRACT..
....(&..........
[derby] 0240 0000000000000100 0001000001000131 ...............1
................
[derby] 0250 0000010000000000 0000000100000100 ................
................
[derby] 0260 0001000001000001 0000000000000000 ................
................
[derby] 0270 0000000000000000 0001000000000001 ................
................
[derby] 0280 000006534348454D 4100000950524F43 ...SCHEMA...PROC
.......(....&.|.
[derby] 0290 4544555245000007 434154414C4F4700 EDURE...CATALOG.
............<|..
[derby] 02A0 0000000000000001 0000010000010000 ................
................
[derby] 02B0 0100000100000000 0000000000000000 ................
................
[derby] 02C0 0000000000010000 0100000100000100 ................
................
[derby] 02D0 0001000001000001 0000000000000000 ................
................
[derby] 02E0 0100000000000000 0000000000000000 ................
................
[derby] 02F0 0000800000000000 0000000000000000 ................
................
[derby] 0300 0000000000000000 0000000000000000 ................
................
[derby] 0310 0000000000800000 0000000000000080 ................
................
[derby] 0320 0000000080000000 0000000000000000 ................
................
[derby] 0330 0001000000000000 0000000000000000 ................
................
[derby] 0340 8000000000000000 00001E0000000002 ................
................
[derby] 0350 0000010007312C32 2C342C3800000100 .....1,2,4,8....
................
[derby] 0360 0000000000000000 000009313030332C ...........1003,
................
[derby] 0370 3130303400223130 30332C313030383B 1004."1003,1008;
................
[derby] 0380 313030342C313030 383B313030352C31 1004,1008;1005,1
................
[derby] 0390 3030372C31303038 0000000000000004 007,1008........
................
[derby] 03A0 3130303300043130 3033000431303033 1003..1003..1003
................
[derby] 03B0 0000000000000000 0100000000643032 .............d02
................
[derby] 03C0 3030304353533130 3031310000000000 000CSS10011.....
................
[derby] 03D0 0000000100000000 0000000000000000 ................
................
[derby] 03E0 0000000020202020 2020202020202000 .... .
................
[derby] 03F0 00000B456E64206F 6620446174610000 ...End of Data..
....>..?..././..
[derby] 0400 FFFF .. ..
[derby]
SQLException: SQLState(58009) vendor code(-4499)
org.apache.derby.client.am.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the conversation. A
PROTOCOL Data Stream Syntax Error was detected. Reason: 0x3
at org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
Source)
at
org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
Source)
at
org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
Source)
at
org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown
Source)
at com.ibm.db2.jdbcwrapper.JavaFunc.prepareStatement(JavaFunc.java:65)
[derby] BEGIN TRACE_DIAGNOSTICS
[EMAIL PROTECTED] java.sql.SQLException
[EMAIL PROTECTED] SQL state = 58009
[EMAIL PROTECTED] Error code = -4499
[EMAIL PROTECTED] Message = Execution failed due to a distribution protocol
error that caused deallocation of the conversation. A PROTOCOL Data Stream
Syntax Error was detected. Reason: 0x3
[EMAIL PROTECTED] Stack trace follows
org.apache.derby.client.am.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the conversation. A
PROTOCOL Data Stream Syntax Error was detected. Reason: 0x3
at org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
Source)
at
org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
Source)
at
org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
Source)
at
org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown
Source)
at com.ibm.db2.jdbcwrapper.JavaFunc.prepareStatement(JavaFunc.java:65)
[derby] END TRACE_DIAGNOSTICS
[derby][Time:1168278892287][Thread:[EMAIL PROTECTED] close () called
[derby][Time:1168278892287][Thread:[EMAIL PROTECTED] close () called
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
