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 "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2007/07/02 19:38:04 UTC
[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
[ 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.