Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-2272

QUICKSTART database needs to be upgraded from 10.1 to 10.7+ to support BOOLEAN

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.4
    • None
    • None
    • None
    • Hide

      Tested by QUICKSTART.

      Show
      Tested by QUICKSTART.

    Description

      Exception in thread "main" dk.netarkivet.common.exceptions.IOFailure: SQL error updating database with sql: ALTER TABLE jobs ADD COLUMN snapshot BOOLEAN
      SQLException trace:
      SQL State:XCL47
      Error Code:20000
      java.sql.SQLException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
      	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:247)
      	at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1037)
      	at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:167)
      	at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:142)
      	at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateJobsv9tov10(DerbySpecifics.java:458)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.upgradeJobsTable(DBSpecifics.java:417)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:149)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTables(DBSpecifics.java:741)
      	at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(HarvestdatabaseUpdateApplication.java:47)
      Caused by: org.apache.derby.client.am.SqlException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
      	at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
      	at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
      	at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
      	... 11 more
      End of SQLException trace
      	at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1048)
      	at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:167)
      	at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(HarvestDBConnection.java:142)
      	at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateJobsv9tov10(DerbySpecifics.java:458)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.upgradeJobsTable(DBSpecifics.java:417)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:149)
      	at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTables(DBSpecifics.java:741)
      	at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(HarvestdatabaseUpdateApplication.java:47)
      Caused by: java.sql.SQLException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
      	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:247)
      	at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:1037)
      	... 7 more
      Caused by: org.apache.derby.client.am.SqlException: Use of 'BOOLEAN' requires database to be upgraded from version 10.1 to version 10.7 or later.
      	at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
      	at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
      	at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
      	at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
      	at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
      	... 11 more
      

      Attachments

        Issue Links

          Activity

            People

              csr Colin Rosenthal
              nicl@kb.dk Nicholas Clarke (Inactive)
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: