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