MySQL Forums
Forum List  »  InnoDB

Re: Power failure and innodb
Posted by: Sunny Bains
Date: February 03, 2015 07:04PM

The use case described is very unusual.

1. Is this running inside a VM?

2. Are the transactions rolled back or the data lost?
I realise that in the OP's description, it says rolled back after a clean shutdown. Did you see something like this?

2015-02-04T01:14:35.098012Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn XXXXXXXX
2015-02-04T01:14:35.098045Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number NNNNNN
2015-02-04T01:14:35.099240Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number NNNNNN
2015-02-04T01:14:35.099261Z 0 [Note] InnoDB: Database was not shutdown normally!
2015-02-04T01:14:35.099277Z 0 [Note] InnoDB: Starting crash recovery.
2015-02-04T01:14:35.551491Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 7 row operations to undo
2015-02-04T01:14:35.551532Z 0 [Note] InnoDB: Trx id counter is XXXX
2015-02-04T01:14:35.699284Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
2015-02-04T01:14:35.699344Z 0 [Note] InnoDB: Rolling back trx with id TTTT, 7 rows to undo

Can you please post the error log.

Options: ReplyQuote


Subject
Views
Written By
Posted
8134
January 27, 2014 09:45AM
2715
January 28, 2014 08:42AM
2758
February 24, 2014 06:21AM
2213
March 05, 2014 08:15AM
2069
March 05, 2014 10:42PM
1935
March 07, 2014 07:46AM
1436
February 02, 2015 09:33AM
1411
February 02, 2015 11:43AM
1518
February 03, 2015 05:09AM
Re: Power failure and innodb
1469
February 03, 2015 07:04PM
1888
February 04, 2015 01:03PM
1158
June 04, 2015 07:35AM
2588
March 31, 2014 06:16AM
1453
March 18, 2015 11:12AM


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.