[
https://issues.apache.org/jira/browse/DERBY-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12559226#action_12559226
]
Kathey Marsden commented on DERBY-3230:
---------------------------------------
Thank you Bryan for the help. I see that the reason my repro does not trigger
the problem is because the server proactively ends the DSS in this code because
it would not be able to fit another 15K row. If I comment out
// if ((stmt.getBlksize() - endLength ) < rowsize)
// getMoreData = false;
I can trigger the problem. I will work to adjust my rowsizes so I don't trigger
this condition.
// if we don't have enough room for a row of the
// last row's size, don't try to cram it in.
// It would get split up but it is not very efficient.
if (getMoreData == true)
{
int endLength = writer.getDSSLength();
int rowsize = endLength - startLength;
if ((stmt.getBlksize() - endLength ) < rowsize)
getMoreData = false;
> 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.
