Details
-
Bug
-
Resolution: Fixed
-
High
-
4.7.0, 5.0, 5.1.0beta1
-
Server OS: Red Hat 6.4
PHP: 5.3.3
Database: MySQL 5.1.61
Browser: Firefox 20.0
Description
1. Create 200 000 articles
2. Add new attribute to the articles class
3. Run script monitor cronjob
4. Verify the the articles have the new field
5. Verify you don't have the following error in error.log
[ Apr 19 2013 10:54:27 ] [pedro.cleverti.qa.ezpublish.no] eZMySQLiDB: Query error (1206): The total number of locks exceeds the lock table size. Query: INSERT INTO ezcontentobject_attribute( contentobject_id, version, contentclassattribute_id, data_type_string, language_code, language_id ) SELECT a.contentobject_id, a.version, 183, 'ezisbn', a.language_code, MAX(a.language_id) FROM ezcontentobject_attribute a, ezcontentobject o WHERE o.id = a.contentobject_id AND o.contentclass_id=2 GROUP BY contentobject_id, version, language_code [ Apr 19 2013 10:55:03 ] [pedro.cleverti.qa.ezpublish.no] eZMySQLiDB: Query error (1206): The total number of locks exceeds the lock table size. Query: UPDATE ezcontentobject_attribute, ( SELECT contentobject_id, language_code, version, contentclassattribute_id, MIN( id ) AS minid FROM ezcontentobject_attribute WHERE contentclassattribute_id = 183 GROUP BY contentobject_id, language_code, version, contentclassattribute_id ) t SET ezcontentobject_attribute.id = t.minid WHERE ezcontentobject_attribute.contentobject_id = t.contentobject_id AND ezcontentobject_attribute.language_code = t.language_code AND ezcontentobject_attribute.contentclassattribute_id = 183