Announcement

Collapse
No announcement yet.

Lock wait timeout exceeded; try restarting transaction

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lock wait timeout exceeded; try restarting transaction

    I have been getting these db errors on and off since October. My host has raised the timeout innodb_lock_wait_timeout from 120 to 200. And yet it still is occurring, 1-2 times a month. The site is running 5.5.5;
    Server Type Linux Users to Moderate 0
    Web Server Apache Topics to Moderate 0
    PHP 7.2.25 Posts to Moderate 0
    PHP Max Post Size 16.00 MB Number of Queued E-Mails 0
    PHP Maximum Upload Size 2.00 MB MySQL Version 10.2.29-MariaDB
    PHP Memory Limit 256.00 MB MySQL Packet Size 256.00 MB
    Database error in vBulletin 5.5.5:

    Invalid SQL:
    /** saveDbCache */ INSERT INTO vb3cache (cacheid,expires,created,locktime,serialized,data)
    VALUES
    ('vbnodetext327311_23_0:963474f4a512e7c80c23b609c6e6cefc', 1575805961, 1575201161, 0, '0', 'First round was on Allen. Second (winter) round was Haystack on third attempt. Would never have happened without HOL, Turkey, and Jr. Turkey. Both were planned.')
    ,
    ('vbnodetext_pre_327311_23_0:963474f4a512e7c80c23b609c6e6cefc', 1575805961, 1575201161, 0, '0', 'First round was on Allen. Second (winter) round was Haystack on third attempt. Would never have happened without HOL, Turkey, and Jr. Turkey. Both...')
    ,


    ON DUPLICATE KEY UPDATE expires = VALUES(expires), created = VALUES(created),
    locktime = VALUES(locktime), serialized = VALUES(serialized),data = VALUES(data);

    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Sunday, December 1st 2019 @ 11:52:41 AM
    Error Date : Sunday, December 1st 2019 @ 11:56:05 AM
    Script : https://www.websiteinquestion.com/fo...46r-peak/page2
    Referrer :
    IP Address : 46.229.168.138
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :


    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 561
    #3 vB_Database->query_write() called in [path]/vb/db/mysql/querydefs.php on line 7151
    #4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
    #5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 301
    #6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
    #7 vB_Cache_Db->shutdown() called in [path]/vb/shutdown.php on line 93
    #8 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
    #9 vB::shutdown() called in on line

  • #2
    And I just received another error, same descriptors.

    Comment


    • #3
      All I can suggest is to clear your database cache tables and/or restart the database. 1 or 2 times a month wouldn't be crippling the site though. If it crippled the site, you would get 100s of these in rapid succession.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #4
        I think i'll just set up a cronjob to do this.

        Thanks Wayne.

        Comment

        Related Topics

        Collapse

        Working...
        X