[MDEV-2388] LP:697174 - mysqldump --single-transaction in maria-5.1-mwl136 uses an absolute path to master_log_file in CHANGE MASTER Created: 2011-01-04  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Philip Stoev (Inactive) Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug697174.xml    

 Description   

When using mysqldump --single-transaction --master data, the following CHANGE MASTER is produced:

CHANGE MASTER TO MASTER_LOG_FILE='/home/philips/bzr/maria-5.1-mwl136/mysql-test/var/log/master-bin.000001', MASTER_LOG_POS=1255946;

Using absolute paths for MASTER_LOG_FILE will cause the slave to stop with a "cannot open first file" error. By contrast, normal mysqldump would return:

CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=1255946;

To reproduce:

  1. default mysqldump from RPM
    mysqldump --single-transaction --master-data -uroot --protocol=tcp --port=19300 test | grep -i change
    CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=1255946;
  1. mysqldump from wl139
    ../client/mysqldump --single-transaction --master-data -uroot --protocol=tcp --port=19300 test | grep -i change
    CHANGE MASTER TO MASTER_LOG_FILE='/home/philips/bzr/maria-5.1-mwl136/mysql-test/var/log/master-bin.000001', MASTER_LOG_POS=1255946;

../client/mysqldump --master-data -uroot --protocol=tcp --port=19300 test | grep -i change
CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=1255946;

 Comments   
Comment by Kristian Nielsen [ 2011-01-27 ]

Re: mysqldump --single-transaction in maria-5.1-mwl136 uses an absolute path to master_log_file in CHANGE MASTER
Thanks for spotting this!

The underlying issue is different output between these two statements:

MariaDB [test]> show master status;

------------------------------------------------------+

File Position Binlog_Do_DB Binlog_Ignore_DB

------------------------------------------------------+

mysql-bin.000051 240    

------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> SHOW STATUS LIKE 'binlog_snapshot_%'

-> ;

--------------------------------------------+

Variable_name Value

--------------------------------------------+

binlog_snapshot_file ./mysql-bin.000051
binlog_snapshot_position 240

--------------------------------------------+

2 rows in set (0.00 sec)

Note the leading `./' in the second version; this should be removed.

Comment by Kristian Nielsen [ 2011-01-27 ]

Re: mysqldump --single-transaction in maria-5.1-mwl136 uses an absolute path to master_log_file in CHANGE MASTER
Fix pushed into mariadb-5.1-mwl136 and mariadb-5.2-rpl

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 697174

Generated at Thu Feb 08 06:41:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.