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

TimeoutError: ResourceRequest timed out #8

Open

zhongs opened this issue Feb 27, 2020 · 0 comments

Labels

mysql

Owner

zhongs commented Feb 27, 2020

今天用 workbench 给一张数据量很大的表加索引加失败了，后面执行 select 语句这张表怎么也打不开，客户端请求接口报 TimeoutError: ResourceRequest timed out 错误；

执行
show processlist;
发现执行加索引的 sql 语句提示 Waiting for table metadata lock
最后杀掉 command 是 query 类型的行就解决了

workbanch 可以用 server -> client connections 界面 kill Querys 杀掉进程

The text was updated successfully, but these errors were encountered:

zhongs added the mysql label

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