Hi folks! I have a question for you all... I've got two separate mysql
servers running on one machine. Both are 3.22.23b but used for separate
instances of separate webservers.
I'm having trouble with the "1030: Got error 127 from table handler" error
on only one of the servers.
Here's the scoop. I get the error when I combine running a slow query (one
that takes a couple of seconds to actually execute) and then another query
that hits the same table. If I start the slow query in one instance of the
mysql client and then the other query in another instance of the client
(connecting to the same server) the first will proceed and the second will
give the 1030 error. When the slow query is not running if I run the second
query it executes and returns results without a problem.
Now the confusing thing is that only one of the two servers is showing this
problem. I was wondering if someone could help point me in the direction of
figuring out what the difference is in the configuration so that I can fix
the one!
Thanks,
-Chris
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
