Fatal error: A database transaction in eZ Publish failed.

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?

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.

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