Hi list,
I think i've found a little bug in MySQL 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz)
Description :
Here's my error log :
Warning: thr_alarm queue is full
Warning: thr_alarm queue is full
[...]
How To Repeat :
Here's my conf file :
[client]
port= 3306
socket
Description:
Mysql 4.0.15 from ports on FreeBSD 4.7 has this repeated many times in
the logs while under heavier loads:
Warning: thr_alarm queue is full
Threads get disconnected when this happens. I assume it is the thread
that has this problem:
(...=removed sensitive data)
DBI-connect
mysqld restarted
Before this, I got thousands of these:
Warning: thr_alarm queue is full
I checked the logs of the other 2 replication clients, and they also had the alarm
queue error, and were also sucking up large resources. I was not able to connect to
them, either.
Before those, both
of these:
Warning: thr_alarm queue is full
I checked the logs of the other 2 replication clients, and they also had the
alarm queue error, and were also sucking up large resources. I was not able
to connect to them, either.
Before those, both replication clients had this logged:
030716 13:42:45 Slave
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
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
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
Chung,
Warning: thr_alarm queue is full
What's this? Is it serious problem?
Looking for thr_alarm in the MySQL Manual, I find this:
If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that
handles alarms is created. This is only used on some systems where
there are problems
query.
I happened to find out that the lots of following error messages are
stored
error log file:
Warning: thr_alarm queue is full
What's this? Is it serious problem?
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
Hi,
I get this error/warning each time server reaches 623 connections and thus
no new clients can connect. What may I do to allow more clients?
I know that the limit on the size of `alarm_queue' is set in
mysys/thr_alarm.c, but is increasing the value in call of init_thr_alarm()
safe?
Regards,
10 matches
Mail list logo