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
---------------------------------------------
This message was sent using WebMail Pro.
http://webmail.hostnoc.net/
---------------------------------------------------------------------
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
