Re: [rt-users] slow join with cachedgroupmembers for a simple "comment" click

[Palle Girgensohn]

> 4 feb. 2016 kl. 02:11 skrev David Gwynne :
> 
>> 
>> On 4 Feb 2016, at 10:21, Palle Girgensohn  wrote:
>> 
>> 
>> 
>> 4 feb. 2016 kl. 00:48 skrev David Gwynne :
>> 
>>> 
 On 4 Feb 2016, at 00:08, Palle Girgensohn  wrote:
 
 Hi David,
 
 Thanks for this input.
 
 it takes the query from 1 minute+ (== timeout in fcgid) to subseond.
 
 Big leap forward!
 
 Thanks!
 
 
 The two queries you posted are equally fast for me, ~ 8 ms, but render 
 different result, 15 vs 16 rows. :-(
>>> 
>>> yeah, after i sent it i recognised some issues with mine. i can fix it, but 
>>> then id have to go back and make RT generate the query and that idea makes 
>>> me sad.
>>> 
>> 
>> Mmm, the problem is really the ORM. It never really marries well with SQL. 
>> Sets vs objects. Sadly, I don't think it'll be worth the effort trying to 
>> force RT to generate the query. But my experience with this specific 
>> implementation is limited.
>> 
>> 
>>> if there's interest i can fix my query, but only if it'll help someone else
>> 
>> I'm happy with the first advice, reverting the patch. It made RT usable from 
>> not being that! :-)
>> 
>> Btw, already had AutocompleteOwnersForSearch enabled.
> 
> and you still got hit with the slow query?

yes.



signature.asc
Description: Message signed with OpenPGP using GPGMail

-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany — March 14 & 15, 2016

[rt-users] RT4.4 - RTIR 4.2 errors

[user1437]

Hello there,

First sorry for posting into two lists but seem to got really stuck with this 
combination. (RT4.4 and RT-IR4.2)

When creating a custom field it gives me the following error in the web 
interface
An internal RT error has occurred. Your administrator can find more details in 
RT's log files.
and this in the logs:

[43631] [Fri Feb  5 08:18:50 2016] [error]: Can't call method "QueueObj" on an 
undefined value at 
/opt/rt4/local/plugins/RT-IR/html/Callbacks/RTIR/Elements/EditCustomField/EditComponentName
 line 51.

Stack:
  
[/opt/rt4/local/plugins/RT-IR/html/Callbacks/RTIR/Elements/EditCustomField/EditComponentName:51]
  [/opt/rt4/share/html/Elements/EditCustomField:127]
  [/opt/rt4/share/html/Admin/CustomFields/Modify.html:133]
  [/opt/rt4/share/html/Admin/autohandler:49]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:696]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:375]
  [/opt/rt4/share/html/autohandler:53] 
(/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:208)


and when I want to access the RTIR web menu it gives me
An internal RT error has occurred. Your administrator can find more details in 
RT's log files.

and this in the logs:
[43631] [Fri Feb  5 08:21:37 2016] [error]: Can't call method "Content" on an 
undefined value at /opt/rt4/local/plugins/RT-IR/html/RTIR/index.html line 57.

Stack:
  [/opt/rt4/local/plugins/RT-IR/html/RTIR/index.html:57]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:696]
  [/opt/rt4/sbin/../lib/RT/Interface/Web.pm:375]
  [/opt/rt4/share/html/autohandler:53] 
(/opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm:208)


Does anyone has any clue?

may thanks in advance!
U









-
RT 4.4 and RTIR Training Sessions 
(http://bestpractical.com/services/training.html)
* Hamburg Germany  March 14 & 15, 2016