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

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

              Dates

              Created:
              Updated: