[rt-users] EX_TEMPFAIL / receiving multiple copies of mail

[bill at daze.net]

> I presume you're running with mysql.  When the system is non-responsive,
> what does mysql processlist tell you?

After the reboot yesterday everything ran fine until earlier today.  Here
is the processlist from when the timeouts started occurring:

Process List
Id	User	Host	db	Command	Time	State	Info	kill

13	rt_user	localhost	rt3	Query	3101	Copying to tmp
table	SELECT DISTINCT main.* FROM Tickets main, Groups Groups_1,
Principals Principals_2, CachedGroupMembe

14	rt_user	localhost	rt3	Query	603	Locked	SELECT
ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE
(ACL.RightName = 'SuperUser' O

15	rt_user	localhost	rt3	Query	3071	User lock
SELECT GET_LOCK('Apache-Session-3a88a0a85901f2ce2a01e1be0d07c63d', 3600)

16	rt_user	localhost	rt3	Query	608	Locked	UPDATE
Principals SET ObjectId='5007' WHERE id='5007'

17	rt_user	localhost	rt3	Query	530	User lock
SELECT GET_LOCK('Apache-Session-209dd683b7d6e71a532db03520db854b', 3600)

40	mysqltool	localhost	mysql	Sleep
41	mysqltool	localhost	mysql	Query
SHOW PROCESSLIST

We have 5 RT processes started by FastCGIServer.

I stopped and started Apache to regain response.  I then did a processlist
and saw the above 5 processes still running and 5 new sleeping processes.
So I stopped and started mysql to clear out the old processes.

Our config:
FreeBSD 4.7
rt3.0.0
mysql 3.23.52
Sendmail 8.12.6p2
Apache/1.3.27 (Unix) mod_ssl/2.8.11 OpenSSL/0.9.6g mod_fastcgi/2.2.12