[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12805864#action_12805864 ] Kristian Waagan commented on DERBY-4337: I observe that the stack trace posted for this issue is somewhat similar to DERBY-4455, which has been fixed. Is the reported problem still an issue? Note: To test you would have to build Derby from the 10.5 branch or trunk. If you test in a non-production environment, and understand that the builds are not as well tested as an official release, you can obtain a test build from http://dbtg.thresher.com/derby/bits/ > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, > derbyJdbcLoggingJar.zip, full_trace.log, protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Un
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12751115#action_12751115 ] Kathey Marsden commented on DERBY-4337: --- Hi Brett, I was wondering if you had a chance to try your test case with the derbyJdbcLoggingJar.zip. I am available to look at the logs now if you can provide them. Thanks Kathey > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, > derbyJdbcLoggingJar.zip, full_trace.log, protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInS
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741333#action_12741333 ] Kathey Marsden commented on DERBY-4337: --- Thank you Brett, I will be away from Derby at that time, but am sure someone else will look at your logs. If not, I will check as soon as I get back in early September. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, > derbyJdbcLoggingJar.zip, full_trace.log, protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(U
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741071#action_12741071 ] Brett Wooldridge commented on DERBY-4337: - I'll be happy to test the attached additional logging. Unfortunately, I am traveling on business and won't get back to Tokyo until the 20th. But I will run the scenario with the additional logging as soon as I return. Sorry for the delay. Brett > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, > derbyJdbcLoggingJar.zip, full_trace.log, protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) >
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740556#action_12740556 ] Kathey Marsden commented on DERBY-4337: --- Hi Brett, I asked Rick if we can backport DERBY-4310 in the upcoming mini-release to fix DERBY-4331. I would like your help however in trying to diagnose what changed in 10.4 to cause this bug to start impacting network server. I think there may be another bug here. Would you mind trying your test case on 10.5 (without the DERBY-4310 fix) with the patch https://issues.apache.org/jira/secure/attachment/12415771/derby-1191_factory_hack_no_commit_diff.txt and see if we see the trace for the XJ001 exception or any other information in derby.log? > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740144#action_12740144 ] Kathey Marsden commented on DERBY-4337: --- I am glad the DERBY-4310 fix resolved your issue. Tiago offered to backport and test on 10.5. The community state of the 10.5 branch is a little weird right now, so might wait a bit before checking it in. It still seems like there is a mystery regarding why there is this new exposure to an existing bug between 10.3 and 10.4. It would be good to figure that out. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739893#action_12739893 ] Brett Wooldridge commented on DERBY-4337: - Good news. After upgrading to the trunk (10.6.0.0), I am no longer able to recreate the problem. You can effectively consider this issue resolved as a duplicate of DERBY-4310. Here's my vote for a back-port of DERBY-4310 to 10.5. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.Tr
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739724#action_12739724 ] Kristian Waagan commented on DERBY-4337: Brett wrote (04/Aug/09 08:41 PM above): - The first thread (thread:Idle-3) performs in INSERT into the 'tool_details' table (including two CLOBS) using setCharacterStream(). I don't really understand the output fully, as there is also a logged call for getCharacterStream() -- why this is needed on an insert I am not sure. - This is because Derby creates a Clob object to accommodate the transfer. The Clob takes the user stream as input, and then Derby retrieves the stream from the newly created Clob when moving the data to the server - hence the call to getCharacterStream(). According to the trace, one of the Clobs had a length of zero characters, resulting in no call to getCharacterStream. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRD
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739716#action_12739716 ] Kathey Marsden commented on DERBY-4337: --- As a matter of bookkeeping, if all of the wisconsin diffs are deemed acceptable and other tests and reviews pass, I think we should do the partial backout as a resolution of this issue. Then both DERBY-3926 and DERBY-4331 can be resolved and a new issue opened for any follow up sort avoidance optimizations. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739680#action_12739680 ] Kathey Marsden commented on DERBY-4337: --- Accidentally added this comment to DERBY-4310. It was meant to go here: Thank you Dag for the analysis. I went back and checked DERBY-4310 on 10.3 and 10.4 and found that while the core embedded problem existed in 10.3, I do not see the network server exposure closing sessions on shutdown with the 10.3 branch. This is very interesting and may explain why myrna only sees hangs with her 10.4 runs and not 10.3. Unfortunately, I don't have time today to track down when ReproDerby4310 started showing the exception, but someone might want to do that investigation. I don't understand the reason for original call to handleException which ends up closing the session and popping DERBY-4310. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739630#action_12739630 ] Kathey Marsden commented on DERBY-4337: --- Yes, the DERBY-4310 fix is in the trunk. Thank to Tiago it went in just a few days ago. It will be very helpful I think in general to continue to diagnose this issue on a trunk sane build. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > protocol-events.log, Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unkno
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739608#action_12739608 ] Brett Wooldridge commented on DERBY-4337: - If it's fixed (DERBY-4310) in the head, I'll build the 10.6.0.0 source and test. Also this should get Bryan the line numbers of the failure if it's still occurring. 2am here in Tokyo ... I've give it a shake in about 8 hours. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrap
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739605#action_12739605 ] Kathey Marsden commented on DERBY-4337: --- That looks like DERBY-4310, but may be occurring after the original protocol error during the subsequent cleanup. In the email thread I suggested backporting the DERBY-4310 fix to at least eliminate that from the picture. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLE
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739592#action_12739592 ] Bryan Pendleton commented on DERBY-4337: It seems like the most substantial clue that we have at this point is the exception: Caused by: java.io.EOFException: Stream has already been read and end-of-file reached and cannot be re-used. at org.apache.derby.iapi.types.ReaderToUTF8Stream.read(Unknown Source) at java.io.DataInputStream.read(DataInputStream.java:80) at org.apache.derby.iapi.types.SQLClob.readExternal(Unknown Source) at org.apache.derby.iapi.types.SQLChar.getString(Unknown Source) Can you build the Derby source tree with the debug flags enabled so that this stack trace contains the actual line numbers? > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and canno
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739566#action_12739566 ] Brett Wooldridge commented on DERBY-4337: - The database is fresh. Which is to say, I do not recreate the DB every time I run this test to create the problem, but it was fresh (re-created) after the upgrade to 10.5.1.1. I've also reproduced on Mac OS X (my main machine) and Windows XP (under Parallels), each with an independently created database. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unkn
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739538#action_12739538 ] Bryan Pendleton commented on DERBY-4337: Do you create your database fresh and populate it with data each time you run the test? Or is this an already-existing database that you are using? I know that the CLOB storage format changed at some point, and I'm wondering if you're seeing some sort of upgrade-related problem. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.handleException(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Caused by: java.sql.SQLException: Java exception: 'Stream has already been > read and end-of-file reached and cannot be re-used.: java.io.EOFException'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > at > org
[jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
[ https://issues.apache.org/jira/browse/DERBY-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12739327#action_12739327 ] Brett Wooldridge commented on DERBY-4337: - I notice that in client_trace.log there are two threads that run sequentially. The first thread (thread:Idle-3) performs in INSERT into the 'tool_details' table (including two CLOBS) using setCharacterStream(). I don't really understand the output fully, as there is also a logged call for getCharacterStream() -- why this is needed on an insert I am not sure. The second thread (thread:Jetty-6) comes along subsequently, re-uses the same connection, and starts a new transaction to perform a SELECT of the just inserted row. However, prior to this query, the connection pool executes a "VALUES 1" query to test the connection. So, there is a separate transaction between the "INSERT" and the "SELECT" which involves a "VALUES 1" query. For this reason, I wouldn't think that the first query is somehow messing up the second, but I could be wrong. > DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond) > -- > > Key: DERBY-4337 > URL: https://issues.apache.org/jira/browse/DERBY-4337 > Project: Derby > Issue Type: Bug > Components: Network Client >Affects Versions: 10.4.1.3, 10.4.2.0, 10.5.1.1 > Environment: WIndows XP, Mac OS X, Bitronix JTA 1.3, Hibernate 3.3 >Reporter: Brett Wooldridge > Attachments: client_trace.log, derby.log, derby.log, full_trace.log, > Server2.trace > > > This bug was created after discussions on the developer mailing list, which > can be found here: > http://www.nabble.com/Derby-10.5.1.1-regression-tt24733315.html#a24733315 > In short summary, in an environment involving JTA, Derby, and connection > pooling we are experiencing a failure retrieving a CLOB. > To answer some of the questions and suggestions raised: > 1. After switching to the EmbeddedXADataSource, the problem goes away. This > is not a "workaround" for me, but is diagnostic of the issue. > 2. After downgrading from 10.5.1.1 -> 10.4.2.0, the problem still occurs. So > the "regression" is between 10.3.2.1 and 10.4.2.0. > 3. I have built 10.5.2.0, the problem still occurs. > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > Execution failed because of a Distributed Protocol Error: > DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error Code Value = 0 > org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of > a Distributed Protocol Error: DRDA_Proto_CMDNSPRM; CODPNT arg = 2414; Error > Code Value = 0 > at > org.apache.derby.impl.drda.DRDAConnThread.codePointNotSupported(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown > Source) > at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) > An IOException was thrown when reading a 'java.sql.String' from an > InputStream. > java.sql.SQLException: An IOException was thrown when reading a > 'java.sql.String' from an InputStream. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown > Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.transferParameters(Unknown > Source) > at > org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(Unknown > Source) > at > org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(Unknown > Source) > at org.apache.derby.iapi.jdbc.BrokeredStatement.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAStatement.close(Unknown Source) > at org.apache.derby.impl.drda.Database.close(Unknown Source) > at org.apache.derby.impl.drda.Session.close(Unknown Source) > at org.apache.derby.impl.drda.DRDAConnThread.closeSession(Unknown > Source)
