[DERBY-6490] hang in dblook_test_net after SQLNonTransientConnectionException ; DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC: XJ040.C : [0]

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Tools
• Assignee: Unassigned
• Reporter: Myrna van Lunteren
• Created: 26/Feb/14 19:33
• Updated: 15/Oct/15 16:08

Description

The nightly derbyall run at IBM failed in dblook_test_net with ibm 1.6 SR15 and then hung the test run last night against trunk on windows (10.11.0.0 alpha - (1571897)).

This is the contents of the dblook_test_net0.log (dblook_test0.log and dblook_test_territory0.log have 0 size):

java.sql.SQLNonTransientConnectionException: DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC: XJ040.C : [0] C:\test\Results.2014-02-25\ibm16_derbyall\derbyall\derbynetclientmats\DerbyNetClient\derbynetclientmats\dblook_test_net
wombat, [1] sun.misc.Launcher$AppClassLoader@271a271a::SQLSTATE: XJ001
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:419)
at java.sql.DriverManager.getConnection(DriverManager.java:367)
at org.apache.derby.tools.dblook.go(Unknown Source)
at org.apache.derby.tools.dblook.<init>(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.tools.dblook_test.lookThree(dblook_test.java:411)
at org.apache.derbyTesting.functionTests.tests.tools.dblook_test.runTest(dblook_test.java:277)
at org.apache.derbyTesting.functionTests.tests.derbynet.dblook_test_net.doTest(dblook_test_net.java:60)
at org.apache.derbyTesting.functionTests.tests.derbynet.dblook_test_net.main(dblook_test_net.java:36)
Caused by: ERROR XJ040: DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC: XJ040.C : [0] C:\test\Results.2014-02-25\ibm16_derbyall\derbyall\derbynetclientmats\DerbyNetClient\derbynetclientmats\dblook_test_net
wombat, [1] sun.misc.Launcher$AppClassLoader@271a271a::SQLSTATE: XJ001
at org.apache.derby.client.am.ClientConnection.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.flowUSRIDPWDconnect(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)
... 9 more
– **--> DEBUG: DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC: XJ040.C : [0] C:\test\Results.2014-02-25\ibm16_derbyall\derbyall\derbynetclientmats\DerbyNetClient\derbynetclientmats\dblook_test_net
wombat, [1] sun.misc.Launcher$AppClassLoader@271a271a::SQLSTATE: XJ001

After using the windows 2008 TaskManager's option to 'Create a Dump', I looked at the dump file, which seems to be mostly binary, but I did see the words 'deadlock' and 'OutOfMemory'...