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 "Bryan Pendleton (JIRA)" <de...@db.apache.org> on 2005/10/14 01:44:05 UTC
[jira] Commented: (DERBY-614) Execution failed because of a Distributed Protocol Error
[ http://issues.apache.org/jira/browse/DERBY-614?page=comments#action_12332046 ]
Bryan Pendleton commented on DERBY-614:
---------------------------------------
I believe I have lucked into a reproducible test case! Below are two queries. The first query does *NOT* exhibit the problem, but the second query *DOES* exhibit the problem. The only difference in the two queries, I believe, is that the first query does not have a WHERE clause, but the second query does.
So apparently it is something about the particular style in which I am including the WHERE clause which is triggering this problem?
Query that works:
select tf.*,i.name as item_name,tc.case_name, p.name as project_name from apt_test_failure tf join apt_test_case tc on tf.test_id = tc.id join apt_history h on tf.history_id = h.id join apt_item_desc i on h.item_id = i.id join apt_projects p on h.project_id = p.id order by tf.id desc
Query that causes missingCodePoint(QRYBLKSZ):
select tf.*,i.name as item_name,tc.case_name, p.name as project_name from apt_test_failure tf join apt_test_case tc on tf.test_id = tc.id join apt_history h on tf.history_id = h.id join apt_item_desc i on h.item_id = i.id join apt_projects p on h.project_id = p.id where ( p.name = ?) order by tf.id desc
> Execution failed because of a Distributed Protocol Error
> --------------------------------------------------------
>
> Key: DERBY-614
> URL: http://issues.apache.org/jira/browse/DERBY-614
> Project: Derby
> Type: Bug
> Components: Network Server
> Versions: 10.1.1.0
> Environment: Linux 2.4, Sun JDK 1.4.2_07, full SYSINFO will be attached.
> Reporter: Bryan Pendleton
> Attachments: clientStack.txt, query.txt, sysinfo.derby
>
> I am intermittently receiving Distributed Protocol Error exceptions in my client code. Simultaneously,
> my derby.log is recording Distributed Protocol Error exceptions on the server side.
> I cannot reliably reproduce this problem.
> However, the problem always occurs in the same section of my application, so I can at least
> describe that section of my application. (I'll do so in an attachment).
> Here is the error I receive on the server side. Sometimes, the CODPNT is 2116 and the
> Error Code Value is 1d, rather than 2114 and e.
> 2005-10-05 02:10:23.663 GMT Thread[DRDAConnThread_2,5,main] (DATABASE = BuildFar
> m), (DRDAID = GA0A0026.P7E6-4182154075488704215{136532}), Execution failed becau
> se of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM; CODPNT arg = 2114; Er
> ror Code Value = e
> Execution failed because of a Distributed Protocol Error: DRDA_Proto_SYNTAXRM;
> CODPNT arg = 2114; Error Code Value = e
> 2005-10-05 02:10:23.663 GMT Thread[DRDAConnThread_2,5,main] (DATABASE = BuildFar
> m), (DRDAID = GA0A0026.P7E6-4182154075488704215{136532}), null
> null
> org.apache.derby.impl.drda.DRDAProtocolException
> at org.apache.derby.impl.drda.DRDAConnThread.throwSyntaxrm(Unknown Sourc
> e)
> at org.apache.derby.impl.drda.DRDAConnThread.missingCodePoint(Unknown So
> urce)
> at org.apache.derby.impl.drda.DRDAConnThread.parseCNTQRY(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.splitQRYDTA(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Sou
> rce)
> at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira