[rt-users] Duplicate tickets?

[Binand Raj S.]

Hi,

Someone showed me this:

tickets=# select * from tickets where id=10245;
  id   | effectiveid | queue |  type  | issuestatement | resolution | owner |       subject        | initialpriority | finalpriority | priority |  status  | timeworked | timeleft |          told          |         starts         |        started         |          due           |        resolved        | lastupdatedby |      lastupdated       | creator |        created         | disabled
  -------+-------------+-------+--------+----------------+------------+-------+----------------------+-----------------+---------------+----------+----------+------------+----------+------------------------+------------------------+------------------------+------------------------+------------------------+---------------+------------------------+---------+------------------------+----------
   10245 |       10245 |     1 | ticket |                |            |     9 | xxxxxxx DNS problem. |               0 |            10 |        0 | resolved |          0 |        0 | 2003-02-06 08:38:20-05 | 1969-12-31 19:00:00-05 | 2003-02-05 08:56:46-05 | 2003-02-12 02:09:11-05 | 2003-02-06 08:38:20-05 |             9 | 2003-02-06 08:38:21-05 |      85 | 2003-02-05 02:09:11-05 |        0
    10245 |       10245 |     1 | ticket |                |            |     9 | xxxxxxx DNS problem. |               0 |            10 |        0 | open     |          0 |        0 | 2003-02-05 09:55:30-05 | 1969-12-31 19:00:00-05 | 2003-02-05 08:56:46-05 | 2003-02-12 02:09:11-05 |                        |             9 | 2003-02-05 09:55:30-05 |      85 | 2003-02-05 02:09:11-05 |        0
    (2 rows)


(Sorry for the formatting).

It seems there were two tickets with the same ID.

Can anyone point out why this could have happened? My installation
is a default one, RedHat 7.3 + RT 2.0.15 + Apache 1.3.27 + RHDB 2.1
(Postgres 7.2.3).

Unfortunately, this happened a few days ago while I was on vacation,
and the admin who noticed this just deleted the duplicate record/ticket.

Binand