Question about ticket bulk update

HI,

I have RT 3.6.7 running on Postgresql 8.3

General performance was very poor, so we did some optimising last week.
We added the following indices :-

rtdb=# create index groups2_lower on groups(lower(type),instance,lower(domain));
rtdb=# create index users1_lower on users(lower(name));
rtdb=# create index users4_lower on users(lower(emailaddress));
rtdb=# create index groupmembers_groupid on groupmembers(groupid);
rtdb=# create index cachedgroupmembers_immediateparentid on cachedgroupmembers(immediateparentid);
rtdb=# create index cachedgroupmembers_immediateparentid on cachedgroupmembers(immediateparentid);

The overall improvement in performance is staggering. Happy users.

However, it appears that these actions may have broken the ticket bulk update routine.

When a user clicks on the ticket bulk update link now, they get a screen with the tickets on and then a very long wait before the list of users is given to them. Before last week, this list just contained our local users, but now the list contains every single person who has every emailed in a ticket as well, which is around a million.

Firstly, did these extra indices cause this problem, and secondly, what can I do to get this list back to just our internal user list ?

Thanks,
Gary

When a user clicks on the ticket bulk update link now, they get a screen with the tickets on and then a very long wait before the list of users is given to them. Before last week, this list just contained our local users, but now the list contains every single person who has every emailed in a ticket as well, which is around a million.

seems someone changed your RT rights and granted most probably the right
OwnTicket on global scope to Unprivileged pseudo group.

if you can’t find it, you can select on the ACLs table for the RightName
“OwnTicket” and send the result here to get help.

Easter-eggs Sp�cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M�tro Gait�
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com