# Error on FLUSH NO\_WRITE\_TO\_BINLOG CHANGED\_PAGE\_BITMAPS after update to 2.2.10 **URL:** \ **Category:** Percona XtraBackup\ **Created:** [April 2, 2015, 3:15am UTC](https://forums.percona.com/t/error-on-flush-no-write-to-binlog-changed-page-bitmaps-after-update-to-2-2-10/4135 "2015-04-02T03:15:46Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![mbetel](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@mbetel](https://forums.percona.com/u/mbetel)\ **Post date:** [April 2, 2015, 3:15am UTC](https://forums.percona.com/t/error-on-flush-no-write-to-binlog-changed-page-bitmaps-after-update-to-2-2-10/4135/1 "2015-04-02T03:15:46Z")
I use xtrabackup on a Mariadb 10.0.15 running on Centos 6.7 It seems something changed in innobackupex. Yesterdays backup using the previous version 2.2.9 had no problems. Any hints on how to solve this? Thanks, Michiel I include the log here: innobackupex: Using server version 10.0.15-MariaDB-log innobackupex: Created backup directory /var/backups/mysql/incr/2015-04-01\_03-21-01/2015-04-02\_03-21-01 150402 03:21:01 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/var/backups/mys ql/incr/2015-04-01\_03-21-01/2015-04-02\_03-21-01 --innodb\_data\_file\_path=“ibdata1:12M:autoextend” --tmpdir=/mydata/data --compress --compress-threads=4 --tab les=‘._[.]._’ --extra-lsndir=‘/mydata/data’ --incremental-basedir=‘/var/backups/mysql/base/2015-04-01\_03-21-01’ --suspend-at-start --parallel=4 innobackupex: Waiting for ibbackup (pid=29526) to suspend innobackupex: Suspend file ‘/var/backups/mysql/incr/2015-04-01\_03-21-01/2015-04-02\_03-21-01/xtrabackup\_suspended\_1’ xtrabackup version 2.2.10 based on MySQL server 5.6.22 Linux (x86\_64) (revision id: ) incremental backup from 2555712792976 is enabled. xtrabackup: uses posix\_fadvise(). xtrabackup: cd to /mydata/data xtrabackup: open files limit requested 65535, set to 16384 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb\_data\_home\_dir = ./ xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend xtrabackup: innodb\_log\_group\_home\_dir = ./ xtrabackup: innodb\_log\_files\_in\_group = 2 xtrabackup: innodb\_log\_file\_size = 536870912 xtrabackup: using O\_DIRECT > > log scanned up to (2560735523319) > > xtrabackup: Generating a list of tablespaces > > xtrabackup: Creating suspend file ‘/var/backups/mysql/incr/2015-04-01\_03-21-01/2015-04-02\_03-21-01/xtrabackup\_suspended\_1’ with pid ‘29526’ 150402 03:21:02 innobackupex: Continuing after ibbackup has suspended DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CHANGED\_PAGE\_BITMAPS’ at line 1 at /usr/bin/innobackupex line 3044. innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3047 main::mysql\_query(‘HASH(0x24ec2f8)’, ‘FLUSH NO\_WRITE\_TO\_BINLOG CHANGED\_PAGE\_BITMAPS’) called at /usr/bin/innobackupex line 1970 main::backup() called at /usr/bin/innobackupex line 1601 innobackupex: Error: Error executing ‘FLUSH NO\_WRITE\_TO\_BINLOG CHANGED\_PAGE\_BITMAPS’: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CHANGED\_PAGE\_BITMAPS’ at line 1 at /usr/bin/innobackupex line 3044. 150402 03:21:02 innobackupex: Waiting for ibbackup (pid=29526) to finish ---
**Author:** ![mbetel](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@mbetel](https://forums.percona.com/u/mbetel)\ **Post date:** [April 2, 2015, 4:18am UTC](https://forums.percona.com/t/error-on-flush-no-write-to-binlog-changed-page-bitmaps-after-update-to-2-2-10/4135/2 "2015-04-02T04:18:48Z")
looking further, it looks like MariaDB does not support the statement [https://mariadb.atlassian.net/browse/MDEV-7472](https://mariadb.atlassian.net/browse/MDEV-7472)) but the statement setting $have\_changed\_page\_bitmaps on line 4984 of innodbex ('SELECT COUNT(\*) FROM INFORMATION\_SCHEMA.PLUGINS WHERE PLUGIN\_NAME LIKE ‘INNODB\_CHANGED\_PAGES’) returns 1 thus making the if in #1966 true. Removing the ‘CHANGED\_PAGE\_BITMAPS’ from the FLUSH in #1970 makes my backup run agian.