Re: ERROR 1037 caused by simple query

[Markus Hoenicka]

Hi,

just for the archive:

It took me a while until I could revisit the ERROR 1037 problem. I installed
4.1.10 to make sure I've got the latest bugfixes. The error would still show
up, but then I fiddled with my my.ini until it worked. Please do not expect me
to understand why this works, but increasing

sort_buffer_size=512K

from 212K fixes the problem. The description of this variable reads:

# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.

It is entirely unclear to me why this affects SELECT statements, but so be it.
Even more interesting to the inclined reader should be the fact that this
setting is listed under the MyISAM section. The database in question is an
InnoDB database, though.  Makes me wonder.

regards,
Markus

-- 
Markus Hoenicka
markus.hoenicka@stripped
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de