Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6490

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None

      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'...

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              myrna Myrna van Lunteren
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: