https://bugs.koozali.org/show_bug.cgi?id=11970
--- Comment #25 from John Crisp <[email protected]> ---
(In reply to Terry Fage from comment #17)
> at this stage NOT seeing the previous error with this dev version, just the
> one ar #c16
>
> mysqldump: Got error: 1556: "You can't use locks with log tables" when using
> LOCK TABLES
> not worried etc, backup still done
OK - this one is in automysqlbackup rpm itself.
Fix is probably like this with skip_lock_tables seemingly the answer:
diff -ruN automysqlbackup.orig automysqlbackup
--- automysqlbackup.orig 2022-08-11 15:23:01.188012917 +0100
+++ automysqlbackup 2022-08-11 15:23:50.291968433 +0100
@@ -457,13 +457,13 @@
# @deps: load_default_config
parse_configuration () {
# OPT string for use with mysqldump ( see man mysqldump )
- opt=( '--quote-names' '--opt' '--events')
+ opt=( '--quote-names' '--opt' '--events' '--skip_lock_tables' )
# OPT string for use with mysql (see man mysql )
mysql_opt=()
# OPT string for use with mysqldump fullschema
- opt_fullschema=( '--all-databases' '--routines' '--no-data' )
+ opt_fullschema=( '--all-databases' '--routines' '--no-data'
'--skip_lock_tables' )
# OPT string for use with mysqlstatus
opt_dbstatus=( '--status' )
If that works tonight then we can patch the automysqlbackup rpm itself.
There are also a couple more mods to smeserver-automysqlbackup to do as well.
runmysql - change to add 2 config entries
-/usr/local/bin/automysqlbackup $1 >/dev/null
+/usr/local/bin/automysqlbackup $1 $2 >/dev/null
config files - use -bc and mymaria105
-$OUT .= "/sbin/e-smith/runmysqlbackup /etc/automysqlbackup/mymaria105.conf
'_mysql105' > /dev/null ; " if $my105 eq "enabled";
+$OUT .= "/sbin/e-smith/runmysqlbackup -bc /etc/automysqlbackup/mymaria105.conf
> /dev/null ; " if $my105 eq "enabled";
Patches attached.
--
You are receiving this mail because:
You are the QA Contact for the bug._______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/
