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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2009/05/07 09:55:33 UTC
[jira] Updated: (DERBY-4218) "Table/View 'MAX_SCAN' does not exist"
in org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest
[ https://issues.apache.org/jira/browse/DERBY-4218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-4218:
--------------------------------------
Attachment: d4218.diff
The tearDown() method first drops the test tables and then waits for the other threads to complete. If the other threads have more work when the test finishes, they may not find the tables since they've been dropped. Changing the order in tearDown() so that we wait for the threads to finish first, and then drop the tables, should fix this issue. See the attached patch.
> "Table/View 'MAX_SCAN' does not exist" in org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest
> ------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4218
> URL: https://issues.apache.org/jira/browse/DERBY-4218
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure
> Affects Versions: 10.5.1.2
> Environment: OS:
> Red Hat Enterprise Linux AS release 4 (Nahant Update 3) 64bits
> Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 GNU/Linux
> JVM:
> Sun Microsystems Inc.
> java version "1.5.0_14"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_14-b03)
> Java HotSpot(TM) Client VM (build 1.5.0_14-b03, mixed mode)
> OS:
> Microsoft Windows XP Professional - 5.1.2600 Service Pack 3 Build 2600
> CYGWIN_NT-5.1 1.5.25(0.156/4/2) 2008-06-12 19:34 Cygwin
> JVM:
> Sun Microsystems Inc.
> java version "1.6.0_10"
> Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
> Java HotSpot(TM) Client VM (build 11.0-b15, mixed mode)
> OS:
> Red Hat Enterprise Linux Server release 5.1 (Tikanga) 64bits
> Linux 2.6.18-53.1.14.el5 #1 SMP Tue Feb 19 07:18:46 EST 2008 GNU/Linux
> JVM:
> Sun Microsystems Inc.
> java version "1.5.0_14"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_14-b03)
> Java HotSpot(TM) Server VM (build 1.5.0_14-b03 mixed mode 32-bit)
> OS:
> SUSE Linux Enterprise Server 10 (x86_64) [Version 10 / Patchlevel 10] 64bits
> Linux 2.6.16.21-0.8-smp #1 SMP Mon Jul 3 18:25:39 UTC 2006 GNU/Linux
> JVM:
> Sun Microsystems Inc.
> java version "1.5.0_14"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_14-b03)
> Java HotSpot(TM) Server VM (build 1.5.0_14-b03 mixed mode 32-bit)
> OS:
> Ubuntu Linux .... 32bits
> Linux 2.6.22-14-generic #1 SMP Sun Oct 14 23:05:12 GMT 2007 GNU/Linux
> JVM:
> phoneME Advanced (phoneme_advanced_mr2-b116)
> Foundation Profile Specification 1.1
> CVM phoneme_advanced_mr2-b116 (interpreter loop)
> Reporter: Ole Solberg
> Assignee: Knut Anders Hatlen
> Attachments: d4218.diff
>
>
> See e.g. http://dbtg.thresher.com/derby/test/trunk15/jvm1.5/testing/testlog/Linux-2.6.9-34.ELsmp_x86_64-x86_64/772381-org.apache.derbyTesting.functionTests.suites.All_diff.txt
> There were 2 errors:
> 1) testMultipleLastKeyWaitsInMaxScan(org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest)java.sql.SQLException: Table/View 'MAX_SCAN' does not exist.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
> at org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest$3.doWork(IndexSplitDeadlockTest.java:590)
> at org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest$AsyncThread.run(IndexSplitDeadlockTest.java:769)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: ERROR 42X05: Table/View 'MAX_SCAN' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.DMLModStatementNode.verifyTargetTable(Unknown Source)
> at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.rePrepare(Unknown Source)
> ... 6 more
> 2) testMultiplePrevKeyWaitsInForwardScan(org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest)java.sql.SQLException: Table/View 'FW_SCAN' does not exist.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
> at org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest$4.doWork(IndexSplitDeadlockTest.java:665)
> at org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest$AsyncThread.run(IndexSplitDeadlockTest.java:769)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: ERROR 42X05: Table/View 'FW_SCAN' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> at org.apache.derby.impl.sql.compile.DMLModStatementNode.verifyTargetTable(Unknown Source)
> at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.rePrepare(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> ... 6 more
> or http://dbtg.thresher.com/derby/test/Daily/jvm1.5/testing/testlog/lin/772336-suitesAll_diff.txt or
> http://dbtg.thresher.com/derby/test/Daily/jvm1.5/testing/testlog/sles/772336-suitesAll_diff.txt or http://dbtg.thresher.com/derby/test/Daily/javaME/testing/testlog/ubuntu/772336-suitesAll_diff.txt
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.