sporadic error accessing Z

[erminardi]

The end of the world is near!!!

[husker]

http://www.planetz.com/forums/viewtopic.php?f=10&t=6639

[John Cooper]

I saw that too a couple weeks ago, but only on one day (August 11). I contacted the ISP and they killed some gigantic spider queries that were running.

I haven't seen it since, so thanks for letting me know. If anyone else sees this, please post here. If it seems like a common recurrence, I'll complain to the ISP again. Maybe they need to bump up our max connections. Or we need to find away to throttle the bots...

-John

[Aries]

General Error
SQL ERROR [ mysql4 ]

User 'planetz' has exceeded the 'max_user_connections' resource (current value: 25) [1226]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

The error occured again when trying to view posts.

[Aries]

General Error
SQL ERROR [ mysql4 ]

User 'planetz' has exceeded the 'max_user_connections' resource (current value: 25) [1226]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

The error occured today again when trying to login to forum.

[Neutron]

I saw it and thought..hmm too many users i wonder why that could be. so i rushed over to soniccore site but

[t_tangent]

Me too....made me nearly sell my scope stuff
but luckily I put it off till tomorrow

[petal]

Yup - havn't been able to access planetz for nearly 2 whole days.

[braincell]

Same here for the last 2 days nothing until now.

[Aries]

Could not login yesterday (01/09/08) I tried throughout the day.

It was similar today until now 8.30 pm.

[erminardi]

The end of the world!

[John Cooper]

Interesting... I thought I posted here this morning, but I don't see my post now.

I had reported that the forums were clobbered somehow, and I had notified the ISP (who fixed it this morning).

These problems started with the upgrade to phpbb 3.

We're not the only ones:
http://www.phpbb.com/bugs/phpbb3/ticket ... t_id=20955

I'm not sure of the solution yet...
-John

[capacitor]

One of my gear bbs had PHP changed to v5 - it messed up phpBB2 big time. They supposedly did that without notification I'm glad I'm done supporting that particular board.

I feel your pain.

[John Cooper]

Yeah, I went through that one too, back with php5 + phpbb2.
It never ends!
-John

[hifiboom]

i had this message now for more than 24h.
okay I use auto-login,
but till reading this I thought the server would be down.

[katano]

yup, same here. now it's working again, guess america's still sleeping

[kylie]

it's alive. we're safe now

[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

[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

[garyb]

again,
THANKS John, for going through the trouble and giving of your time!