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"

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'

Re: read_const error 127 - then MySQL dies

50bf > > 0x40035941 > > 0x420da1ca > > New value of fp=(nil) failed sanity check, terminating stack trace! > > Please read http://www.mysql.com/doc/en/Using_stack_trace.html and > > follow instructions on how to resolve the stack trace. > resolve_stack_dump -s mys

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 q

read_const error 127 - then MySQL dies

2:21 InnoDB: Started /usr/sbin/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:

Re: table error 127

help 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]>

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 -

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: "Ric

Re: table error 127

hared 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 Gabr

Software Application Engineer WANTED (MySQL focus)

mponents 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

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! Richa

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

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" &l

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

Re: Frequent Table Corruption - Please Help

support from https://order.mysql.com/ > > - Original Message - > From: "Richard Gabriel" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Tuesday, July 15, 2003 9:52 PM > Subject: Frequent Table Corruption - Please Help > > > > Hi

Frequent Table Corruption - Please Help

-id=1 master-host=192.168.1.3 master-user=repl master-password=* master-port=3306 set-variable = query_cache_size=268435456 Log Entries: [The first entry is repeated many times. The second is from the mysqlcheck cron that repairs the tables] 030715 0:43:49 read_const: Got error 127 when reading table 030715 2:00:31 Note: Found 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]

3.23.53 can't change to user mysql bug

ll via RPM 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

MySQL 3.23.52 high load bug/leak report

ySQL lists. Please 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 chec

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) To