New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

strictTxIsolation=true 不走事务的sql异常关闭连接 #2933

Open

kleinla opened this issue Feb 2, 2023 · 1 comment

Assignees

Labels

bug

kleinla commented Feb 2, 2023

1、bug描述
server.xml配置strictTxIsolation=true和 idleTimeout=30000 ，接口持续查询30s后出现报错：No operations allowed after connection closed. con:JDBCConnection

2、版本号(非常重要)
mycat: v 1.6.7.5
数据库：5.7.mysql_aurora.2.09.2
3、相关表的配置信息
schema.xml (mysql的连接驱动是JDBC)
rule.xml (无)
server.xml
true
30000

4、操作步骤

单查询接口压测5分钟
30秒后出现异常

5、期望结果
链接重新连接
6、实际结果
No operations allowed after connection closed. con:JDBCConnection

kleinla added the bug label

kleinla assigned funnyAnt

3721518 commented Feb 9, 2023

用1.6.7.6试下看看，好像用这个版本不会

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment