MySQL Forums
Forum List  »  InnoDB

Re: Database keeps crashing - Assertion Failure?
Posted by: BENJAMIN LINIER
Date: January 30, 2014 03:53AM

Hi,

I have the same error on a production server, i solved it by converting InnoBD tables in MyISAM tables.

Every time I made a query on an InnoDB table, MySQL server crached with an Assertion Failure.


I have a question :

On this page we can found a procedure to recover InnoDB : http://dev.mysql.com/doc/mysql-backup-excerpt/5.0/en/forcing-innodb-recovery.html

The procédure starts by "If there is database page corruption, ..."

But the question is :

- Why, and how a data corruption may occur ? I search the root cause to avoid it in the future cause my system is a critical system of safety of personal.

I have around 10 safety system in production over the world, all are identical and works fine since their installations. Can i guarantee at my client that the InnoDB will not crash randomly like my last installed system ?


Thanks for your answers,

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Database keeps crashing - Assertion Failure?
6798
January 30, 2014 03:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.