Your message dated Mon, 2 Oct 2006 20:54:47 +0300
with message-id <[EMAIL PROTECTED]>
and subject line Slow Queries from Users Table
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---
Package: request-tracker3.4
Version: 3.4.4-1

I'm experiencing the same problem described in this mailing list
thread: http://www.gossamer-threads.com/lists/rt/users/51543 . Certain
select statements involving the Users table take a long time to
complete. When performing a "Resolve", it may take 10-20 seconds
before the page is displayed.

I've used mytop to watch which queries are causing the issue, and it
is a select from the Users table that causes this :

Query SELECT DISTINCT main.* FROM Users ...


--- End Message ---
--- Begin Message ---
Version: 3.4.5-1

On Thu, Jan 12, 2006 at 03:13:48PM -0600, Mark Stover wrote:
> Package: request-tracker3.4
> Version: 3.4.4-1
> 
> I'm experiencing the same problem described in this mailing list
> thread: http://www.gossamer-threads.com/lists/rt/users/51543 . Certain
> select statements involving the Users table take a long time to
> complete. When performing a "Resolve", it may take 10-20 seconds
> before the page is displayed.
> 
> I've used mytop to watch which queries are causing the issue, and it
> is a select from the Users table that causes this :
> 
> Query SELECT DISTINCT main.* FROM Users ...

Hi,

according to Jesse Vincent (the upstream author), this is fixed in
version 3.4.5, which was uploaded yesterday. Therefore I'm closing this
bug. Please let us know if the problem still persists.

Cheers,
-- 
Niko Tyni       [EMAIL PROTECTED]

--- End Message ---

Reply via email to