Disabling Change Buffer Dynamically Can Corrupt InnoDB

Description

I changed some dynamic mysql settings, MySQL then got stuck on &dict_operation_lock
stop slave, show slave status, all hung....

MySQL died after 600+ seconds, and when starting again it was corrupted.

The very weird thing that happened is that 'checkpoint age' went above 'max checkpoint age', as you can see below.

This is what I originally did:

MySQL crashes after +600 seconds....

If we then try to start MySQL... I get InnoDB Corruption...

Here's the log:

Environment

debian wheezy 7.2

Assignee

Jan Lindström

Reporter

Kenny

Labels

Components

Sprint

None

Fix versions

Affects versions

Priority

Critical
Configure