Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2388

LP:697174 - mysqldump --single-transaction in maria-5.1-mwl136 uses an absolute path to master_log_file in CHANGE MASTER

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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;

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                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.

                Show
                knielsen Kristian Nielsen added a comment - 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.
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                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

                Show
                knielsen Kristian Nielsen added a comment - 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
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 697174

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 697174

                  People

                  • Assignee:
                    knielsen Kristian Nielsen
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: