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

mysql.gtid_slave_pos should be declared with STATS_PERSISTENT=0

    XMLWordPrintable

Details

    Description

      A user on IRC reported getting the following error in when trying to replicate all databases from one host to another (10.1.17 to 10.1.20):

      ERROR 1062 (23000) at line 839574: Duplicate entry 'mysql-gtid_slave_pos-PRIMARY-n_diff_pfx01' for key 'PRIMARY'

      The message is clearly originated from InnoDB persistent statistics.

      I think that scripts/mysql_system_tables.sql should specify STATS_PERSISTENT=0 for all small tables when they are defined with ENGINE=InnoDB, and especially for all tables that have something to do with GTID or replication state.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            marko Marko Mäkelä
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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