You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "hai feng li (JIRA)" <ji...@apache.org> on 2007/01/08 10:16:27 UTC
[jira] Created: (DERBY-2219) 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
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: liming01@gmail.com. Thank you!
======================= JDBC LOG ===============================
[derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
[derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
[derby][SQLException@7dad7dad] java.sql.SQLException
[derby][SQLException@7dad7dad] SQL state = 58009
[derby][SQLException@7dad7dad] Error code = -4499
[derby][SQLException@7dad7dad] 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
[derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
[derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] 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
[jira] Commented: (DERBY-2219) 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
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463296 ]
Bryan Pendleton commented on DERBY-2219:
----------------------------------------
There may be some differences between Cloudscape and Derby, but I think that for
the most part they are quite compatible. Hopefully you can set up a test environment
where you can try using Derby 10.2 in place of Cloudscape 10.1.
Alternatively, can you package up a reproducible test case and attach it to the issue?
Then, others could try your case with different versions of Derby to see where the
problem reproduces.
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] 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
[jira] Commented: (DERBY-2219) 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
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463320 ]
Bryan Pendleton commented on DERBY-2219:
----------------------------------------
Also, can you attach the entire derby.log (cloudscape.log?) file from your server? Maybe there
is something earlier in the log which provides some clues.
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] 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
[jira] Commented: (DERBY-2219) 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
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463096 ]
Bryan Pendleton commented on DERBY-2219:
----------------------------------------
1) Can you try your application with Derby 10.2 to see if the problem is fixed there?
2) On the client side, you can try to get more information by calling getNextException
on your SQLException to see if there is a nested exception
3) What sort of information is present in the derby.log file on the server when this happens?
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] 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
[jira] Commented: (DERBY-2219) 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
Posted by "Ming Li (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463201 ]
Ming Li commented on DERBY-2219:
--------------------------------
Hi Bryan,
Thank you for your help. As for your suggestion, I add comments below:
1) I use Cloudscape, whose newest version is 10.1 now. I do not know whether is there some differences between derby jdbc and cloudscape jdbc. but from the jdbc log, it seems that the log is generated from derby.
2) Because our client code is using C++, which call jni to call java. So it seems it's not an easy way to change client code to get next exception.
3) I look into the server log, only find one error msg during execution:
Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 0; Error Code Value = 3
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAProtocolException.<init>(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.exchangeServerAttributes(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.sessionInitialState(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
null
org.apache.derby.impl.drda.DRDAProtocolException
at org.apache.derby.impl.drda.DRDAProtocolException.<init>(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Source)
at org.apache.derby.impl.drda.DDMReader.readDssHeader(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.exchangeServerAttributes(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.sessionInitialState(Unknown Source)
at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] 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
[jira] Updated: (DERBY-2219) 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
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-2219:
--------------------------------------
Priority: Major (was: Critical)
lowering priority because of lack of input.
> 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
>
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] close () called
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2219) 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
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-2219.
-----------------------------------
Resolution: Cannot Reproduce
Closing this CannotReproduce, since we haven't gotten input for some time. It can be reopened if we get a reproduction.
> 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
>
> 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: liming01@gmail.com. Thank you!
> ======================= JDBC LOG ===============================
> [derby][Time:1168278886300][Thread:main][Connection@5b975b97] prepareStatement (INSERT INTO "USR"."TBIC00T6" ( "C5", "C1", "C2", "C3", "C4") VALUES ( ? , ? , ? , ? , ? ), 1003, 1007) called
> [derby][Time:1168278886300][Thread:Finalizer thread][PreparedStatement@7e147e14] 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
> [derby][SQLException@7dad7dad] java.sql.SQLException
> [derby][SQLException@7dad7dad] SQL state = 58009
> [derby][SQLException@7dad7dad] Error code = -4499
> [derby][SQLException@7dad7dad] 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
> [derby][SQLException@7dad7dad] 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:main][ResultSet@78f578f5] close () called
> [derby][Time:1168278892287][Thread:main][PreparedStatement@78ac78ac] close () called
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.