Skip to content
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.

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

没有释放executeSqlQueue队列,导致客户端假死 #2944

Open
whipfeng opened this issue Jan 5, 2024 · 0 comments
Open

没有释放executeSqlQueue队列,导致客户端假死 #2944

whipfeng opened this issue Jan 5, 2024 · 0 comments
Assignees
Labels

Comments

@whipfeng
Copy link

whipfeng commented Jan 5, 2024

1、bug描述

类中io.mycat.backend.jdbc.JDBCConnection这段逻辑,前两个分支最终是不是没有释放executeSqlQueue队列,导致客户端假死现象
if ((sqlType == ServerParse.SHOW) && (!dbType.equals("MYSQL"))) {
// showCMD(sc, orgin);
//ShowVariables.execute(sc, orgin);
ShowVariables.execute(sc, orgin,this);
} else if ("SELECT CONNECTION_ID()".equalsIgnoreCase(orgin)) {
//ShowVariables.justReturnValue(sc,String.valueOf(sc.getId()));
ShowVariables.justReturnValue(sc,String.valueOf(sc.getId()),this);
} else {
ouputResultSet(sc, orgin);
}.

2、版本号(非常重要)
main分支

3、相关表的配置信息
schema.xml (JDBC方式连接的sqlite)

4、操作步骤

  1. 客户端连接后执行use TESTDB
  2. show tables卡住不返回
    5、期望结果
    有返回(报错都行).

6、实际结果
卡住假死.

7、额外信息
无.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants