natehuangting opened a new issue, #18124: URL: https://github.com/apache/shardingsphere/issues/18124
## Bug Report ### Which version of ShardingSphere did you use? 5.1.2-SNAPSHOT ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Expected behavior Restarting the Proxy will restore the original unsuccessfully committed transaction (the log has been recorded in the DB) ### Actual behavior A transaction that has been prepared and requires a commit is rolled back ### Reason analyze (If you can) Each time the Proxy starts, it will drop the ActionJBossTSTxTable and other tables in the DB, resulting in the loss of the transaction log. ### SQL Record 2022-06-01T07:22:31.542763Z 16979 Query DROP TABLE ActionJBossTSTxTable 2022-06-01T07:22:52.129847Z 16936 Query show tables 2022-06-01T07:23:05.238010Z 16979 Query CREATE TABLE ActionJBossTSTxTable (StateType INTEGER NOT NULL, Hidden INTEGER NOT NULL, TypeName VARCHAR(255) NOT NULL, UidString VARCHAR(255) NOT NULL, ObjectState BLOB, PRIMARY KEY(UidString, TypeName, StateType)) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
