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

[Jesse Vincent]

Ack. that needs to get into the upgrade notes. See the RT1 to RT2
importer for the explanation of what postgres is losing on.
you need to manually increment the sequence counters.

	-j


On Mon, Apr 07, 2003 at 05:57:27PM +1000, Jamie Wilkinson wrote:
> Hi all.
> 
> I've just spent an exciting few days moving our RT installation from Red Hat
> 7.0, RT 2.0.14, with a pile of CPAN installed with chewing gum and straw, to
> Red Hat 8.0, RT 3.0.0 (on httpd 2.0.40, mod_perl 1.99 and postgresql 7.3.2).
> Atually most of it went smoothly, I would highly recommend cpan2rpm for those
> package management control freaks ( http://perl.arix.com/cpan2rpm/man.html ).
> 
> After installing the new rt3 code, and running make initialize-database, I
> can create tickets from the web interface and from rt-mailgate.
> 
> Then I did a make dropdb (to clear out these dummy tickets) and make
> initialize-database again.
> 
> I used rt2-to-rt3 1.7 to dump the old database from the old machine, and
> reimported it without errors into the new database.
> 
> Now, I've logged in with the username and password from rt2 (so the import
> must have worked), and checked my ACLs:
> 
> Everyone can CreateTicket, CommentOnTicket, ReplyToTicket, and SeeQueue
> Requestor can ShowTicket
> staff can ModifyTicket, OwnTicket, ShowTicket, ShowTicketComments, Watch,
>     WatchAsAdminCC
> and finally, my own user has most of the other rights enabled.
> 
> I create the ticket by clicking on the New ticket in button, and pressing
> Create on the next page.
> 
> RT3 responds with:
> 
> RT Error       
> Ticket could not be created due to an internal error
> 
> and rt.log has the following:
> 
> [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.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:08 2003] [warning]: RT::Handle=HASH(0x93501d0) couldn't execute the query 'INSERT INTO Tickets (Owner, 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 383.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:08 2003] [warning]: DBD::Pg::st execute failed: ERROR:  current transaction is aborted, queries ignored until end of transaction block at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 376.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:08 2003] [warning]: RT::Handle=HASH(0x93501d0) couldn't execute the query 'UPDATE Tickets SET EffectiveId=? WHERE id=? ' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 383.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:08 2003] [err]: RT::Ticket=HASH(0x97796d0) ->Create couldn't set EffectiveId: EffectiveId could not be set to 0.
>  (/opt/rt3/lib/RT/Ticket_Overlay.pm:490)
> [Mon Apr  7 07:49:09 2003] [warning]: DBD::Pg::st execute failed: ERROR:  current transaction is aborted, queries ignored until end of transaction block at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 376.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [warning]: RT::Handle=HASH(0x93501d0) couldn't execute the query 'INSERT INTO Principals (PrincipalType, Disabled, ObjectId) VALUES (?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 383.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [warning]: DBD::Pg::st execute failed: ERROR:  current transaction is aborted, queries ignored until end of transaction block at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 376.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [warning]: RT::Handle=HASH(0x93501d0) couldn't execute the query 'UPDATE Principals SET ObjectId=? WHERE id=? ' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 383.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [warning]: DBD::Pg::st execute failed: ERROR:  current transaction is aborted, queries ignored until end of transaction block at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 376.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [warning]: RT::Handle=HASH(0x93501d0) couldn't execute the query 'INSERT INTO Groups (Type, Instance, Id, Domain, Name, Description)
> VALUES (?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 383.
>  (/opt/rt3/lib/RT.pm:222)
> [Mon Apr  7 07:49:09 2003] [error]: Couldn't create a ticket group of type 'Requestor' for ticket : Could not create group (/opt/rt3/lib/RT/Ticket_Overlay.pm:1282)
> [Mon Apr  7 07:49:09 2003] [crit]: Couldn't create ticket groups for ticket . aborting Ticket creation. (/opt/rt3/lib/RT/Ticket_Overlay.pm:495)
> [Mon Apr  7 07:49:09 2003] [error]: WebRT: Ticket could not be created due to an internal error () (/opt/rt3/share/html/Elements/Error:53)
> 
> I am guessing this is a problem with ACLs, possibly, because the only thing
> that has changed is the contents of the database.
> 
> -- 
> jaq at spacepants.org                           http://spacepants.org/jaq.gpg
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.