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

[Philippe Van Hecke]

On Monday 17 November 2003 18:45, Philippe Van Hecke wrote:
> On Monday 17 November 2003 12:13, Ruslan U. Zakirov wrote:
> > 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.
>
> Have try to search in the rt-user mailing list archive but find nothing
> for pg related. But after looking more deeply into my postgres log
> it seem that this not the only error i get when i import the old db
> i have also many pg_atoi error followed by some email adresses.
>
> like this
> ERROR:  pg_atoi: error in "xxxt at yyy.be": can't parse "xxxt at yyy.be"
>
> and also many following
>
> ERROR:  Invalid UNICODE character sequence found (0xe964e9)
>
> So i thing that i will drop pg usage and try to use mysql.
> my question is  does the dump from rt2+pg will be
> imported into rt3 with mysql ?
>
> regards,
Have swaped  pg to mysql and it seem that all is in order now.

-- 
_____________________
Philippe Van Hecke
NETWORK ENGINEER
BELNET
Rue de la Science, 4 
B-1000 Brussels 
Belgium 
Tel: +32 (0) 27903333 
Fax: +32 (0) 27903335
______________________