Announcement

Collapse
No announcement yet.

Fatal error after several Database errors

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

  • Fatal error after several Database errors

    Hi,

    after several database errors - e.g. the last one:

    Invalid SQL:
    /** saveDbCache */ INSERT INTO cache (cacheid,expires,created,locktime,serialized,data)
    VALUES
    ('vB_CommonRoutes', 1599810367, 1599723967, 0, '1', 'a:6:{s:8:"homepage";a:15:{s:7:"routeid";s:3:"172";s:4:"name";s:4:"home";s:11:" redirect301";N;s:6:"prefix";s:8:"homepage";s:5:"regex";s:8:"homepage";s:5:"class ";s:17:"vB5_Route_Channel";s:10:"controller";s:4:"page";s:6:"action";s:5:"index\ ";s:8:"template";s:0:"";s:9:"arguments";s:51:"a:2:{s:9:"channelid";s:1:"1";s:6: "pageid";s:1:"1";}";s:9:"contentid";s:1:"1";s:4:"guid";s:33:"vbulletin-4ecbdacd6a4ad0.58738735";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";s:1:"1" ;s:6:"length";i:8;}s:5:"forum";a:15:{s:7:"routeid";s:2:"54";s:4:"name";N;s:11:" redirect301";N;s:6:"prefix";s:5:"forum";s:5:"regex";s:40:"forum(??:/|^)page(?P<pagenum>[0-9]+))?";s:5:"class";s:17:"vB5_Route_Channel";s:10:"controller";s:4:"page";s:6:"act ion";s:5:"index";s:8:"template";s:0:"";s:9:"arguments";s:90:"a:4:{s:9:"channeli d";i:2;s:6:"nodeid";i:2;s:7:"pagenum";s:8:"$pagenum";s:6:"pageid";i:39;}";s:9:" contentid";s:1:"2";s:4:"guid";s:33:"vbulletin-5e11b0363f2d29.50922125";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";N;s:6:"l ength";i:5;}s:24:"special/visitor-messages";a:15:{s:7:"routeid";s:2:"56";s:4:"name";N;s:11:"redirect301";N;s:6:"pr efix";s:24:"special/visitor-messages";s:5:"regex";s:59:"special/visitor-messages(??:/|^)page(?P<pagenum>[0-9]+))?";s:5:"class";s:17:"vB5_Route_Channel";s:10:"controller";s:4:"page";s:6:"act ion";s:5:"index";s:8:"template";s:0:"";s:9:"arguments";s:90:"a:4:{s:9:"channeli d";i:7;s:6:"nodeid";i:7;s:7:"pagenum";s:8:"$pagenum";s:6:"pageid";i:41;}";s:9:" contentid";s:1:"7";s:4:"guid";s:33:"vbulletin-5e11b036accb72.85453626";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";N;s:6:"l ength";i:24;}s:5:"blogs";a:15:{s:7:"routeid";s:2:"31";s:4:"name";s:4:"blog";s:1 1:"redirect301";N;s:6:"prefix";s:5:"blogs";s:5:"regex";s:40:"blogs(??:/|^)page(?P<pagenum>[0-9]+))?";s:5:"class";s:14:"vB5_Route_Page";s:10:"controller";s:4:"page";s:6:"action ";s:5:"index";s:8:"template";s:0:"";s:9:"arguments";s:81:"a:3:{s:7:"pagenum";s :8:"$pagenum";s:9:"channelid";s:1:"3";s:6:"pageid";s:2:"17";}";s:9:"contentid\ ";s:2:"17";s:4:"guid";s:33:"vbulletin-4ecbdacd6aac05.50909926";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";N;s:6:"l ength";i:5;}s:13:"social-groups";a:15:{s:7:"routeid";s:2:"35";s:4:"name";s:6:"sghome";s:11:"redirect301" ;N;s:6:"prefix";s:13:"social-groups";s:5:"regex";s:48:"social-groups(??:/|^)page(?P<pagenum>[0-9]+))?";s:5:"class";s:14:"vB5_Route_Page";s:10:"controller";s:4:"page";s:6:"action ";s:5:"index";s:8:"template";s:0:"";s:9:"arguments";s:81:"a:3:{s:7:"pagenum";s :8:"$pagenum";s:9:"channelid";s:1:"4";s:6:"pageid";s:2:"21";}";s:9:"contentid\ ";s:2:"21";s:4:"guid";s:33:"vbulletin-4ecbdac93742a5.43676037";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";N;s:6:"l ength";i:13;}s:24:"special/private-messages";a:15:{s:7:"routeid";s:2:"58";s:4:"name";N;s:11:"redirect301";N;s:6:"pr efix";s:24:"special/private-messages";s:5:"regex";s:59:"special/private-messages(??:/|^)page(?P<pagenum>[0-9]+))?";s:5:"class";s:17:"vB5_Route_Channel";s:10:"controller";s:4:"page";s:6:"act ion";s:5:"index";s:8:"template";s:0:"";s:9:"arguments";s:90:"a:4:{s:9:"channeli d";i:8;s:6:"nodeid";i:8;s:7:"pagenum";s:8:"$pagenum";s:6:"pageid";i:43;}";s:9:" contentid";s:1:"8";s:4:"guid";s:33:"vbulletin-5e11b0372541b6.84455370";s:7:"product";s:9:"vbulletin";s:11:"ishomeroute";N;s:6:"l ength";i:24;}}')
    I now have a fatal error if visiting my site at http://forum.napoleon-online.de

    I'm really unhappy with the whole construction of vbulletin, as always problems with updates and now I got this fatal error.

    How could I reach the admin section?

    Thank you for any help
    Markus Stein

  • #2
    The fatal error doesn't happen any more ... but how could I "repair" the boards?

    Thank you
    Markus Stein

    Comment


    • #3
      And here are the next two database errors:

      Database error in vBulletin 5.6.2:

      Invalid SQL:
      UPDATE session SET `lastactivity`=1599724550,`styleid`=6,`languageid`=2
      WHERE (`sessionhash` = 'dcb4b244836c66b691a8e132a23a10c1')
      /**session**/;

      MySQL Error : Lock wait timeout exceeded; try restarting transaction
      Error Number : 1205
      Request Date : Thursday, September 10th 2020 @ 09:55:50 AM
      Error Date : Thursday, September 10th 2020 @ 09:56:41 AM
      Script : http://forum.napoleon-online.de/...
      Referrer :
      IP Address : 85.25.185.103
      Username : Gast
      Classname : vB_Database_MySQLi
      MySQL Version :


      Stack Trace:
      #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.phpon line 1207
      #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
      #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 561
      #3 vB_Database->query_write() called in phar://[path]/vb/vb.phar/db/query/update.php on line 104
      #4 vB_dB_Query_Update->doUpdates() called in phar://[path]/vb/vb.phar/db/query/update.php on line 89
      #5 vB_dB_Query_Update->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
      #6 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/db/assertor.php on line 530
      #7 vB_dB_Assertor->update() called in phar://[path]/vb/vb.phar/session.php on line 611
      #8 vB_Session->save() called in phar://[path]/vb/vb.phar/shutdown.php on line 86
      #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
      #10 vB::shutdown() called in on line
      And

      Database error in vBulletin 5.6.2:

      Invalid SQL:
      UPDATE session SET `lastactivity`=1599724710,`styleid`=6,`languageid`=2
      WHERE (`sessionhash` = 'dcb4b244836c66b691a8e132a23a10c1')
      /**session**/;

      MySQL Error : Lock wait timeout exceeded; try restarting transaction
      Error Number : 1205
      Request Date : Thursday, September 10th 2020 @ 09:58:30 AM
      Error Date : Thursday, September 10th 2020 @ 09:59:21 AM
      Script : http://www.forum.napoleon-online.de/...
      Referrer :
      IP Address : 85.25.185.103
      Username : Gast
      Classname : vB_Database_MySQLi
      MySQL Version :


      Stack Trace:
      #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.phpon line 1207
      #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
      #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 561
      #3 vB_Database->query_write() called in phar://[path]/vb/vb.phar/db/query/update.php on line 104
      #4 vB_dB_Query_Update->doUpdates() called in phar://[path]/vb/vb.phar/db/query/update.php on line 89
      #5 vB_dB_Query_Update->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
      #6 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/db/assertor.php on line 530
      #7 vB_dB_Assertor->update() called in phar://[path]/vb/vb.phar/session.php on line 611
      #8 vB_Session->save() called in phar://[path]/vb/vb.phar/shutdown.php on line 86
      #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 483
      #10 vB::shutdown() called in on line

      My actual version is 5.6.2 - now I try to get in the administration and switch the board offf ... and hope to get some hints from the board here.

      Thank you
      Markus Stein
      Last edited by naponline; Thu 10 Sep '20, 7:51am.

      Comment


      • #4
        And after having succeeded in switching off the board I wanted to delete the system cache ... received a fatal error again:

        Fatal error: Uncaught Error: Call to a member function hasAdminPermission() on null in phar:///homepages/1/d16368409/htdocs/forum/core/vb/vb.phar/api/wrapper.php:254 Stack trace: #0 /homepages/1/d16368409/htdocs/forum/includes/api/interface/collapsed.php(105): vB_Api_Wrapper->__call('fetchCurrentUse...', Array) #1 /homepages/1/d16368409/htdocs/forum/includes/vb5/user.php(52): Api_Interface_Collapsed->callApi('user', 'fetchCurrentUse...', Array) #2 /homepages/1/d16368409/htdocs/forum/includes/vb5/user.php(41): vB5_User->__construct() #3 /homepages/1/d16368409/htdocs/forum/includes/vb5/user.php(76): vB5_User::instance() #4 /homepages/1/d16368409/htdocs/forum/includes/vb5/string.php(406): vB5_User::get('lang_charset') #5 /homepages/1/d16368409/htdocs/forum/includes/vb5/applicationabstract.php(562): vB5_String::getCharset() #6 /homepages/1/d16368409/htdocs/forum/includes/vb5/applicationabstract.php(480): vB5_ApplicationAbstract::setCharset() #7 /homepages/1/d16368409/htdocs/forum/includes/vb5/applicationabstract.php(636): vB5 in phar:///homepages/1/d16368409/htdocs/forum/core/vb/vb.phar/api/wrapper.php on line 254
        I'll stop to post more error / database messages and hope that anybody may help ... thank you and greetings from Berlin

        Markus Stein

        Comment


        • #5
          It seems, that everything works fine again - didn't get any notifications again. So I dare to reopen the board.

          And in case you have ideas what happened I'd like to know your opinion about these errors.

          Thank you
          Markus Stein

          Comment


          • #6
            Just a short feedback after a "restart" of these database/fatal errors - I phoned with the technical support of my webspace provider (Ionos in Germany) and they felt uncomfortable as some technicians obviously caused these errors and promised to stop them. So perhaps other boards running at Ionos may be conflicted in a similar way.

            I hope that the board will run without complications for a longer period :-)

            Greetings from Berlin
            Markus Stein

            Comment


            • #7
              MySQL Error : Lock wait timeout exceeded; try restarting transaction
              These are caused by the database getting into a state where it cannot finish the transaction of adding new nodes to the database. Unfortunately, this is extremely difficult to reproduce in testing. We've never actually been able to do so. This means we haven't found the queries that could put a database into the state. From past reports, the issue seems to occur more often on MariaDB installations than on MySQL installations. This could mean that it is due to an INNODB bug that didn't have its fix ported over to MariaDB.

              The recommendation here are:
              1. To increase the innodb_lock_wait_timeout value to at least 120 seconds (the default value is 50).
              2. Start your server with the --innodb-rollback-on-timeout option.
              3. Increase the wait_timeout value to 120 seconds (default is much higher).
              4. Make sure all vBulletin tables except language, phrase, and userfield are using INNODB if you're using MySQL 5.6 or MariaDB less than 10.3.
              5. Delete your system cache regularly. There is a Scheduled Task addon over a www.vbulletin.org for this purpose.
              Translations provided by Google.

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

              Comment


              • #8
                Dear Wayne,

                again thank you very much for your detailed answer ... unfortunately I'm not able to change the settings of my mySQL settings (same for PHP), as I'm using a shared environment at my provider. But I'm still thinking about renting a vServer in order to get more influence on these technical points.

                But your help is useful, so if the problems reappear, I'll send the recommendations to my provider.

                Greetings from Berlin
                Markus Stein

                Comment

                Related Topics

                Collapse

                Working...
                X