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