|
Brendan Pike
|
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.
|