Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.22
-
Debian 8.2
parallel replication without gtid model
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
- relates to
-
MDEV-15393 gtid_slave_pos duplicate key errors after mysqldump restore
- Closed