[rt-users] TicketHistory slow on 4.2.0

[Tod Detre]

Sorry, here is the trace:

SELECT count(main.id) FROM ObjectCustomFieldValues main WHERE
(main.Disabled = '0') AND (main.ObjectId = '3561835') AND
(main.ObjectType = 'RT::Transaction')Toggle stack trace

Stack:
  [/opt/rt4/sbin/../lib/RT/Handle.pm:1646]
  [/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:591]
  [/usr/local/share/perl/5.14.2/DBIx/SearchBuilder.pm:295]
  [/opt/rt4/sbin/../lib/RT/SearchBuilder.pm:1001]
  [/opt/rt4/sbin/../lib/RT/ObjectCustomFieldValues.pm:158]
  [/usr/local/share/perl/5.14.2/DBIx/SearchBuilder.pm:1471]
  [/opt/rt4/share/html/Elements/ShowTransaction:71]
  [/opt/rt4/share/html/Elements/ShowHistory:120]
  [/opt/rt4/share/html/Helpers/TicketHistory:48]
  [/opt/rt4/share/html/Helpers/autohandler:51]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:680]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:368]
  [/opt/rt4/share/html/autohandler:53]

On Thu, Oct 31, 2013 at 1:09 PM, Alex Vandiver <alexmv at bestpractical.com> wrote:
> On Mon, 2013-10-28 at 09:54 -0400, Tod Detre wrote:
>> Adding the index did indeed fix the issue. I've pasted the line from
>> the SQL log below. It looks like the query is coming from
>> RT::Transaction. I'm not that great at perl so I'm not sure, but I
>> think it might be the method LoadCustomFieldByIdentifier. I do know
>> that the URL that starts the query is /Helpers/TicketHistory.
>>
>> [29826] [Mon Oct 28 13:33:12 2013] [debug]: SQL(2.188469s): SELECT
>> count(main.id) FROM ObjectCustomFieldValues main  WHERE (main.Disabled
>> = '0') AND (main.ObjectId = '307581') AND (main.ObjectType =
>> 'RT::Transaction') ; (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1292)
>
> To be useful, we'd unfortunately need to know the full stack trace.  The
> full stack trace is shown in the UI in the Admin → Tools → SQL Queries
> page if StatementLog is enabled.
>  - Alex
>



-- 
Tod