# Incremental backup on slave failed
**URL:** https://forums.percona.com/t/incremental-backup-on-slave-failed/31897
**Category:** Percona XtraBackup
**Created:** [July 30, 2024, 7:39am UTC](https://forums.percona.com/t/incremental-backup-on-slave-failed/31897 "2024-07-30T07:39:06Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@sukit](https://forums.percona.com/u/sukit)
#### Post date: [July 30, 2024, 7:39am UTC](https://forums.percona.com/t/incremental-backup-on-slave-failed/31897/1 "2024-07-30T07:39:06Z")
I found error when created incremental backup on slave
[ERROR] [MY-011825] [Xtrabackup] failed to execute query ‘SET SESSION lock\_wait\_timeout=31536000’ : 2013 (HY000) Lost connection to MySQL server during query
mysql\> show global variables like ‘%timeout%’;
±----------------------------------±---------+
| Variable\_name | Value |
±----------------------------------±---------+
| connect\_timeout | 10 |
| delayed\_insert\_timeout | 300 |
| have\_statement\_timeout | YES |
| innodb\_flush\_log\_at\_timeout | 1 |
| innodb\_lock\_wait\_timeout | 50 |
| innodb\_rollback\_on\_timeout | OFF |
| interactive\_timeout | 28800 |
| lock\_wait\_timeout | 31536000 |
| mysqlx\_connect\_timeout | 30 |
| mysqlx\_idle\_worker\_thread\_timeout | 60 |
| mysqlx\_interactive\_timeout | 28800 |
| mysqlx\_port\_open\_timeout | 0 |
| mysqlx\_read\_timeout | 30 |
| mysqlx\_wait\_timeout | 28800 |
| mysqlx\_write\_timeout | 60 |
| net\_read\_timeout | 30 |
| net\_write\_timeout | 60 |
| replica\_net\_timeout | 60 |
| rpl\_stop\_replica\_timeout | 31536000 |
| rpl\_stop\_slave\_timeout | 31536000 |
| slave\_net\_timeout | 60 |
| ssl\_session\_cache\_timeout | 300 |
| wait\_timeout | 28800 |
±----------------------------------±---------+
mysql\> show processlist
→ ;
±—±----------------±----------------±-----±--------±-----±---------------------------------------------------------±-----------------+
| Id | User | Host | db | Command | Time | State | Info |
±—±----------------±----------------±-----±--------±-----±---------------------------------------------------------±-----------------+
| 5 | event\_scheduler | localhost | NULL | Daemon | 309 | Waiting on empty queue | NULL |
| 6 | system user | connecting host | NULL | Connect | 309 | Waiting for source to send event | NULL |
| 7 | system user | | NULL | Query | 309 | Replica has read all relay log; waiting for more updates | NULL |
| 10 | system user | | NULL | Connect | 309 | Waiting for an event from Coordinator | NULL |
| 11 | system user | | NULL | Connect | 309 | Waiting for an event from Coordinator | NULL |
| 12 | system user | | NULL | Connect | 309 | Waiting for an event from Coordinator | NULL |
| 13 | system user | | NULL | Connect | 309 | Waiting for an event from Coordinator | NULL |
| 14 | root | localhost | NULL | Query | 0 | init | show processlist |
±—±----------------±----------------±-----±--------±-----±---------------------------------------------------------±-----------------+
Is there any way to fix this?
No error when create full backup on slave, no error when create full and incremental backup on master
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [July 30, 2024, 2:25pm UTC](https://forums.percona.com/t/incremental-backup-on-slave-failed/31897/2 "2024-07-30T14:25:52Z")
Hello @sukit,
I don’t understand your issue. Can you please give all commands used and all output? It looks like everything is fine with replication.
---
### Author:  [@sukit](https://forums.percona.com/u/sukit)
#### Post date: [July 31, 2024, 2:46am UTC](https://forums.percona.com/t/incremental-backup-on-slave-failed/31897/3 "2024-07-31T02:46:03Z")
I run this command “xtrabackup --user=bkpuser --password --backup --slave-info --target-dir=/var/mysql\_backup/full” for full backup and “xtrabackup --user=bkpuser --password --backup --slave-info --target-dir=/var/mysql\_backup/incr --incremental-basedir=/var/mysql\_backup/full” for incremental backup
output in attach file
[output\_full.txt](https://forums.percona.com/uploads/short-url/zIvrGEdhmvFZNDz5y1JObAUBFce.txt) (51.5 KB)
[output\_incr.txt](https://forums.percona.com/uploads/short-url/w8IHGYJ2wAzwFPcCWvm103GFY8w.txt) (5.4 KB)