db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Huber (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3230) Selecting data from a Table raises Error XN008: Query processing has been terminated due to an error on the server
Date Tue, 27 Nov 2007 15:46:43 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12545878
] 

Stefan Huber commented on DERBY-3230:
-------------------------------------

Sorry, but I forgot to mention that there is no error reported in the server log file. 
I tried it with the "derby.drda.debug" property set to "true" and i got pretty much output
in derby.log. But no errors or exceptions were reported.
I also tried to use the debug libraries to get more information on the error, but there were
still  no error messages. 
All the rows of the table are reported in derby.log. This is one of the reasons why I believe
that it could be a client problem. I used the debugger on the client side and got to the line
in method
        org.apache.derby.client.net.NetCursor.checkAndThrowReceivedEndqryrm
where the exception is thrown. 
At the time when the exception is thrown all data are already transferred to the client side
and it seems like there is just one byte missing for method readFdocaOneByte (which is than
calling checkAndThrowReceivedEndqryrm because position_ == lastValidBytePosition_) but the
server connection is already closed.

I've been working with derby for a long time and i never got such a behavior. I'm curious
about an explanation for this.

> Selecting data from a Table raises Error XN008: Query processing has been terminated
due to an error on the server
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3230
>                 URL: https://issues.apache.org/jira/browse/DERBY-3230
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client, Network Server
>    Affects Versions: 10.3.1.4
>         Environment: Windows XP
>            Reporter: Stefan Huber
>            Priority: Critical
>         Attachments: test.rar
>
>
> I got a table (PCLASS) in my database where I cannot select the data via a simple select
statement:
> - If I execute 'select * from PCLASS': XN008: Query processing has been terminated due
to an error on the server
> - If I execute 'select * from PCLASS order by CLASSNAME': it works
> - If I add or remove only one row to/from the table: it works
> If I use the embedded driver everything works fine. But as soon as I use the derby network
client to access the database, this problem occurs.
> This is very odd. I spent a lot of time to do some research on this behavior because
I could not believe that the network client produces errors depending on the data contained
in a table. But after all it looks like I managed to fill the table with an exact amount of
data that causes this error to arise.
> To reproduce the problem download the attached file and follow these instructions:
> * extract test.rar to $derby.system.home$
> * start derby network server
> * start ji utility and execute the following commands:
> ** connect to database test using client driver:
> 	connect 'jdbc:derby://localhost/test;user=ZOL;password=zol';
> ** select content of table PCLASS
> 	select * from PCLASS;
> --> Error XN008: Query processing has been terminated due to an error on the server

> ** disconnect from database
> 	disconnect;
> ** shutdown database 'test'
> 	connect 'jdbc:derby://localhost/test;user=ZOL;password=zol;shutdown=true';
> ** connect to database 'test' using embedded driver: 
> 	connect 'jdbc:derby:test;user=ZOL;password=zol';
> ** select content of table PCLASS
> 	select * from PCLASS;
> --> everything o.k.

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