Re: ERROR 1030: Got error 127 from table handler

What kernel are you running? Also, try increasing the max open tables. That might help. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Dathan Vance Pattishall [EMAIL PROTECTED] To: 'Tom Roos' [EMAIL PROTECTED]; [EMAIL PROTECTED

Re: ERROR 1030: Got error 127 from table handler

the max open tables to 512. I don't have much more info than that unfortunately. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Dathan Vance Pattishall [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

Re: read_const error 127 - then MySQL dies

, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, August 08, 2003 11:50 PM Subject: read_const error 127

Re: Error 127, some questions

What OS/kernel are you running? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Terence [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 11, 2003 2:28 AM Subject: Error 127, some questions Dear List, We

read_const error 127 - then MySQL dies

/mysqld-max: ready for connections. Version: '4.0.14-Max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 This happens often. Any ideas? Thanks. -- Richard Gabriel [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: table error 127

me pinpoint the problem and ultimately get this resolved. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Jonathan Patton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 8:58 AM

Re: table error 127

library linked to MySQL (I use RPMs) 3. RAID issue causing corruption Unfortunately I haven't been able to pinpoint which query causes the issue so I can't report a bug. It anyone else has experienced this or has information on it, I would really appreciate it. Thanks. Richard Gabriel Director

Re: table error 127

Thanks walt. Actually I use mysqlcheck to check the databases. This can be safely run while the server is in use. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: walt [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED

Fw: table error 127

Even though we don't know what exact query produces this, is there a way to raise it up to the MySQL team to take a look at? It seems to be more than a random occurrence. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From

Software Application Engineer WANTED (MySQL focus)

of an application connect to create a comprehensive solution Please send resumes to [EMAIL PROTECTED] Thanks! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951

Re: Frequent Table Corruption - Please Help

What do you consider high volume? Also, please keep me in the loop on this. Any configuration changes that help would be appreciated. Thanks! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Tom Roos [EMAIL PROTECTED] To: Richard

Re: Frequent Table Corruption - Please Help

I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the problem? What 2.4 version exactly did you run and was it a RedHat kernel? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno

Re: Frequent Table Corruption - Please Help

the forthcoming MySQL 4.0.14 to see if any bugs fixed solve my problem. 2. Upgrade the kernel to RedHat's 2.4.20 (update to RH 8.0) 3. Try to tweak MySQL settings 4. Install kernel.org's 2.4.21 kernel without RedHat patches. Does anyone have any other ideas? Thanks again for your help! Richard Gabriel

Frequent Table Corruption - Please Help

23550 of 23551 rows when repairing Thanks again for your help in advance! -- Richard Gabriel [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Frequent Table Corruption - Please Help

? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL

Re: Frequent Table Corruption - Please Help

Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense

3.23.53 can't change to user mysql bug

packages and I'm running RedHat Linux 7.1 (kernel 2.4.18-ac3). Richard Gabriel, CTO CoreSense Inc. (866) 229-2804 Toll Free (518) 580 9843 Fax - Before posting, please check: http

MySQL 3.23.52 high load bug/leak report

direct me to the correct list if I am mistaken. Thanks. Richard Gabriel, CTO CoreSense Inc. (866) 229-2804 Toll Free (518) 580 9843 Fax - Before posting, please check: http

Time bug with MySQL 3.23.49

Richard Gabriel, CTO CoreSense Inc. (518) 276-2673 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive