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
8142
January 27, 2014 09:45AM
2719
January 28, 2014 08:42AM
2762
February 24, 2014 06:21AM
2216
March 05, 2014 08:15AM
2072
March 05, 2014 10:42PM
1937
March 07, 2014 07:46AM
1439
February 02, 2015 09:33AM
1414
February 02, 2015 11:43AM
1521
February 03, 2015 05:09AM
Re: Power failure and innodb
1472
February 03, 2015 07:04PM
1891
February 04, 2015 01:03PM
1161
June 04, 2015 07:35AM
2592
March 31, 2014 06:16AM
1455
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.