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

[Jesse Vincent]

On Thu, Apr 03, 2003 at 01:57:44PM -0800, bill at daze.net wrote:
> 
> > 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
>

That's a ticket search.

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

That's an ACL check.

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

This is someone who has an existing page view in progress that's waiting
on the other page view to finish, so they can unlock their session



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

That's a user creation in progress

> 
> 17	rt_user	localhost	rt3	Query	530	User lock
> SELECT GET_LOCK('Apache-Session-209dd683b7d6e71a532db03520db854b', 3600)
> 
This is someone who has an existing page view in progress that's waiting
on the other page view to finish, so they can unlock their session
> 
> 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

Can you verify that your RT database tables are InnoDB tables and not
MyISAM tables? (Did I already ask you this?)

> Sendmail 8.12.6p2
> Apache/1.3.27 (Unix) mod_ssl/2.8.11 OpenSSL/0.9.6g mod_fastcgi/2.2.12
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.