[rt-users] Slow Query when Displaying "Owners" dropdown (Query Builder, Reply, etc.)

[Ruslan Zakirov]

On 12/30/05, mark matyas <mark at library.ucsc.edu> wrote:
> Hi Jesse,
> Thanks for responding. Before I got your email I decided to go ahead and
> try 3.5.6 for the heck of it, and it seems to have fixed the problem. I
> really like 3.5.6 actually  especially the WebUI and Simple Search. I
> have another problem now though.
> Myspecs: RT 3.5.6 + apache 2 + fastcgi + + mysql 4.1 + HTML::Mason
> v1.3101 + DBI v1.48 + DBIx::SearchBuilder v1.36;
> The only problem now though is that I get alot of the following errors
> in my apache log:
> [Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Fri Dec 30 07:12:13
> 2005] [err]: Couldn't load  from the users database.
I saw this sveral times too. I find it harmless, but anyway it should
be debugged.

> (/opt/rt3/lib/RT/CurrentUser.pm:146)
> [Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized
> value in concatenation (.) or string at
> /opt/rt3/lib/RT/Principal_Overlay.pm line 425.
> [Thu Dec 29 23:12:13 2005] [error] [client 64.233.172.40] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: [Fri Dec 30 07:12:13
> 2005] [err]: Couldn't load  from the users database.
> (/opt/rt3/lib/RT/CurrentUser.pm:146)
> [Thu Dec 29 23:12:13 2005] [error] [client 64.233.172.40] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized
> value in concatenation (.) or string at
> /opt/rt3/lib/RT/Principal_Overlay.pm line 425.
> [Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute
> failed: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'AND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR
> (ACL.ObjectType = '' at line 1 at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 493.
> [Thu Dec 29 23:12:13 2005] [error] [client 67.180.231.50] FastCGI:
> server "/opt/rt3/bin/mason_handler.fcgi" stderr:
> RT::Handle=HASH(0xaabfb6c) couldn't execute the query 'SELECT ACL.id
> from ACL, Groups, Principals, CachedGroupMembers WHERE  (ACL.RightName =
> 'SuperUser' OR  ACL.RightName = 'ModifySelf') AND Principals.Disabled =
> 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND
> Principals.PrincipalType = 'Group' AND Principals.id =
> CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId =  AND
> ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType
> = 'RT::System')) AND ACL.PrincipalId = Principals.id AND
> ACL.PrincipalType = 'Group'  LIMIT 1' at
> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 506
This is bad.
"AND CachedGroupMembers.MemberId =  AND"
                                                          ^^^^^ here
Could turn on stack traces logging in RT config:
Set($LogToFile, 'error');
Set($LogStackTraces, 1);
Then reproduce this query error and send us stack trace from log file,
note that stacktraces are not logged via syslog.

>
>
> what could this be? should I downgrade or upgrade a certain perl module?
> I would really like to keep using 3.5.6 if possible. should i downgrade RT?
> Thanks for your help,
> mark matyas
>
> Jesse Vincent wrote:
> >
> >
> > On Wed, Dec 28, 2005 at 03:16:09PM -0800, mark matyas wrote:
> >
> >>Hello RT Users,
> >>
> >>We just upgraded from RT 3.0 to 3.4.4 and everything went fine expect
> >>for one thing:
> >>There is a specific query that takes more than 50 Seconds and is
> >>executed frequently as the results of the Query seems to be the list of
> >>Owners in the Drop down menu for the Query Builder page or When
> >>Selecting Reply, etc. So when a user clicks on the Query Builder it
> >>takes 50 seconds, making it very hard to use sometimes.
> >
> >
> >
> > Mark,
> >
> > Can you please test out RT 3.4.5RC2 to see if it solves your performance
> > problem? We spent about half a man week working on just that for this
> > release.
> >
> > Jesse
> _______________________________________________
> 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
>


--
Best regards, Ruslan.