Percona Server moved to https://jira.percona.com/projects/PS

I_S.INNODB_CHANGED_PAGES unavailable with custom innodb_data_home_dir

Bug #1364315 reported by Alexey Kopytov on 2014-09-02

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
Percona Server moved to https://jira.percona.com/projects/PS	Fix Released	Medium	Nickolay Ihalainen	Percona Server moved to https://jira.percona.com/projects/PS 5.6.27-75.0
5.1	Won't Fix	Medium	Unassigned
5.5	Fix Released	Medium	Nickolay Ihalainen	Percona Server moved to https://jira.percona.com/projects/PS 5.5.46-37.5
5.6	Fix Released	Medium	Nickolay Ihalainen	Percona Server moved to https://jira.percona.com/projects/PS 5.6.27-75.0

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.

Tags:

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2014-09-02:

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

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2015-09-24:

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

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

This report contains Public information

Everyone can see this information.

You are

Subscribing...

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