Percona Server with XtraDB

innodb_extra_undoslots option is disabled error

Reported by Vadim Tkachenko on 2010-09-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
High
Unassigned

Bug Description

Percona Server may complain

"innodb_extra_undoslots option is disabled but it was enabled before"

after upgrade from MySQL,
but innodb_extra_undoslots never used.

Changed in percona-server:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
importance: Undecided → High
milestone: none → 5.1-13.0
status: New → Confirmed

It seems to detect uncleared area of builtin InnoDB.
(builtin InnoDB doesn't clear unused area of the page)

OK...

more exact check is needed.
I will try to implement it.

The first aid for the bug have been pushed

http://bazaar.launchpad.net/~percona-dev/percona-server/release-5.1.52-12/revision/137
http://bazaar.launchpad.net/~percona-dev/percona-server/release-5.1.51-12/revision/135

The first aid is to pass 0 also at least as not used.
The first aid pass if the extended slots area filled with 0, but not pass with other values.

--- innodb_expand_undo_slots.patch 2010-10-04 11:53:08 +0000
+++ innodb_expand_undo_slots.patch 2010-11-12 07:29:47 +0000
@@ -117,7 +117,7 @@
 + page_no = mtr_read_ulint(rseg_header + TRX_RSEG_UNDO_SLOTS
 + + i * TRX_RSEG_SLOT_SIZE,
 + MLOG_4BYTES, &mtr);
-+ if (page_no != FIL_NULL) {
++ if (page_no != 0 && page_no != FIL_NULL) {
 + srv_extra_undoslots = TRUE;
 + fprintf(stderr,
 +"InnoDB: Error: innodb_extra_undoslots option is disabled, but it was enabled before.\n"

Changed in percona-server:
milestone: 5.1-13.0 → 5.1.53-12.4
status: Confirmed → Fix Committed
Changed in percona-server:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers