Re: Table handler errors
On Sun, April 24, 2005 5:20 am, Mike Blezien said: > we started getting these table handler errors 12, not all the time, but > just now > then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The > database > in question is used by this vBulletin BBS system. Not sure it's a problem > with > the BBS or how MySQL is configured. Was wonder if anyone may have some > insight > on how to remedy this type of error. I think I saw that once, and I Google for it, and I found the answer... Damned if I remember what it was. Disk full??? -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Table handler errors
Hi all, Sounds like a max heap table size reached : mysql> show variables like '%heap%'; +-+--+ | Variable_name | Value| +-+--+ | max_heap_table_size | 16777216 | +-+--+ 1 row in set (0.00 sec) if you redefine it, it may work better in memory. Else use temporary tables. Mathias -Original Message- From: Jigal van Hemert [mailto:[EMAIL PROTECTED] Sent: dimanche 24 avril 2005 17:08 To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: Table handler errors > Yes, I've going through the docs and the manual i have hear locally, couldn't > really find a specific reason and/or causing for the error. The table type that > was causing the error was a HEAP table, changed it to a MyISAM table type and > the error disappeared, no more handler errors now... go figure! HEAP tables are stored in memory http://dev.mysql.com/doc/mysql/en/memory-storage-engine.html Error 12 may be Out of memory? Which would explain the error... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table handler errors
> Yes, I've going through the docs and the manual i have hear locally, couldn't > really find a specific reason and/or causing for the error. The table type that > was causing the error was a HEAP table, changed it to a MyISAM table type and > the error disappeared, no more handler errors now... go figure! HEAP tables are stored in memory http://dev.mysql.com/doc/mysql/en/memory-storage-engine.html Error 12 may be Out of memory? Which would explain the error... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table handler errors
Jigal van Hemert wrote: From: "Mike Blezien" we started getting these table handler errors 12, not all the time, but just now For errors from the operating system you can use perror to find out the description of the code: http://dev.mysql.com/doc/mysql/en/perror.html Regards, Jigal. Yes, I've going through the docs and the manual i have hear locally, couldn't really find a specific reason and/or causing for the error. The table type that was causing the error was a HEAP table, changed it to a MyISAM table type and the error disappeared, no more handler errors now... go figure! Thx's -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table handler errors
From: "Mike Blezien" > we started getting these table handler errors 12, not all the time, but just now For errors from the operating system you can use perror to find out the description of the code: http://dev.mysql.com/doc/mysql/en/perror.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table Handler Errors
possible table corruption. Run myisamchk on the table to check it and then, if needed, repair it. Bhavin. - Original Message - From: "Amit Lonkar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 22, 2002 10:52 PM Subject: Table Handler Errors > Hi All! > > I am using mysql-.3.23.49 on windows. It generates the > following error:- > > General error: Incorrect key file for table: 'lotjob'. > Try to repair it . > > or some times it generates a table handler error. > > why do these errors occur? > > Regards > Amit Lonkar > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php