Hi! >>>>> "Chung" == Chung Ha-nyung <[EMAIL PROTECTED]> writes:
Chung> query. Chung> I happened to find out that the lots of following error messages are Chung> stored Chung> error log file: Chung> Warning: thr_alarm queue is full Chung> What's this? Is it serious problem? The above is a very strange error; Basicly something that should never happen. It means that somehow you have more threads wanting to request for a alarm (used to timeout connections) than was registered when mysqld started. This should be impossible as we init the alarms with the following code in mysqld.cc init_thr_alarm(max_connections+max_insert_delayed_threads) In other words, we reserve as many alarms as we can have connections + insert delay threads; As a thread can only have one alarm and and no other threads than a connection or insert delay thread uses alarms I can't understand how you can get this error. Note that even if the alarm call fails, mysqld will work normally with the exception that a long lived connection will not time out. If you cando a new bug report, preferably with the 'mysqlbug' script, that includes the following information, I could try to dig deeper into this problem. Synopsis: <synopsis of the problem (one line)> Severity: <[ non-critical | serious | critical ] (one line)> Priority: <[ low | medium | high ] (one line)> Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> Release: Operating system: Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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