I_S.INNODB_CHANGED_PAGES unavailable with custom innodb_data_home_dir

Bug #1364315 reported by Alexey Kopytov on 2014-09-02
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Nickolay Ihalainen
5.1
Won't Fix
Medium
Unassigned
5.5
Fix Released
Medium
Nickolay Ihalainen
5.6
Fix Released
Medium
Nickolay Ihalainen

Bug Description

This is essentially the incompletely fixed bug #1181887.

$ ./mysqld --innodb-data-home-dir=/usr/local/mysql/ibdata --innodb_track_changed_pages=1

mysql> select * from information_schema.innodb_changed_pages;
ERROR 1012 (HY000): Can't read record in system table

Error log:

2014-09-02 14:20:15 93905 [Warning] InnoDB: error opening the changed page bitmap '/usr/local/mysql/ibdataib_modified_log_1_0.xdb'

The PXB side of this bug is bug #1362259.

Alexey Kopytov (akopytov) wrote :

The workaround is to make sure innodb_data_home_dir has a trailing slash, e.g. /usr/local/mysql/ibdata/

tags: added: bitmap xtradb
tags: added: low-hanging-fruit

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

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

Other bug subscribers