Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 06-15-2012, 07:04 AM
autoescala autoescala is offline
 
Join Date: Oct 2011
Posts: 101
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default HELP plz: the CMS crash my server on VB 4.2 PL1

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!
Reply With Quote
  #2  
Old 06-15-2012, 01:33 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think it would be better if you started a ticket at your vb client 's desk about this so the vb staff can investigate this further.
Reply With Quote
  #3  
Old 06-15-2012, 02:28 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What is your widget 29 (you'll have to look that up in the cms_widget table)? Is it custom? Have you tried removing it from your page to see if you still have the same problem?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:36 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05085 seconds
  • Memory Usage 2,173KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete