Are you current on DBIX::SearchBuilder? ------- Original message ------- From: J.P. Racine <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
