Announcement

Collapse
No announcement yet.

Database error in vBulletin 5.2.0:

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

  • Database error in vBulletin 5.2.0:

    Sometimes i got a database error e mail like this and the site is going extremely slow.

    How can i fix it?


    Database error in vBulletin 5.2.0:

    Invalid SQL:
    UPDATE session SET `lastactivity`=1456713172,`languageid`=19
    WHERE (`sessionhash` = 'ed531481f0bf5431f5fb5833053c8e17')
    /**session**/;

    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Monday, February 29th 2016 @ 04:32:52 AM
    Error Date : Monday, February 29th 2016 @ 04:33:48 AM
    Script : http:///showthread.php/639-Plastik-T...&mode=threaded
    Referrer :
    IP Address : 136.243.36.80
    Username : Misafir
    Classname : vB_Database_MySQLi
    MySQL Version :


    Database error in vBulletin 5.2.0:

    Invalid SQL:
    INSERT INTO searchtowords_b (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (8530,14359,0,10000,5)
    /**searchtowords_b**/;

    MySQL Error : Duplicate entry '14359-8530' for key 'wordid'
    Error Number : 1062
    Request Date : Monday, February 29th 2016 @ 11:09:15 PM
    Error Date : Monday, February 29th 2016 @ 11:10:49 PM
    Script : http:///uploader/saveattachmentsetting
    Referrer : http://www.okuloncem.com/forum/etkin...bulutlar%C4%B1
    IP Address : 176.33.126.90
    Username : dygylmzz
    Classname : vB_Database_MySQLi
    MySQL Version : 5.5.44-cll-lve


    Database error in vBulletin 5.2.0:

    Invalid SQL:
    UPDATE session SET `lastactivity`=1456628309,`styleid`=12,`languageid`=19
    WHERE (`sessionhash` = 'dbd7b3c0bc27cc3b7424e2003dcba802')
    /**session**/;

    MySQL Error : Lock wait timeout exceeded; try restarting transaction
    Error Number : 1205
    Request Date : Sunday, February 28th 2016 @ 04:58:29 AM
    Error Date : Sunday, February 28th 2016 @ 05:01:02 AM
    Script :
    http:///robots.txt
    Referrer :
    IP Address : 157.55.39.89
    Username : Misafir
    Classname : vB_Database_MySQLi
    MySQL Version :

  • #2
    I would try repair optimize your tables, and also in the general update tools -> run Delete duplicate topics.

    did you just upgrade recently? because you should run the rebuild topics, search index's and others after upgrading your forums from an older version.

    I think in your admincp information block tells you to do this when upgrading.

    Comment


    • #3
      Originally posted by cjg9590 View Post
      I would try repair optimize your tables, and also in the general update tools -> run Delete duplicate topics.

      did you just upgrade recently? because you should run the rebuild topics, search index's and others after upgrading your forums from an older version.

      I think in your admincp information block tells you to do this when upgrading.
      I've optimized tables in vbulletin and phpmyadmin.
      I was getting the same error before the update. I'm using vbulletin 5.2.0 patch level 1 and still have same errors.

      Comment


      • #4
        This means a transaction was waiting to get a lock on one of the tables, most likely the session table.

        In this instance, as the data in the session table is not site critical, it may be worth emptying the session table and see if that helps. Sometimes it gets bloated, although it is supposed to clear itself over time.

        Run this query:

        DELETE FROM session

        NOTE: Do not run DELETE queries on any other table - you will break your site!
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.6 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          Originally posted by Mark.B View Post
          This means a transaction was waiting to get a lock on one of the tables, most likely the session table.

          In this instance, as the data in the session table is not site critical, it may be worth emptying the session table and see if that helps. Sometimes it gets bloated, although it is supposed to clear itself over time.

          Run this query:

          DELETE FROM session

          NOTE: Do not run DELETE queries on any other table - you will break your site!
          Thank you, Mark. Now it looks good.

          Comment


          • #6
            Originally posted by Mark.B View Post
            This means a transaction was waiting to get a lock on one of the tables, most likely the session table.

            In this instance, as the data in the session table is not site critical, it may be worth emptying the session table and see if that helps. Sometimes it gets bloated, although it is supposed to clear itself over time.

            Run this query:

            DELETE FROM session

            NOTE: Do not run DELETE queries on any other table - you will break your site!
            Mark, I got another error today.

            Database error in vBulletin 5.2.0:

            Invalid SQL:
            /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
            ('getSearchResults_e5a5a3321c25b5219e30df300ec38d1d','perms_changed'),
            ('getSearchResults_e5a5a3321c25b5219e30df300ec38d1d','vB_ChannelStructure_chg'),
            ('getSearchResults_e5a5a3321c25b5219e30df300ec38d1d','vB_SearchResults_chg_0'),
            ('getSearchResults_e5a5a3321c25b5219e30df300ec38d1d','nodeChg_1359'),
            ('getSearchResults_3a039e8a95bff0bf8072f2cce86234d1','perms_changed'),
            ('getSearchResults_3a039e8a95bff0bf8072f2cce86234d1','vB_ChannelStructure_chg'),
            ('getSearchResults_3a039e8a95bff0bf8072f2cce86234d1','vB_SearchResults_chg_0'),
            ('getSearchResults_3a039e8a95bff0bf8072f2cce86234d1','nodeChg_65'),
            ('vbPre_conversation164.147.65.1359','');

            MySQL Error : Lock wait timeout exceeded; try restarting transaction
            Error Number : 1205
            Request Date : Wednesday, March 2nd 2016 @ 05:20:21 AM
            Error Date : Wednesday, March 2nd 2016 @ 05:25:09 AM
            Script : http:///forum/soru-cevap/bilgi-edinme/1359-çocuklarla-evde-oynayabileceğiniz-oyunlar
            Referrer :
            IP Address : 51.255.65.32
            Username : Misafir
            Classname : vB_Database_MySQLi
            MySQL Version :


            Database error in vBulletin 5.2.0:

            Invalid SQL:
            /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
            ('getSearchResults_16d20649f35ba43ada8370007ce63a5e','perms_changed'),
            ('getSearchResults_16d20649f35ba43ada8370007ce63a5e','vB_ChannelStructure_chg'),
            ('getSearchResults_16d20649f35ba43ada8370007ce63a5e','vB_SearchResults_chg_0'),
            ('getSearchResults_16d20649f35ba43ada8370007ce63a5e','nodeChg_8563'),
            ('getSearchResults_7e42faaa6cdae904a5da02097c49b6b9','perms_changed'),
            ('getSearchResults_7e42faaa6cdae904a5da02097c49b6b9','vB_ChannelStructure_chg'),
            ('getSearchResults_7e42faaa6cdae904a5da02097c49b6b9','vB_SearchResults_chg_0'),
            ('getSearchResults_7e42faaa6cdae904a5da02097c49b6b9','nodeChg_39'),
            ('vbPre_conversation112.95.39.8563','');

            MySQL Error : Lock wait timeout exceeded; try restarting transaction
            Error Number : 1205
            Request Date : Wednesday, March 2nd 2016 @ 01:00:37 AM
            Error Date : Wednesday, March 2nd 2016 @ 01:02:13 AM
            Script : http:///forum/öğretmenler-odasi/günlük-etkinlik-havuzu/8563-çocuklarin-boy-nasil-uzar-sorusuna-etkinlik-ile-cevap-verme
            Referrer :
            http://m.facebook.com/
            IP Address : 78.175.86.51
            Username : Misafir
            Classname : vB_Database_MySQLi
            MySQL Version :

            Comment


            • #7
              You can do the same with the following two tables ONLY:

              DELETE FROM cache
              DELETE FROM cacheevent

              MARK.B | vBULLETIN SUPPORT

              TalkNewsUK - My vBulletin 5.5.6 Demo
              AdminAmmo - My Cloud Demo

              Comment


              • #8
                Originally posted by Mark.B View Post
                You can do the same with the following two tables ONLY:

                DELETE FROM cache
                DELETE FROM cacheevent
                Thank you Mark.

                Comment


                • #9
                  Originally posted by Mark.B View Post
                  You can do the same with the following two tables ONLY:

                  DELETE FROM cache
                  DELETE FROM cacheevent


                  Mark,

                  When i do DELETE FROM cache and DELETE FROM cacheevent i got 8 error mails

                  Database error in vBulletin 5.2.0:
                  [Showing truncated query, original length: 2429]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_9177434d8f17d9aab5335d4542afc585' AND event = 'nodeChg_30') OR
                  (cacheid = 'getSearchResults_9177434d8f17d9aab5335d4542afc585' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_9177434d8f17d9aab5335d4542afc585' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_9177434d8f17d9aab5335d4542afc585' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'getSearchResults_92ae10e84
                  [Last 500 chars]
                  4_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_8614') OR
                  (cacheid = 'vbnodetext8614_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_8614_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_30') OR
                  (cacheid = 'vbnodetext_pre_8614_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_8614') OR
                  (cacheid = 'vbnodetext_pre_8614_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:04 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:54:57 PM
                  Script : http:///forum/etkinlik-odasi/türkçe-dil-etkinlikleri/8614-örnek-film-şeridi-hazırlama
                  Referrer : http://m.facebook.com/
                  IP Address : 88.243.213.237
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:



                  [Showing truncated query, original length: 3127]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'nodeChg_999') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'getSearchResults_97e32b93
                  [Last 500 chars]
                  text999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_84') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:09 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:02 PM
                  Script : http:///forum/etkinlik-odasi/sanat-etkinlikleri/artik-materyaller/999-artık-materyallerden-akvaryum-yapımı
                  Referrer : https://www.google.com.tr/
                  IP Address : 88.237.159.29
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:



                  [Showing truncated query, original length: 3127]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'nodeChg_999') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'getSearchResults_97e32b93
                  [Last 500 chars]
                  text999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_84') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:35 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:28 PM
                  Script : http:///forum/etkinlik-odasi/sanat-etkinlikleri/artik-materyaller/999-artık-materyallerden-akvaryum-yapımı
                  Referrer : http://www.google.com/search?q=okul+...HfrICyoQ_AUIBQ
                  IP Address : 78.169.234.208
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:



                  [Showing truncated query, original length: 2723]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_1b6ff1eaed919061dc43c11642c6a9dc' AND event = 'nodeChg_89') OR
                  (cacheid = 'getSearchResults_1b6ff1eaed919061dc43c11642c6a9dc' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_1b6ff1eaed919061dc43c11642c6a9dc' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_1b6ff1eaed919061dc43c11642c6a9dc' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'getSearchResults_a8fcaf214
                  [Last 500 chars]
                  etext379_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_89') OR
                  (cacheid = 'vbnodetext379_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_379_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_379') OR
                  (cacheid = 'vbnodetext_pre_379_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_89') OR
                  (cacheid = 'vbnodetext_pre_379_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:39 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:36 PM
                  Script : http:///forum/etkinlik-odasi/türkçe-dil-etkinlikleri/bilmeceler/379-yüzlerce-bilmece
                  Referrer : https://www.google.com.tr/
                  IP Address : 78.184.115.57
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:



                  [Showing truncated query, original length: 3127]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'nodeChg_999') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_30298a1db29dbca7f20ec14ebc938d06' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'getSearchResults_97e32b93
                  [Last 500 chars]
                  text999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_84') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_999') OR
                  (cacheid = 'vbnodetext_pre_999_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:45 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:38 PM
                  Script : http:///forum/etkinlik-odasi/sanat-etkinlikleri/artik-materyaller/999-artık-materyallerden-akvaryum-yapımı
                  Referrer : http://www.google.com/search?q=okul+...HfrICyoQ_AUIBQ
                  IP Address : 78.169.234.208
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:


                  Invalid SQL:
                  /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
                  ('vB_UserPerms7677','userPerms_7677'),
                  ('vB_UserPerms7677','userChg_7677'),
                  ('vB_UserPerms7677','perms_changed'),
                  ('vB_UserPerms7677','vB_ChannelStructure_chg'),
                  ('getSearchResults_c1dc2d136593ebc841664bc3dbd8d677','perms_changed'),
                  ('getSearchResults_c1dc2d136593ebc841664bc3dbd8d677','vB_ChannelStructure_chg'),
                  ('getSearchResults_c1dc2d136593ebc841664bc3dbd8d677','vB_SearchResults_chg_0');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:26 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:44 PM
                  Script : http:///member/7677-filizfiliz
                  Referrer :
                  IP Address : 68.180.229.152
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:


                  Invalid SQL:
                  /** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
                  ('vB_UserPerms1517','userPerms_1517'),
                  ('vB_UserPerms1517','userChg_1517'),
                  ('vB_UserPerms1517','perms_changed'),
                  ('vB_UserPerms1517','vB_ChannelStructure_chg'),
                  ('getSearchResults_4fe903c31f8c21b60f664a3cc357de46','perms_changed'),
                  ('getSearchResults_4fe903c31f8c21b60f664a3cc357de46','vB_ChannelStructure_chg'),
                  ('getSearchResults_4fe903c31f8c21b60f664a3cc357de46','vB_SearchResults_chg_0');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:26 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:43 PM
                  Script : http:///member/1517-esragltekin
                  Referrer :
                  IP Address : 157.55.39.3
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :

                  Database error in vBulletin 5.2.0:



                  [Showing truncated query, original length: 2144]
                  [First 500 chars]
                  Invalid SQL:
                  /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_97e32b93f2cb27188661c0b3ce81cd3c' AND event = 'nodeChg_84') OR
                  (cacheid = 'getSearchResults_97e32b93f2cb27188661c0b3ce81cd3c' AND event = 'perms_changed') OR
                  (cacheid = 'getSearchResults_97e32b93f2cb27188661c0b3ce81cd3c' AND event = 'vB_ChannelStructure_chg') OR
                  (cacheid = 'getSearchResults_97e32b93f2cb27188661c0b3ce81cd3c' AND event = 'vB_SearchResults_chg_0') OR
                  (cacheid = 'node_2380_lvl1data' AND ev
                  [Last 500 chars]
                  etext305_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_84') OR
                  (cacheid = 'vbnodetext305_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache') OR
                  (cacheid = 'vbnodetext_pre_305_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_305') OR
                  (cacheid = 'vbnodetext_pre_305_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'nodeChg_84') OR
                  (cacheid = 'vbnodetext_pre_305_12_0:963474f4a512e7c80c23b609c6e6cefc' AND event = 'vB_Language_languageCache');

                  MySQL Error : Lock wait timeout exceeded; try restarting transaction
                  Error Number : 1205
                  Request Date : Wednesday, March 2nd 2016 @ 03:54:51 PM
                  Error Date : Wednesday, March 2nd 2016 @ 03:55:44 PM
                  Script : http:///forum/etkinlik-odasi/sanat-etkinlikleri/artik-materyaller/305-kelebek-yapımı
                  Referrer :
                  IP Address : 5.46.254.76
                  Username : Misafir
                  Classname : vB_Database_MySQLi
                  MySQL Version :


                  Comment


                  • #10
                    You're going to need to run that by your host....if your server won't even let you run a simple query then it's a server issue rather than a vBulletin issue. Sorry.
                    MARK.B | vBULLETIN SUPPORT

                    TalkNewsUK - My vBulletin 5.5.6 Demo
                    AdminAmmo - My Cloud Demo

                    Comment


                    • #11
                      If you had problems with your database before you upgraded, you should have fixed those first. Upgrading was not going to repair your site or database, if you have a corrupt db you may need to find a backup to resort to. Did you do anything to your server or phpadmin which created the db problem to begin with? some of those querys look like they are missing parts to the cacheid.

                      look close at each table with an error the first line is invalid.


                      cacheid = 'vbnodetext999_ << this one is missing the _pre_999
                      cacheid = 'vbnodetext_pre_999 << here this looks correct compared to the others within the table

                      that's just a guess on my part as i did not look into the tables in vb to see if mine are the same. but if that's your problem your whole database could be corrupt.

                      Comment


                      • #12
                        Hi Mark,

                        We recently upgraded the vBulletin version to 5.2.1 and we are facing a very critical issue of site performance. It takes more 20 seconds to complete the page. More over getting lot of emails by saying the database issues. An example is



                        Database error in vBulletin 5.2.1:

                        Invalid SQL:

                        REPLACE INTO wfi_searchlog
                        (type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,resu lts,results_count)
                        VALUES
                        ('0','0','66.249.69.184','7981b93bc19883e0197ce0f5531326ea','created','asc','0.00165796279 90723','1465476972','0','{"sort":{"created":"ASC"},"channel":"40587","depth":1,"include_st arter":1,"ignore_protected":1,"nolimit":1}','40587,1464316,1464331,1464353','4');

                        MySQL Error : Lock wait timeout exceeded; try restarting transaction
                        Error Number : 1205
                        Request Date : Thursday, June 9th 2016 @ 02:56:12 PM
                        Error Date : Thursday, June 9th 2016 @ 02:57:03 PM
                        Script : LInk to page
                        Referrer :
                        IP Address : 66.249.69.184
                        Username : Gast
                        Classname : vB_Database_MySQLi
                        MySQL Version :



                        Could you please check and reply whats the solution for solving this serious issue. Thanks

                        Comment


                        • #13
                          The transaction is hitting the innodb_lock_wait_timeout value. This is a server issue, and you should contact your hosts.
                          MARK.B | vBULLETIN SUPPORT

                          TalkNewsUK - My vBulletin 5.5.6 Demo
                          AdminAmmo - My Cloud Demo

                          Comment


                          • #14
                            Hi Mark,
                            Thanks for the reply. I have increased the innodb_lock_wait_timeout value. Now i didnt get such emails yet. But my vBulletin 5.2.1 is facing extreme slow especially in the message center pages. Can you give some ideas for increasing the page performance. Thanks

                            Comment

                            Related Topics

                            Collapse

                            Working...
                            X