Problem upgrade from rt-2.0.9 to rt3-0.6

RT Users
1

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.

regards,

Philippe.

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

2

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.

3

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@yyy.be”: can’t parse “xxxt@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,

Philippe.

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

4

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@yyy.be”: can’t parse “xxxt@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