On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote:
Good day,
R: are you using MyISAM or InnoDB tables? For the past 2 weeks, we have been dealing with some rather strange
problems. While nothing changed in terms of the mySQL server or clients configuration ( including the options provided to the server during startup, by either my.cnf or as arguments to the executable ), we are getting the following kind of errors.
o Server shutdown in progress R: Could be any fatal error in mysql that produce this "server shutdown in progress" o Out of memory (Needed 5256540 bytes) R: What is your sort_buffer_size setting? o Sort Aborted R: filesort.cc ..The error 'Sort aborted' comes if the sort function fails for some reason. You can try identified what query is a cause of error. o o Can't create a new thread (errno 11); if you are not out of
available memory, you can consult the manual for a possible OS-dependent bug o Unknown Error ( this occurs more often than the rest )
R: What say the error file in specific? There is plenty of memory on the system, as much as there was before
the problems surfaced. We moved a database from that system, to another system ( that database was the one hit more often ) in hope to perhaps solve the problem. Indeed, the errors are coming up less frequently now, but they still do.
R: It`s a correct version of MySQL for your OS? Is there any chance this is due to tables corruption or corruption of
any other kind on the server side? I didn't see any bug fixes in 0.27+ revisions that seem to be related to this problem, so I assume its not a bug that existed in <= 0.26.
R: Can you try to upgrade your mysql to 5.0.27?. Any ideas ? R: Can you delete your installation of mysql and reinstall it ( install 5.0.27)? Thank you very much in advance.
PS: Please reply to this email address as well, if possible.
--
MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]