[rt-users] Upgrade problem.

[Jesse Vincent]

Are you current on DBIX::SearchBuilder?

------- Original message -------
From: J.P. Racine <racinejp at vianet.ca>
Sent: 5-8-'08,  15:51

> 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
> 
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>