Deletion strategy not clearing indices for some mysql clients
还没有人认领这个 Issue。
评估
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 新手友好度
- 20/100
调研方向
未指定任何文件或测试。首先在使用 MariaDB 和 MySQL 的 Arch Linux 上重现删除策略，然后比较客户端和配置方面的差异；当在所报告的环境中重复运行测试不再因重复索引错误而失败时，即视为完成。
由索引模型根据 Issue 内容生成。
描述
We switched from truncation to deletion for a project of ours because for some reason truncation was incredibly slow on some clients (apparently this has been observed before).
Unfortunately, on some machines this breaks the tests because mysql is complaining about a duplicate index. So to me this suggests that the indices are not reliably reset on all clients.
The behaviour seems particularly erratic:
- It works on my machine (Mac OS X Yosemite), on our CI server (I believe Debian or Ubuntu, although I'd have to check) and on a freshly set up Ubuntu VM
- But it doesn't work on a freshly set up Arch Linux VM (regardless of whether I use mariadb or the official Oracle mysql), nor on my coworker's Ubuntu machine.
However, the behaviour differs only across machines, it's consistent on one specific machine.
I suppose it must have something to do with specific mysql configuration options, but I'm at a loss as to what it could be in particular.
I realise this is not a precise problem description but maybe somebody around here has a clue?
Edit:
On a second look, it doesn't even appear to be consistent on a single machine. At least it works perfectly fine in the Arch Linux VM today. That's even weirder.
Edit2:
Works on Arch Linux with MySQL, but not mariadb, it seems.
- 主要语言
- Ruby
- 星标
- 76
- 派生
- 76
- PR 合并指标
- 30 天内没有已合并 PR
环境准备
我们还没有检查这个项目的环境配置文件。先看它的 README，通用步骤见我们的新手贡献指南。
从这里开始
- 先读完整个 Issue，再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库，在一个分支上完成修改。
- 提交 Pull Request，并在描述里引用这个 Issue 编号。
DatabaseCleaner/database_cleaner-active_record 的其他 Issue
-
难度 2/5 1-3 小时 新手友好度 62/100
-
难度 5/5 一周以上 新手友好度 30/100
DatabaseCleaner/database_cleaner-active_record#128 · 1 条评论 ·
-
难度 3/5 1-2 天 新手友好度 35/100
DatabaseCleaner/database_cleaner-active_record#127 · 3 条评论 ·
-
难度 2/5 1-3 小时 新手友好度 45/100
-
难度 5/5 一周以上 新手友好度 25/100
查看 DatabaseCleaner/database_cleaner-active_record 的全部 Issue
相似的 Issue
-
难度 2/5 1-3 小时 新手友好度 75/100
维护者通常 1 天内回复
-
难度 2/5 1-3 小时 新手友好度 78/100
solana-foundation/pay-kit#341 ·
维护者通常 1 天内回复
-
难度 1/5 1 小时以内 新手友好度 72/100
TheOdinProject/curriculum#31427 · 3 条评论 ·
维护者通常 1 天内回复
-
难度 1/5 1 小时以内 新手友好度 90/100
cyclestreets/cyclescape#1107 · 1 个 reaction ·
-
难度 1/5 1 小时以内 新手友好度 95/100
维护者通常 1 天内回复