[#CONF-1710] Upgrade failed: Can't call commit when autocommit=true

Confluence

Upgrade failed: Can't call commit when autocommit=true

Created: 24/Aug/04 02:57 AM Updated: 24/Aug/04 02:59 AM

Component/s:

None

Affects Version/s:

1.0.1, 1.0.2, 1.0.3

Fix Version/s:

1.2

Time Tracking:

Not Specified

Participants:	Dave Loeng [Atlassian]
Since last comment:	4 years, 45 weeks ago
Resolution Date:	24/Aug/04 02:59 AM
Labels:

Description

« Hide

If you are running against a MySQL database and upgrading Confluence from 1.0.x to 1.1.x, you may encounter the following error:

2004-06-29 11:09:11,052 ERROR [bucket.upgrade.UpgradeManager] Upgrade failed: Can't call commit when autocommit=true
java.sql.SQLException: Can't call commit when autocommit=true
at com.mysql.jdbc.Connection.commit(Connection.java:1175)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:248)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:244)
at com.atlassian.confluence.upgrade.VersionedAttachmentDatabaseUpgradeTask.updateAttachmentsTable(VersionedAttachmentDatabaseUpgradeTask.java:71)
at com.atlassian.confluence.upgrade.VersionedAttachmentDatabaseUpgradeTask.doUpgrade(VersionedAttachmentDatabaseUpgradeTask.java:41)

All

Comments

Work Log

Change History

Sort Order:

[ Permalink | « Hide ]

Dave Loeng [Atlassian] added a comment - 24/Aug/04 02:59 AM

This error can be fixed by adding:

&relaxAutoCommit=true

to the end of your JDBC url.

Example:
jdbc:mysql://localhost/confdb?autoReconnect=true&relaxAutoCommit=true

This JDBC url can be found in your confluence.cfg.xml file located in your confluence home folder.