~lachlan-mulcahy/percona-xtrabackup/1.6-bug903984

  • Committer: Alexey Kopytov
  • Date: 2011-11-11 18:12:31 UTC
  • Revision ID: akopytov@gmail.com-20111111181231-ax8fbousm0s09s43
Bug #408803: innodbbackupex reaches Servers wait_timeout

The problem was the flawed keep-alive logic in innobackupex: keep-alive
queries were only sent to server when mysql_keep_alive() or
mysql_check() were explicitly called. Which led to connection timeouts
when some activity between those calls (e.g. copying a large non-InnoDB
file) took longer than server's wait_timeout.

Fixed innobackupex so that keep-alive queries are now sent automatically
using alarms. The time interval was also reduced from 1800 to 5 seconds
to accommodate low wait_timeout values. Since there is no need for
explicit calls to mysql_check() and mysql_keep_alive(), those functions
were removed.

There is no test case, because time sensitive tests for innobackupex are
basically impossible.
Filename Latest Rev Last Changed Committer Comment Size
..
contrib 241.2.1 13 years ago Daniël van Eeden Add contrib directory with an backup script exampl Diff
doc 213.3.1 13 years ago Aleksandr Kuzminsky Added XtraBackup manual page Diff
patches 228.1.2 13 years ago Alexey Kopytov Port XtraBackup to Percona Server 5.5.9-beta20.1 c Diff
test 134.1.1 13 years ago Aleksandr Kuzminsky Added the XtraBackup test framework Diff
utils 30.1.2 15 years ago Vadim Tkachenko directory restructure Diff
BUILD.txt 280 12 years ago Stewart Smith backport BUILD.txt fixes 2.7 KB Diff Download File
COPYING 174.1.1 13 years ago Stewart Smith add COPYING file with GPLv2 license. xtrabackup is 18.6 KB Diff Download File
File innobackupex 305 12 years ago Alexey Kopytov Bug #408803: innodbbackupex reaches Servers wait_t 89.5 KB Diff Download File
Symlink innobackupex-1.5.1 216 13 years ago Vadim Tkachenko Bugfix #701767 Script innobackupex-1.5.1 renamed .
Makefile 297 12 years ago Stewart Smith Merge 1.4 release tag 7.8 KB Diff Download File
VERSION 290.1.1 12 years ago Ignacio Nin Upgrade version to 1.6.3 25 bytes Diff Download File
xtrabackup.c 304 12 years ago Alexey Kopytov Bug #884737: xtrabackup's --parallel option assert 172 KB Diff Download File