You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/06/01 07:41:38 UTC

[GitHub] [shardingsphere] natehuangting opened a new issue, #18124: bug: use JDBCStore For Narayana, each time the Proxy is started, the table will be dropped and the transaction log will be lost.

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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu closed issue #18124: bug: use JDBCStore For Narayana, each time the Proxy is started, the table will be dropped and the transaction log will be lost.

Posted by GitBox <gi...@apache.org>.
jingshanglu closed issue #18124: bug: use JDBCStore For Narayana, each time the Proxy is started, the table will be dropped and the transaction log will be lost.
URL: https://github.com/apache/shardingsphere/issues/18124


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org