[rt-users] Ticket Query causes mysql to spin endlessly

Brian Kerr kerrboy at gmail.com
Mon Oct 23 16:20:28 EDT 2006


On 11/15/05, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
>
> On Tue, Nov 15, 2005 at 12:39:51PM -0800, Aaron Nichols wrote:
> > On 11/15/05, Vance Vagell <vance.vagell at audiumcorp.com> wrote:
> > >  We also have this problem, where searching through the content of tickets
> > > causes the session to lock up.  If it is a lengthy search, the browser needs
> > > to be closed and the cookies deleted.  If it a short search, it returns
> > > results and has no problems.  I have found that specify more search
> > > parameters speeds up the search (obviously), and that avoids this problem
> > > most of the time.  But there are times when you need a more general search,
> > > and then you gamble with locking up the session.
> >
>
> It does very much look like the query engine is generating an incorrect
> query (sticking the join inside an OR).
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>

Has anyone tried this in 3.4.6?  Was it fixed?
Thanks,
Brian



More information about the rt-users mailing list