Hello Jamie,
Tuesday, July 17, 2001, 7:40:03 AM, you wrote:
If I'm not mistaken this was other bug. At least I remember I've
reported really same looking bug which make sometimes mysql hang after
optimize or repair table (may be alter table also had it).
JM> I've been experiencing a simmilar problem only with MyISAM tables.
JM> This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7.
JM> For me the problem occurs when doing an ALTER TABLE or a simmilar
JM> operation (eg OPTIMIZE) on relatively large tables (>4 millon rows)
JM> with one or two indeces.
JM> The table in question is occasionally accessed by other queries;
JM> these access could occur during the ALTER TABLE. In this case,
JM> the application running the other queries would not mind seeing the
JM> old structure (for read) or wating until the ALTER is complete
JM> (for write).
Yes. All of them was only read queries so it should not be the
problem. But still I'm not quite shure how INNODB works in this
case...
JM> The symptom is the same as described below; with ALL threads
JM> (not just those touching the ALTERed table) getting stuck in
JM> "opening tables" or "closing tables".
JM> To recover it is necessary to terminate mysqld a SIGKILL;
JM> though data loss can usually be avoided by doing a
JM> FLUSH TABLES first (which also hangs) and also sending
JM> a SIGTERM and waiting a minute before sending the KILL.
Well. I also used this with above bug. But with this bug it looks like
killing mysqld does not make it to flush any tables, nor flush tables
forks. So the only way is to kill it with 9th signal.
JM> Would upgrading to 3.23.39 fix this problem? Or is it
JM> still a live bug in the current version?
Your bug probably allready fixed as I didn't have such bug using only
MYISAM with mysql 3.23.39.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
