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

During database-upgrade using MySQL upgrade succeeds but w/ warning about rollback not possible

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Minor
    • None
    • 3.8
    • None

    Description

      Upgrading the MySQL tables used by NetarchiveSuite the upgrade succeeds which is not evident from the log which complains about not being able to rollback (with commit set to true).
      Apr 21 2009 2:53:15 PM dk.netarkivet.harvester.datamodel.DomainDBDAO <init>
      INFO: Migrate table 'configurations' to version 4
      Apr 21 2009 2:53:15 PM dk.netarkivet.harvester.datamodel.DBSpecifics updateTable
      INFO: Trying to migrate table 'configurations' from version '3' to version '4'.
      Apr 21 2009 2:53:15 PM dk.netarkivet.harvester.datamodel.DBConnect updateTable
      INFO: Updating table to version 4
      Apr 21 2009 2:53:15 PM dk.netarkivet.common.utils.DBUtils executeSQL
      FINE: Executing SQL-statement: ALTER TABLE configurations ALTER maxbytes SET DEFAULT -1
      Apr 21 2009 2:53:15 PM dk.netarkivet.common.utils.DBUtils executeSQL
      FINE: Executing SQL-statement: UPDATE schemaversions SET version = 4 WHERE tablename = 'configurations'
      Apr 21 2009 2:53:15 PM dk.netarkivet.common.utils.DBUtils executeSQL
      FINE: Updated database using updates 'ALTER TABLE configurations ALTER maxbytes SET DEFAULT -1;UPDATE schemaversions SET version = 4 WHER
      E tablename = 'configurations''.
      Apr 21 2009 2:53:15 PM dk.netarkivet.common.utils.DBUtils rollbackIfNeeded
      WARNING: SQL error doing rollback after updating table with SQL: ALTER TABLE configurations ALTER maxbytes SET DEFAULT -1;UPDATE schemav
      ersions SET version = 4 WHERE tablename = 'configurations''.
      SQLException trace:
      SQL State:08003
      Error Code:0
      com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
      at com.mysql.jdbc.Connection.rollback(Connection.java:5257)
      at dk.netarkivet.common.utils.DBUtils.rollbackIfNeeded(DBUtils.java:524)
      at dk.netarkivet.common.utils.DBUtils.executeSQL(DBUtils.java:846)
      at dk.netarkivet.harvester.datamodel.DBConnect.updateTable(DBConnect.java:114)
      at dk.netarkivet.harvester.datamodel.MySQLSpecifics.migrateConfigurationsv3ov4(MySQLSpecifics.java:175)
      at dk.netarkivet.harvester.datamodel.DBSpecifics.updateTable(DBSpecifics.java:212)
      at dk.netarkivet.harvester.datamodel.DomainDBDAO.<init>(DomainDBDAO.java:83)
      at dk.netarkivet.harvester.datamodel.DomainDAO.getInstance(DomainDAO.java:58)
      at dk.netarkivet.harvester.webinterface.DefinitionsSiteSection.initialize(DefinitionsSiteSection.java:110)
      at dk.netarkivet.common.webinterface.GUIWebServer.addWebApplication(GUIWebServer.java:156)
      at dk.netarkivet.common.webinterface.GUIWebServer.<init>(GUIWebServer.java:100)
      at dk.netarkivet.common.webinterface.GUIWebServer.getInstance(GUIWebServer.java:120)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at dk.netarkivet.common.utils.ApplicationUtils.startApp(ApplicationUtils.java:155)
      at dk.netarkivet.common.webinterface.GUIApplication.main(GUIApplication.java:39)
      End of SQLException trace

      Attachments

        Activity

          People

            svc Søren Vejrup Carlsen (Inactive)
            svc Søren Vejrup Carlsen (Inactive)
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: