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

SQL Error During harvestDatabaseUpdate (TEST7)

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.2
    • Component/s: PostgreSQL, Test
    • Labels:
      None
    • Verification:
      Hide

      This can be verified by running an update file and checksum information job for a checksum-replica. The GUIApplication log should no longer show an SQL error and stacktrace when the job is completed.

      Show
      This can be verified by running an update file and checksum information job for a checksum-replica. The GUIApplication log should no longer show an SQL error and stacktrace when the job is completed.

      Description

      At https://sbforge.org/display/NAS/TEST+7#TEST7-Upgradethedatabase in TEST7, the log has several errors like:

      [test@kb-test-adm-001 TEST7]$ cat start_harvestdatabaseUpdateApplication.log 
      Beginning database upgrade at Thu Aug 08 11:01:00 CEST 2013
      log4j:WARN No appenders could be found for logger (com.mchange.v2.log.MLog).
      log4j:WARN Please initialize the log4j system properly.
      Aug 8, 2013 11:02:01 AM dk.netarkivet.common.utils.DBUtils rollbackIfNeeded
      WARNING: SQL error doing rollback after updating table with SQL:  ALTER TABLE domains ALTER COLUMN crawlertraps type text;UPDATE schemaversions SET version = 3 WHERE tablename = 'domains''.
      SQLException trace:
      SQL State:25P01
      Error Code:0
      org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled.
      	at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:842)
      	at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
      	at dk.netarkivet.common.utils.DBUtils.rollbackIfNeeded(DBUtils.java:734)
      

      I'm slighty worried about the "Cannot rollback when autoCommit is enabled" but more worried as to why it's trying to roll back at all.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                csr Colin Rosenthal
                Reporter:
                csr Colin Rosenthal
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: