Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2008, 01:58 PM
shlomot's Avatar
shlomot shlomot is offline
 
Join Date: Apr 2007
Location: Haifa, Israel
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Can't create a new thread (errno 11)

Hello,

A new error message has arrive on my forum for the past few days, and users are complaining that, from time to time they are being kicked out when submitting a PM, but the submission usually succeeds the second time around.

The error email that I'm getting is below and has to do with database connectivity. Can any one help me with a good advice on how to troubleshoot this issue? The problem is that the problem occurs randomly and only a very few times a day. That's why both the host and myself have a hard time pin-pointing the source.

Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: #HY000Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug /home/a/2/4/5231/5231/public_html/includes/class_core.php on line 311

MySQL Error   : 
Error Number  : 
Request Date  : Monday, May 19th 2008 @ 09:40:49 AM
Error Date    : Monday, May 19th 2008 @ 09:40:49 AM
Script        : http://www.topsynergy.net/external.php?type=js&lastpost=1
Referrer      : 
IP Address    : 134.2.166.30
Username      : 
Classname     : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 05-19-2008, 02:18 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OS error code 11: Resource temporarily unavailable

Your host should be able to resolve this.
Reply With Quote
  #3  
Old 05-19-2008, 02:27 PM
shlomot's Avatar
shlomot shlomot is offline
 
Join Date: Apr 2007
Location: Haifa, Israel
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello Marco van Herwaarden, long time no talk

My host requires me to provide a means to test the problem and to be able to regenerate it.

Due to the random occurance, they do not manage to replicate this error. Any idea?

Quote:
Originally Posted by Marco van Herwaarden View Post
OS error code 11: Resource temporarily unavailable

Your host should be able to resolve this.
Reply With Quote
  #4  
Old 05-19-2008, 03:13 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have you tried going to the Script page that produced the error - http://www.yoursite.net/external.php?type=js&lastpost=1 (your site name edited out)? I just did and it's a mess of text. Perhaps fix that script and see if you no longer get the errors.
Reply With Quote
  #5  
Old 05-19-2008, 03:54 PM
shlomot's Avatar
shlomot shlomot is offline
 
Join Date: Apr 2007
Location: Haifa, Israel
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm sorry for my ignorance, Lynne, but I never have touched that page. Besides errors are being issued from that page as well as from:
showthread.php; cron.php (referred from this page), private.php (referred from this page), private.php?do=showpm, etc.

Thanks for your help

Quote:
Originally Posted by Lynne View Post
Have you tried going to the Script page that produced the error - http://www.yoursite.net/external.php?type=js&lastpost=1 (your site name edited out)? I just did and it's a mess of text. Perhaps fix that script and see if you no longer get the errors.
Reply With Quote
  #6  
Old 05-19-2008, 04:19 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know that you will be able to reproduce the problem consistently as it is an error because of your server specs. When you reach a certain 'limit', you get the error. Read up on it here: http://www.jigsawboys.com/2006/04/13...read-errno-11/ and http://forums.powweb.com/showthread.php?t=78318 and
Reply With Quote
  #7  
Old 05-19-2008, 04:26 PM
shlomot's Avatar
shlomot shlomot is offline
 
Join Date: Apr 2007
Location: Haifa, Israel
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a lot for your kind help and dedication to the cause. I'll read this information and get back to you if something is still unclear or if I gained some insight that may help other members as well. Thanks again.

Quote:
Originally Posted by Lynne View Post
I don't know that you will be able to reproduce the problem consistently as it is an error because of your server specs. When you reach a certain 'limit', you get the error. Read up on it here: http://www.jigsawboys.com/2006/04/13...read-errno-11/ and http://forums.powweb.com/showthread.php?t=78318 and
--------------- Added 05/20/2008 at 08:40 ---------------

Current status report:

Resolving the issue has taken three steps, all psycological by nature, no technical experise required:

1. Understand from supportive members (see previous posts) that this is a pure OS resources issue.

2. Getting a really annoying letter from HostWay that the correct way to avoid such issues in the future is to buy a dedicated server from them.

3. Sending them back a real nasty letter about the apparent deterioration on their customer orientation and a fearsome dilapidation of their professional capabilities.

Follow these three steps and your database connectivity issues may vanished as mine

Thanks, guys & gals for your support.
Reply With Quote
  #8  
Old 05-20-2008, 08:48 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You forget step 2b: Backup everything of your forum and store ofline.

(Wouldn't be the first time i see a host cancel the account - with all the data - when a customer complains too much.)
Reply With Quote
  #9  
Old 05-20-2008, 09:03 AM
shlomot's Avatar
shlomot shlomot is offline
 
Join Date: Apr 2007
Location: Haifa, Israel
Posts: 246
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Marco. I just hope that the fact that we are paying over $500/mo. for our dedicated Windows hosting and quite a few shared domains will keep them from doing just that

I wonder if a discussion can be started over sharing and voting member experiences and recommendations regarding hosts?

Quote:
Originally Posted by Marco van Herwaarden View Post
You forget step 2b: Backup everything of your forum and store ofline.

(Wouldn't be the first time i see a host cancel the account - with all the data - when a customer complains too much.)
Reply With Quote
  #10  
Old 05-20-2008, 09:16 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We don't have a Hosting Discussions forum on vBulletin.org anymore.

Please where you could start such a discussion:
- (vB.com) vBulletin Hosting Options
- Webhostingtalk.com
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 10:45 AM.


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.04578 seconds
  • Memory Usage 2,257KB
  • 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
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete