Data-base error warning

[SeeMoreDigital]

Hi all,

Is it just me or is anybody else obtaining sporadic data-base error warnings when connecting to the forum?


Cheers

[setarip_old]

It's not just you...

[Shinigami-Sama]

it only seems to happen around lunch time, the time I wake up

but yeah
you're not the only one

[LoRd_MuldeR]

Yeah, that is going in for the last several days:
Works » Database Error » Server is Busy » Works » Database Error » Server is Busy » Works » (...)

BTW: I also receive one and the same notification email multiple times.

[Carpo]

norm after 6pm here

[mitsubishi]

It seems to go funky for me late GMT, like 2-6am, more so when the board is less busy.

[nautilus7]

I am experiencing such problems over 2 weeks... Should i feel unique? :rolleyes:

[Inventive Software]

Nope. Seems to be a lot of US traffic around lunchtime and after work. Go figure! :D

[nautilus7]

Accessing the forum today is almost impossible... So the this is because of increased traffic or there is a problem in the server?

[squid_80]

Remember we're getting all this for free folks. There are ways to help out (http://www.doom9.org/donate.htm)...

[Shinigami-Sama]

Remember we're getting all this for free folks. There are ways to help out (http://www.doom9.org/donate.htm)...

remember you can donate webspace for mirror as well
if you got 50-75gigs of free bandy/month as well

[Zotty]

This is getting insane.... anything else we can do to help out?

[Doom9]

I finally managed to turn on the db error emails so somebody will get the error emails. From the looks of it, it seems mysql got temporarily overwhelmed and wouldn't allow any additional connections. And for some reason I can't quite figure out, the load was going through the roof (it was up too 100 at one point when I tried to reboot.. so the system took ages to actually go down after I sent the command).
I'm wondering - is there some commandline linux tool that would tell me what processes cause the load? (top looked quite reasonable but with a lot of httpd processes things aren't necessarily as indicative as they should be - I find the windows task manager to be quite a bit easier to handle (plus being able to directly kill processes is an added bonus)?

[Shinigami-Sama]

you might try mtop, hear thats supposed to better

[Doom9]

Unfortunately mtop doesn't seem to be there with the default install so I rather wait for the admin to get back. I'll suggest that we'll double the amount of ram as we're skimming rather close to the edge - although swapping wasn't the reason for the complete breakdown that occured earlier this evening.

@Zotty: If you have experience running a vbb on a lamp system and how to trace an overload back to the source (knowing that the resources available are enough - the same hardware has withstood digging and slashdotting a couple times without any problems) that would be good to know (the person in charge of the server is currently not around to have a look and while I have no trouble with the basic admin tasks and do very funky stuff on my linux based routers, the whole process management thing on linux is kinda new to me). Other than that I think the money for the additional ram should be in the donations account but it's getting close to depletion with buying the server and all (at least we put the donations to good use)

We might also have hit a but somewhere along the lines. When I logged into the server and wanted to launch mysqladmin, mysql told me that there were too many connections.. looking at the number of active users, this should never have happened so there must have been something opening but not closing connections to the database - and in time that can cause major trouble (I've been guilty of writing code that acted that way and eventually stopped working as I exhausted the number of allowed connections)

[SeeMoreDigital]

How about adding a "donations link" (http://www.doom9.org/donate.htm)to the forum?

[Shinigami-Sama]

open a ticket with VB and check their forums to see if its a bug on their end as well

[Swede]

Sorry for all the downtime/problems. Just returned from 3 weeks in Thailand and will try to figure out what went wrong.. When my internal clock syncronizes with 'Real Life' :)

[Adub]

Good to know that you are back!