collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18365
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

Author Topic: Table is full  (Read 4100 times)

0 Members and 1 Guest are viewing this topic.

Offline Dabaron

  • BeBot Apprentice
  • ***
  • Posts: 163
  • Karma: +0/-0
Table is full
« on: March 10, 2008, 08:29:22 am »
I'm getting a bit confused/frustrated here.

I run a few bots and they all run fine overall.  I ran into an issue a while back with the tower_attack table saying it was full (not sure whoever decided to make that an MyISAM instead of InnoDB was thinking, but whatever) so I had to tweak it's max size.  I'm now setting up a brand new bot for someone and I get this same message with the botname_settings table on creation.  At first I had it sharing a DB with another bot so I could share whois info and such so I even tried moving it to its own table to see if that made a difference but it didn't.  I've checked the HDD itself thinking maybe I had ran out of space but that isn't it (have gigs of available space on there) so I'm now sort of at a loss as to what the heck (the tweak I did before dosen't work, and actually wouldn't since it is an InnoDB table, not a MyISAM).

Any ideas?

Offline Blueeagle

  • Omnipotent
  • BeBot Hero
  • ******
  • Posts: 323
  • Karma: +0/-0
Re: Table is full
« Reply #1 on: March 10, 2008, 11:11:15 am »
Does this help?
The only problem that can't be solved by adding another wrapper is having too many wrappers.

Offline Glarawyn

  • BeBot Hero
  • ******
  • Posts: 521
  • Karma: +0/-0
Re: Table is full
« Reply #2 on: March 10, 2008, 10:22:19 pm »
The only way I can see an issue is if the user is using FAT32. Even then, 2gb or 4gb is rather large for MySQL tables... All my org bots weigh in at 24mb, even Campalot is only 67mb of data.

Seems like there might be something else going on on the user's system...like a full (or near full?) hard drive?

MyISAM is the default storage engine for MySQL. The Windows installer howerver sets the default to InnoDB in the config file. I haven't been able to find any reason why this change was made on Windows.

Offline Dabaron

  • BeBot Apprentice
  • ***
  • Posts: 163
  • Karma: +0/-0
Re: Table is full
« Reply #3 on: March 15, 2008, 01:16:30 am »
Hosted on Linux so a windows installer doesn't apply   ;)

That link is the very link I followed to fix my problem with tower attacks but not working to fix this one.

Any other ideas?

Sidenote... If I let the bot launching the first time create the entries in the table it does create them correctly... but when I go to modify them via the bot I get a table is full message in my console.  Also trying to modify directly in sql gives same full error.
« Last Edit: March 15, 2008, 01:50:38 am by Dabaron »

Offline Dabaron

  • BeBot Apprentice
  • ***
  • Posts: 163
  • Karma: +0/-0
Re: Table is full
« Reply #4 on: March 15, 2008, 03:16:41 am »
Ok, I got this one fixed... but the fix is really odd.

I changed the engine on that table from Innnodb to MyISAM and then did the ALTER TABLE botname_settings MAX_ROWS=1000000000
part of that article (which is the same one I was following before actually) and suddenly all is fine with the world.  No freaking clue why my server suddenly hates InnoDB!!

 

* Recent Posts
0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm ]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am ]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm ]

* Who's Online
  • Dot Guests: 306
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal