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 <[email protected]> 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
