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

Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-3913850' for key 'PRIMARY'

    XMLWordPrintable

    Details

      Description

      Last_Errno: 1942
      Last_Error: Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos: 1062: Duplicate entry '0-3913850' for key 'PRIMARY'
      

      variables:

      root@localhost:(none) 10:27:55> show global variables like '%repl%';
      +----------------------------------+-----------+
      | Variable_name                    | Value     |
      +----------------------------------+-----------+
      | innodb_replication_delay         | 0         |
      | replicate_annotate_row_events    | OFF       |
      | replicate_do_db                  |           |
      | replicate_do_table               |           |
      | replicate_events_marked_for_skip | REPLICATE |
      | replicate_ignore_db              |           |
      | replicate_ignore_table           |           |
      | replicate_wild_do_table          |           |
      | replicate_wild_ignore_table      |           |
      | wsrep_mysql_replication_bundle   | 0         |
      | wsrep_replicate_myisam           | OFF       |
      +----------------------------------+-----------+
      11 rows in set (0.00 sec)
      

      root@localhost:(none) 10:27:57> show global variables like '%para%';
      +-------------------------------+--------------+
      | Variable_name                 | Value        |
      +-------------------------------+--------------+
      | slave_domain_parallel_threads | 0            |
      | slave_parallel_max_queued     | 131072       |
      | slave_parallel_mode           | conservative |
      | slave_parallel_threads        | 8            |
      +-------------------------------+--------------+
      4 rows in set (0.00 sec)
      

      root@localhost:(none) 10:28:03> show global variables like '%gtid%';
      +------------------------+-------------------+
      | Variable_name          | Value             |
      +------------------------+-------------------+
      | gtid_binlog_pos        | 0-23603584-215540 |
      | gtid_binlog_state      | 0-23603584-215540 |
      | gtid_current_pos       | 0-23603584-215540 |
      | gtid_domain_id         | 0                 |
      | gtid_ignore_duplicates | OFF               |
      | gtid_slave_pos         | 0-23603584-215540 |
      | gtid_strict_mode       | OFF               |
      | wsrep_gtid_domain_id   | 0                 |
      | wsrep_gtid_mode        | OFF               |
      +------------------------+-------------------+
      9 rows in set (0.00 sec)
      

      root@localhost:(none) 10:37:50> show global variables like '%binlog%';
      +-----------------------------------------+----------------------+
      | Variable_name                           | Value                |
      +-----------------------------------------+----------------------+
      | binlog_annotate_row_events              | OFF                  |
      | binlog_cache_size                       | 2097152              |
      | binlog_checksum                         | NONE                 |
      | binlog_commit_wait_count                | 0                    |
      | binlog_commit_wait_usec                 | 100000               |
      | binlog_direct_non_transactional_updates | OFF                  |
      | binlog_format                           | ROW                  |
      | binlog_optimize_thread_scheduling       | ON                   |
      | binlog_row_image                        | FULL                 |
      | binlog_stmt_cache_size                  | 1048576              |
      | encrypt_binlog                          | OFF                  |
      | gtid_binlog_pos                         | 0-23603584-215945    |
      | gtid_binlog_state                       | 0-23603584-215945    |
      | innodb_api_enable_binlog                | OFF                  |
      | innodb_locks_unsafe_for_binlog          | OFF                  |
      | max_binlog_cache_size                   | 18446744073709547520 |
      | max_binlog_size                         | 1073741824           |
      | max_binlog_stmt_cache_size              | 18446744073709547520 |
      | sync_binlog                             | 1                    |
      | wsrep_forced_binlog_format              | NONE                 |
      +-----------------------------------------+----------------------+
      20 rows in set (0.00 sec)
      

      root@localhost:(none) 10:39:28> show global variables like '%slave%';
      +-------------------------------+-------------------+
      | Variable_name                 | Value             |
      +-------------------------------+-------------------+
      | gtid_slave_pos                | 0-23603584-221689 |
      | init_slave                    |                   |
      | log_slave_updates             | ON                |
      | log_slow_slave_statements     | ON                |
      | slave_compressed_protocol     | OFF               |
      | slave_ddl_exec_mode           | IDEMPOTENT        |
      | slave_domain_parallel_threads | 0                 |
      | slave_exec_mode               | STRICT            |
      | slave_load_tmpdir             | /dev/shm          |
      | slave_max_allowed_packet      | 1073741824        |
      | slave_net_timeout             | 360               |
      | slave_parallel_max_queued     | 131072            |
      | slave_parallel_mode           | conservative      |
      | slave_parallel_threads        | 8                 |
      | slave_run_triggers_for_rbr    | NO                |
      | slave_skip_errors             |                   |
      | slave_sql_verify_checksum     | ON                |
      | slave_transaction_retries     | 10                |
      | slave_type_conversions        |                   |
      | sql_slave_skip_counter        | 0                 |
      | wsrep_restart_slave           | OFF               |
      | wsrep_slave_fk_checks         | ON                |
      | wsrep_slave_uk_checks         | OFF               |
      | wsrep_slave_threads           | 1                 |
      +-------------------------------+-------------------+
      24 rows in set (0.00 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              ruochen wy
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: