innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server.

[melon]

I'm testing percona-xtrabackup-2.2.3 to backup our databases based on mysql-5.1.63. It's awesome. I'm preparing to use it in our production environment. But today when i do my backup test i noticed that there is a warning such like following:

"innobackupex: Warning: FLUSH ENGINE LOGS is not supported by the server. Data may be inconsistent with binary log coordinates!

Wil the backup have very less chance to be inconsistent when we don't use "FLUSH ENGINE LOGS"? If not, will it be better if we use "FLUSH LOGS" rather than just give a warning when we backup the databases based on mysql-5.1.x?

please give me some advice

BTW,I found that the following source which check the condition to eject the warning is not very correct.
4857 if ($mysql{vars}->{version}->{Value} =~ m/5.[123]\.\d/) {
should be
4857 if ($mysql{vars}->{version}->{Value} =~ m/5\.[123]\.\d/) {

best regards!

melon

[Alexey Kopytov (akopytov)]

Yes, there's a rather low chance to get inconsistent binary log coordinates when backing up 5.1 servers. Note that data consistency is not affected.

Using FLUSH LOGS instead of FLUSH ENGINE LOGS looks too invasive for a backup utility.

Closing this report as invalid, but thank you for catching this regexp bug in detect_mysql_capabilities_for_backup()! Reported separately as bug #1357404.

[Shahriyar Rzayev (rzayev-sehriyar)]

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