Unrecognized character \x01; marked by <-- HERE

[Sergei Glushchenko]

Error message

Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374

is printed when backup taken with version check enabled.

[pako (pakonet)]

Thank you for reporting this bug. I believe the message is harmless, but it took me some time to figure out if it causes any problems with the backups.

[Roel Van de Paar (roel11)]

The command of one user running into this looked like this;
root@server:/mnt/data/backup# xtrabackup --backup --target-dir=.

[Jericho Rivera (jericho-rivera)]

Can't reproduce this on latest 2.3.7 and 2.4.6 versions of Xtrabackup so marking this as Invalid.

[Shahriyar Rzayev (rzayev-sehriyar)]

Well, it should be already fixed with latest versions, as I remember.

[Marcelo Altmann (marcelo.altmann)]

I can reproduce it on 2.4.6:

[root@localhost mnt]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
[root@localhost mnt]# uname -a
Linux localhost.localdomain 3.10.0-514.2.2.el7.x86_64 #1 SMP Tue Dec 6 23:06:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost mnt]# xtrabackup --version; xtrabackup --backup --target-dir=/root/backups/xtrabk_base_`date '+%Y%m%d%H%M%S'` --user=root --password='Passw0rd!'
xtrabackup version 2.4.6 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 8ec05b7)
Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
170324 11:56:07 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

[Marcelo Altmann (marcelo.altmann)]

I can also reproduce on 2.3.7

[root@localhost mnt]# xtrabackup --version; xtrabackup --backup --target-dir=/root/backups/xtrabk_base_`date '+%Y%m%d%H%M%S'` --user=root --password='Passw0rd!'
xtrabackup version 2.3.7 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 40f611f)
Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
170324 12:01:16 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2).

Package was installed via yum repo.

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-xtrabackup/pull/341
https://github.com/percona/percona-xtrabackup/pull/342

[Alexander Orlovskiy (nordicdyno)]

same error with 2.3.7-2.xenial (from ppa:percona-daily/percona-xtrabackup)

[Shahriyar Rzayev (rzayev-sehriyar)]

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