[rt-users] R??p. : Re: R??p. : Re: Query Builder froze

[Kenneth Marshall]

You will need to turn on query logging for you DB. I think
you just define a file to log to in the my.cnf file. I am
not very familiar with MySQL since we use PostgreSQL as our
backend here. Check the MySQL documentation.

Cheers,
Ken

On Tue, Jul 06, 2010 at 03:21:05PM +0200, Horst Kriegers wrote:
> Hi Kenn,
> thanks for your answer.
>  
> How can I see the QueryBuilder's executed query ?
>  
> Regards,
> Horst
>  
> 
> >>> Le Mardi, 6. Juillet 2010 ??  14:57, Kenneth Marshall <ktm at rice.edu>
> a ??crit :
> Hi Horst,
> 
> Is the query hitting the DB the same with the CLI versus
> QueryBuilder? Maybe you are hitting a resource limit when
> the request goes through the web server. Try checking the
> system and web server logs to see if there is any more
> information. If it is not generating the same query, then
> that will give you a place to look for a problem. Good
> luck. At least, there is a good consulting group available
> should you need some expert assistance.
> 
> Regards,
> Ken
> 
> On Mon, Jul 05, 2010 at 11:20:42AM +0200, Horst Kriegers wrote:
> > I've tried in CLI mode and have no problem.
> > The execution of request is quick.
> >  
> > Horst
> > 
> > >>> Le Lundi, 5. Juillet 2010 ??  08:58, "Horst Kriegers"
> > <Horst.Kriegers at loro.ch> a ??crit :
> > Hi and tanks Kenn for your answer.
> >  
> >  
> > RT_Config : Identical (not modified)
> >  
> > RT_SiteConfig - Differences are minimal : 
> > - $rtname
> > - $DatabasePort
> > - $DatabaseUser
> > - $DatabaseName
> > - $ParseNewMessageForTicketCcs
> > - $LogToFileNamed
> > - $WebPort
> >  
> > And log files contains nothings special
> >  
> >  
> > This behavior seem to appear by inserting Custom Fields in the
> query.
> >  
> >  
> >  
> > Any idea where can I investigate to resolve this problem ?
> >  
> >  
> > Horst
> > 
> > >>> Le Mercredi, 30. Juin 2010 ??  16:53, Kenneth Crocker
> > <kfcrocker at lbl.gov> a ??crit :
> > Horst,
> > 
> > What are the differences in you RT_Config and RT_SiteConfig.pm
> files?
> > 
> > Kenn
> > LBNL
> > 
> > On Wed, Jun 30, 2010 at 7:32 AM, Horst Kriegers
> > <Horst.Kriegers at loro.ch> wrote:
> > 
> > 
> > Hi,
> > Suze Linux 2.6.16
> > RT 3.6.6
> > Apache 2.2.6
> > MySQL 5.1.45
> > We have 2 instances of RT:
> > - DEV for development
> > - PRD for production
> > A query created in RT's Query Builder on the DEV environment works
> > fine.
> > By creating the same query on the PRD environment froze until
> timeout
> > appear.
> > I've tried to connect the RT DEV to MySQL PRD, all works fine.
> > I've tried to connect the RT PRD to MySQL DEV, it froze.
> > I've tried to compare the both RT's directory content, all seems to
> be
> > identical.
> > How can I solve this probl??m ?
> > Many thanks in advance.
> > Horst
> > 
> > 
> >
> _______________________________________________________________________
> > 
> > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou
> > l'organisme ?? qui il est destin??. Si vous n'??tes pas le
> destinataire
> > pr??vu, veuillez nous en informer au plus vite et d??truire le
> pr??sent
> > courriel. Dans ce cas, il ne vous est pas permis de copier ce
> courriel,
> > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. 
> >
> _______________________________________________________________________
> > 
> > The content of this e-mail is intended only and solely for the use
> of
> > the named recipient or organisation. If you are not the named
> recipient,
> > please inform us immediately and delete the present e-mail. In this
> > case, you are nor allowed to copy, distribute or use this e-mail in
> any
> > way. 
> >
> _______________________________________________________________________
> > 
> > 
> > 
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com 
> > 
> > 
> > 
> > 
> >
> _______________________________________________________________________
> > 
> > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou
> > l'organisme ?? qui il est destin??. Si vous n'??tes pas le
> destinataire
> > pr??vu, veuillez nous en informer au plus vite et d??truire le
> pr??sent
> > courriel. Dans ce cas, il ne vous est pas permis de copier ce
> courriel,
> > de le distribuer ou de l'utiliser de quelque mani??re que ce soit. 
> >
> _______________________________________________________________________
> > 
> > The content of this e-mail is intended only and solely for the use
> of
> > the named recipient or organisation. If you are not the named
> recipient,
> > please inform us immediately and delete the present e-mail. In this
> > case, you are nor allowed to copy, distribute or use this e-mail in
> any
> > way. 
> >
> _______________________________________________________________________
> > 
> > 
> > ___________________________________________________________
> > Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou
> 
> > l'organisme ?? qui il est destin??. Si vous n'??tes pas le
> destinataire
> > pr??vu, veuillez nous en informer au plus vite et d??truire le
> pr??sent
> > courriel. Dans ce cas, il ne vous est pas permis de copier ce
> courriel,
> > de le distribuer ou de l'utiliser de quelque mani??re que ce soit.
> > 
> > The content of this e-mail is intended only and solely for the use 
> > of the named recipient or organisation. If you are not the named 
> > recipient, please inform us immediately and delete the present
> e-mail. 
> > In this case, you are nor allowed to copy, distribute or use this 
> > e-mail in any way.
> > ___________________________________________________________
> 
> > 
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> 
> ___________________________________________________________
> Le contenu de ce courriel est uniquement r??serv?? ?? la personne ou 
> l'organisme ?? qui il est destin??. Si vous n'??tes pas le destinataire
> pr??vu, veuillez nous en informer au plus vite et d??truire le pr??sent
> courriel. Dans ce cas, il ne vous est pas permis de copier ce courriel,
> de le distribuer ou de l'utiliser de quelque mani??re que ce soit.
> 
> The content of this e-mail is intended only and solely for the use 
> of the named recipient or organisation. If you are not the named 
> recipient, please inform us immediately and delete the present e-mail. 
> In this case, you are nor allowed to copy, distribute or use this 
> e-mail in any way.
> ___________________________________________________________

> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com