Page 2 of 2
Re: sporadic error accessing Z
Posted: Wed Sep 03, 2008 3:00 am
by Mary Mungo
Hi,
I've had this error comming up for the last few days and am glad to be able to finally get back on to the site
Cheers
Re: sporadic error accessing Z
Posted: Mon Sep 08, 2008 7:40 am
by John Cooper
Ugh, another whole weekend lost to this error. Sorry for the downtime.
At the time of failure, there are queries running stuck somehow for hours and hours and hours.
As a workaround, I'm going to write a script to periodically run, check for long-running queries, and kill them.
Bug in phpbb3, but the phpbb team seems in denial about it. We never had any issues with phpbb2.
Hopefully this will be an improvement...
-John
Re: sporadic error accessing Z
Posted: Mon Sep 08, 2008 7:50 am
by garyb
again,
THANKS John, for going through the trouble and giving of your time!
Re: sporadic error accessing Z
Posted: Mon Sep 08, 2008 7:55 am
by dbmac
Yeah, thanks John. My day doesn't start right without my Z.
/dave
Re: sporadic error accessing Z
Posted: Mon Sep 08, 2008 8:52 am
by hifiboom
the downtimes are a horror for every serious planetz addicted.
thx for the efforts.

Re: sporadic error accessing Z
Posted: Mon Sep 08, 2008 10:28 am
by braincell
Speaking of Unix, I just had a bug in a WP plugin which I worked on trying to fix for a whole day until I read someone say that he got it fixed by deactivating and activating it 5 times. I tried the same and this solved the problem. Very strange.
Re: sporadic error accessing Z
Posted: Tue Sep 09, 2008 10:32 am
by Mary Mungo
Thanks for your efforts in keeping the site going. I experienced the errors this weekend but by Sunday had seen your message instead of the error. I'll just keep trying to login. Problem solved for now.
Once again many thanks
Re: sporadic error accessing Z
Posted: Tue Sep 09, 2008 4:47 pm
by John Cooper
Ok, the workaround is in place. Once an hour, a script runs and kills any planetz queries that have been running for too long.
Hopefully this will fix it.
Please post here if you see that dreaded "max_connections" error again!
-John
Re: sporadic error accessing Z
Posted: Tue Sep 09, 2008 7:01 pm
by MikeRaphone
Thank you John,
much appreciated!
Stefan
Re: sporadic error accessing Z
Posted: Thu Oct 09, 2008 10:15 am
by John Cooper
Has anyone seen this problem the last few weeks?
Seems like the workaround is successful.
-John
Re: sporadic error accessing Z
Posted: Thu Oct 09, 2008 10:39 am
by Shroomz~>
It's been ok for us here John.
cheers,
Mark
Re: sporadic error accessing Z
Posted: Thu Oct 09, 2008 10:42 am
by pling
no, not once

only one thing: the RSS always show the 1st page of a thread. no big thing though, since there is "view active topics".
thx 4 all the work
