Database error in vBulletin 5.2.0:

[Soner3d]

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 :

[cjg9590]

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.

[Soner3d]

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.

[Mark.B]

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!

[Soner3d]

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.

[Soner3d]

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 :

[Mark.B]

You can do the same with the following two tables ONLY:

DELETE FROM cache
DELETE FROM cacheevent

[Soner3d]

You can do the same with the following two tables ONLY:

DELETE FROM cache
DELETE FROM cacheevent

Thank you Mark.

[Soner3d]

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 :

[Mark.B]

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.

[cjg9590]

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.

[moonshiner]

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

[Mark.B]

The transaction is hitting the innodb_lock_wait_timeout value. This is a server issue, and you should contact your hosts.

[moonshiner]

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

[zweeper]

Hey moonshiner, could ou solve this issue at the end somehow?