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 "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2010/04/28 21:43:48 UTC
[jira] Created: (DERBY-4635) intermittent failure in
(...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
intermittent failure in (...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
-------------------------------------------------------------------------------------------------------------
Key: DERBY-4635
URL: https://issues.apache.org/jira/browse/DERBY-4635
Project: Derby
Issue Type: Bug
Components: Test
Affects Versions: 10.6.1.0, 10.7.0.0
Reporter: Myrna van Lunteren
Priority: Minor
During test cycle for 10.6 RC1 (10.6.1.0 build 938214) on windows (win2008, ibm15 sr10) I saw a failure in org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing.
This same failure was also reported to the derby-dev list in this thread:
http://mail-archives.apache.org/mod_mbox/db-derby-dev/201004.mbox/%3c4BBB1323.9090806@sun.com%3e
Here's my stack trace (I modified the physical paths):
1) testReplication_Local_1_Indexing(org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing)java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:572)
at java.sql.DriverManager.getConnection(DriverManager.java:218)
at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.bootMasterDatabase(ReplicationRun.java:863)
at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.makeReadyForReplication(ReplicationRun.java:2746)
at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing(ReplicationRun_Local_1Indexing.java:70)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.runBare(ReplicationRun.java:207)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
... 33 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4635) intermittent failure in
(...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12914218#action_12914218 ]
Knut Anders Hatlen commented on DERBY-4635:
-------------------------------------------
Yes, that sounds like a good idea. In fact, it looks like there are many methods in the replications tests' Utils class that could be replaced with methods in PrivilegedFileOpsForTests.
> intermittent failure in (...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4635
> URL: https://issues.apache.org/jira/browse/DERBY-4635
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.6.1.0, 10.7.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
>
> During test cycle for 10.6 RC1 (10.6.1.0 build 938214) on windows (win2008, ibm15 sr10) I saw a failure in org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing.
> This same failure was also reported to the derby-dev list in this thread:
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/201004.mbox/%3c4BBB1323.9090806@sun.com%3e
> Here's my stack trace (I modified the physical paths):
> 1) testReplication_Local_1_Indexing(org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing)java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:572)
> at java.sql.DriverManager.getConnection(DriverManager.java:218)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.bootMasterDatabase(ReplicationRun.java:863)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.makeReadyForReplication(ReplicationRun.java:2746)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing(ReplicationRun_Local_1Indexing.java:70)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.runBare(ReplicationRun.java:207)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
> at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
> at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
> ... 33 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4635) intermittent failure in
(...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12914197#action_12914197 ]
Knut Anders Hatlen commented on DERBY-4635:
-------------------------------------------
Discussed this issue briefly with Kathey and Lily on IRC. Some thoughts:
ReplicationRun.makeReadyForReplication() has called initMaster() before it fails in bootMasterDatabase(). initMaster() is supposed to remove all old files in the db_master directory, but it cannot have done so in this case, otherwise we wouldn't have seen this error. Unfortunately, it only prints a message to the console if it cannot delete a file.
It would probably be better if it just failed immediately when it failed to delete a file, as that would make it easier to pinpoint the cause of the failure. And even better if each test case had cleaned the db_master directory after it has completed instead of before it has started, so that we can tell exactly which test case is not shutting down cleanly.
> intermittent failure in (...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4635
> URL: https://issues.apache.org/jira/browse/DERBY-4635
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.6.1.0, 10.7.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
>
> During test cycle for 10.6 RC1 (10.6.1.0 build 938214) on windows (win2008, ibm15 sr10) I saw a failure in org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing.
> This same failure was also reported to the derby-dev list in this thread:
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/201004.mbox/%3c4BBB1323.9090806@sun.com%3e
> Here's my stack trace (I modified the physical paths):
> 1) testReplication_Local_1_Indexing(org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing)java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:572)
> at java.sql.DriverManager.getConnection(DriverManager.java:218)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.bootMasterDatabase(ReplicationRun.java:863)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.makeReadyForReplication(ReplicationRun.java:2746)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing(ReplicationRun_Local_1Indexing.java:70)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.runBare(ReplicationRun.java:207)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
> at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
> at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
> ... 33 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4635) intermittent failure in
(...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12914208#action_12914208 ]
Kristian Waagan commented on DERBY-4635:
----------------------------------------
Maybe the new method PrivilegedFileOpsForTests.persistentRecursiveDelete (or BaseJDBCTestCase.assertDirectoryDeleted) can be used? It will try to delete all files, and report those it couldn't delete.
> intermittent failure in (...)replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4635
> URL: https://issues.apache.org/jira/browse/DERBY-4635
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.6.1.0, 10.7.0.0
> Reporter: Myrna van Lunteren
> Priority: Minor
>
> During test cycle for 10.6 RC1 (10.6.1.0 build 938214) on windows (win2008, ibm15 sr10) I saw a failure in org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing.
> This same failure was also reported to the derby-dev list in this thread:
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/201004.mbox/%3c4BBB1323.9090806@sun.com%3e
> Here's my stack trace (I modified the physical paths):
> 1) testReplication_Local_1_Indexing(org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing)java.sql.SQLException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:572)
> at java.sql.DriverManager.getConnection(DriverManager.java:218)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.bootMasterDatabase(ReplicationRun.java:863)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.makeReadyForReplication(ReplicationRun.java:2746)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun_Local_1Indexing.testReplication_Local_1_Indexing(ReplicationRun_Local_1Indexing.java:70)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
> at org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationRun.runBare(ReplicationRun.java:207)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ041, SQLERRMC: Failed to create database 'C:\jartest\db_master\wombat', see the next exception for details.::SQLSTATE: XBM0JDirectory C:\jartest\db_master\C:\jartest\db_master\wombat already exists.
> at org.apache.derby.client.am.Connection.completeSqlca(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseRdbAccessFailed(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
> at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
> at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowUSRIDONLconnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
> at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
> at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
> ... 33 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.