mysql - 备份 "Error: failed to execute query SET SESSION lock_wait_timeout=31536000: Lost connection to MySQL server during query"

Question

有备份日志，但是昨天备份正常，请问是哪里出了问题？

Mysql是:5.6.28

xtrabackup是:2.4.6

Unrecognized character \x01; marked by <-- HERE after <-- HERE near column 1 at - line 1374.
171107 01:36:18 Connecting to MySQL server host: 172.0.0.40, user: root, password: set, port: 3306, socket: /var/run/mysqld/mysqld.sock
Using server version 5.6.28-76.1-56-log
xtrabackup version 2.4.6 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 8ec05b7)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 1048576
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 134217728
InnoDB: Number of pools: 1
171107 01:36:18 >> log scanned up to (12857047584)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2723 for management/HzsInsertUserInfoTemp, old maximum was 0
171107 01:36:19 [01] Copying ./ibdata1 to /xtrabackup_backupfiles/ibdata1
171107 01:36:19 >> log scanned up to (12857047584)
171107 01:36:20 [01]        ...done

......
......
......

171107 01:37:40 >> log scanned up to (12857139552)
Error: failed to execute query SET SESSION lock_wait_timeout=31536000: Lost connection to MySQL server during query

Answer 1

mysql> 显示类似“%timeout%”的变量；
+----------------------------------------+----------+
|变量名 |值(value)|
+----------------------------------------+----------+
|连接超时 | 10 | 10
|延迟插入超时| 300 | 300
|有_语句_超时|是 |
| innodb_flush_log_at_timeout | innodb_flush_log_at_timeout | innodb_flush_log_at_timeout 1 |
| innodb_lock_wait_timeout | innodb_lock_wait_timeout | innodb_lock_wait_timeout 50 | 50
| innodb_rollback_on_timeout | innodb_rollback_on_timeout | innodb_rollback_on_timeout关闭 |
|交互超时 | 28800 |
|锁等待超时| 31536000 |
|网络读取超时 | 30|
|网络写入超时 | 300 | 300
| rpl_stop_slave_timeout | rpl_stop_slave_timeout | rpl_stop_slave_timeout 31536000 |
|从属网络超时 | 3600 | 3600
|线程池空闲超时 | 300 | 300
|等待超时| 28800 |
+----------------------------------------+----------+

mysql> 显示全局变量，如“%timeout%”；
+----------------------------------------+----------+
|变量名 |值(value)|
+----------------------------------------+----------+
|连接超时 | 10 | 10
|延迟插入超时| 300 | 300
|有_语句_超时|是 |
| innodb_flush_log_at_timeout | innodb_flush_log_at_timeout | innodb_flush_log_at_timeout 1 |
| innodb_lock_wait_timeout | innodb_lock_wait_timeout | innodb_lock_wait_timeout 50 | 50
| innodb_rollback_on_timeout | innodb_rollback_on_timeout | innodb_rollback_on_timeout关闭 |
|交互超时 | 28800 |
|锁等待超时| 31536000 |
|网络读取超时 | 30|
|网络写入超时 | 300 | 300
| rpl_stop_slave_timeout | rpl_stop_slave_timeout | rpl_stop_slave_timeout 31536000 |
|从属网络超时 | 3600 | 3600
|线程池空闲超时 | 300 | 300
|等待超时| 28800 |
+----------------------------------------+----------+