MySQL 错误：排序中止
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5165112/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL Error: Sort aborted
提问by Sinmo Kim
I have MySQL 5.1 on Windows 2008 which has 8G Memory. The error occured every two seconds on Event Viewer. The error is
我在具有 8G 内存的 Windows 2008 上安装了 MySQL 5.1。该错误在事件查看器上每两秒发生一次。错误是
D:\SW\MySQL\MySQL server 5.1\bin\mysqld: Sort aborted.
D:\SW\MySQL\MySQL server 5.1\bin\mysqld：排序中止。
does anyone see this error?
有没有人看到这个错误？
回答by nhaa123
There are at least a few known things to cause this message:
至少有一些已知的事情会导致此消息：
- Insufficient disk space in tmpdir prevented tmpfile from being created.
- Insufficient memory for sort_buffer_size to be allocated.
- Somebody ran KILL in the middle of a filesort.
- The server was shutdown while some queries were sorting.
- A transaction got rolled back or aborted due to lock wait timeout or deadlock.
- Unexpected errors, such as source table or even tmp table was corrupt.
- Processing of a subquery failed which was also sorting.
- tmpdir 中的磁盘空间不足导致无法创建 tmpfile。
- 内存不足，无法分配 sort_buffer_size。
- 有人在文件排序过程中运行了 KILL。
- 一些查询正在排序时，服务器已关闭。
- 由于锁定等待超时或死锁，事务被回滚或中止。
- 意外错误，例如源表或什至 tmp 表已损坏。
- 子查询的处理失败，这也是排序。
Check these, and I bet your issue will be resolved.
检查这些，我打赌你的问题会得到解决。
回答by Delan Azabani
Please check that you have enough free disk space that MySQL can write to. 'Sort aborted' commonly occurs when there is no disk space left.
请检查您是否有足够的可用磁盘空间供 MySQL 写入。“排序中止”通常发生在没有剩余磁盘空间时。
