Fatal error: A database transaction in eZ Publish failed.

Author Message

Alexander Trotter

Thursday 18 March 2010 12:50:19 am

Hello everybody,
i get the following error, when trying to publish various nodes in my ezpublish installtion:
Fatal error: A database transaction in eZ Publish failed.
The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-411ebb7e2cc1daadec5f961a8afff413 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.
The error message in the error log is:
eZDBInterface::commit TRANSID-45d2af34c8f58513b380b91bd3f1cf17:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-45d2af34c8f58513b380b91bd3f1cf17.
I'm using ezpublish version 4.0.1 and MySQL 5.
Has anybody come across this error and fixed it successfully?

Steven E. Bailey

Thursday 18 March 2010 2:48:10 am

That's pretty much what you see in your browser when a database transaction fails. What you want to do is look in the eZPublish error log files for that that transaction id and you'll usually get a useful error message from your database server - such as column not found, etc.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

Alexander Trotter

Thursday 18 March 2010 3:06:28 am

Hi,

thanks for your reply.

I already looked into the error.log. It says:

The error message in the error log is:
eZDBInterface::commit TRANSID-45d2af34c8f58513b380b91bd3f1cf17:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-45d2af34c8f58513b380b91bd3f1cf17.

I read that this problem occurs, if the database user doesn't has the right LOCK_TABLES, but I already checked this and it isn't the problem.

Alexander Trotter

Thursday 18 March 2010 3:23:26 am

Just checked with our hosting provider. There isn't an underlying MySQL error in the MySQL error log to this error.

Can anybody point me in the right direction, please?^^

Steven E. Bailey

Thursday 18 March 2010 3:32:05 am

You might want to try DatabaseSettings -> SQLOutput=enabled to see what query is failing.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.