MySQL错误:排序中止 [英] MySQL Error: Sort aborted

问题描述

我在Windows 8上具有8G内存的MySQL 5.1. 该错误每两秒钟在事件查看器上发生一次. 错误是

I have MySQL 5.1 on Windows 2008 which has 8G Memory. The error occured every two seconds on Event Viewer. The error is

D:\ SW \ MySQL \ MySQL服务器5.1 \ bin \ mysqld:排序中止.

D:\SW\MySQL\MySQL server 5.1\bin\mysqld: Sort aborted.

有人看到这个错误吗?

推荐答案

至少有一些已知的情况会导致此消息:

There are at least a few known things to cause this message:

• tmpdir中的磁盘空间不足阻止了tmpfile的创建.
• 内存不足，无法分配sort_buffer_size.
• 有人在文件排序中间运行了KILL.
• 正在对某些查询进行排序时，服务器已关闭.
• 由于锁定等待超时或死锁，事务被回滚或中止.
• 意外错误，例如源表甚至tmp表已损坏.
• 子查询处理失败，该查询也正在排序.

• 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.

检查这些，我敢打赌您的问题将得到解决.

Check these, and I bet your issue will be resolved.

这篇关于MySQL错误:排序中止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！