autoescala
06-15-2012, 07:04 AM
Dear sirs,
Recently, we have lot of problems with or Vbulletin software, every day, we have 3 o 4 big errors "503" with no service, after we update to 4.2 PL1
The ISP says the cause is about a bad or very slow query from "content.php"
The response of ISP: (copy/paste)
"We have analyzed precisely the code 503 refers to us and we see that this code is generated by running:
SCRIPT_FILENAME = content.php
We see that sometimes this script may be running over 20 minutes, causing the server, for security reasons and to avoid saturation of your account, returns the code 503 to generate more requests are not on it that do not end or take a long time.
___________________________________
Here are the logs I debug from vbullletin:
Database error in vBulletin 4.2.0:
Invalid SQL:
REPLACE INTO cache
SET cacheid = 'widget_29.fcf5670fd46d373d20bfa5f6daa40f2b',
expires = 1339691318,
created = 1339691018,
locktime = 0,
data = "a:1:{s:5:\"items\";b:0;}",
serialized = '1';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 14th 2012 @ 06:23:38 PM
Error Date : Thursday, June 14th 2012 @ 06:29:49 PM
Script : http://www.myweb.net/content.php
Referrer :
IP Address : 88.25.57.113
Username : joanmarc89
Classname : vB_Database
MySQL Version :
================================================== ===
Database error in vBulletin 4.2.0:
Invalid SQL:
REPLACE INTO cache
SET cacheid = 'widget_29.fcf5670fd46d373d20bfa5f6daa40f2b',
expires = 1339691320,
created = 1339691020,
locktime = 0,
data = "a:1:{s:5:\"items\";b:0;}",
serialized = '1';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 14th 2012 @ 06:23:40 PM
Error Date : Thursday, June 14th 2012 @ 06:29:51 PM
Script : http://www.myweb/content.php/167-joanpere
Referrer :
IP Address : 213.186.127.12
Username : No Registrado
Classname : vB_Database
MySQL Version :
================================================== ===
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, June 15th 2012 @ 08:36:02 AM
Error Date : Friday, June 15th 2012 @ 08:42:12 AM
Script : http://www.myweb/content.php
Referrer : http://www.myweb/login.php?do=login
IP Address : 85.91.71.252
Username : je7sietes
Classname : vB_Database
MySQL Version :
Any help will be apreciated!
Recently, we have lot of problems with or Vbulletin software, every day, we have 3 o 4 big errors "503" with no service, after we update to 4.2 PL1
The ISP says the cause is about a bad or very slow query from "content.php"
The response of ISP: (copy/paste)
"We have analyzed precisely the code 503 refers to us and we see that this code is generated by running:
SCRIPT_FILENAME = content.php
We see that sometimes this script may be running over 20 minutes, causing the server, for security reasons and to avoid saturation of your account, returns the code 503 to generate more requests are not on it that do not end or take a long time.
___________________________________
Here are the logs I debug from vbullletin:
Database error in vBulletin 4.2.0:
Invalid SQL:
REPLACE INTO cache
SET cacheid = 'widget_29.fcf5670fd46d373d20bfa5f6daa40f2b',
expires = 1339691318,
created = 1339691018,
locktime = 0,
data = "a:1:{s:5:\"items\";b:0;}",
serialized = '1';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 14th 2012 @ 06:23:38 PM
Error Date : Thursday, June 14th 2012 @ 06:29:49 PM
Script : http://www.myweb.net/content.php
Referrer :
IP Address : 88.25.57.113
Username : joanmarc89
Classname : vB_Database
MySQL Version :
================================================== ===
Database error in vBulletin 4.2.0:
Invalid SQL:
REPLACE INTO cache
SET cacheid = 'widget_29.fcf5670fd46d373d20bfa5f6daa40f2b',
expires = 1339691320,
created = 1339691020,
locktime = 0,
data = "a:1:{s:5:\"items\";b:0;}",
serialized = '1';
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 14th 2012 @ 06:23:40 PM
Error Date : Thursday, June 14th 2012 @ 06:29:51 PM
Script : http://www.myweb/content.php/167-joanpere
Referrer :
IP Address : 213.186.127.12
Username : No Registrado
Classname : vB_Database
MySQL Version :
================================================== ===
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, June 15th 2012 @ 08:36:02 AM
Error Date : Friday, June 15th 2012 @ 08:42:12 AM
Script : http://www.myweb/content.php
Referrer : http://www.myweb/login.php?do=login
IP Address : 85.91.71.252
Username : je7sietes
Classname : vB_Database
MySQL Version :
Any help will be apreciated!