--history can not insert table xtrabackup_history
Bug #1707811 reported by
supersujj
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
New
|
Undecided
|
Unassigned |
Bug Description
my environment is mysql 5.7.18 and build a mysql group replication. when i use xtrabackup with --history option,it can create database "percona_schema" and table "xtrabackup_
my command like this :
innobackupex --login-
Changed in percona-xtrabackup: | |
status: | Invalid → New |
To post a comment you must log in.
Hi,
What is your xtrabackup version?
I use the same PS 5.7.18 with ordinary master/slave setup + PXB 2.4.8 and everything looks OK.
xtrabackup --defaults- file=/home/ shahriyar. rzaev/sandboxes /rsandbox_ Percona- Server- 5_7_18/ master/ my.sandbox. cnf --user=msandbox --password= 'msandbox' --target- dir=/home/ shahriyar. rzaev/backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt- key='VVTBwgM4Uh wkTTV98fhuj+ D1zyWoA89K' --encrypt-threads=4 --encrypt- chunk-size= 65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream="xbstream" > /home/shahriyar .rzaev/ backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15/full_ backup. stream
master [localhost] {root} (PERCONA_SCHEMA) > show tables; ------- ------- ------+ in_PERCONA_ SCHEMA | ------- ------- ------+ ------- ------- ------+
+------
| Tables_
+------
| xtrabackup_history |
+------
1 row in set (0.00 sec)
> select * from xtrabackup_ history\ G ******* ******* ****** 1. row ******* ******* ******* ****** 7689-11e7- ac73-002590e9b4 48 file=/home/ shahriyar. rzaev/sandboxes /rsandbox_ Percona- Server- 5_7_18/ master/ my.sandbox. cnf --user=msandbox --password=... --target- dir=/home/ shahriyar. rzaev/backup_ dir/ps_ 5.7_master/ full/2017- 08-01_07- 17-15 --backup --host=127.0.0.1 --port=20393 --encrypt=AES256 --encrypt-key=... --encrypt-threads=4 --encrypt- chunk-size= 65536 --check-privileges --no-version-check --parallel=8 --throttle=1000 --history --stream=xbstream 1111-1111- 1111-1111111111 11:1-1511'
*******
uuid: 830b4057-
name: NULL
tool_name: xtrabackup
tool_command: --defaults-
tool_version: 2.4.7
ibbackup_version: 2.4.7
server_version: 5.7.18-15-log
start_time: 2017-08-01 07:17:15
end_time: 2017-08-01 07:17:43
lock_time: 0
binlog_pos: filename 'mysql-bin.000005', position '154', GTID of the last change '00020393-
innodb_from_lsn: 0
innodb_to_lsn: 2892770773
partial: N
incremental: N
format: xbstream
compact: N
compressed: N
encrypted: Y
1 row in set (0.00 sec)
RESULT: could not reproduce. Marking as invalid for now.
As a general rule, I am not suggesting to use innobackupex because it is already deprecated and it is going to be removed in future releases. Please use xtrabackup instead. /www.percona. com/doc/ percona- xtrabackup/ LATEST/ manual. html
As described here:
https:/