[rt-users] Problem upgrade from rt-2.0.9 to rt3-0.6

[Ruslan U. Zakirov]

Philippe Van Hecke wrote:
> I have a problem to migrate my rt-2.0.9 installation to rt3-0.6
> after importing the rt2 db to rt3 db with rt2-to-rt3-v1.20 i am 
> unable to create new ticket or udpate existing ticket in rt3.
> befor the update rt3 work well.
> 
> I use a gentoo system with postgres postgresql-7.3.4
>  Server Version: Apache/1.3.28 (Unix) (Gentoo/Linux) mod_perl/1.27
> HTML-Mason 1.20
> 
> *  Apache-DBI
>       Latest version installed: 0.91
> 
> *  DBI
>       Latest version installed: 1.37
> 
> *  DBD-Pg
>       Latest version installed: 1.22
> 
> DBIx::SearchBuilder 0.92
> 
> looking in the log when i try to create the ticket i obtain this.
> 
> 
> Nov 17 11:32:34 philippe-2 RT: 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 410.  (/usr/local/rt3//lib/
> RT.pm:247)
> Nov 17 11:32:34 philippe-2 RT: RT::Handle=HASH(0x8befe80) couldn't execute the 
> query 'INSERT INTO Tickets (Owner, Started, Type, InitialPriority, 
> LastUpdatedBy, Resolved, Starts, Subject, Status, Created, FinalPriority, 
> Priority, Queue, Due, LastUpdated, Creator) VALUES 
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/
> site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  (/usr/local/rt3//lib/
> RT.pm:247)
> 
> As rt3 working correctly befor update of db from rt2 i suspect the conversion 
> tools but have no idea where to investigate to try to resolve my problem.
> 
> Any help will be welcom.
I think you should update PG autoincrement generators.
I don't use Pg so I don't know how to do it, but search in archives 
there was same problem.
	Good luck. Ruslan.
> 
> regards,
> 
> Philippe.
> 
> 
>