[rt-users] ticket creation error after using migration scripts

[Binand Sethumadhavan]

On Mon, Apr 07, 2003 at 05:57:27PM +1000, Jamie Wilkinson wrote:
> [Mon Apr  7 07:49:08 2003] [warning]: DBD::Pg::st execute failed: ERROR:
> Cannot insert a duplicate key into unique index tickets_pkey at
> /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 376.

When I had this problem, it went away after re-indexing the database.

The procedure is outlined in reindex(7). Essentially, shut down httpd,
sendmail (or whatever SMTP listener you use) and postgres, then

su - postgres
postgres -D $PGDATA -O -P rt2 # Your database name here
REINDEX DATABASE rt2 FORCE;

and restarting everything did the trick for me.

Binand