InnoDB error in server log of innodb_bug34300

Bug #937859 reported by Laurynas Biveinis
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Laurynas Biveinis

Bug Description

With the suggested fix for upstream 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

Related branches

Changed in percona-server:
assignee: nobody → Laurynas Biveinis (laurynas-biveinis)
milestone: none → 5.1.62-13.3
status: New → In Progress
importance: Undecided → Medium
Changed in percona-server:
status: In Progress → Fix Committed
Changed in percona-server:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1240

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.