github / github/gh-mysql-conf-diff

Connection and query timeouts

未关闭
#2 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Go
星标
6
派生
3
PR 合并指标
30 天内没有已合并 PR

描述

### Problem

- [ ] If MySQL does not respond as expected, there should be a timeout on the connection and query attempts.
- [ ] Timeout should be set to a reasonable value.
- [ ] User should be able to specify a timeout value.

### Original reported issue

```
gh-mysql-config-diff-apply does not behave well when the MySQL server is running but not behaving correctly.

Details
[hostname] (part of a vitess keyspace), MySQL was in some weird state. It reported the following error message:

Error 1135: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

When I logged into the machine, I saw that there were hundreds of processes related to gh-mysql-config-diff-apply running.

I killed the processes, killed the mysql server, and restarted it. Things seem to be back to normal now.

I'm not sure whether this is a symptom or the cause of MySQL being in a weird state.

Either way, gh-mysql-config-diff-apply needs to be better at handling error conditions and timing out conservatively if MySQL does not behave as expected.
```

贡献指南

打开贡献指南

调研方向

从 gh-mysql-config-diff-apply 入口点开始,跟踪 MySQL 连接和查询的创建方式。确定保守的默认超时和用户指定的超时应放在哪里;完成标准是 MySQL 无响应时,连接尝试和查询尝试都能可靠地停止。

由索引模型根据 Issue 内容生成。

评估

技术栈
go, mysql
领域
cli, databases
Issue 类型
缺陷
难度
4/5
预计耗时
3-5 天
活跃度
停滞
描述清晰度
基本清楚
新手友好度
48/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。