Derby
  1. Derby
  2. DERBY-4973

NullPointerException in updatelocks.sql encryption tests on IBM 1.6

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Component/s: Store
    • Labels:
      None
    • Environment:
    • Issue & fix info:
      High Value Fix
    • Bug behavior facts:
      Regression Test Failure

      Description

      The IBM 1.6 results for Jan 13, 2011 show the following failure for IBM 1.6 on XP

          • End: TestEnc jdk1.6.0 DerbyNetClient derbynetclientmats:encodingTests 2011-01-14 00:05:38 ***
                      • Diff file derbyall/encryptionAll/storemats/storemats/updatelocks.diff
          • Start: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:18:37 ***
            19859a19860,19868
            > ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
            > ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
            > ij> next scan_cursor;
            > A |B |C
            > --------------------------------------------------------------------------------------------------------------------------------------------------------
            > -3 |-30 |-three
            > ij> update a set a=3,b=30,c='three' where current of scan_cursor;
            > 1 row inserted/updated/deleted
            > ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            19861a19871
            > APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
            19866,19876d19875
            < -3 |-30 |-three
            < ij> update a set a=3,b=30,c='three' where current of scan_cursor;
            < 1 row inserted/updated/deleted
            < ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
            < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
            < ---------------------------------------------------------------------------
            < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
            < APP |UserTran|TABLE |1 |X |A |Tablelock |GRANT|ACTIVE
            < ij> next scan_cursor;
            < A |B |C
            < --------------------------------------------------------------------------------------------------------------------------------------------------------
            Test Failed.
          • End: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:19:24 ***
            ------------------------------------------------------

      Stack trace is:
      Fri Jan 14 00:19:08 PST 2011 Thread[main,5,main] (XID = 2648), (SESSIONID = 1), (DATABASE = wombat), (DRDAID = null), Failed Statement is: select * from lock_table order by tabname, type desc, mode, cnt, lockname

      ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.

      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

      at org.apache.derby.iapi.error.StandardException.unexpectedUserException(Unknown Source)

      at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)

      at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.HashTableResultSet.getNextRowFromRowSource(Unknown Source)

      at org.apache.derby.iapi.store.access.BackingStoreHashtable.getNextRowFromRowSource(Unknown Source)

      at org.apache.derby.iapi.store.access.BackingStoreHashtable.<init>(Unknown Source)

      at org.apache.derby.impl.sql.execute.HashTableResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)

      at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)

      at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

      at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

      at org.apache.derby.tools.ij.main(Unknown Source)

      Caused by: java.lang.NullPointerException

      at org.apache.derby.impl.store.raw.xact.Xact.getContextId(Unknown Source)

      at org.apache.derby.impl.store.raw.xact.TransactionTableEntry.getTransactionTypeString(Unknown Source)

      at org.apache.derby.diag.TransactionTable.getString(Unknown Source)

      at org.apache.derby.iapi.types.SQLChar.setValueFromResultSet(Unknown Source)

      ... 25 more

      ============= begin nested exception, level (1) ===========

      java.lang.NullPointerException

      at org.apache.derby.impl.store.raw.xact.Xact.getContextId(Unknown Source)

      at org.apache.derby.impl.store.raw.xact.TransactionTableEntry.getTransactionTypeString(Unknown Source)

      at org.apache.derby.diag.TransactionTable.getString(Unknown Source)

      at org.apache.derby.iapi.types.SQLChar.setValueFromResultSet(Unknown Source)

      at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)

      at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.HashTableResultSet.getNextRowFromRowSource(Unknown Source)

      at org.apache.derby.iapi.store.access.BackingStoreHashtable.getNextRowFromRowSource(Unknown Source)

      at org.apache.derby.iapi.store.access.BackingStoreHashtable.<init>(Unknown Source)

      at org.apache.derby.impl.sql.execute.HashTableResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)

      at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)

      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)

      at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

      at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

      at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

      at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

      at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

      at org.apache.derby.tools.ij.main(Unknown Source)

      ============= end nested exception, level (1) ===========

      1. updatelocks_results.zip
        942 kB
        Kathey Marsden
      2. derby-4973_diff.txt
        1 kB
        Kathey Marsden

        Activity

        Kathey Marsden created issue -
        Kathey Marsden made changes -
        Field Original Value New Value
        Affects Version/s 10.8.0.0 [ 12315561 ]
        Environment Booting Derby version The Apache Software Foundation - Apache Derby - 10.8.0.0 alpha - (1058840): instance a816c00e-012d-839a-de59-ffff9cf6fc6d
        on database directory C:\jartest\JarResults.2011-01-13\ibm16_derbyall\derbyall\encryptionAll\storemats\storemats\updatelocks\wombat with class loader sun.misc.Launcher$AppClassLoader@4bf94bf9
        Loaded from file:/C:/jartest/classes/derby.jar

        java.vendor=IBM Corporation
        java.runtime.version=jvmwi3260sr9-20101124_69295
        java.fullversion=JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr9-20101124_69295 (JIT enabled, AOT enabled)
        J9VM - 20101124_069295
        JIT - r9_20101028_17488ifx2
        GC - 20101027_AA
        Description The IBM 1.6 results for Jan 13, 2011 show the following failure for IBM 1.6 on XP


        *** End: TestEnc jdk1.6.0 DerbyNetClient derbynetclientmats:encodingTests 2011-01-14 00:05:38 ***
        ********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocks.diff
        *** Start: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:18:37 ***
        19859a19860,19868
        > ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
        > ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
        > ij> next scan_cursor;
        > A |B |C
        > --------------------------------------------------------------------------------------------------------------------------------------------------------
        > -3 |-30 |-three
        > ij> update a set a=3,b=30,c='three' where current of scan_cursor;
        > 1 row inserted/updated/deleted
        > ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
        19861a19871
        > APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
        19866,19876d19875
        < -3 |-30 |-three
        < ij> update a set a=3,b=30,c='three' where current of scan_cursor;
        < 1 row inserted/updated/deleted
        < ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
        < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
        < ---------------------------------------------------------------------------
        < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
        < APP |UserTran|TABLE |1 |X |A |Tablelock |GRANT|ACTIVE
        < ij> next scan_cursor;
        < A |B |C
        < --------------------------------------------------------------------------------------------------------------------------------------------------------
        Test Failed.
        *** End: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:19:24 ***
        ------------------------------------------------------

        I will look for and attach the stack trace.
        The IBM 1.6 results for Jan 13, 2011 show the following failure for IBM 1.6 on XP


        *** End: TestEnc jdk1.6.0 DerbyNetClient derbynetclientmats:encodingTests 2011-01-14 00:05:38 ***
        ********* Diff file derbyall/encryptionAll/storemats/storemats/updatelocks.diff
        *** Start: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:18:37 ***
        19859a19860,19868
        > ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
        > ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
        > ij> next scan_cursor;
        > A |B |C
        > --------------------------------------------------------------------------------------------------------------------------------------------------------
        > -3 |-30 |-three
        > ij> update a set a=3,b=30,c='three' where current of scan_cursor;
        > 1 row inserted/updated/deleted
        > ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
        19861a19871
        > APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
        19866,19876d19875
        < -3 |-30 |-three
        < ij> update a set a=3,b=30,c='three' where current of scan_cursor;
        < 1 row inserted/updated/deleted
        < ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
        < USERNAME|TRANTYPE|TYPE |CNT |MODE|TABNAME |LOCKNAME |STATE|STATUS
        < ---------------------------------------------------------------------------
        < APP |UserTran|TABLE |1 |IX |A |Tablelock |GRANT|ACTIVE
        < APP |UserTran|TABLE |1 |X |A |Tablelock |GRANT|ACTIVE
        < ij> next scan_cursor;
        < A |B |C
        < --------------------------------------------------------------------------------------------------------------------------------------------------------
        Test Failed.
        *** End: updatelocks jdk1.6.0 storemats:storemats 2011-01-14 00:19:24 ***
        ------------------------------------------------------

        Stack trace is:
        Fri Jan 14 00:19:08 PST 2011 Thread[main,5,main] (XID = 2648), (SESSIONID = 1), (DATABASE = wombat), (DRDAID = null), Failed Statement is: select * from lock_table order by tabname, type desc, mode, cnt, lockname

        ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.

        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

        at org.apache.derby.iapi.error.StandardException.unexpectedUserException(Unknown Source)

        at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)

        at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.HashTableResultSet.getNextRowFromRowSource(Unknown Source)

        at org.apache.derby.iapi.store.access.BackingStoreHashtable.getNextRowFromRowSource(Unknown Source)

        at org.apache.derby.iapi.store.access.BackingStoreHashtable.<init>(Unknown Source)

        at org.apache.derby.impl.sql.execute.HashTableResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)

        at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

        at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

        at org.apache.derby.tools.ij.main(Unknown Source)

        Caused by: java.lang.NullPointerException

        at org.apache.derby.impl.store.raw.xact.Xact.getContextId(Unknown Source)

        at org.apache.derby.impl.store.raw.xact.TransactionTableEntry.getTransactionTypeString(Unknown Source)

        at org.apache.derby.diag.TransactionTable.getString(Unknown Source)

        at org.apache.derby.iapi.types.SQLChar.setValueFromResultSet(Unknown Source)

        ... 25 more

        ============= begin nested exception, level (1) ===========

        java.lang.NullPointerException

        at org.apache.derby.impl.store.raw.xact.Xact.getContextId(Unknown Source)

        at org.apache.derby.impl.store.raw.xact.TransactionTableEntry.getTransactionTypeString(Unknown Source)

        at org.apache.derby.diag.TransactionTable.getString(Unknown Source)

        at org.apache.derby.iapi.types.SQLChar.setValueFromResultSet(Unknown Source)

        at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)

        at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.HashTableResultSet.getNextRowFromRowSource(Unknown Source)

        at org.apache.derby.iapi.store.access.BackingStoreHashtable.getNextRowFromRowSource(Unknown Source)

        at org.apache.derby.iapi.store.access.BackingStoreHashtable.<init>(Unknown Source)

        at org.apache.derby.impl.sql.execute.HashTableResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)

        at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

        at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)

        at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)

        at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)

        at org.apache.derby.tools.ij.main(Unknown Source)

        ============= end nested exception, level (1) ===========
        Component/s Store [ 11412 ]
        Kathey Marsden made changes -
        Attachment updatelocks_results.zip [ 12468416 ]
        Kathey Marsden made changes -
        Attachment derby-4973_diff.txt [ 12468907 ]
        Kathey Marsden made changes -
        Bug behavior facts [Regression Test Failure, Regression] [Regression Test Failure]
        Issue & fix info [High Value Fix] [High Value Fix, Patch Available]
        Kathey Marsden made changes -
        Status Open [ 1 ] Closed [ 6 ]
        Issue & fix info [Patch Available, High Value Fix] [High Value Fix]
        Fix Version/s 10.3.3.1 [ 12313143 ]
        Fix Version/s 10.4.2.1 [ 12313401 ]
        Fix Version/s 10.5.3.2 [ 12315436 ]
        Fix Version/s 10.6.2.3 [ 12315434 ]
        Fix Version/s 10.7.1.3 [ 12315902 ]
        Fix Version/s 10.8.0.0 [ 12315561 ]
        Resolution Fixed [ 1 ]
        Rick Hillegas made changes -
        Affects Version/s 10.8.1.1 [ 12316356 ]
        Affects Version/s 10.8.1.0 [ 12315561 ]
        Fix Version/s 10.8.1.1 [ 12316356 ]
        Fix Version/s 10.8.1.0 [ 12315561 ]
        Rick Hillegas made changes -
        Fix Version/s 10.8.1.2 [ 12316362 ]
        Fix Version/s 10.8.1.1 [ 12316356 ]
        Affects Version/s 10.8.1.2 [ 12316362 ]
        Affects Version/s 10.8.1.1 [ 12316356 ]
        Kathey Marsden made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Assignee Kathey Marsden [ kmarsden ]
        Kathey Marsden made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Knut Anders Hatlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12542530 ] Default workflow, editable Closed status [ 12802822 ]

          People

          • Assignee:
            Kathey Marsden
            Reporter:
            Kathey Marsden
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development