Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL)
-
None
-
Linux
Description
Replication sql thread stopped on error 12605, 'This xid is already exist'
No prepared XA on the spider head or its datanodes.
After restarting the sql thread it continues, but the rows in mysql.spider_xa/mysql.spider_xa_member tables still remains.
Should this row be removed manually or automatically?
Slave status after the sql thread stopped:
spider_head> show slave status\G
|
*************************** 1. row ***************************
|
Slave_IO_State: Waiting for master to send event
|
Master_Host: spider_intermediate_mariadb_master
|
...
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: No
|
...
|
Last_Errno: 12605
|
Last_Error: This xid is already exist
|
Skip_Counter: 0
|
...
|
Last_IO_Errno: 0
|
Last_IO_Error:
|
Last_SQL_Errno: 12605
|
Last_SQL_Error: This xid is already exist
|
...
|
Using_Gtid: No
|
...
|
Parallel_Mode: conservative
|
SQL_Delay: 0
|
SQL_Remaining_Delay: NULL
|
Slave_SQL_Running_State:
|
Slave_DDL_Groups: 330705
|
Slave_Non_Transactional_Groups: 0
|
Slave_Transactional_Groups: 157650443
|
1 row in set (0.00 sec)
|
Content of spider_xa tables after it was stopped (also the same after starting the sql thread).
spider_head> select * from spider_xa\G
|
*************************** 1. row ***************************
|
format_id: 1
|
gtrid_length: 5
|
bqual_length: 7
|
data: 5195bb56c949
|
status: NOT YET
|
1 row in set (0.00 sec)
|
|
|
spider_head> select * from spider_xa_failed_log\G
|
Empty set (0.00 sec)
|
|
|
spider_head> select * from spider_xa_member\G
|
*************************** 1. row ***************************
|
format_id: 1
|
gtrid_length: 5
|
bqual_length: 7
|
data: 5195bb56c949
|
scheme: mysql
|
host: datanode1.example.com
|
port: 3306
|
socket:
|
username: spider_user
|
password: ***************
|
ssl_ca: NULL
|
ssl_capath: NULL
|
ssl_cert: NULL
|
ssl_cipher: NULL
|
ssl_key: NULL
|
ssl_verify_server_cert: 0
|
default_file: NULL
|
default_group: NULL
|
*************************** 2. row ***************************
|
format_id: 1
|
gtrid_length: 5
|
bqual_length: 7
|
data: 5195bb56c949
|
scheme: mysql
|
host: datanode2.example.com
|
port: 3306
|
socket:
|
username: spider_user
|
password: **************
|
ssl_ca: NULL
|
ssl_capath: NULL
|
ssl_cert: NULL
|
ssl_cipher: NULL
|
ssl_key: NULL
|
ssl_verify_server_cert: 0
|
default_file: NULL
|
default_group: NULL
|
2 rows in set (0.00 sec)
|
From error log on spider head:
20180822 11:20:48 [SEND SPIDER SQL] from 334171 to [datanode2.example.com] 7230589: sql: xa end 0x3531393562,0x62353663393439,1
|
20180822 11:20:48 [ERROR SPIDER RESULT] to 334171: 1159
|
20180822 11:20:48 [SEND SPIDER SQL] from 334171 to [datanode1.example.com] 8131371: sql: xa end 0x3531393562,0x62353663393439,1
|
20180822 11:20:48 [ERROR SPIDER RESULT] to 334171: 1399 XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state
|
20180822 11:20:48 [SEND SPIDER SQL] from 334171 to [datanode2.example.com] 7230589: sql: xa end 0x3531393562,0x62353663393439,1
|
2018-08-22 11:20:48 334171 [Warning] WSREP: handlerton rollback failed, thd 334171 528536546 conf 0 SQL (null)
|
20180822 11:20:48 [SEND SPIDER SQL] from 8 to [datanode2.example.com] 2720391: sql: show table status from `db` like 't1'
|
2018-08-22 11:24:54 334171 [ERROR] Slave SQL: This xid is already exist, Gtid 0-190237001-119268216, Internal MariaDB error code: 12605
|
2018-08-22 11:24:54 334171 [Warning] Slave: This xid is already exist Error_code: 12605
|
2018-08-22 11:24:54 334171 [Warning] Slave: Got error 12605 "Unknown error 12605" during COMMIT Error_code: 1180
|
2018-08-22 11:24:54 334171 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.001912' position 25922247
|
2018-08-22 11:24:54 334170 [ERROR] Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334170 [Warning] Slave: Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334170 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.001912' position 25922247
|
2018-08-22 11:24:54 334172 [ERROR] Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334172 [Warning] Slave: Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334172 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.001912' position 25922247
|
2018-08-22 11:24:54 334171 [ERROR] Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334171 [Warning] Slave: This xid is already exist Error_code: 12605
|
2018-08-22 11:24:54 334171 [Warning] Slave: Got error 12605 "Unknown error 12605" during COMMIT Error_code: 1180
|
2018-08-22 11:24:54 334171 [Warning] Slave: Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964
|
2018-08-22 11:24:54 334171 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.001912' position 25922247
|
2018-08-22 11:24:54 334169 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.001912' at position 25922247
|
On all datanodes: (no prepared xa transactions)
datanode1 [(none)]> xa recover;
|
Empty set (0.00 sec)
|
Also the error message should be changed to 'This XID already exists'.
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Confirmed
-