Details
-
Bug
-
Resolution: Fixed
-
Critical
-
None
-
None
-
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
- mentioned in
-
Wiki Page Loading...