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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to