Re: [rt-users] Mailgate doesnt generate tickets after Upgrade
On Wed, May 07, 2014 at 12:51:07AM +0200, m...@fv-berlin.de wrote: used rt-serializer to dump the database, used rt-importer. Yeah - those are the relevant steps you didn't mention. You're running into this bug I expect http://issues.bestpractical.com/Ticket/Display.html?id=29158 -kevin pgpyXCWhmW8Sn.pgp Description: PGP signature -- RT Training - Dallas May 20-21 http://bestpractical.com/training
[rt-users] Mailgate doesnt generate tickets after Upgrade
Hi, I just updated an old 3.8.4 RT to 4.2.3 and from what I can tell the actual RT system works fine, fulltext search is up and running... but the mailgate seems to unable to create tickets. heres the apache2/error.log section: [warning]: Use of uninitialized value $domain in pattern match (m//) at /opt/rt4/sbin/../lib/RT/Group.pm line 659. (/opt/rt4/sbin/../lib/RT/Group.pm:659) [error]: Couldn't create a role group of type 'AdminCc' for RT::Ticket 1: Gruppe konnte nicht erstellt werden (/opt/rt4/sbin/../lib/RT/Record/Role/Roles.pm:587) [critical]: Couldn't create ticket groups for ticket 1. aborting Ticket creation. (/opt/rt4/sbin/../lib/RT/Ticket.pm:433) [crit]: Ticket creation failed: test2: Anfrage konnte aufgrund eines internen Fehlers nicht angelegt werden (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:245) [error]: Could not record email: Ticket creation From: [redacted] u...@example.com[redacted] failed: Anfrage konnte aufgrund eines internen Fehlers nicht angelegt werden (/opt/rt4/share/html/REST/1.0/NoAuth/mail-gateway:75) [warning]: DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint principals_pkey DETAIL: Key (id)=(3) already exists. at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589. (/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589) [warning]: RT::Handle=HASH(0x7dacfb0) couldn't execute the query 'INSERT INTO Principals (ObjectId, PrincipalType) VALUES (?, ?)' at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 602. DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x7dacfb0), INSERT INTO Principals (ObjectId, PrincipalType) VALUES (?, ?), 0, Group) called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 352 [...] To me this looks like the mailgate tries to create tickets with IDs starting from 1 instead of using an unused ID and subsequently everything else associated to this ticket creation (Role/Group creation) fails too, but maybe I am looking at this the wrong way. In any case, feedback is greatly appreciated. -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Mailgate doesnt generate tickets after Upgrade
On Tue, May 06, 2014 at 02:34:32PM +0200, m...@fv-berlin.de wrote: Hi, I just updated an old 3.8.4 RT to 4.2.3 and from what I can tell the actual RT system works fine, fulltext search is up and running... but the mailgate seems to unable to create tickets. heres the apache2/error.log section: This looks like your sequences are wrong. Did you do just an upgrade, or an upgrade and a database migration. If a database migration, how? -kevin pgpxlp5KKNAjg.pgp Description: PGP signature -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Mailgate doesnt generate tickets after Upgrade
On 06/05/2014 22:26, Kevin Falcone wrote: On Tue, May 06, 2014 at 02:34:32PM +0200, m...@fv-berlin.de wrote: Hi, I just updated an old 3.8.4 RT to 4.2.3 and from what I can tell the actual RT system works fine, fulltext search is up and running... but the mailgate seems to unable to create tickets. heres the apache2/error.log section: This looks like your sequences are wrong. Did you do just an upgrade, or an upgrade and a database migration. If a database migration, how? -kevin I mysqldump'd the 3.8.4 system, imported it into mysql on a different system (VM) that had RT 4.0.4 installed, upgraded to 4.0.4, ran the additional steps mentioned in the UPGRADE docs (vulnerable-passwords, shrink_transactions_table, shrink_cgm_table), mysqldump'd the result, imported that into yet another system into mysql, upgraded to 4.2.3, ran rt-validator --check --resolve, used rt-serializer to dump the database, ran ./configure (--with-db-type=Pg), make testdeps, make fixdeps, make install again to get pgsql-support, changed RT_SiteConfig to set it to pgsql, used rt-importer. I have also since I posted this initially, found out that I can browse the RT just fine, but it seems I cannot write to the database in any way (by say creating a new ticket) because I'd get the same internal error and either the apache errorlog or syslog saying [933] DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint principals_pkey DETAIL: Key (id)=(7) already exists. at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589. as if RT had lost track of the highest occupied ticket ID along the way and just started from 1 again. -- RT Training - Dallas May 20-21 http://bestpractical.com/training