[
https://issues.apache.org/jira/browse/DERBY-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12731086#action_12731086
]
Kathey Marsden commented on DERBY-4155:
---------------------------------------
I changed the test to check for an unordered result set to avoid the PREPARED
vs IDLE error above and get fairly consistently this issue on network shutdown
running the test standalone if I use the derby-4053_diag_diff.txt patch. I am
guessing this error is the one that caused DERBY-4053 in the second run.
I am guessing this is some kind of embedded bug regarding closing
BrokeredStatements when the referenced table had been dropped. I will try to
get a stand-alone repro for that.
testDerby966 used 125 ms java.sql.SQLSyntaxErrorException: Table/View 'APP.FOO'
does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:91)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:147)
at
org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1542)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1423)
at
org.apache.derby.iapi.jdbc.BrokeredPreparedStatement30.createDuplicateStatement(BrokeredPreparedStatement30.j
ava:56)
at
org.apache.derby.jdbc.XAStatementControl.getRealPreparedStatement(XAStatementControl.java:143)
at
org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getPreparedStatement(BrokeredPreparedStatement.java:526)
at
org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.getStatement(BrokeredPreparedStatement.java:533)
at
org.apache.derby.iapi.jdbc.BrokeredStatement.close(BrokeredStatement.java:130)
at
org.apache.derby.impl.drda.DRDAStatement.close(DRDAStatement.java:1027)
at org.apache.derby.impl.drda.Database.close(Database.java:352)
at org.apache.derby.impl.drda.Session.close(Session.java:115)
at
org.apache.derby.impl.drda.NetworkServerControlImpl.blockingStart(NetworkServerControlImpl.java:826)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at
org.apache.derby.iapi.jdbc.DRDAServerStarter.run(DRDAServerStarter.java:236)
at java.lang.Thread.run(Thread.java:735)
Caused by: java.sql.SQLException: Table/View 'APP.FOO' does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
9)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 24 more
Caused by: ERROR 42X05: Table/View 'APP.FOO' does not exist.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2463)
at
org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2183)
at
org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:310)
at
org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:390)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:199)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:137)
at
org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:245)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:316)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
ctionContext.java:822)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:129)
... 18 more
> jdbcapi/XATest.java doesn't seem to be running anywhere
> --------------------------------------------------------
>
> Key: DERBY-4155
> URL: https://issues.apache.org/jira/browse/DERBY-4155
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.5.1.1, 10.6.0.0
> Environment: jdbcapi/XATest does not seem to be included in any
> suite. It currently fails in testMorph because a transaction is active when
> a connection is closed. I think the error is correct and the test needs to
> be changed.
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
