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

Slave error message incorrectly mentions server_uuid

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 11.7.1
    • Replication
    • None

    Description

      Users can see the following error message in MariaDB:

      2019-07-23 23:24:06 1337162 [ERROR] Error reading packet from server: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000645' at 83358751, the last event read from 'mysql-bin.000645' at 83360832, the last byte read from 'mysql-bin.000645' at 83360859. (server_errno=4052)

      This error message should not mention server_uuid, because server_uuid does not exist in MariaDB. The server_uuid system variable is available starting in MySQL 5.6, but we chose not to port it to MariaDB. See MDEV-5277 for more information.

      https://dev.mysql.com/doc/refman/5.6/en/replication-options.html#sysvar_server_uuid

      This error is thrown here:

      https://github.com/MariaDB/server/blob/mariadb-10.2.25/sql/sql_repl.cc#L2844

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-5277 Ensure that all MySQL 5.6 options are supported by the MariaDB 10.0 server

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            askadhum Ali Salam added a comment - - edited

            This bug seems not fixed yet and I got it in MariaDB community 10.5

            askadhum Ali Salam added a comment - - edited This bug seems not fixed yet and I got it in MariaDB community 10.5
            cs charlie sum (Inactive) added a comment -

            why is this assigned to me?

            Charlie Sum, Executive Technical Advisor
            MariaDB Corporation

            On Tue, Apr 20, 2021 at 2:37 AM Hartmut Holzgraefe (Jira) <jira@mariadb.org>

            cs charlie sum (Inactive) added a comment - why is this assigned to me? Charlie Sum, Executive Technical Advisor MariaDB Corporation On Tue, Apr 20, 2021 at 2:37 AM Hartmut Holzgraefe (Jira) <jira@mariadb.org>
            bnestere Brandon Nesterenko added a comment -

            Hi Elkin, knielsen!

            This is ready for review: PR-3454.

            I targeted 10.5, though I wonder if 11.7 makes more sense, as I wonder if changing error message text may break existing scripts..

            bnestere Brandon Nesterenko added a comment - Hi Elkin , knielsen ! This is ready for review: PR-3454 . I targeted 10.5, though I wonder if 11.7 makes more sense, as I wonder if changing error message text may break existing scripts..
            Elkin Andrei Elkin added a comment - - edited

            Thanks for this overdued piece, Brandon! (I even started considering server_uuid to make myself comfortable :blush: ).
            To the version, no GA rules of course apply here. 11.6 is not yet there which makes it the target I read.

            Elkin Andrei Elkin added a comment - - edited Thanks for this overdued piece, Brandon! (I even started considering server_uuid to make myself comfortable :blush: ). To the version, no GA rules of course apply here. 11.6 is not yet there which makes it the target I read.
            bnestere Brandon Nesterenko added a comment -

            Pushed into 11.7 as a812dba6dc8

            bnestere Brandon Nesterenko added a comment - Pushed into 11.7 as a812dba6dc8

            People

              bnestere Brandon Nesterenko
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.