[rt-users] Upgrade from 3.0.11 to 3.4.4, owner query time out

[Jesse Vincent]

On Mon, Jan 23, 2006 at 05:20:06PM +0200, Andre Sachs wrote:
> 
> On 23 Jan 2006, at 4:14 PM, Jesse Vincent wrote:
> 
> >Well, the problem you've described is exactly the problem we've fixed.
> >I'm not sure it'll deliver the result you require either. It is,
> >however, the first step you should be taking if you're looking for  
> >help
> >from me  or anyone else on the mailinglist.
> 
> Apologies, I did not mean to offend.
> 
> The upgrade to 3.4.5 improved the situation, the owner query now  
> returns results on the Query Builder page.
> It is however still taking some time to complete the query - 108  
> seconds with a cost that looks like :
> 
> Unique  (cost=26792.76..26794.16 rows=16 width=2692)
> 
> To the meat of the question - at install time I setup RT to allow  
> Everyone "Create Ticket" and "Reply To Ticket". Needless to say this  
> was a mistake :)
> The result is that RT has created lots of possible ticket owners.

Neither of those implies "Own Ticket"  Perhaps you've granted "Everyone"
the right to Own tickets? Also, are you vacuuming your postgres database
regularly?

> I am unclear on how Users relate ACLs and ACLs to Tickets, can  
> someone help me understand how to go about fixing my mistake ?
> 
> Thanks for all the help and a great product,
>    Andre
> 
> --
> Andre Sachs
> IT Architect, Clue Technologies PTY (LTD)
> email: andre at clue.co.za
> 
> 
> _______________________________________________
> 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
> 

--