Gleb, thanks for the forcing-recovery pointer, thats what we ended up
using to recover the data for the corrupted table. After that we dropped
the table and recreated it, and imported the data and everything seems
fine for now.
Here are the OS/MySQL details:
brand new 64bit dual xeon w/ 6gigs of ram, running RHEL 3.2 64bit
mysql 4.0.25 EMT 64bit
thanks,
M
Gleb Paharenko wrote:
Hello.
Please provide information about MySQL and operating system versions.
Include your configuration file. This link might be helpful in case you
want to save your data:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
Mayuran Yogarajah wrote:
Mayuran Yogarajah wrote:
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld
got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly
built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is
definitely wrong
and this may fail.
key_buffer_size=67108864
read_buffer_size=1044480
max_used_connections=1
max_connections=160
threads_connected=1
It is possible that mysqld could use up to key_buffer_size +
(read_buffer_size + sort_buffer_size)*max_connections = 1539454 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Is this equation out of date? It differs from the formula in the
current documentation. This one
doesn't take into consideration innodb_buffer_pool size or
binlog_cache_size.
M
Initially I thought I was dealing with a memory problem but it seems now
that some tables are corrupt. It looks like the trouble began
at around 6am, which is when our backup script (which calls mysqldump to
dump the databases) also runs. Has anyone had similar
problems? Why would mysqldump cause corruption in the database?
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
