嗨, 大家好: 网站在新年后正式开通,欢迎大家加入我们,共同维护一个良好氛围的中国技术社区。 欢迎举报不良帖子,欢迎提供建议。
我们的QQ群:136102234,欢迎进群找答案,里边会有很多资深的大师们。 point overflow

查询到错误日志有这么一条。

Sort aborted: Query execution was interrupted

虽然有列表说导致这个问题的原因,但是又无法确认,先分享出来。如果你有确认的办法,请指导下。

asked 2016-03-14 14:16:24

jkant's gravatar image

jkant ♦♦
11134138139
accept rate: 3%


以下是错误的列表原因:

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.

link

answered 2016-03-14 14:17:03

jkant's gravatar image

jkant ♦♦
11134138139
accept rate: 3%

翻译后大概是:

临时文件磁盘空间不够

sort_buffer_size没有了足够的内存分配了

排序的时候被kill

排序的时候服务器关闭

事物锁等待超时或者死锁的时候回滚或者取消

其他错误,比如原表或者临时表有问题

子查询执行失败

link

answered 2016-03-14 14:19:02

jkant's gravatar image

jkant ♦♦
11134138139
accept rate: 3%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×72
×1

Asked: 2016-03-14 14:16:24

Seen: 6,418 times

Last updated: 2016-03-14 14:19:02