MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Power off: The log sequence numbers in ibdata files do not match the log sequence number in the ib_logfiles!
Posted by: Tobia Bea
Date: June 04, 2015 07:16AM

Locking into windows events I DID NOT find any "critical power off" events, seems that mysql server stops or were killed from windows shutdown.
The mysqldump backup has all rollback rows, so I'm sure that these rows were commited.

What I really did not understand is why there was a rollback... I can understand a table corruption in case of disk error, but why a rollback during the improper server shutdown?
More over it can't be a disk flush problem, because the last row was inserted at 9:02:57PM and the server shutdown was start 9:21:41PM...
I'm really scared about this behavour.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Power off: The log sequence numbers in ibdata files do not match the log sequence number in the ib_logfiles!
16046
Tobia Bea
June 03, 2015 02:55PM
Re: Power off: The log sequence numbers in ibdata files do not match the log sequence number in the ib_logfiles!
6265
Tobia Bea
June 04, 2015 07:16AM
Re: Power off: The log sequence numbers in ibdata files do not match the log sequence number in the ib_logfiles!
5493
Tobia Bea
June 15, 2015 01:23AM


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.