[rt-users] Upgrade problem.

[J.P. Racine]

Greetings,

I've just upgraded an RT installation from 3.4.4 to 3.6.6 and found that 
although the schema hasn't changed that there are some SQL queries that 
seem to behave strangely.  The database is about 9 gigs in size and is 
runing on mysql 5 ( mysql-server-5.0 debian package 5.0.51a-3~bpo40+1 ).

After the upgrade we noticed some strange behavior when trying to view a 
ticket that was in a resolved state.  The query below was called when 
the problem occured and and seem to return *all* resolved tickets and 
that was a bit to much for the memory of the system to handle. 

http://hostname.domain.com/Ticket/Display.html?id=123456

SELECT main.* FROM Tickets main  WHERE (main.Status != 'deleted') AND 
(main.Status = 'resolved') AND (main.EffectiveId
= main.id) AND (main.Type = 'ticket')  ORDER BY main.id ASC

The same database is running fine ( albeit a bit slow ) with a 
production 3.4.4 install. Any pointers or suggestions to remedy this 
problem would be appreciated.  I just don't see why there is a query 
with no limit for no apparent reason returning unlimited results.

Thanks,

JP