db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [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
Date Mon, 17 Nov 2008 20:54:44 GMT

     [ 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.


Mime
View raw message