Description
HarvestdatabaseUpdateApplication failed after using DB init with createfullhddb.mysql with following error:
08.08.2013 10:38:23 dk.netarkivet.harvester.datamodel.DBSpecifics updateTable
INFO: Trying to migrate table 'jobs' from version '8' to version '9'.
08.08.2013 10:38:23 dk.netarkivet.harvester.datamodel.HarvestDBConnection updateTable
INFO: Updating table 'jobs' to version 9
08.08.2013 10:38:23 dk.netarkivet.common.utils.DBUtils executeSQL
WARNUNG: SQL error updating database with sql: ALTER TABLE jobs ADD COLUMN harvestname_prefix VARCHAR(100)
SQLException trace:
SQL State:42S21
Error Code:1060
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'harvestname_prefix'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
Attachments
Issue Links
- related to
-
NAS-2232 harvestDatabaseUpdate: problem with harvestdefinitions
- Closed