Forum Crashed very hard today and I need some help.

[admin]

This was something I never saw coming.;D

We had three things go wrong today. It all started with a little thing,
Birthdays. I never thought about this causing issues like this.

This is the very first New Years on vB. vB thinks that 18k of the members was born on Jan 1 1901. The forum wants to put them on the birthday list and send out a nice message.

MySQL said “Thou Shalt Not”

MySQL Error : Got a packet bigger than ‘max_allowed_packet’ bytes

So the forum tries again, and MySQL still says no.

So they go round and round enough that now the G-mail account that I have error message go to is 25% full.

I try and get in to the forum to turn off the birthday stuff, nope, can’t get in. We now are getting

Database error in vBulletin : mysql_connect() [<a href=’function.mysql-connect’>function.mysql-connect</a>]: Too many connections

So I try and handle this from the server side. Nope, Too many connections.

The hosting company gets involved.

Pretty soon we have on top of a mega packet being blocked my mysql and vB and all the error messages it put out and all the connections being used up the data base became corrupted.

The repair failed.

vb4_post Check Warning: Table is marked as crashed and last repair failed
vb4_post Check Error: Found key at page -1 that points to record outside datafile
vb4_post Check Error: Corrupt

Well it turns out the disk became full. The error messages became bigger than the forum itself.

This was my fault for not realizing this could happen. I have set the forum so people have to put a birthday in to join the forum.

Everyone, set your birthday in your profile, you can have the birthday hidden but please set it to something.

#1JonSidneyB, Dec 31, 2010

[Author]

Posts