Derby
  1. Derby
  2. DERBY-4676

NullPointerException on SELECT on INNER JOIN

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0, 10.6.1.0
    • Fix Version/s: 10.5.3.1, 10.6.2.1, 10.7.1.1
    • Component/s: Store
    • Environment:

      Description

      Running into a NullPointerException error in the Apache Derby database over multiple versions of the derby jars. From testing, this issue intermittently occurs during moderate load test scenarios, but has never occurred in production. This is using Derby as embedded and always occurs on the same statement as shown below and in the attachment. Following the error, hibernate throws an exception which results in the code attempting to rollback the transaction. The rollback fails as the NullPointerException appears to kill the connection.

          • derby.log

      2010-04-27 16:05:22.429 GMT Thread[SNMPDelayedStoreRunnable2Thread,5,main] (XID = 244546), (SESSIONID = 17), (DATABASE = db), (DRDAID = null), Cleanup action starting
      2010-04-27 16:05:22.429 GMT Thread[SNMPDelayedStoreRunnable2Thread,5,main] (XID = 244546), (SESSIONID = 17), (DATABASE = db), (DRDAID = null), Failed Statement is: select nonprimary0_.componentid as componen1_1_, nonprimary0_.deviceid as deviceid1_, device1_.deviceid as deviceid0_, device1_.name as name3_0_, device1_.description as descript3_3_0_, device1_.device_type as device4_3_0_, device1_.managed_address as managed5_3_0_, device1_.csid as csid3_0_, device1_.url as url3_0_, device1_.date_written_to_db as date8_3_0_, device1_.valid as valid3_0_, device1_.invalid_reason as invalid10_3_0_, device1_.version as version3_0_ from subsystem_callserver_map nonprimary0_ inner join device_data device1_ on nonprimary0_.deviceid=device1_.deviceid where nonprimary0_.componentid=? with 1 parameters begin parameter #1: 86b5b069-ca5c-4c38-9643-d9308c246100 :end parameter
      java.lang.NullPointerException
      at org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.fetch(Unknown Source)
      at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
      at org.hibernate.loader.Loader.doQuery(Loader.java:408)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
      at org.hibernate.loader.Loader.loadCollection(Loader.java:1434)
      at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:99)
      at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:488)
      at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
      at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1430)
      at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:280)
      at org.hibernate.engine.PersistenceContext.initializeNonLazyCollections(PersistenceContext.java:796)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
      at org.hibernate.loader.Loader.doList(Loader.java:1593)
      at org.hibernate.loader.Loader.list(Loader.java:1577)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
      at ooad.p.ga(p.java:288)
      at ooad.p.ga(p.java:117)
      at oo.c.gdc(c.java:119)
      at oo.d.c(d.java:805)
      at oo.d.c(d.java:785)
      at oo.d.c(d.java:766)
      at oodb.s.run(s.java:82)
      at java.lang.Thread.run(Thread.java:595)

          • application log

      Apr 27 2010 12:05:22.476 -0400: %_JDBCExceptionReporter-3-org.hibernate.util.JDBCExceptionReporter: Java exception: ': java.lang.NullPointerException'.
      Apr 27 2010 12:05:22.492 -0400: %_JDBCTransaction-3-org.hibernate.transaction.JDBCTransaction: JDBC rollback failed
      java.sql.SQLException: No current connection.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:755)
      at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:163)
      at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:142)
      at ooad.p.r(p.java:888)
      at ooad.p.ga(p.java:310)
      at ooad.p.ga(p.java:117)
      at oa.c.gdc(c.java:119)
      at oa.d.c(d.java:805)
      at oa.d.c(d.java:785)
      at oa.d.c(d.java:766)
      at ooad.s.run(s.java:82)
      at java.lang.Thread.run(Thread.java:595)

      1. derbyerror.log
        3 kB
        Seth Katzman
      2. error.log
        1 kB
        Seth Katzman
      3. 2010-05-25-derbyerror.log
        17 kB
        Seth Katzman
      4. 2010-05-25-applicationerror.log
        36 kB
        Seth Katzman
      5. D4676.java
        2 kB
        Knut Anders Hatlen
      6. junit.diff
        6 kB
        Knut Anders Hatlen
      7. derby-4676-1a.diff
        12 kB
        Knut Anders Hatlen
      8. derbyall_diff.txt
        26 kB
        Mamta A. Satoor
      9. derbyall.sum
        94 kB
        Mamta A. Satoor
      10. derbyall_fail.txt
        0.1 kB
        Mamta A. Satoor

        Issue Links

          Activity

          Seth Katzman created issue -
          Seth Katzman made changes -
          Field Original Value New Value
          Attachment derbyerror.log [ 12445353 ]
          Attachment error.log [ 12445354 ]
          Seth Katzman made changes -
          Attachment 2010-05-25-derbyerror.log [ 12445458 ]
          Attachment 2010-05-25-applicationerror.log [ 12445459 ]
          Knut Anders Hatlen made changes -
          Attachment D4676.java [ 12445477 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-4678 [ DERBY-4678 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Attachment junit.diff [ 12446015 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Attachment derby-4676-1a.diff [ 12446129 ]
          Knut Anders Hatlen made changes -
          Bug behavior facts [Deviation from standard]
          Issue & fix info [Patch Available]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Issue & fix info [Patch Available]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 10.6.1.1 [ 12314973 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4728 [ DERBY-4728 ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Mamta A. Satoor made changes -
          Assignee Knut Anders Hatlen [ knutanders ] Mamta A. Satoor [ mamtas ]
          Mamta A. Satoor made changes -
          Attachment derbyall_diff.txt [ 12448838 ]
          Attachment derbyall.sum [ 12448839 ]
          Attachment derbyall_fail.txt [ 12448840 ]
          Mamta A. Satoor made changes -
          Assignee Mamta A. Satoor [ mamtas ] Knut Anders Hatlen [ knutanders ]
          Fix Version/s 10.5.3.1 [ 12314182 ]
          Mamta A. Satoor made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Fix Version/s 10.6.2.0 [ 12315342 ]
          Fix Version/s 10.6.1.1 [ 12314973 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.6.2.1 [ 12315343 ]
          Fix Version/s 10.6.2.0 [ 12315342 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Knut Anders Hatlen made changes -
          Component/s Store [ 11412 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12511653 ] Default workflow, editable Closed status [ 12802794 ]

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Seth Katzman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development