SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • None
    • Affects Version/s: None
    • Component/s: None

      problem

      On migration scripts affecting large tables like LEK_segment_data it can happen that the script fails with:

      exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size' in /webs/in cludes/ZendFramework-1.12.9-minimal/library/Zend/Db/Statement/Pdo.php:228

      solution

      1. edit /etc/my.cnf
      2. add the line
        innodb_buffer_pool_size=64MB
      3. Restart the MySQL server

      See: https://stackoverflow.com/questions/6901108/the-total-number-of-locks-exceeds-the-lock-table-size

            Assignee:
            Thomas Lauria
            Reporter:
            Thomas Lauria
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: