Changed page bitmaps support does not work in innobackupex

Bug #1436793 reported by Sergei Glushchenko on 2015-03-26
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
High
Sergei Glushchenko
2.2
Fix Released
High
Sergei Glushchenko
2.3
Fix Released
High
Sergei Glushchenko

Bug Description

Following always sets $have_changed_page_bitmaps to 0
$have_changed_page_bitmaps =
    mysql_query($con, "SELECT COUNT(*) FROM " .
                "INFORMATION_SCHEMA.PLUGINS " .
                "WHERE PLUGIN_NAME LIKE 'INNODB_CHANGED_PAGES'");

Wayne Davison (wayned) wrote :

This also affects MariaDB 5.5, so the released fix is too specific:

                          "AND NOT VERSION() LIKE '10.%MariaDB%'");

You could either just drop the "10." prefix, so that it matches all MariaDBs, or perhaps switch to an RLIKE that matches more versions:

                          "AND NOT VERSION() RLIKE '^(5|10)\..*MariaDB'");

Wayne Davison (wayned) wrote :

Note: my suggested RLIKE would need an extra backslash to make it through perl's double-quoted string parsing:

                          "AND NOT VERSION() RLIKE '^(5|10)\\..*MariaDB'");

Can you please point me to the documentation or JIRA ticket from where I can see which exact versions of MariaDB report INNODB_CHANGED_PAGES plugin and don't support corresponding FLUSH syntax? Is 10.1 affected as well?

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

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

Other bug subscribers