HTTP error 500 and a lot of database errors

**William Thomas Jr** · Fri 28 Oct '16, 3:05pm

Originally posted by naszeaudio

Our forum has crashed with HTTP 500 and on email I got 200-300 emails regarding similar db error (as below)
It is generated by the same user and the date is tomorrow date.

Last time it happens my provider said it is application issue and the killed some apache prcesses on the server.
But this is not normal, it has happen in the night and there is noone to help.

Database error in vBulletin 5.2.4:

Invalid SQL:
/** saveDbCache */REPLACE INTO vb_cacheevent (cacheid, event) values
('vB_UserPerms31','userPerms_31'),
('vB_UserPerms31','userChg_31'),
('vB_UserPerms31','perms_changed'),
('vB_UserPerms31','vB_ChannelStructure_chg'),
('vb_UserWPerms_31_4','userPerms_31'),
('vb_UserWPerms_31_4','userChg_31');

MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Saturday, October 29th 2016 @ 12:33:15 AM
Error Date : Saturday, October 29th 2016 @ 12:33:19 AM
Script : http:///chat/loadheaderdata
Referrer : https://naszeaudio.pl/forum/po-godzi...3-turbo/page66
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version :

I have the same issue, and I am unclear whether the emails are coming from vbulletin or my host. My errors are different, but I created a log file and disabled emails but still receive the database emails. Having hundreds of emails blasted on the server creates server load.

William

**William Thomas Jr** · Fri 28 Oct '16, 3:07pm

Have you tried to check yes in admincp options error handling and logging: >> Disable Database Error Email Sending

William

**naszeaudio** · Fri 28 Oct '16, 3:10pm

Thanks William, another bug in vbulletin? This one is crazy. All errors generated by the same user?
I have now around 1000 emails in 45minutes, with 15min gap.

**naszeaudio** · Sat 29 Oct '16, 2:15pm

No help here?

User was Apple OS system (but not the latest) in some hotel, using wifi there... vbulletin any idea where is the gap in the software?

**naszeaudio** · Sat 29 Oct '16, 2:30pm

Today another user, another 500 emails with errors.

Database error in vBulletin 5.2.4:

Invalid SQL:
/** saveDbCache */REPLACE INTO vb_cacheevent (cacheid, event) values
('vB_UserPerms130','userPerms_130'),
('vB_UserPerms130','userChg_130'),
('vB_UserPerms130','perms_changed'),
('vB_UserPerms130','vB_ChannelStructure_chg'),
('vb_UserWPerms_130_4','userPerms_130'),
('vb_UserWPerms_130_4','userChg_130');

MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Saturday, October 29th 2016 @ 11:49:53 PM
Error Date : Saturday, October 29th 2016 @ 11:49:55 PM
Script : http:///chat/loadheaderdata
Referrer : https://naszeaudio.pl/forum/po-godzi...3-turbo/page63
IP Address :
Username : Irek.N.
Classname : vB_Database_MySQLi
MySQL Version :

**naszeaudio** · Sat 29 Oct '16, 2:40pm

And another user, just right now... lots of emails like this

Database error in vBulletin 5.2.4:

Invalid SQL:
/** saveDbCache */ DELETE FROM vb_cacheevent WHERE (cacheid = 'node_11_lvl1data' AND event = 'nodeChg_11') OR
(cacheid = '6f9a3405d7f8c8468440d4b24cc222a5' AND event = 'vB_Language_languageCache') OR
(cacheid = 'vB_CommonRoutes' AND event = 'vB_routesChgMultiple') OR
(cacheid = 'vb_types.types' AND event = 'vb_types.contenttype_updated') OR
(cacheid = 'vb_types.types' AND event = 'vb_types.package_updated') OR
(cacheid = 'vb_types.types' AND event = 'vb_types.type_updated');

MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Sunday, October 30th 2016 @ 12:39:35 AM
Error Date : Sunday, October 30th 2016 @ 12:39:38 AM
Script : http:///chat/loadheaderdata
Referrer : https://naszeaudio.pl/forum/po-godzi...3-turbo/page68
IP Address :
Username : LorinSi
Classname : vB_Database_MySQLi
MySQL Version :

**Maltair** · Mon 31 Oct '16, 8:57am

I was getting these too after the 5.2.4 upgrade and the change to a VPS server, for the vb_cacheevent. The truncated error message is below.

---

Database error in vBulletin 5.2.4:
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values

.
.
.

MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Monday, October 10th 2016 @ 03:48:35 AM
Error Date : Monday, October 10th 2016 @ 03:48:52 AM
Script : http:///forums/forum/XXX
Referrer : IP Address : 192.254.XXX.XXX
Username : Guest

---

Also getting the occasional internal server error 500s.

I have a vbulletin support ticket 1518453 pending on all this.

Also, Hostgator thought it may have something to do with an incomplete upgrade:

<< Site has this recent error:

[30-Oct-2016 03:06:59 UTC] PHP Warning: Declaration of vB_BbCodeParser_PlainText::handle_bbcode_url($text, $link) should be compatible with vB_BbCodeParser::handle_bbcode_url($text, $link, $image = false) in /home/mdawg/public_html/forums/core/includes/class_bbcode_alt.php on line 711

Which is a PHP coding error, although one that looks like it may have resulted from a partial upgrade.

Compare:

/home/mdawg/public_html/forums/core/includes/class_bbcode_alt.php
class vB_BbCodeParser_PlainText extends vB_BbCodeParser
...
function handle_bbcode_url($text, $link)

with:

/home/mdawg/public_html/forums/upload/core/includes/class_bbcode.php
class vB_BbCodeParser
...
function handle_bbcode_url($text, $link, $image = false)
>>

HTTP error 500 and a lot of database errors

HTTP error 500 and a lot of database errors

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Related Topics