[MDEV-16028] 10.3 server is not compatible with previous versions of mysqldump Created: 2018-04-25  Updated: 2019-03-19  Resolved: 2018-04-27

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Scripts & Clients, Versioned Tables
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

mysqldump of 10.2 cannot dump mysql database of 10.3, it fails with 

mysqldump: Got error: 1556: "You can't use locks with log tables" when using LOCK TABLES

due to mysql.transaction_registry table. The change is apparently intentional, since 10.3 mysqldump has special logic to deal with it, introduced by the commit below (and possibly more):

commit af88c662527e9a989fe44e653c2e7adde29f3876
 
Author: Aleksey Midenkov
 
Date:   Wed Nov 15 14:46:13 2017 +0300
 
 
 
    SQL,Client: mysqldump for TRT fix [#302]
 
    
    Test results:
 
    main.
 
    mysqldump
 
    mysqldump-max
 
    mysqld--help
 
    openssl_1

This unfortunate incompatibility needs to be documented somewhere.

 Comments   
Comment by Ian Gilfillan [ 2018-04-27 ]

Documented in https://mariadb.com/kb/en/library/mysqldump/ and https://mariadb.com/kb/en/library/upgrading-from-mariadb-102-to-mariadb-103/

Generated at Thu Feb 08 08:25:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.