Details
-
Sub-task
-
Resolution: Fixed
-
Critical
-
None
-
None
-
None
-
SB/KB
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.