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

Derby complains about wrong version, although nas bundled with 10.10.1.1

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • None
    • None
    • Derby
    • None

    Description

      Deployment with QUICKSTART-Guide failed, due to following exception.

      Version: 4.3.0 status UNSTABLE (r2813)
      Beginning database upgrade at Mon Jan 06 09:36:07 CET 2014
      log4j:WARN No appenders could be found for logger (com.mchange.v2.log.MLog).
      log4j:WARN Please initialize the log4j system properly.
      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 ve
      rsion 10.1 to version 10.7 or later.
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unkn
      own Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Sourc
      e)
      at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source
      )
      at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxy
      Connection.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(Har
      vestDBConnection.java:167)
      at dk.netarkivet.harvester.datamodel.HarvestDBConnection.updateTable(Har
      vestDBConnection.java:142)
      at dk.netarkivet.harvester.datamodel.DerbySpecifics.migrateJobsv9tov10(D
      erbySpecifics.java:458)
      at dk.netarkivet.harvester.datamodel.DBSpecifics.upgradeJobsTable(DBSpec
      ifics.java:408)
      at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics
      .java:149)
      at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTables(DBSpecific
      s.java:721)
      at dk.netarkivet.harvester.tools.HarvestdatabaseUpdateApplication.main(H
      arvestdatabaseUpdateApplication.java:47)
      Caused by: org.apache.derby.client.am.SqlException: Use of 'BOOLEAN' requires da
      tabase 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(Unkno
      wn Source)
      at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unk
      nown Source)

      Attachments

        Issue Links

          Activity

            People

              svc Søren Vejrup Carlsen (Inactive)
              aponb Andreas P
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: