db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4337) DRDA regression in LOB retrieval between 10.3.2.1 -> 10.4.2.0 (and beyond)
Date Wed, 05 Aug 2009 19:12:14 GMT

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


Mime
View raw message