Server issues as of late...

Post by **Jon 94GT** » Tue May 08, 2007 11:14 am

Ok guys, I have been having some hardware issues that began late last week around friday. I am currently building a new machine to host this site on.

Thank you for all that have been patient. I didn't know about the outage till yesterday morning.

I will keep everyone up to date on the current status of the site as things progress.

-Jon / Owner

Post by **cgrey8** » Tue May 08, 2007 12:28 pm

We were noticing DNS issues as well with the toilsoft.com domain expiring.

Post by **Jon 94GT** » Tue May 08, 2007 2:48 pm

cgrey8 wrote:We were noticing DNS issues as well with the toilsoft.com domain expiring.

Yep that was the initial cause for failure, but that was a quick 30 second fix. DNS issues have been resolved and now there are instability issues related to (i think) the memory or motherboard.

That machine is due for an upgrade so I've decided just to swap it out with a new box i am hopefully going to get to piece together tonight.

-Jon

Post by **cgrey8** » Tue May 08, 2007 3:12 pm

Even in it's problematic state, it seemed faster than this machine. Surfing around the forum now seems much slower running on this machine.

I admin a phpBB forum for my company, but there's only internal employees that log into it. It never gets webscraped, or attacked, or anything like that. Point being, it runs on a 2.4GHz machine and it flies. But that's with me sitting with it on a 100baseT network and it has no other duties other than serving up that forum with no more than 2-3 people logged into it...ever. This forum was almost as fast on the previous machine, going over the Internet. But now, it's noticeably slower especially when posting updates to threads.

BTW, while you have the hood up on this forum and the server serving it, you might want to check out the phpBB forums for the error we kept getting a few weeks back about the MySQL table "sessions" getting too full. There's a php fix for this over there. It seems when the webscraping bots like Google and Yahoo come along to cache the pages, they use invalid session IDs that get inadvertently entered into the sessions table and don't get purged before the table gets full. What the code mod does is resizes the table when it gets full. Juse make a search on the phpBB forums for:

SQL Error : 1114 The table 'sessions' is full

You'll find the thread with the code fix AND some further comments about what happened to some people after the fix was implemented and how they had to deal with it.

There's also some good threads about ways to modify the php that catch the auto-registering bots that constantly spam this forum. Thanks to 2Shaker, this isn't as big of an issue for the rest of us anymore, but it's because he is cleaning crap out of the discussions multiple times a day.

BTW, thanks for taking the time to get us back online. We use this site quite a bit and we missed it when it was down.

sailorbob · Post by **sailorbob** » Tue May 08, 2007 3:39 pm

cgrey8 wrote:BTW, thanks for taking the time to get us back online. We use this site quite a bit and we missed it when it was down.

I second that :D

Brian-Mc · Post by **Brian-Mc** » Tue May 08, 2007 4:33 pm

Ditto...

Post by **2Shaker** » Tue May 08, 2007 10:28 pm

And ditto again, thanks Jon. And if you could do something to reduce the SPAM it would be terrific. I did notice that since it was down I haven't had to remove any.

Post by **cgrey8** » Fri May 11, 2007 11:38 am

Jon,
What's the server status?

Post by **cgrey8** » Wed May 23, 2007 2:22 pm

Site's back up and responding very snappy.

86GT · Post by **86GT** » Wed May 23, 2007 2:38 pm

I agree, It appears to have a better response.

Post by **Jon 94GT** » Wed May 23, 2007 2:52 pm

Yep, I used my lunch break today @ work to run up to the colo and install the new hardware, so that is the reason for the snappier response.

Everything should be good to go, so let me know if anyone sees any problems.

Sorry it took so long guys/gals.

Jon

Post by **cgrey8** » Wed May 23, 2007 2:58 pm

Is it a dedicated server running the site or do you have it Virtual Hosted with other websites using the same webserver?

BTW, navigating around the site goes pretty smoothly, but it seems submitting responses takes a little long. It's not unreasonable, but it is taking an extra few seconds longer than I'd generally expect. I don't know what that's about, but I thought I'd mention it since I noticed it.

