http://bugzilla.novell.com/show_bug.cgi?id=525325 Summary: [server:database/mysql] mysqlhotcopy locks failure; knwon bug w/ fix available Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: Other OS/Version: openSUSE 11.1 Status: NEW Severity: Normal Priority: P5 - None Component: 3rd party software AssignedTo: mhrusecky@novell.com ReportedBy: pgnet.dev@gmail.com QAContact: opensuse-communityscreening@forge.provo.novell.com Found By: --- running opensuse 11.1, with mysql from .../server:/database/openSUSE_11.1, rpm -qa | grep -i ^mysql mysql-bench-5.1.36-20.1 mysql-5.1.36-20.1 mysql-tools-5.1.36-20.1 mysql-client-5.1.36-20.1 MySQL-zrm-2.1-1 at exec of a simple/manual zrm backup, mysql-zrm-scheduler --now --backup-set manual --backup-level 0 the backup fails @, ... manual:backup:INFO: PHASE START: Creating raw backup manual:backup:INFO: Command used for raw backup is /usr/share/mysql-zrm/plugins/socket-copy.pl --mysqlhotcopy=/usr/bin --host="localhost" --port="3306" --socket="/var/run/mysql/mysql.sock" --quiet mysql drupal phpmyadmin "/data/backups/db/manual/20090726120211" > /var/run/tmp/PBKYgHjF3l 2>&1 manual:backup:INFO: Output of command: 'mysqlhotcopy' is { -> DBD::mysql::db do failed: You can't use locks with log tables. at /usr/bin/mysqlhotcopy line 452. } manual:backup:INFO: raw-databases=mysql drupal phpmyadmin manual:backup:INFO: PHASE END: Creating raw backup ... where, @ /usr/bin/mysqlhotcopy:452 ... else { my $start = time; 452: $dbh->do("LOCK TABLES $hc_locks"); printf "Locked $num_tables tables in %d seconds.\n", time-$start unless $opt{quiet}; $hc_started = time; # count from time lock is granted ... digging finds, "ZRM Failed-Cant use locks with log files?" http://forums.zmanda.com/showthread.php?p=7554 "MySQL 5.1 mysqlhotcopy and log tables: check your backup scripts! " http://planet.mysql.com/entry/?id=17913 "mysqlhotcopy does not ignore log tables and others in mysql database" http://bugs.mysql.com/bug.php?id=43594 and a simple patch to openSUSE's mysqlhotcopy fixes the problem, wget -k -O /usr/local/src/mysqlhotcopy.bug43594.patch "http://bugs.mysql.com/file.php?id=11560" cd /usr/bin ln -sf mysqlhotcopy mysqlhotcopy.sh patch -p1 < /usr/local/src/mysqlhotcopy.bug43594.patch mv mysqlhotcopy.sh mysqlhotcopy although i'm seeing this in a zrm backup, this is a general problem. as patch won't survive a mysql update/upgrade, the problem will re-surface, causing relatively quiet failures of any automate/scripted backups etc etc. should be applied as a fix to opensuse's pkg until if/when applied upstream. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.