Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-1994 Bitarchive - spurious java.sql.SQLNonTransientConnectionException / java.lang.ArrayIndexOutOfBoundsException
  3. NAS-1997

Update of Activebitpreservation information failed - java.sql.SQLException: Exceeded maximum number of sections 32k

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Fixed
    • Critical
    • 3.18.0
    • None
    • None
    • None
    • SB/KB
    • Hide

      Verified by running TEST11B successfully

      Show
      Verified by running TEST11B successfully

    Description

      During TEST11B step 2 this now happens, and the filestatus is never updated even though the indexing jobs complete.

      WARNING: Update of Activebitpreservation information failed
      dk.netarkivet.common.exceptions.IllegalState: Cannot add replicafileinfo
      to the database.
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheHelpers.createReplicaFileInfoEntriesInDB(Re
      plicaCacheHelpers.java:223)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheHelpers.insertFileIntoDB(ReplicaCacheHelper
      s.java:163)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheDatabase.addChecksumInformation(ReplicaCach
      eDatabase.java:834)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.runChecks
      um(DatabaseBasedActiveBitPreservation.java:262)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.initCheck
      sumStatusUpdate(DatabaseBasedActiveBitPreservation.java:244)
      at dk.netarkivet.archive.arcrepository.bitpreservation.DatabaseBasedActiveBitPreservation.findChang
      edFiles(DatabaseBasedActiveBitPreservation.java:459)
      at dk.netarkivet.archive.webinterface.BitpreservationUpdateThread.run(BitpreservationUpdateThread.j
      ava:75)
      Caused by: java.sql.SQLException: Exceeded maximum number of sections 32k
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
      Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
      at dk.netarkivet.common.utils.DBUtils.prepareStatement(DBUtils.java:236)
      at dk.netarkivet.archive.arcrepositoryadmin.ReplicaCacheHelpers.createReplicaFileInfoEntriesInDB(Re
      plicaCacheHelpers.java:207)
      ... 6 more
      Caused by: org.apache.derby.client.am.SqlException: Exceeded maximum number
      of sections 32k
      at org.apache.derby.client.am.SectionManager.getSection(Unknown Source)
      at org.apache.derby.client.am.SectionManager.getDynamicSection(Unknown
      Source)
      at org.apache.derby.client.am.PreparedStatement.initPreparedStatement(Unknown
      Source)
      at org.apache.derby.client.am.PreparedStatement.<init>(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement40.<init>(Unknown
      Source)
      at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newPreparedStatement(Unknown
      Source)
      at org.apache.derby.client.net.NetPreparedStatement.<init>(Unknown
      Source)
      at org.apache.derby.client.net.NetConnection.newPreparedStatement_(Unknown
      Source)
      at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
      ... 10 more

      I've never seen this type of error in any other sql server so the following link may be fud.

      http://objectmix.com/apache/647155-xj200-error.html

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            nicl@kb.dk Nicholas Clarke (Inactive)
            Nicholas Clarke Nicholas Clarke (Inactive)
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: