Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.3(EOL)
-
Debian
Description
See also (original report):
http://bugs.debian.org/946671
Using mysqlhotcopy, I received the error:
DBD::mysql::db do failed: You can't use locks with log tables at /usr/bin/mysqlhotcopy line 545.
(Your line number may differ: I use my "own" mysqlhotcopy, as per
http://bugs.debian.org/735014 .)
This seems related to the new transaction_registry table
as suggested in
https://mariadb.com/kb/en/library/mysqldump/
that says:
mysqldump in MariaDB 10.3 includes logic to cater for the
mysql.transaction_registry table. ...
My patch for this issue, below.
Cheers, Paul
--- /usr/bin/mysqlhotcopy.OLD 2017-12-26 09:11:27.000000000 +1100
|
+++ /usr/bin/mysqlhotcopy 2019-12-13 21:10:34.225611502 +1100
|
@@ -317,8 +317,24 @@
|
## keep in sync with mysqldump.
|
if ($db =~ m/^mysql$/i)
|
{
|
+#####
|
+# @dbh_base_tables = grep
|
+# { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables
|
+#####
|
+# PSz 13 Dec 2019
|
+# Skip transaction_registry also.
|
+# See also:
|
+# https://bugs.mysql.com/bug.php?id=43594
|
+# https://bugs.debian.org/574514
|
+# and see
|
+# https://mariadb.com/kb/en/library/mysqldump/
|
+# that says:
|
+# mysqldump in MariaDB 10.3 includes logic to cater for the mysql.transaction_registry table. ...
|
+# but I guess they forgot about mysqlhotcopy.
|
+#####
|
@dbh_base_tables = grep
|
- { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables
|
+ { !/^(apply_status|schema|general_log|slow_log|transaction_registry)$/ } @dbh_base_tables
|
+#####
|
}
|
|
## generate regex for tables/files |
–
Paul Szabo psz@maths.usyd.edu.au http://www.maths.usyd.edu.au/u/psz/
School of Mathematics and Statistics University of Sydney Australia
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
See also (original report):
http://bugs.debian.org/946671 Using mysqlhotcopy, I received the error: DBD::mysql::db do failed: You can't use locks with log tables at /usr/bin/mysqlhotcopy line 545. (Your line number may differ: I use my "own" mysqlhotcopy, as per http://bugs.debian.org/735014 .) This seems related to the new transaction_registry table as suggested in https://mariadb.com/kb/en/library/mysqldump/ that says: mysqldump in MariaDB 10.3 includes logic to cater for the mysql.transaction_registry table. ... My patch for this issue, below. Cheers, Paul --- /usr/bin/mysqlhotcopy.OLD 2017-12-26 09:11:27.000000000 +1100 +++ /usr/bin/mysqlhotcopy 2019-12-13 21:10:34.225611502 +1100 @@ -317,8 +317,24 @@ ## keep in sync with mysqldump. if ($db =~ m/^mysql$/i) { +##### +# @dbh_base_tables = grep +# { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables +##### +# PSz 13 Dec 2019 +# Skip transaction_registry also. +# See also: +# https://bugs.mysql.com/bug.php?id=43594 +# https://bugs.debian.org/574514 +# and see +# https://mariadb.com/kb/en/library/mysqldump/ +# that says: +# mysqldump in MariaDB 10.3 includes logic to cater for the mysql.transaction_registry table. ... +# but I guess they forgot about mysqlhotcopy. +##### @dbh_base_tables = grep - { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables + { !/^(apply_status|schema|general_log|slow_log|transaction_registry)$/ } @dbh_base_tables +##### } ## generate regex for tables/files -- Paul Szabo psz@maths.usyd.edu.au http://www.maths.usyd.edu.au/u/psz/ School of Mathematics and Statistics University of Sydney Australia |
See also (original report):
http://bugs.debian.org/946671 Using mysqlhotcopy, I received the error: DBD::mysql::db do failed: You can't use locks with log tables at /usr/bin/mysqlhotcopy line 545. (Your line number may differ: I use my "own" mysqlhotcopy, as per http://bugs.debian.org/735014 .) This seems related to the new transaction_registry table as suggested in https://mariadb.com/kb/en/library/mysqldump/ that says: mysqldump in MariaDB 10.3 includes logic to cater for the mysql.transaction_registry table. ... My patch for this issue, below. Cheers, Paul {code:diff} --- /usr/bin/mysqlhotcopy.OLD 2017-12-26 09:11:27.000000000 +1100 +++ /usr/bin/mysqlhotcopy 2019-12-13 21:10:34.225611502 +1100 @@ -317,8 +317,24 @@ ## keep in sync with mysqldump. if ($db =~ m/^mysql$/i) { +##### +# @dbh_base_tables = grep +# { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables +##### +# PSz 13 Dec 2019 +# Skip transaction_registry also. +# See also: +# https://bugs.mysql.com/bug.php?id=43594 +# https://bugs.debian.org/574514 +# and see +# https://mariadb.com/kb/en/library/mysqldump/ +# that says: +# mysqldump in MariaDB 10.3 includes logic to cater for the mysql.transaction_registry table. ... +# but I guess they forgot about mysqlhotcopy. +##### @dbh_base_tables = grep - { !/^(apply_status|schema|general_log|slow_log)$/ } @dbh_base_tables + { !/^(apply_status|schema|general_log|slow_log|transaction_registry)$/ } @dbh_base_tables +##### } ## generate regex for tables/files {code} -- Paul Szabo psz@maths.usyd.edu.au http://www.maths.usyd.edu.au/u/psz/ School of Mathematics and Statistics University of Sydney Australia |
| Assignee | Aleksey Midenkov [ midenok ] |
| Labels | Patch patch |
| Labels | Patch patch | patch |
| Labels | patch | patch trx-versioning |
| Fix Version/s | 10.3 [ 22126 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.3.23 [ 24222 ] | |
| Fix Version/s | 10.4.13 [ 24223 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 101884 ] | MariaDB v4 [ 157100 ] |