[rt-users] Ticket Query causes mysql to spin endlessly
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).
> 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?
More information about the RT-Users