Great god to mysql xa lead to can't kill the transaction how broken?-CodePudding

Using xa testing, some for mysql xa lock in different stages of the test, then stuck situation to kill the thread, restart the mysql service, restart the discovery after insert, modify the data is normal, but can't modify the table structure, modify the table structure in a stuck state, after more than a minute timeout error,

Query innodb_trx table, found that there are two issues in running, online information is said according to kill trx_mysql_thread_id find corresponding process, but I am here is zero, no process id, can not kill, and it is to restart the mysql service automatically run after two transactions,

And information, through the xa recover the xa transaction, then roll back or submit, but I'm here by the xa recover to check the result is empty, so also can't solve,

Probably infer should redo undo, abnormal xa transaction, after restart the mysql service detected the two transactions to run automatically, this is my guess, I don't know right,

But now I don't know how to resolve some of these two affairs in operation, and help you a great god, and give some advice,

CodePudding user response:

refer to the building of shandong green Chinese onion brother reply:

using the xa testing, some for mysql xa lock in different stages of the test, then stuck situation to kill the thread, restart the mysql service, restart the discovery after insert, modify the data is normal, but can't modify the table structure, modify the table structure in a stuck state, after more than a minute timeout error,

Query innodb_trx table, found that there are two issues in running, online information is said according to kill trx_mysql_thread_id find corresponding process, but I am here is zero, no process id, can not kill, and it is to restart the mysql service automatically run after two transactions,

And information, through the xa recover the xa transaction, then roll back or submit, but I'm here by the xa recover to check the result is empty, so also can't solve,

Probably infer should redo undo, abnormal xa transaction, after restart the mysql service detected the two transactions to run automatically, this is my guess, I don't know right,

But now I don't know how to resolve some of these two transaction in operation, and help you a great god, and give some advice,

Using xa testing, some for mysql xa lock in different stages of the test, then stuck situation to kill the thread, restart the mysql service, restart the discovery after insert, modify the data is normal, but can't modify the table structure, modify the table structure in a stuck state, after more than a minute timeout error,

Query innodb_trx table, found that there are two issues in running, online information is said according to kill trx_mysql_thread_id find corresponding process, but I am here is zero, no process id, can not kill, and it is to restart the mysql service automatically run after two transactions,

And information, through the xa recover the xa transaction, then roll back or submit, but I'm here by the xa recover to check the result is empty, so also can't solve,

Probably infer should redo undo, abnormal xa transaction, after restart the mysql service detected the two transactions to run automatically, this is my guess, I don't know right,

But now I don't know how to solve the point the two running affairs, help you a great god, and give some advice,

CodePudding user response:

refer to the building of shandong green Chinese onion brother reply:

using the xa testing, some for mysql xa lock in different stages of the test, then stuck situation to kill the thread, restart the mysql service, restart the discovery after insert, modify the data is normal, but can't modify the table structure, modify the table structure in a stuck state, after more than a minute timeout error,

Query innodb_trx table, found that there are two issues in running, online information is said according to kill trx_mysql_thread_id find corresponding process, but I am here is zero, no process id, can not kill, and it is to restart the mysql service automatically run after two transactions,

And information, through the xa recover the xa transaction, then roll back or submit, but I'm here by the xa recover to check the result is empty, so also can't solve,

Probably infer should redo undo, abnormal xa transaction, after restart the mysql service detected the two transactions to run automatically, this is my guess, I don't know right,

But now I don't know how to resolve some of these two transaction in operation, and help you a great god, and give some advice,

Hair after, can't edit?

CodePudding user response:

refer to 2nd floor spring onion in shandong brother reply:

Quote: refer to the building of shandong green Chinese onion brother reply:
using the xa testing, some for mysql xa lock in different stages of the test, then stuck situation to kill the thread, restart the mysql service, restart the discovery after insert, modify the data is normal, but can't modify the table structure, modify the table structure in a stuck state, after more than a minute timeout error,

Query innodb_trx table, found that there are two issues in running, online information is said according to kill trx_mysql_thread_id find corresponding process, but I am here is zero, no process id, can not kill, and it is to restart the mysql service automatically run after two transactions,

And information, through the xa recover the xa transaction, then roll back or submit, but I'm here by the xa recover to check the result is empty, so also can't solve,

Probably infer should redo undo, abnormal xa transaction, after restart the mysql service detected the two transactions to run automatically, this is my guess, I don't know right,

But now I don't know how to resolve some of these two transaction in operation, and help you a great god, and give some advice,

Hair after, can't edit?

Come on, hurry up to help, thank you for your enthusiastic friends,