Bug #64128 InnoDB error in server log of innodb_bug34300
Submitted: 25 Jan 2012 11:53 Modified: 15 Oct 2012 13:46
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: InnoDB Plugin storage engine Severity:S3 (Non-critical)
Version:5.1 bzr revno 3670 OS:Any
Assigned to: CPU Architecture:Any

[25 Jan 2012 11:53] Laurynas Biveinis
With the suggested fix for bug 64127 applied, the testcase innodb_bug34300 starts (correctly) failing: (or the error log may be inspected manually without that fix applied)

innodb_plugin.innodb_bug34300            [ fail ]  Found warnings/errors in server log file!
        Test ended at 2012-01-25 13:31:50
120125 14:31:49  InnoDB: ERROR: the age of the last checkpoint is 9439048,
^ Found warnings in /home/laurynas/percona/mysql-PS/5.1/mysql-test/var/log/mysqld.1.err

The testcase inserts a 8.5MB BLOB while the server is using the default redo log file size, making the checkpoint age go beyond the log capacity.

How to repeat:
Apply the fix for bug 64127 and then ./mysql-test-run innodb_bug34300.

Alternatively just ./mysql-test-run innodb_bug34300 and inspect the error log for InnoDB errors.

Suggested fix:
Following the rule of thumb that log group capacity must be 10x the size of largest row with BLOB, add a innodb_bug34300-master.opt with contents

[25 Jan 2012 12:06] Valeriy Kravchuk
Thank you for the problem report. Verified just as described with current 5.1.62 from bzr on 64-bit FC14.
[15 Oct 2012 13:46] Erlend Dahl
Fixed in 5.1.63