MySQL server has gone away [2006]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
ayudame
Registered User
Posts: 4
Joined: Mon Dec 03, 2007 5:15 pm

Re: MySQL server has gone away [2006]

Post by ayudame » Tue Dec 04, 2007 7:44 am

I put in a support ticket to bluehost which included a link to this thread... and they responded with this reply: [great tech support I must say...they answered the call in 8 seconds - at MidPhase 25-45 minutes]

Dear Customer,
This is a commonly misunderstood issue. The error you are seeing is caused by a number of things relating to the settings or configuration of your script. The most common reason that you will see this error, on our servers, is that your connection to the MySQL database is timing out and being disconnected while the script that is calling it is working on other things, like FTP uploads and the like. There is a 45 second limit on idle connections to the MySQL database. An idle connection is one in which no data is being accessed or written.

Related to this, but not quite the same, is that persistent MySQL connections will not work on our server. It is pretty much guaranteed that a continuous connection to the MySQL database will lie idle for more than 45 seconds at some point. When this happens the connection is closed, and the script only realizes this when it tries to use the connection the next time. This is the easier of the two issues, as you would simply turn off the setting for persistent connections in your script.
Sincerely, Craig Coxson - Level I Support - BlueHost.com

So...not knowing how this code works...is there something I can change to make it work on their servers?
while the script that is calling it is working on other things
Is the script doing other things or is the call that processes display_custom_bbcodes() running linier?

Or is this level I tech just sending me a "canned response"?

Mickey14
Registered User
Posts: 88
Joined: Sat Mar 05, 2005 10:45 am

Re: MySQL server has gone away [2006]

Post by Mickey14 » Tue Dec 04, 2007 8:12 am

I think the new config PHPBB_DB_NEW_LINK may help here, or am I wrong ?

DudeWoofie
Registered User
Posts: 136
Joined: Sat Oct 13, 2007 1:20 am
Location: Venice CA
Contact:

Re: MySQL server has gone away [2006]

Post by DudeWoofie » Tue Dec 04, 2007 4:06 pm

Bluehost's response still doesn't address or explain - to my neophyte mind, anyway - the reasoning behind why this problem just started.

I am in the process of switching hosts and will post a followup when complete.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29252
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: MySQL server has gone away [2006]

Post by Marshalrusty » Wed Dec 05, 2007 1:35 am

Mickey14 wrote::lol: I chose hostmonster because it is recommended everywhere here by phpBB team...
Hmm? We have a policy of not recommending hosts. Nowhere will you find any hosting recommendations on this site.

Advertisements (if that's what you're referring to) are in no way endorsements.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

DudeWoofie
Registered User
Posts: 136
Joined: Sat Oct 13, 2007 1:20 am
Location: Venice CA
Contact:

Re: MySQL server has gone away [2006]

Post by DudeWoofie » Wed Dec 05, 2007 5:32 am

Migration to new host has been completed as of a couple hours ago. So far, all systems go.

No changes were made nor required in my cPanel. I'll be sure and update here if things go south again.

User avatar
lurttinen
Translator
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka
Contact:

Re: MySQL server has gone away [2006]

Post by lurttinen » Wed Dec 05, 2007 5:51 am

Since this is a hostmonster/bluehost you are using. Humor me and do a little test and see if it makes any difference. (For those who still have the "mysql gone away error")

Go to ACP and from there to security settings. Disable the IP checking against DNSBL list.
Submit it and try to post again.

The reason i'm suggesting this is because i have personally "fixed" the mysql gone away error on hostmonster server by just disabling this option.
Signature is here

HellBelly
Registered User
Posts: 31
Joined: Mon Oct 15, 2007 12:06 am

Re: MySQL server has gone away [2006]

Post by HellBelly » Wed Dec 05, 2007 6:29 am

I just want to give my two cents here.

I’ve been running on Blue Host for 2 years now and I just renewed my contract for another 2 years. I ran phpNuke those first two years and recently did the painful conversion over to phpbb 3.0 RC5 back in October I believe. I’ve been steadily keeping up with the RC versions and tonight I just completed RC7 to RC8, without any issues.

All of my users are able to post without issue, no error messages.

Now my box at blue host is running:

PHP Version 4.4.7
MySQL Version 4.1.22

Sure sounds like a PHP versioning issue…

ayudame
Registered User
Posts: 4
Joined: Mon Dec 03, 2007 5:15 pm

Re: MySQL server has gone away [2006]

Post by ayudame » Wed Dec 05, 2007 8:33 pm

HellBelly wrote:Now my box at blue host is running: PHP Version 4.4.7 / MySQL Version 4.1.22
Sure sounds like a PHP versioning issue…
HellBelly...I wonder how you got to keep these versions on your box? :shock:

I guess that's a question for me to ask BH. They just upgraded my box [and I assumed by the support response...EVERY box either had already been upgraded or is in pipe to be].

I'll get back with the reply...

HellBelly
Registered User
Posts: 31
Joined: Mon Oct 15, 2007 12:06 am

Re: MySQL server has gone away [2006]

Post by HellBelly » Thu Dec 06, 2007 1:20 am

I'd appreciate that, if they plan on upgrading my box to php5 then I guess I need to start calling myself before it hoses my site up.

ayudame
Registered User
Posts: 4
Joined: Mon Dec 03, 2007 5:15 pm

Re: MySQL server has gone away [2006]

Post by ayudame » Thu Dec 06, 2007 8:07 pm

lurttinen wrote:Go to ACP and from there to security settings. Disable the IP checking against DNSBL list...Submit it and try to post again.
Tried to post my first post again...received the error.
Disabled the IP checking against DNSBL list.
Tried to post my first post again...Success.

:D Thank-you lurttinen...your quick-fix worked for me...Now I'm back in business.

User avatar
lurttinen
Translator
Posts: 4670
Joined: Tue Sep 21, 2004 12:05 pm
Location: Tampere, Finland
Name: Martti Lokka
Contact:

Re: MySQL server has gone away [2006]

Post by lurttinen » Fri Dec 07, 2007 5:56 am

Great :)
Signature is here

DudeWoofie
Registered User
Posts: 136
Joined: Sat Oct 13, 2007 1:20 am
Location: Venice CA
Contact:

Re: MySQL server has gone away [2006]

Post by DudeWoofie » Fri Dec 07, 2007 6:04 pm

Update: New host up and running with no probs. (No slam against Bluehost... they were just unable to resolve the issue.) New host is running PHP version 4.4.4 so that would appear to be the root of the problem...? (MySQL version is 5.0.37-standard-log; the same as with Bluehost.)

I had already made the switch before lurtinnen posted so wasn't able to try that. Again, though, why would that have been the cause of an out-of-the-blue MySQL error?

neps
Registered User
Posts: 66
Joined: Thu Nov 21, 2002 12:38 pm

Re: MySQL server has gone away [2006]

Post by neps » Sat Dec 15, 2007 3:23 am

trying to upgrade from 2.0.x to 3 and I'm getting this error. i tried raising the timeout from 60 to 180 and eventually to -1 (which it says means no limit) and I still get the error.

I also checked the setting someone mentioned, and I got nothing there either.

Any other suggestions or configs to modify?

User avatar
salty78
Registered User
Posts: 63
Joined: Sat Feb 21, 2004 10:14 am

Re: MySQL server has gone away [2006]

Post by salty78 » Sun Dec 16, 2007 1:39 pm

I'm having the same problem as well and I'm using the XAMPP package locally to do the conversion. It runs great for a while and then once it gets near the end of the PM section I get this error and it refuses to do anything else. I've set the timeout to -1 so I'm not sure what else to do. The board I'm converting has 860,000+ posts
meh

User avatar
raul2010
Registered User
Posts: 14
Joined: Wed Sep 17, 2003 11:17 am
Location: Barcelona
Contact:

Re: MySQL server has gone away [2006]

Post by raul2010 » Mon Dec 17, 2007 1:26 pm

salty78 wrote:I'm having the same problem as well and I'm using the XAMPP package locally to do the conversion. It runs great for a while and then once it gets near the end of the PM section I get this error and it refuses to do anything else. I've set the timeout to -1 so I'm not sure what else to do. The board I'm converting has 860,000+ posts
I'm in the exact same situation here. Only my board is a bit smaller (500.000+ posts)

Edit: I've restarted the conversion, but this time I picked mySQL instead of mySQLi. It has converted all the posts but now I'm wondering if I'll ever be able to switch to mySQLi again.

Locked

Return to “[3.0.x] Support Forum”