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

有些长耗时SQL会返回EOF错误,这一般是什么原因呢? #268

Open
ryeLearnMore opened this issue Sep 23, 2024 · 9 comments
Open

Comments

@ryeLearnMore
Copy link

No description provided.

Copy link

Thank you for raising an issue. We will try and get back to you as soon as possible. Please make sure you have given us as much context as possible.

@gongna-au
Copy link
Collaborator

No description provided.

能提供具体的SQL例子吗?以及详细的日志信息

@ryeLearnMore
Copy link
Author

No description provided.

能提供具体的SQL例子吗?以及详细的日志信息

SQL是长耗时类型的SQL。日志信息说实话比较简单,有2个特征:1. r, err = se.doQuery(reqCtx, sql)中的error返回EOF。2. 会话时间很长大于20s

@xiyangxixian
Copy link
Contributor

用的是 Gaea 哪个版本呢?旧版本 sql 运行时间太长,被 kill 会返回 eof 错误

@ryeLearnMore
Copy link
Author

用的是 Gaea 哪个版本呢?旧版本 sql 运行时间太长,被 kill 会返回 eof 错误

用的是master版本,git log:de11b227581b49f409313914650cee7fb7e02935。大概是23年9.21号左右的版本。 多问一句,请问您说的被kill指的是数据库底层kill还是Gaea本身kill?最新版本对这块有什么优化嘛?

@xiyangxixian
Copy link
Contributor

是 mysql 这端 kill 的情况下发生,最新版本这块行为逻辑和 mysql 保持一致了,不会报 eof 错误,会直接断开数据库连接

@ryeLearnMore
Copy link
Author

是 mysql 这端 kill 的情况下发生,最新版本这块行为逻辑和 mysql 保持一致了,不会报 eof 错误,会直接断开数据库连接

请问最新版本怎么获取?直接更新gaea就行吗?

@xiyangxixian
Copy link
Contributor

需要从 master 分支 build

@ryeLearnMore
Copy link
Author

需要从 master 分支 build

好的,我试试。

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

No branches or pull requests

3 participants