MySQL Forums
Forum List  »  InnoDB

Re: Database keeps crashing - Assertion Failure?
Posted by: Peter Brawley
Date: January 08, 2014 05:11PM

4 innodb_buffer_pool instances won't help with 2GB RAM.

> it crashed 12 times during this with the exact same error every time:

> 140105 20:30:38 InnoDB: Assertion failure in thread 2172095376 in file trx0purge.c line 840

Does your import tool show which table is being processed at the time of the crash?

Otherwise I'd take all the crashes as an indication the DBs need more mem.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Database keeps crashing - Assertion Failure?
13949
January 08, 2014 05:11PM


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.