Re: Strange issue with special characters and "select failed" messages

Markus Hoenicka <[email protected]>
Newsgroups gmane.text.refdb.general
Message-ID <[email protected]>
Sebastian Hoehn <[email protected]> was heard to say:

> Hope this help to improve the tool. I run it on cygwin. Could Linux
> solve the issue? I might try a linux machine, but then I have to redo
> all the config and install process so I would like to avoid it.

I'm happily running my production database on a Windows/Cygwin box, using MySQL
as database engine. There are more pitfalls compared to a Unix box, but Cygwin
is certainly one of the supported platforms.

> 1037: Out of memory; restart server and try again (needed 207864 bytes)

This seems to be a configuration problem of the MySQL Windows version (what you
see here is a MySQL error message, not a RefDB error message). I had to
increase the following setting in my.ini to:

sort_buffer_size=512K

to make things work. See also this thread:

http://www.issociate.de/board/post/175668/ERROR_1037_caused_by_simple_query.html

Maybe this should go into the manual. No such fiddling is required on other
platforms.

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.