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
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
