Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #11  
Old 09-28-2012, 06:37 PM
MegaManSec MegaManSec is offline
 
Join Date: Aug 2011
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PM me what the error is please.
And yes, I can atleast load the website now. but database error.
Reply With Quote
  #12  
Old 09-28-2012, 06:43 PM
Mark_Zuckerberg Mark_Zuckerberg is offline
 
Join Date: Sep 2011
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

pm sent to you please check
Reply With Quote
  #13  
Old 09-28-2012, 07:26 PM
MegaManSec MegaManSec is offline
 
Join Date: Aug 2011
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry I forgot about this.

edit your mysql config file and raise max_user_connections to something higher than it currently is.
You should probably check your logs and find out what is causing it..
Then you can block them from your website.
Reply With Quote
  #14  
Old 09-28-2012, 07:30 PM
Mark_Zuckerberg Mark_Zuckerberg is offline
 
Join Date: Sep 2011
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i am getting mails again and again the users are from same ip range and the site is giving database error
Reply With Quote
  #15  
Old 09-28-2012, 07:32 PM
MegaManSec MegaManSec is offline
 
Join Date: Aug 2011
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what is the 'common' ip address? like the ip address that is most likely causing the problem?
Reply With Quote
  #16  
Old 09-28-2012, 07:40 PM
Mark_Zuckerberg Mark_Zuckerberg is offline
 
Join Date: Sep 2011
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

lastly i have installed this mod will it be the reason or not

Code:
https://vborg.vbsupport.ru/showthread.php?t=267506
The ip is 180.76.5.89 and so on changes the last 2 digits

--------------- Added [DATE]1348864877[/DATE] at [TIME]1348864877[/TIME] ---------------

i have blocked the ips of china as this ip os from china
Reply With Quote
  #17  
Old 09-28-2012, 08:13 PM
MegaManSec MegaManSec is offline
 
Join Date: Aug 2011
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's baidu spider.. that shouldn't be a problem.
Are there any other 'common' ip address's?
Reply With Quote
  #18  
Old 09-28-2012, 08:22 PM
Mark_Zuckerberg Mark_Zuckerberg is offline
 
Join Date: Sep 2011
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hosting guy said

Quote:
It appears multiple connections are being made to the database and not being killed off, causing the database not to be able to service any new requests. The site is up at this time. I would advise to reach out to you web developer in regards to this issue.
--------------- Added [DATE]1348867922[/DATE] at [TIME]1348867922[/TIME] ---------------

he also send me some recommendations which are this

Quote:
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 32M)
join_buffer_size (> 1.0M, or always use indexes with joins)
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
what should i do know can you help me out?
Reply With Quote
  #19  
Old 09-28-2012, 08:34 PM
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
Location: Riverside, California USA
Posts: 1,080
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.
Reply With Quote
  #20  
Old 09-28-2012, 08:39 PM
Mark_Zuckerberg Mark_Zuckerberg is offline
 
Join Date: Sep 2011
Posts: 195
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by CAG CheechDogg View Post
Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.
how can i find that any path details?
Reply With Quote
Reply


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:27 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07102 seconds
  • Memory Usage 2,253KB
  • Queries Executed 11 (?)
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)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete