Announcement

Collapse
No announcement yet.

Database errors at vb5 and vb4 forum even after moving to more powerful server

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

  • Database errors at vb5 and vb4 forum even after moving to more powerful server

    I wasn't getting any database errors then we turned PHP-FM off and the errors started pouring in. However, we had to turn PHP-FM off to address a different issue and I never had it on at my prior server.

    I realize you always say this is a server problem, but I am on a new server at Liquid Web with now 8Gb (versus 2Gb before) and 8 core (versus 2 core before) and still stacks of database errors are coming in.

    There may be something wrong with my database? that perhaps has to do with that it is upgraded from vb3. It doesn't make sense that a forum with as little traffic as mine (no more than a couple hundred logged on at the same time, and usually more like a hundred) would have all these problems on a 8 core VPS.

    (errors below are truncated, too long to post here)

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_64199_lvl1data' AND event = 'nodeChg_64199') OR
    (cacheid = 'node_64200_lvl1data' AND event = 'nodeChg_64200') OR
    (cacheid = 'node_64201_lvl1data' AND event = 'nodeChg_64201') OR
    (cacheid = 'node_64202_lvl1data' AND event = 'nodeChg_64202') OR
    (cacheid = 'node_64203_lvl1data' AND event = 'nodeChg_64203') OR
    (cacheid = 'node_64204_lvl1data' AND event = 'nodeChg_64204') OR
    (cacheid = 'node_64205_lvl1data' AND event = 'nodeChg_64205') OR

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    /** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
    VALUES
    ('node_132_lvl1data', 1573486984, 1573400584, 0, '1', 'a:57:{s:6:"nodeid";s:3:"132";s:7:"routeid";s:2:"91";s:13:"contenttypeid";s:2:"20";s:11:"p ublishdate";s:10:"1237530543";s:13:"unpublishdate";s:1:"0";s:6:"userid";s:1:"1";s:7:"group id";N;s:10:"authorname";s:5:"XXXXX";s:11:"description";N;s:5:"title";s:84:"XXXXXXXX";s:9 :" htmltitle";s:84:"MC___ suspension

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT * FROM cache
    WHERE `cacheid` IN ('node_1_lvl1data');

    MySQL Error : MySQL server has gone away

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT * FROM cache
    WHERE `cacheid` IN ('vB_UserPerms1');

    MySQL Error :

    Database error in vBulletin 5.5.5:

    Invalid SQL:
    SELECT `title`,`textonly`,`template_un`,`template` FROM template
    WHERE `templateid` IN (25551);

    MySQL Error : MySQL server has gone away

    ---
    also in my vb4 forum

    Database error in vBulletin :

    mysqli_real_connect(): (HY000/2002): Connection refused
    /home/XXX/public_html/XXXX.com/forums/includes/class_core.php on line 1351
    Last edited by MDawg; Sun 10th Nov '19, 9:36am.

  • #2
    We re-implemented PHP-FM for the vb5 forum, made some tweaks, and are hoping this will resolve. For now, the database errors have settled down.

    Comment


    • #3
      A MySQL Gone Away error means that MySQL closed the connection before returning the results of the query. There are many reasons for this. However, they all go back to MySQL Resources. Make sure you buffers, timeouts, and settings can support your database. Unfortunately, we don't have anyone on the staff that can provide server optimization at this time.
      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
        After re-implementing PHP-FM and doing some tweaking, the only database error that seems to be recurring is a cache event one:

        Database error in vBulletin 5.5.5:

        Invalid SQL:
        /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
        ('node_91016_lvl1data','nodeChg_91016'),
        ('node_90852_lvl1data','nodeChg_90852'),
        ('node_90633_lvl1data','nodeChg_90633'),
        ('node_90492_lvl1data','nodeChg_90492'),
        ('node_90462_lvl1data','nodeChg_90462'),
        .
        .
        .

        ('node_64260_lvl1data','nodeChg_64260'),
        ('node_64347_lvl1data','nodeChg_64347'),
        ('node_64207_lvl1data','nodeChg_64207'),
        ('node_64206_lvl1data','nodeChg_64206');

        MySQL Error : Deadlock found when trying to get lock; try restarting transaction
        Error Number : 1213
        Request Date : Wednesday, November 13th 2019 @ 06:11:08 AM
        Error Date : Wednesday, November 13th 2019 @ 06:11:11 AM
        Script : XXX
        Referrer :
        IP Address : 64.91.XXX.37
        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 7214
        #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

        ---

        Truncating this table doesn't seem to prevent the error from recurring.

        Comment


        • #5
          Restart MySQL to clear the locks. I am guessing your MySQL installation is the basic installation and not optimized to actually be used as production database.

          https://www.mysql.com/news-and-event...or-mysql-2019/
          https://www.mysql.com/why-mysql/performance/index.html
          https://www.percona.com/blog/2016/10...-installation/

          Do you have PHP opcache installed? Memcached? Have you thought about offloading search to Sphinx Server?

          Though, I have to admit that I know nothing about PHP-FPM. We use mod_php here.
          Last edited by Wayne Luke; Wed 13th Nov '19, 9:43am.
          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

          Related Topics

          Collapse

          Working...
          X