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 "Dag H. Wanvik" <da...@oracle.com> on 2010/08/20 02:55:09 UTC
instability in ImportExportLobTest?
In a recent regression suite run I saw 11 instances of this error (in
client suite part of the test). Running the test standalone, it
worked. The missing table is detected in the setUp method, the table
is created in the decorateSQL method given to the
CleanDatabaseTestSetup constructor. Any ideas hwo this could happen?
Dag
There were 11 errors:
1) testImportTableExportTable(org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest)java.sql.SQLSyntaxErrorException: Table/View 'BOOKS_IMP' does not exist.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:84)
at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358)
at org.apache.derby.client.am.Statement.executeUpdate(Statement.java:509)
at org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest.setUp(ImportExportLobTest.java:114)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: org.apache.derby.client.am.SqlException: Table/View 'BOOKS_IMP' does not exist.
at org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1833)
at org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:1421)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:208)
at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:59)
at org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:45)
at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:128)
at org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:1417)
at org.apache.derby.client.am.Statement.flowExecute(Statement.java:2120)
at org.apache.derby.client.am.Statement.executeUpdateX(Statement.java:514)
at org.apache.derby.client.am.Statement.executeUpdate(Statement.java:500)
... 38 more
Re: instability in ImportExportLobTest?
Posted by Knut Anders Hatlen <kn...@oracle.com>.
"Dag H. Wanvik" <da...@oracle.com> writes:
> In a recent regression suite run I saw 11 instances of this error (in
> client suite part of the test). Running the test standalone, it
> worked. The missing table is detected in the setUp method, the table
> is created in the decorateSQL method given to the
> CleanDatabaseTestSetup constructor. Any ideas hwo this could happen?
One possibility is that you could have had an external network server
running. Since CleanDatabaseTestSetup is the outermost decorator, it
will use the embedded driver when it invokes decorateSQL(), and the
tables won't be made available on the external server.
--
Knut Anders