Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20737

EzscriptMonitor - The total number of locks exceeds the lock table size

    XMLWordPrintable

Details

    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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            pedro.resende-obsolete@ez.no Pedro Resende (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 5 hours, 47 minutes
                5h 47m