Help needed with database transaction errors

Friday 26 August 2005 9:57:06 pm

I want to enable database transactions on a site but I am receiving fatal transaction errors but strangely only on the user siteacess. I have logged in with the admin user account on both the administrative and user siteaccess. But I only ever receive transaction errors on the user side. This happens about 50% of the time when performing edits. I guess that points to something wrong in my templates or ini settings but I can not for the life of me find it yet. I would appreciate some tips on how to track this problem down. I seem to get two different specific errors which are as follows:

Notice: eZMySQLDB::query(0.000 ms) query number per page:0  	Aug 27 2005 14:07:04

SET NAMES 'latin1'

Timing: 	Aug 27 2005 14:07:04

Module start 'content'

Error: eZMySQLDB 	Aug 27 2005 14:07:04

Query error: Deadlock found when trying to get lock; try restarting transaction. Query: INSERT INTO ezcontentobject_attribute (id, contentobject_id, version, language_code, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES('13025', '1359', '3', 'eng-GB', '209', '0', '0', '', 'ezstring', '', NULL, '0.000000')
	
Error: eZDBInterface::commit TRANSID-6d77cb515918c2c6a1b5ab283a940a2a 	Aug 27 2005 14:07:04

Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-6d77cb515918c2c6a1b5ab283a940a2a.

and

Module start 'content'

Error: eZMySQLDB 	Aug 27 2005 12:35:09

Query error: Duplicate entry '13003-6' for key 1. Query: INSERT INTO ezcontentobject_attribute (id, contentobject_id, version, language_code, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES('13003', '1357', '6', 'eng-GB', '209', '0', '0', 'test 2', 'ezstring', 'test 2', NULL, '0.000000')

Error: eZDBInterface::commit TRANSID-0e7cda51b6b1f809a3138fba5e425e20 	Aug 27 2005 12:35:09

Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-0e7cda51b6b1f809a3138fba5e425e20.

When I see a get a fatal db transaction like this if I click reload it then successfully loads 100% of the time. Can any suggest how I can find the reason?

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.