Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Folder Limit?

Quote Reply
Folder Limit?
Does anyone know if GM has a limit to the number of messages you can have in a folder? I just tried to go to a folder with 663 messages in it and got the following message...


A fatal error has occured:

DBD::mysql::st execute failed: The table 'SQL64373_0' is full at /home/webmail/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 68.

Please enable debugging in setup for more details.


I gather that this means mySQL's temporary table ran out of space when querying the database for this folder, no?

Everything else seems to be working fine, including all of the other folders.

thanks,

Michael Coyne
seaturtle.org
Quote Reply
Re: Folder Limit? In reply to
Hi,

Can you enable debugging and let me know what the query was?

The problem can be fixed in a number of ways by adjusting mysql settings. See:

http://www.mysql.com/doc/F/u/Full_table.html

for more info.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Folder Limit? In reply to
Is there somewhere in GM that I can/should throw in the SQL_BIG_TABLES option or do I need to restart mySQL with big tables?



Michael Coyne
seaturtle.org
Quote Reply
Re: Folder Limit? In reply to
Hi,

I'd be interested to know the SQL query. Could you turn debug on, reproduce the error, and just drop me an email with the full dump.

As for the option, I would recommend starting with --big-tables option if possible (i.e. your own server) as that avoids problems with any other scripts as well.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Folder Limit? In reply to
Done! Sorry, I sent it to support the first time.

How much of a performance hit is it to run with big-tables on? I understand that this will then write all temporary tables to disk instead of keeping them in memory.



Michael Coyne
seaturtle.org