Constantly getting "SMF Database Error!" emails

hiwd · February 19, 2013, 06:52:13 AM

Hi all,

I am constantly getting an "SMF Database Error!" email from the forum. I have checked the forum logs and there is nothing in releation to a database error.

Also I have checked the MySQL server and all looks like, the site is never not accessable and is always running quickly, so I don't think it is a server side issue.

Anyone know if there is other ways of looking into this?

Cheers.

Kindred · February 19, 2013, 07:29:52 AM

well, there will not be any error in the forum error log since that requires the database to store it.

you can always check with your host....

Ricky. · February 19, 2013, 07:34:48 AM

Let me give you more info, I used to get that error from one of my smf forum when suddenly there was a spike in load and MySQL server restarts and for few moments its is not accessible and thats when I used to get that error.

I solved that problem by moving my that forum to better server.

hiwd · February 19, 2013, 02:48:47 PM

This is a dedicated server I have root access to. It only has a hand full of web sites on it and a pretty good spec. I have been watching server load and check logs, MySQL is not going down. I installed fresh copy of SMF on a new hosting account on the same server and have not been getting emails from that.

I'm just a bit stumped where to look next.

Ricky. · February 20, 2013, 12:51:01 AM

Well, this issue probably goes into server performance section and also you should check stickies there.

hiwd · February 20, 2013, 06:18:49 AM

I have made tweaks to MySQL config, adjust max load/connections and have been monitoring it. It is not going down yet I am still getting email's. The forum is not running slow and I have never seen a database issue.

I also upgraded MySQL to the latest stable verison along with PHP and I'm stilll getting emails at least once an hour.

LiroyvH · February 20, 2013, 07:52:33 AM

Means there still is an issue with your mySQL server that makes SMF be unable to connect to it.

What is your mySQL connection limit set to and do you use persisting connections in SMF?

hiwd · February 20, 2013, 08:32:11 AM

Hi,

Persistent connection is not enabled but I will give it a try.

Max connections is currently set to 500.

Thank you for the replies.

Ricky. · February 20, 2013, 08:50:21 AM

Every tried following:
https://launchpad.net/mysql-tuning-primer

hiwd · February 20, 2013, 08:57:27 AM

Quote from: Ricky. on February 20, 2013, 08:50:21 AM
Every tried following:
https://launchpad.net/mysql-tuning-primer

Thank you. I will take a look.

LiroyvH · February 20, 2013, 09:14:13 AM

I wouldn't enable persistent but you can give it a try nontheless, lol.

I'd up the maximum connections to a higher count, see if it helps.

Try something like 1024 for starters.

hiwd · February 20, 2013, 10:52:18 AM

Thank you. I have upped the max connections to 1024 and enabled persistent for now, its a dedicated server with only a handfull of other very small web sites so should be ok. I will continue monitoring.

No email's the last hour anyway.

hiwd · February 20, 2013, 02:35:03 PM

No email's since 2PM GMT today, thank you for the help guys. Really appreciate it.

Ricky. · February 20, 2013, 11:31:02 PM

Glad to know that, it simply means you were reaching your max connection limit. Have you looked into script I mentioned ?

hiwd · February 21, 2013, 04:25:41 AM

Quote from: Ricky. on February 20, 2013, 11:31:02 PM
Glad to know that, it simply means you were reaching your max connection limit. Have you looked into script I mentioned ?

I have not had a chance yet, I was planning to trial it later today. Thanks again.

butch2k · February 28, 2013, 02:33:16 AM

How many Apache workers did you declare ?

News:

Constantly getting "SMF Database Error!" emails