Author Message

<  Important Messages  ~  "Table is Full"

PostPosted: Thu Mar 30, 2006 3:25 am Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
You guys have more than likely seen a couple of times a wierd looking SQL error about a table being full. To my knowledge this has happened twice, with the same error.

Stopping and starting the mySQL engine seems to clear the error, but I'm going to try and look into it in a bit more detail, possibly upgrade the SQL engine and see if that is a more permanent solution.

Meantime, if you should see it happening, email me to let me know on

tromador at tromador dot com

and I'll clear it.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Thu Mar 30, 2006 3:49 pm Reply with quote
User avatarVentruePosts: 1554Location: Virginia, USAJoined: Fri Apr 04, 2003 5:05 pm
Okies chief! :)



_________________
Money can't buy you friends, but it can buy you a better class of enemies.
Offline Profile
PostPosted: Fri Apr 07, 2006 11:54 am Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
Unless anyone knows who gigablast.com is or recognizes the ip address
66.154.102.44, I shall be banning it, seeing as 95% of all the sessions in our struggling session table are created from that IP.

Apparently this is a common error with phpBB boards and isn't caused by any particular factor. From the following page:

http://www.phpbb.com/kb/article.php?article_id=42

"Now, why does this happen in the first place?? 'I'm innocent!', I hear you say, 'I haven't added any MODs or anything, I just woke up one day to see that error message!'. Well, you are innocent. This error is nothing to do with you (or any of your users) breaking the fora, don't worry."

The above IP looks like it's potentially session flooding us and that's the problem. I have any number of fixes I can put into place, however the enormous number of sessions from that IP are suspicious, so unless it's one of you guys, I want to ban it regardless.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Fri Apr 14, 2006 2:20 am Reply with quote
User avatarCappadocianPosts: 590Location: Sydney, AustraliaJoined: Fri Apr 04, 2003 11:55 am
I'd ban it, if it's someone who shouldn't be banned, they'll soon let you know. Just put a custom error doc up so when they're banned they don't get a generic page but a statement saying "hey you're banned, email for details" or something. :)



_________________
If I told you this was killing me, would you stop?
Dressed to Depress
Offline Profile WWW ICQ YIM
PostPosted: Mon Apr 17, 2006 7:17 am Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
Looks like it's a "broken" search engine spider. I'll just ban it. Can't be bothered making a nice error page cos someone is too lazy to program their spider properly.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Mon May 29, 2006 9:43 pm Reply with quote
User avatarGangrelPosts: 1117Location: The riverbank.Joined: Fri Apr 04, 2003 7:20 pm
Been getting this screen the last coupla days. Lasts about 2 hrs then all is normal.

:/


Offline Profile ICQ
PostPosted: Tue May 30, 2006 6:21 am Reply with quote
User avatarEndeavor Mod LeaderPosts: 142Location: Lacey, WAJoined: Thu Apr 01, 2004 12:35 am
Damn bots!

I've been hit by them too. There's no one monitoring those accounts. They were created by a program so yes - delete them, ban them, lock them out or something.

THEY ARE EVERYWHERE!

My friend's forum was hit too and so was mine. What ever is doing it, is most likely affecting most of the php boards

BTW: I recognize inezjjohaansen. It was on my forum too.

IT'S A BOT! NUKE THAT BASTARD GOOD!



_________________
erm... ZOINK
Offline Profile WWW
PostPosted: Tue May 30, 2006 8:53 am Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
Really? Um... ok :) Thx.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Sat Jun 03, 2006 12:32 pm Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
I had hoped upgrading to mySQL version 5 would cure this problem, but I logged on to find a table full today.

I'll look into one of the other methods for curing it.

Meantime, continue to drop me an email if you find the error and I'll reset it as soon as I get the message.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Sun Jun 04, 2006 10:04 pm Reply with quote
User avatarVentruePosts: 1554Location: Virginia, USAJoined: Fri Apr 04, 2003 5:05 pm
I was SO sad today. :(

Perfect day to write.

Thanks for gettin' her back up though!



_________________
Money can't buy you friends, but it can buy you a better class of enemies.
Offline Profile
PostPosted: Sun Jun 11, 2006 2:35 am Reply with quote
User avatarCappadocianPosts: 590Location: Sydney, AustraliaJoined: Fri Apr 04, 2003 11:55 am
a new version of phpBB was released this week. not sure if it addresses these issues but it's worth upgrading just the same.



_________________
If I told you this was killing me, would you stop?
Dressed to Depress
Offline Profile WWW ICQ YIM
PostPosted: Mon Jun 12, 2006 7:45 pm Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
I'll have a look at it when I have a moment :)



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Wed Jun 14, 2006 10:08 am Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
Board is now upgraded to the latest version. We'll see if that solves the problem.



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Sat Jun 24, 2006 7:23 pm Reply with quote
User avatarTremerePosts: 845Joined: Sat Apr 05, 2003 2:47 pm
Having just watched googlebot take the board down, I'll apply one of the mods.

*sigh*



_________________
Blood is thicker than water... and much tastier.
Offline Profile WWW ICQ
PostPosted: Tue Jun 27, 2006 6:17 am Reply with quote
User avatarCappadocianPosts: 590Location: Sydney, AustraliaJoined: Fri Apr 04, 2003 11:55 am
Put this in your robot file

User-Agent: Googlebot-Image
Disallow: /

User-agent: Slurp
Disallow: /

etc.



_________________
If I told you this was killing me, would you stop?
Dressed to Depress
Offline Profile WWW ICQ YIM

Display posts from previous:  Sort by:

All times are UTC [ DST ]
Page 1 of 2
21 posts
Go to page 1, 2  Next
Users browsing this forum: No registered users and 4 guests
Search for:
Post new topic  Reply to topic
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
cron