Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.12, 10.1.32, 10.2.14, 10.3.5
-
None
-
CentOS Linux 7.4
-
10.2.14
Description
mariabackup is starting with not existing mysql user
expected :
mariabackup does not start if mysql user does not exist
target-dir does not left over
how to repeat :
start mariabackup with unexisting mysql username – operations is accepted and
copyng started ;
at some stage it's received Error but target-dir left over
[root@t4w6 ~]# mariabackup -u dd --backup --target-dir /var/backuup
|
180117 18:09:16 Connecting to MySQL server host: localhost, user: dd, password: not set, port: not set, socket: not set
|
Using server version 10.2.12-MariaDB
|
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /var/lib/mysql/
|
mariabackup: open files limit requested 0, set to 1024
|
mariabackup: using the following InnoDB configuration:
|
mariabackup: innodb_data_home_dir = .
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = ./
|
2018-01-17 18:09:16 140109404092544 [Note] InnoDB: Number of pools: 1
|
180117 18:09:16 >> log scanned up to (1628412)
|
mariabackup: Generating a list of tablespaces
|
2018-01-17 18:09:16 140109404092544 [Warning] InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0
|
180117 18:09:16 [01] Copying ./ibdata1 to /var/backuup/ibdata1
|
180117 18:09:16 [01] ...done
|
180117 18:09:16 [01] Copying ./mysql/innodb_table_stats.ibd to /var/backuup/mysql/innodb_table_stats.ibd
|
180117 18:09:16 [01] ...done
|
180117 18:09:16 [01] Copying ./mysql/innodb_index_stats.ibd to /var/backuup/mysql/innodb_index_stats.ibd
|
180117 18:09:16 [01] ...done
|
180117 18:09:16 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/backuup/mysql/gtid_slave_pos.ibd
|
180117 18:09:16 [01] ...done
|
180117 18:09:17 [01] Copying ./ff/ff.ibd to /var/backuup/ff/ff.ibd
|
180117 18:09:17 [01] ...done
|
180117 18:09:17 [01] Copying ./ff1/ff1.ibd to /var/backuup/ff1/ff1.ibd
|
180117 18:09:17 [01] ...done
|
180117 18:09:17 >> log scanned up to (1628412)
|
180117 18:09:17 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
|
Error: failed to execute query FLUSH NO_WRITE_TO_BINLOG TABLES: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
|
MariaDB [(none)]> select user from mysql.user; |
+------+ |
| user | |
+------+ |
| ff |
|
| root |
|
| root |
|
| |
|
| ff |
|
| root |
|
| |
|
| ff |
|
| root |
|
+------+ |
9 rows in set (0.01 sec) |
[root@t4w6 ~]# ls /var/backuup
|
ff ff1 ibdata1 ib_logfile0 mysql
|