Announcement

Collapse
No announcement yet.

Slow posting since 5.5.3

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

  • Slow posting since 5.5.3

    Since upgrading to 5.5.3 (and now running 5.5.4) I have some users complaining that posting and creating threads in some threads and forums take roughly two minutes to post.

    What information can I provide to pinpoint where this is coming from?

    I never get an email with a database error until last night:

    Database error in vBulletin 5.5.4:

    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'vB_Announcements_1' AND event = 'nodeChg_1') OR
    (cacheid = 'vB_Announcements_1' AND event = 'vB_AnnouncementChg') OR
    (cacheid = 'vbnodetext1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591753') OR
    (cacheid = 'vbnodetext1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
    (cacheid = 'vbnodetext1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591755') OR
    (cacheid = 'vbnodetext1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
    (cacheid = 'vbnodetext1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591756') OR
    (cacheid = 'vbnodetext1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
    (cacheid = 'vbnodetext_pre_1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591753') OR
    (cacheid = 'vbnodetext_pre_1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext_pre_1591753_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
    (cacheid = 'vbnodetext_pre_1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591755') OR
    (cacheid = 'vbnodetext_pre_1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext_pre_1591755_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
    (cacheid = 'vbnodetext_pre_1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_1591756') OR
    (cacheid = 'vbnodetext_pre_1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_51') OR
    (cacheid = 'vbnodetext_pre_1591756_108_4:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Tuesday, October 1st 2019 @ 12:33:49 AM
    Error Date : Tuesday, October 1st 2019 @ 12:34:43 AM
    Script : /forum/
    Referrer :
    IP Address : xx.xxx.xx.xxx
    Username : Prof. 9
    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 7111
    #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
    Clear your cache in the AdminCP. Maintenance -> Clear System Cache.
    Last edited by Wayne Luke; Mon 14 Dec '20, 8:06am.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      Clear you cache in the AdminCP. Maintenance -> Clear System Cache.
      That's it. Since some weeks there are no database errors anymore.
      Many thanks Wayne Luke.

      Comment

      Related Topics

      Collapse

      Working...
      X