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