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

Produce a more meaningful error message on attempt to start GTID-based replication from master which does not support GTID

        Details

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

          Description

          If a slave was configured with GTID position, an attempt to start replication from a master which does not support GTID, e.g. from 5.5, causes the error message on start slave:

          Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event '.' at 0, the last event read from 'ubuntu12-04-bin.000001' at 4, the last byte read from 'ubuntu12-04-bin.000001' at 4.'

          It would be good to make it clearer more explicit, if at all possible.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-26 Global transaction ID

                • Major - Major loss of function.
                • Closed

                  Activity

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

                  Urgh, the slave doesn't attempt to detect if master knows about GTID, and if not it just sends a random junk start position. Will fix.

                  Show
                  knielsen Kristian Nielsen added a comment - Urgh, the slave doesn't attempt to detect if master knows about GTID, and if not it just sends a random junk start position. Will fix.
                  Hide
                  Permalink
                  knielsen Kristian Nielsen added a comment -

                  The slave now attempts to read @@global.gtid_domain_id. This fails if master
                  does not have GTID support, resulting in this error on the slave:

                  [ERROR] Slave I/O: The slave I/O thread stops because master does not support MariaDB global transaction id. A fatal error is encountered when it tries to SELECT @@GLOBAL.gtid_domain_id.

                  Show
                  knielsen Kristian Nielsen added a comment - The slave now attempts to read @@global.gtid_domain_id. This fails if master does not have GTID support, resulting in this error on the slave: [ERROR] Slave I/O: The slave I/O thread stops because master does not support MariaDB global transaction id. A fatal error is encountered when it tries to SELECT @@GLOBAL.gtid_domain_id.

                    People

                    • Assignee:
                      knielsen Kristian Nielsen
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: