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

SQL Error During harvestDatabaseUpdate (TEST7)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 4.2
    • None
    • PostgreSQL, Test
    • None
    • 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

          mentioned in

          Page Loading...

          Activity

            People

              csr Colin Rosenthal
              csr Colin Rosenthal
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: