Jason Senich
|
Wednesday 26 April 2006 2:50:19 pm
I am running into the same issue with creating different content objects. The problems disappears for a little while after restarting mysql but then the problem returns. Does anybody know what could be causing this or how to fix. My SQL output is below:
-------------------------- Timing: Apr 26 2006 17:32:32 Module start 'content' Notice: eZMySQLDB::query(1 rows, 1.386 ms) query number per page:3 Apr 26 2006 17:32:32
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name,
ezcontentclass.identifier as class_identifier
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id IN ( 42920 ) AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and ezcontentobject_name.content_translation = 'eng-US' Notice: eZMySQLDB::query(1 rows, 0.565 ms) query number per page:3 Apr 26 2006 17:32:32
SELECT id, version, name, identifier, contentobject_name, creator_id, modifier_id,
created, remote_id, modified, is_container
FROM ezcontentclass
WHERE id='20' AND version='0'
ORDER BY version ASC LIMIT 0, 2 Notice: eZMySQLDB::query(0 rows, 0.209 ms) query number per page:4 Apr 26 2006 17:32:32 BEGIN WORK Notice: eZMySQLDB::query(7 rows, 0.797 ms) query number per page:5 Apr 26 2006 17:32:32
SELECT id, name, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE contentclass_id='20' AND version='0' ORDER BY placement ASC Notice: eZMySQLDB::query(1 rows, 0.476 ms) query number per page:6 Apr 26 2006 17:32:32 INSERT INTO ezcontentobject (section_id, owner_id, contentclass_id, name, is_published, published, modified, current_version, status, remote_id) VALUES('6', '10', '20', 'New Comment (IHE)', '0', '0', '0', '1', '0', '6bbbc2e2d94d3413a13e08ba89748d2c') Notice: eZMySQLDB::query(1 rows, 0.406 ms) query number per page:7 Apr 26 2006 17:32:32
SELECT id, name, locale
FROM ezcontent_translation ORDER BY id ASC Notice: eZMySQLDB::query(0 rows, 0.388 ms) query number per page:8 Apr 26 2006 17:32:32 DELETE FROM ezcontentobject_name WHERE contentobject_id = 56074 and content_version = 1 and content_translation ='eng-US' Notice: eZMySQLDB::query(-1 rows, 120,353.104 ms) query number per page:9 Apr 26 2006 17:32:32
INSERT INTO ezcontentobject_name( contentobject_id,
name,
content_version,
content_translation,
real_translation )
VALUES( '56074',
'New Comment (IHE)',
'1',
'eng-US', 'eng-US' ) Error: eZMySQLDB Apr 26 2006 17:32:32
Query error: Lock wait timeout exceeded; try restarting transaction. Query: INSERT INTO ezcontentobject_name( contentobject_id,
name,
content_version,
content_translation,
real_translation )
VALUES( '56074',
'New Comment (IHE)',
'1',
'eng-US', 'eng-US' ) Notice: eZMySQLDB::query(0 rows, 0.258 ms) query number per page:10 Apr 26 2006 17:32:32 UNLOCK TABLES Error: eZDBInterface::commit TRANSID-2d2b9233df4becb807fb5b289b0cdd30 Apr 26 2006 17:32:32 Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-2d2b9233df4becb807fb5b289b0cdd30. Notice: eZMySQLDB::query(0 rows, 0.267 ms) query number per page:11 Apr 26 2006 17:32:32 ROLLBACK ------------------
|