List:General Discussion« Previous MessageNext Message »
From:Ian Collins Date:June 26 2003 12:04am
Subject:Warning: thr_alarm queue is full
View as plain text  
My MySQL database just stopped. I had 47 users running on it who just 
stopped being able to access the database.
The .err file in the MySQL data directory has,

Version: '4.0.11-gamma-standard-log'  socket: '/tmp/mysql.sock'  port: 3306
030611 10:45:45  mysql_ha_read: Got error 124 when reading table
030616 11:21:37  mysql_ha_read: Got error 134 when reading table
030616 12:13:15  mysql_ha_read: Got error 134 when reading table
Warning: thr_alarm queue is full
Warning: thr_alarm queue is full

The last line repeats about 500 times.
To get my users up and running, I restarted mysql.

What is the alarm queue. The documentation says it creates a queue for 
alarms, but little else. What was the alarm queue full of? and how do I 
stop it?

-- 

Many Regards,
Ian Collins
System Manager
KIWIPLAN NZ Ltd.
================

There are always alternatives.
		-- Spock, "The Galileo Seven", stardate 2822.3


Thread
Warning: thr_alarm queue is fullIan Collins26 Jun
  • Re: Warning: thr_alarm queue is fullNils Valentin26 Jun