About Forum Crashings...

the_x5

<div class="IPBDescription">JoeV please respond</div> Well ladies and gents TAK and I discussed this and I now know I'm not the only person seeing the frequent crashing of the "NSF" as it is called.

I have seen this exact same thing happen before with <a href='http://koforum.e-games.com.my/' target='_blank'>another forum</a> durring a time of mass spam and lockage and the problem was solved when the massive "general forum" (kinda like our Off Topic and General forums combined with 20 times more complaints) was pruned and then the traffic reduced after KO died.

I know we have a no delete policy and in certain forum like the new and fixed I&S we must not delete the locked topics (so we can reference) but I think we all can agree that much of what is said in the Off Topic and General forums is spam stuff with a thread life time of only a few days. I have sent 3 e-mail to the forum "admin" and have seen no result despite volunteering to prune thouggh all of the last 5-10 pages of the OT and Gen forums.

Now here's what TAK has to say:

That_Annoying_Kid

I have started to notice a MySQL error which states "to many connections" while I don't know the specifics x5 stated that he saw the same thing with massive forums, granted the NSF doesn't delete stuff they move it out of view or let it fall, maybe it is time to do some prunning. I believe that Joev would be the person we should talk to as last time I check he was the one who actually did the tweaking to the database.

another issue I want to address is the fact that this should belong in general discussion as it is pertanint to natural selection, so before people start saying phase I want to nip that in the bud

DragonMech

I've been getting this error as well.

Sky

*raises hand*
Only once....

crazynet

I have gotten it a number of times, the error is that there are two many connections, which could mean that there just to many people trying to read the boards these days.

How to fix, idk since im not all that great with mySQL and php

IBT

i never got this error, but i really havent checked a whole lot.
still though, with this type of forum, 5 pages should be the max.
for all sections, cept maybe I&S

im_lost

I have also had this error a number of times.

Clashen

They're changing servers, it'll be over soon my children.

That_Annoying_Kid

I want sources to back up you claims clashen!

[edit]
just after I posted lo and behold they crash again
[/edit]

the_x5

<!--QuoteBegin-Clashen+Oct 21 2004, 01:41 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (Clashen @ Oct 21 2004, 01:41 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> They're changing servers, it'll be over soon my children. <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
Florian "NemesisZero" Schwarzer be kind enough to give us a time frame on this? <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html//emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->

~edit~

I confirm that TAK. Crashed at 14:50-ish and resumed at 15:00 (EST)

PS: anyone want to keep a record of the times it crashes at?

Clashen

<!--QuoteBegin-x5+Oct 21 2004, 08:55 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (x5 @ Oct 21 2004, 08:55 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> <!--QuoteBegin-Clashen+Oct 21 2004, 01:41 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (Clashen @ Oct 21 2004, 01:41 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> They're changing servers, it'll be over soon my children. <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
Florian "NemesisZero" Schwarzer be kind enough to give us a time frame on this? <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html//emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->

~edit~

I confirm that TAK. Crashed at 14:50-ish and resumed at 15:00 (EST)

PS: anyone want to keep a record of the times it crashes at? <!--QuoteEnd--> </td></tr></table><div class='postcolor'> <!--QuoteEEnd-->
Yea it was from Nem0 i got it, on IRC, so yea.

Comprox

Yes, it may be due to other reasons like Nem stated.

Grendel

Any problems you are experiencing should be resolved within a week at the outside. Forum related ones, at least. Anything else really isn't any of our business.

BulletHead

<!--QuoteBegin--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> </td></tr><tr><td id='QUOTE'><!--QuoteEBegin-->mySQL query error: SELECT id, member_id, running_time, location FROM ivb_sessions WHERE id='9623b2d970c1315a1ede06f64e544264' and ip_address='69.242.88.196'

mySQL error: Too many connections
mySQL error code:
Date: Thursday 21st of October 2004 04:57:20 PM <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->


The error... I get it at least 4-8 times a day...

Marik_Steele

<!--QuoteBegin-x5+Oct 21 2004, 01:55 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (x5 @ Oct 21 2004, 01:55 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> <!--QuoteBegin-Clashen+Oct 21 2004, 01:41 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (Clashen @ Oct 21 2004, 01:41 PM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> They're changing servers, it'll be over soon my children. <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
Florian "NemesisZero" Schwarzer be kind enough to give us a time frame on this? <!--emo&:)--><img src='http://www.unknownworlds.com/forums/html//emoticons/smile-fix.gif' border='0' style='vertical-align:middle' alt='smile-fix.gif' /><!--endemo-->
[...] <!--QuoteEnd--></td></tr></table><div class='postcolor'><!--QuoteEEnd-->
I'm trying to recall the most recent major things done to the forums which may have affected the database...things as major as the mass pruning of 0-post accounts I did some time back...

Most of the things I can bring to memory are obviously things I can't talk about much in public. Mentally narrowing down what sort of things could cause these errors, I've come to the conclusion that:

Possibility 1: we should be patient at least one week
and/or
Possibility 2: I've been purposely left in the dark about something happening behind the scenes, which happens quite often even to Admins for various reasons I'm in complete agreement with.

joev

We're moving servers.

The process of taking backups (to upload to the other server) pretty much hogs the database connections.

While it's ugly, it's necessary.

All will be finished soon, just have patience and bear with us.

joe.

That_Annoying_Kid

fantastic, thank you for shedding light on this topic

Alkiller

<!--QuoteBegin-joev+Oct 22 2004, 03:59 AM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><b>QUOTE</b> (joev @ Oct 22 2004, 03:59 AM)</td></tr><tr><td id='QUOTE'><!--QuoteEBegin--> We're moving servers.

The process of taking backups (to upload to the other server) pretty much hogs the database connections.

While it's ugly, it's necessary.

All will be finished soon, just have patience and bear with us.

joe. <!--QuoteEnd--> </td></tr></table><div class='postcolor'> <!--QuoteEEnd-->
We'll live. <!--emo&::marine::--><img src='http://www.unknownworlds.com/forums/html//emoticons/marine.gif' border='0' style='vertical-align:middle' alt='marine.gif' /><!--endemo-->

Thanks for filling us in.