innodbbackupex reaches Servers wait_timeout
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Alexey Kopytov | ||
1.6 |
Fix Released
|
High
|
Alexey Kopytov | ||
2.0 |
Fix Released
|
High
|
Alexey Kopytov |
Bug Description
Hi,
during --backup innodbbackupex holds an open mysql session on the source which reaches the wait_timeout setting of the server if the backup takes longer.
Error Message:
>> log scanned up to (10 2391690023)
>> log scanned up to (10 2391690023)
>> log scanned up to (10 2391690023)
>> log scanned up to (10 2391690023)
innobackupex: Error: mysql child process has died: ERROR 2006 (HY000) at line 19: MySQL server has gone away
Here is my fix:
[root@lnxp-
--- /tmp/old/
+++ /tmp/new/
@@ -1022,6 +1022,9 @@
$now = current_time();
print STDERR "$now $prefix Connected to database with mysql child process (pid=$mysql_
+ print MYSQL_WRITER "SET SESSION wait_timeout = 1800;\n"
+ or die "Connection to mysql child process failed: $!";
+
mysql_check();
}
KR,
Thomas
Related branches
- Alexey Kopytov (community): Approve
- Vadim Tkachenko: Pending requested
-
Diff: 51 lines (+36/-0)2 files modifiedinnobackupex (+1/-0)
test/experimental/bug408803.sh (+35/-0)
- Stewart Smith (community): Approve
-
Diff: 262 lines (+77/-57)3 files modifiedinnobackupex (+59/-53)
test/t/bug884737.sh (+14/-0)
xtrabackup.c (+4/-4)
- Stewart Smith (community): Approve
-
Diff: 282 lines (+81/-60)5 files modifieddoc/source/innobackupex/how_innobackupex_works.rst (+1/-1)
doc/source/innobackupex/privileges.rst (+1/-1)
innobackupex (+61/-54)
test/t/bug884737.sh (+14/-0)
xtrabackup.c (+4/-4)
Changed in percona-xtrabackup: | |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
Changed in percona-xtrabackup: | |
importance: | Undecided → Medium |
Changed in percona-xtrabackup: | |
assignee: | Yasufumi Kinoshita (yasufumi-kinoshita) → Alexey Kopytov (akopytov) |
milestone: | none → 1.6 |
status: | New → Confirmed |
Changed in percona-xtrabackup: | |
status: | Confirmed → New |
assignee: | Alexey Kopytov (akopytov) → Valentine Gostev (core-longbow) |
Changed in percona-xtrabackup: | |
importance: | Medium → High |
Changed in percona-xtrabackup: | |
status: | New → Fix Committed |
Changed in percona-xtrabackup: | |
milestone: | 1.6 → 1.7 |
Changed in percona-xtrabackup: | |
assignee: | nobody → Alexey Kopytov (akopytov) |
status: | Triaged → Fix Released |
wait_timeout = 1800 is maybe a bit short. A large dataset will probably take longer. Would be useful to have a commandline option therefore or a bigger timeout like 60.000.