vb5_nodehash Table is Crashing Periodically

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jaredyates
    New Member
    • Sep 2014
    • 16
    • 5.7.0

    vb5_nodehash Table is Crashing Periodically

    I can't figure out exactly what leads to it, but sometimes it takes a few weeks and sometimes it takes a few hours to get one of these error messages:

    Database error in vBulletin 5.2.2:

    Invalid SQL:
    SELECT * FROM vb5_nodehash
    WHERE `dupehash` = 3922050991 AND `userid` = 77 AND `dateline` > 1467564152
    LIMIT 1;

    MySQL Error : Table './[ourdatabasename]/vb5_nodehash' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Sunday, July 3rd 2016 @ 09:47:32 AM
    Error Date : Sunday, July 3rd 2016 @ 09:47:32 AM
    Script : http:///create-content/text/
    Referrer : http://bearhawkforums.com/forum/bear...o-buck-a-rivet
    IP Address : [IP is here]
    Username : [username is here]
    Classname : vB_Database_MySQLi
    MySQL Version :


    When I manually repair and optimize the table, it starts working again, perhaps for a few weeks or perhaps for a few hours. I can setup a cron job to periodically fix the table, but is there a way to try and get to the bottom of what is causing the error?
  • jaredyates
    New Member
    • Sep 2014
    • 16
    • 5.7.0

    #2
    I'd appreciate any help and can provide more diagnostics if I know where to look. Even with the daily cron job this is still a problem at times.

    Comment

    • Zachery
      Former vBulletin Support
      • Jul 2002
      • 59097

      #3
      tables shouldn't crash periodically or at all. I suspect something else is at work causing the issue. If it was an issue with a query or operation in vBulletin I'd think the issue would be more wide spread.

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        As Zachery mentions, this shouldn't be happening. You should speak to your host about it.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • jaredyates
          New Member
          • Sep 2014
          • 16
          • 5.7.0

          #5
          Thanks for the info. After 26 messages back and forth with Dreamhost, the most plausible explanation is that they are killing processes on the shared server when usage gets high. Frustratingly, I'm still not sure that this is the problem, and don't have an appealing path forward, short of changing hosts.

          Comment

          Related Topics

          Collapse

          Working...