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

HarvestdatabaseUpdateApplication failed after using DB init with createfullhddb.mysql

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.2
    • None
    • MySQL
    • None
    • ONB

    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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: