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 > w

RE: Table handler errors

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

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

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 goi

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 F

Re: table handler error

[EMAIL PROTECTED] mysql-debug-4.1.9-pc-linux-gnu-i686]$ perror 5 Error code 5: Input/output error See: http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html http://dev.mysql.com/doc/mysql/en/error-handling.html http://dev.mysql.com/doc/mysql/en/perror.html

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 m

Re: table handler error 27 (cont'd)

Hi. Hm. Maybe you have too few free space in your tmp directory? Regards, Benjamin. On Fri, May 10, 2002 at 06:38:19PM -0400, [EMAIL PROTECTED] wrote: > I have checked my file size in my data dir and can't find any files > close to 2GB even looking in subdirs. > > Does this mean th

Re: table handler error 27 (cont'd)

I have checked my file size in my data dir and can't find any files close to 2GB even looking in subdirs. Does this mean that my problem is most likely corruption or could it still be "file too large". Augey Augey Mikus wrote: > when running > select count(distinct value) from table; >

re: table handler prob

Hi again No .. not really that big (the table) -rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD -rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM -rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm 100K the ISD

Re: table handler prob

Hi again No .. not really that big (the table) -rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD -rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM -rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm 100K the ISD

Re: table handler prob

Nuno Ferreira wrote: > > Hi again. > > I've been reading all the archieve files about a error i get when > trying to do any sql thing with a table. > > check this out ... > mysql> select * from imp_addr; > ERROR 1030: Got error 127 from table handler > > than

RE: table handler

The valid range for an 'int' data type (your "id" column) is -2147483648 to 2147483647. The value you are attempting to set (37647438380) is not within this range. --Greg Johnson -Original Message- From: Andreas Gietl [mailto:[EMAIL PROTECTED]]