MySQL Bugs: #64128: InnoDB error in server log of innodb

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:	None
Category:	MySQL Server: InnoDB Plugin storage engine	Severity:	S3 (Non-critical)
Version:	5.1 bzr revno 3670	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
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
line
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

--innodb-log-file-size=40M

Thank you for the problem report. Verified just as described with current 5.1.62 from bzr on 64-bit FC14.

Fixed in 5.1.63