[GitHub] [shardingsphere] yunqian-c9 opened a new issue #12759: Failed to switch schema, please terminate current transaction.

Sun, 26 Sep 2021 19:33:18 -0700 


yunqian-c9 opened a new issue #12759:
URL: https://github.com/apache/shardingsphere/issues/12759


   使用**python sqlalchemy** ，在创建连接中，必须添加**autocommit**参数，否则在进行连接中便会报错：
   
![image](https://user-images.githubusercontent.com/30698152/134836519-5bbb437f-b721-40c0-a707-6e86ccdcf46c.png)
   
   **报错提示（4.1.0）：**
   
![image](https://user-images.githubusercontent.com/30698152/134836608-37578dd4-86f0-4266-96e9-dc57043efe25.png)
   
   
   这个问题在 **sharding-porxy 4.1.1**  or   **sharding-porxy 5.0.0** 版本都会出现
   
   另外，即使添加了这个参数，不用报错了，但是在 commit 之前使用 **session.flush()** 
预提交数据时，便已经提交数据保存了，之后不管是 rollback还是 commit都无效：
   
![lALPDhJzxskh6h7M4c0Buw_443_225](https://user-images.githubusercontent.com/30698152/134837235-8cc0866f-5e41-4ac3-ad77-f4ff5ab3c767.png)
   
   
![lALPDgfLStrnkqfNAVbNBQ4_1294_342](https://user-images.githubusercontent.com/30698152/134837251-24f5f9a6-d416-4aa6-8290-ef706dc6132a.png)
   
   
![lALPDgQ9zDYOOIZszQFe_350_108](https://user-images.githubusercontent.com/30698152/134837265-0db98357-0575-4718-a760-8e8e7b744dd6.png)
   


-- 
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]

Reply via email to