Can someone help me out of this mess?
I use RT 2.0.15 with RHDB 2.1 (Postgres 7.2.3) as the backend. Today,
while I tried to resolve a ticket, I got this:
Status: Status could not be set to resolved.
I found this in the database:
tickets=# select id from tickets where id = 10622;
tickets=# update tickets set status = ‘resolved’ where id = 10622;
ERROR: Cannot insert a duplicate key into unique index tickets_pkey
Why is it showing me ticket 10613 for a query on 10622?
How do I get out of this mess?
Any help will be appreciated.
(Now I find more tickets with the same problem, viz:
tickets=# select id from tickets where id = 10613;
I feel the index has gone bust. How do I rebuild it?)