You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2010/01/28 11:48:05 UTC
[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(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(Unknown Source)
> ... 13 more
> 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)
> at org.apache.derby.iapi.types.SQLChar.setFrom(Unknown Source)
> at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
> at org.apache.derby.impl.sql.GenericParameterValueSet.transferDataValues(Unknown Source)
> at org.apache.derby.impl.sql.execute.BaseActivation.setParameters(Unknown Source)
> at org.apache.derby.impl.sql.GenericActivationHolder.setParameters(Unknown Source)
> ... 11 more
> Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM = ziptie; diagnostic msg = An IOException was thrown when reading a 'java.sql.String' from an InputStream.
> org.apache.derby.impl.drda.DRDAProtocolException: Execution failed because of Permanent Agent Error: SVRCOD = 40; RDBNAM = ziptie; diagnostic msg = An IOException was thrown when reading a 'java.sql.String' from an InputStream.
> at org.apache.derby.impl.drda.DRDAProtocolException.newAgentError(Unknown Source)
> at org.apache.derby.impl.drda.DRDAConnThread.sendUnexpectedException(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)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.