I have upgraded one of my VM’s to xtrabackup version 2.2.10. It is running MariaDB 5.5.38. I am getting a failure while trying to run an incremental.
I get this in the log
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3047
main::mysql_query(‘HASH(0x280e288)’, ‘FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS’) called at /usr/bin/innobackupex line 1970 main::backup() called at /usr/bin/innobackupex line 1601
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 fo$
150408 06:00:07 innobackupex: Waiting for ibbackup (pid=10257) to finish
I think it has to do with the flush using CHANGED_PAGE_BITMAPS and the version of MariaDB I am using.
Is there a way to change the flush method. In the mean time I have downgraded to 2.2.9 and all is working as it should