No announcement yet.

experiencing database errors today

  • Filter
  • Time
  • Show
Clear All
new posts

  • experiencing database errors today

    Just home from work to see my forum has experienced several database errors today. Indeed, as I attempted to post to the forum, I received the error below.

    Only recent change to the forum was modifying the charset to UTF-8. I upgraded my forum May 29th and paid for telephone support, but no one is answering.

    Click image for larger version

Name:	databaseerror.png
Views:	91
Size:	7.3 KB
ID:	4393643

    The email I receive from the error looks something like this:

    Database error in vBulletin 5.4.1:
    Invalid SQL:
    UPDATE node AS node
    SET node.lastcontent = CASE WHEN 1529437888 >= node.lastcontent THEN 1529437888 ELSE node.lastcontent END,
    node.lastcontentid = CASE WHEN 1529437888 >= node.lastcontent THEN 1580495 ELSE node.lastcontentid END,
    node.lastcontentauthor = CASE WHEN 1529437888 >= node.lastcontent THEN '-Deborah-' ELSE node.lastcontentauthor END,
    node.lastauthorid = CASE WHEN 1529437888 >= node.lastcontent THEN 3 ELSE node.lastauthorid END
    WHERE node.nodeid IN (1,2,14,16,7508) /**setLastDataParentList**/;
    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Tuesday, June 19th 2018 @ 07:51:28 PM
    Error Date : Tuesday, June 19th 2018 @ 07:52:20 PM

    Any ideas on steps to take to resolve this?

    Thank you.

  • #2
    Additionally, none of my forum/topic info is up to date. Says last post was early today, but newer posts are there. I've cleared System Cache, no change.


    • #3
      What do you have the lock_wait_timeout value set to. The default is the number of seconds in a week. About 350 million or something like that.

      Translations provided by Google.

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


      • #4
        I have no idea Where do I find this setting?


        • #5
          I'm kind of panicking here, can you please tell me if I should rebuild indexes to get the forum/topic information to display properly again? Or is there other action I can take?


          • #6
            lock_wait_timeout is a server setting. If you have never heard of it (which is fine), it is probably best to ask you host for this information.

            For the forum and topic info, rebuild the forum and topic information in AdminCP > Maintenance > General Update Tools.

            TalkNewsUK - My vBulletin 5.7.1 Demo
            AdminAmmo - My Cloud Demo


            • #7
              Thank you, Mark -- that did the trick.

              Wayne, I had my host set the lock wait timeout to 500 for now. Let me know if you feel that could still cause a problem.


              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.