And thanks again for taking your lunch break to do that.

86GT · Post by **86GT** » Wed May 23, 2007 3:16 pm

When I submitted a response I had to wait longer than usual too. The navigation as chris said is nice, it is just submitting.

I ended up submitting twice because I was not patient. LOL

Post by **Jon 94GT** » Wed May 23, 2007 4:22 pm

I'll look into the posting issue as time permits. The site is hosted on its own server. No virtualization is happening on the hardware it runs on. I might end up moving the sql process to its own hardware as well...but I will let you guys know what I do to fix the posting speed issues when it happens.

Jon

twinturbostang · Post by **twinturbostang** » Wed May 23, 2007 4:49 pm

Wow, it lives! :D

Brian-Mc · Post by **Brian-Mc** » Wed May 23, 2007 4:59 pm

Thanks for getting the site back up Jon... definitely felt beside myself without being able to get on for some assistance.

Post by **2Shaker** » Wed May 23, 2007 5:34 pm

YES!!! We're back on line. Thanks Jon.

Cougar5.0 · Post by **Cougar5.0** » Thu May 24, 2007 9:00 am

Whew! Glad it's back! I was having withdrawl symptoms

sailorbob · Post by **sailorbob** » Sun May 27, 2007 10:37 am

Good news:
It's great to have the forum back :D

Bad news:
I keep seeing the "The table 'sessions' is full" too, it seems to be becoming a daily occurrence

Ed Hohenberg · Post by **Ed Hohenberg** » Thu Jun 07, 2007 12:02 pm

any update on the broken RSS feed?

RyanW · Post by **RyanW** » Thu Jun 21, 2007 3:39 pm

sailorbob wrote: Bad news:
I keep seeing the "The table 'sessions' is full" too, it seems to be becoming a daily occurrence

I'm still seeing this often, FYI. Other than that- it appears to be running good.

Thanks for the great site!

stanger007 · Post by **stanger007** » Wed Jul 04, 2007 10:46 am

sailorbob wrote:Good news:
It's great to have the forum back :D

Bad news:
I keep seeing the "The table 'sessions' is full" too, it seems to be becoming a daily occurrence

Jon - could you switch the sessions table from a Heap to MyISAM or increase the row limit on the Heap table? Lastly, a scheduled script to clear out the old sessions would fix this as well.

Let me know if I can help out with anything.

Wes

Post by **cgrey8** » Wed Jul 04, 2007 10:58 am

There's a php code patch on the phpBB forum for fixing this. It just needs to be applied to the code that manages the sessions. But yes, doing this at the db level would also be useful. This error is getting quite frequent...

Post by **Jon 94GT** » Wed Jul 04, 2007 10:10 pm

I have upgraded to the most recent version of phpBB, need to update the templates soon so for now we will suffer with the default template.

Starting work on updating...new content coming...its been waay too long.

You guys let me know if you see anything critical...

(PS: RSS feed coming back soon.)

Post by **cgrey8** » Wed Aug 01, 2007 8:01 am

I'm still getting the Sessions table full errors like clockwork every single morning and sometimes infrequently during the day.

Post by **2Shaker** » Sun Aug 12, 2007 11:31 am

Jon,

You have an urgent PM from me.

dwinthrup · Post by **dwinthrup** » Wed Sep 12, 2007 11:12 pm

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'sessions' is full

INSERT INTO sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('f22f09031dd0271aee3a31e100c33398', 2711, 1189651789, 1189651789, '18b3f519', -2, 1, 0)

Line : 187
File : sessions.php

Post by **cgrey8** » Thu Sep 13, 2007 6:12 am

Yeah, that's the same annoying error the rest of us are getting.

dwinthrup · Post by **dwinthrup** » Thu Sep 13, 2007 9:20 am

as long as I'm not alone I guess :(

meatheadmike · Post by **meatheadmike** » Wed Oct 10, 2007 11:02 am

Looks like you simply need a session purge script that cleans up the sessions table every hour (or something like that).

Server issues as of late...

I keep getting this

Who is online