Page 1 of 1 [ 9 posts ] 

0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 44
Gender: Male
Posts: 11,038
Location: London

29 Apr 2007, 2:12 pm

There is a sparodic MySQL error

If you haven't done already suggest you check your error log. It might be the dreaded too many connections error. Usually due to persistent connection or connections not timing out. Also check if there has not been any breaches.



Belfast
Veteran
Veteran

User avatar

Joined: 17 Jul 2005
Age: 53
Gender: Female
Posts: 1,802
Location: Windham County, VT

29 Apr 2007, 3:21 pm

0_equals_true wrote:
There is a sparodic MySQL error

If you haven't done already suggest you check your error log. It might be the dreaded too many connections error. Usually due to persistent connection or connections not timing out. Also check if there has not been any breaches.

Am not technologically sophisticated enough to comprehend. Got tossed off WP a couple hours ago (2 p.m. Eastern), with the MySQL error message/page instead. There were less than 500 members online. Yesterday (or the day before), I saw the yellow banner (for the first time) atop the forum index that read WP may be slow because many people are on right now-yet there were under 500. Other times I've seen 600 or 700 members online (according to the lefthand side counter), yet no warning of slowdown. Aggravating when I'm trying to post & cannot. Baffling, unpredictable & inconsistent, it seems.
Then I have to log in again, which means the "new posts since last visit" are reset, and I miss out on the ones from before the error, that I didn't finish getting to look through.


_________________
*"I don't know what it is, but I know what it isn't."*


calandale
Veteran
Veteran

User avatar

Joined: 9 Mar 2007
Gender: Male
Posts: 12,439

29 Apr 2007, 7:43 pm

0_equals_true wrote:
There is a sparodic MySQL error

If you haven't done already suggest you check your error log. It might be the dreaded too many connections error. Usually due to persistent connection or connections not timing out. Also check if there has not been any breaches.


It happens during site updates and maintenance.



0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 44
Gender: Male
Posts: 11,038
Location: London

30 Apr 2007, 5:42 am

Belfast wrote:
0_equals_true wrote:
There is a sparodic MySQL error

If you haven't done already suggest you check your error log. It might be the dreaded too many connections error. Usually due to persistent connection or connections not timing out. Also check if there has not been any breaches.

Am not technologically sophisticated enough to comprehend. Got tossed off WP a couple hours ago (2 p.m. Eastern), with the MySQL error message/page instead. There were less than 500 members online. Yesterday (or the day before), I saw the yellow banner (for the first time) atop the forum index that read WP may be slow because many people are on right now-yet there were under 500. Other times I've seen 600 or 700 members online (according to the lefthand side counter), yet no warning of slowdown. Aggravating when I'm trying to post & cannot. Baffling, unpredictable & inconsistent, it seems.
Then I have to log in again, which means the "new posts since last visit" are reset, and I miss out on the ones from before the error, that I didn't finish getting to look through.

Don't worry I was talking admin.



0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 44
Gender: Male
Posts: 11,038
Location: London

30 Apr 2007, 5:42 am

calandale wrote:
0_equals_true wrote:
There is a sparodic MySQL error

If you haven't done already suggest you check your error log. It might be the dreaded too many connections error. Usually due to persistent connection or connections not timing out. Also check if there has not been any breaches.


It happens during site updates and maintenance.

Sure it can happen for an number of other reasons too.



calandale
Veteran
Veteran

User avatar

Joined: 9 Mar 2007
Gender: Male
Posts: 12,439

30 Apr 2007, 5:55 am

Yeah. But it's the strain of the updates that cause
it. It's a known problem.



shadexiii
Veteran
Veteran

User avatar

Joined: 15 Dec 2006
Age: 41
Gender: Male
Posts: 3,545

30 Apr 2007, 10:16 am

The issue is that it is happening at times not known to be "normal" upgrade / update / backup times. Could have been that anyways, but hard to be sure. He's (didn't check profile so I'm assuming...I know the risk of that blah blah blah) just being cautious about it.

Also, last night's down time seemed really short, maybe it was just me.



calandale
Veteran
Veteran

User avatar

Joined: 9 Mar 2007
Gender: Male
Posts: 12,439

30 Apr 2007, 9:55 pm

I think that Alex moved the update time.
It's NOT been happening when it used to.



0_equals_true
Veteran
Veteran

User avatar

Joined: 5 Apr 2007
Age: 44
Gender: Male
Posts: 11,038
Location: London

01 May 2007, 6:35 am

Can they possibly add something like so we know it is not some random error?

Code:
switch (mysql_errno()) {

// locked table (while flush)
case 1099:
   
   $err_msg = "Database being backed up. Please try later";
   break;
   
// ... whatever

default:
    $err_msg = "A MySQL error occured. Please try later";
}