db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (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, 15 Jan 2008 18:27:34 GMT

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

Bryan Pendleton commented on DERBY-3230:
----------------------------------------

Hi Kathey, I think that you are proceeding along the right course; developing a
standalone repro seems like the right plan. I agree that it should be very data
dependent.  Unfortunately, I am temporarily without a computer as my main
computer has died, so I'm kind of handicapped until I get another computer set up.

Can you (using a debugger) examine how the server behaves with your repro?
In particular, I thought it was particularly fascinating that with the original repro
we had a call to splitQRYDTA made from doneData, because I had never seen
that case happen before while stepping through the server code. With your
repro, can you tell whether there is a splitQRYDTA call made from doneData?


> 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, TestBoundaries.java
>
>
> 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