On 7/12/2011 10:36 PM, Jeff Blaine wrote:
Hmm, you're right. I just imported principal and
cachedgroupmembers again -- this time fully. Not
sure what went wrong, but I'll go back and redo
group and groupmember as well, then run rt-validate
again.
Thanks!
Okay, now we're getting somewhere! Zero validation
problems other than the expected "Ticket" ones.
Now the problem is that the sequence stuff is out
of whack I guess. Any ideas as to how I might I go
about fixing that? It really doesn't matter to us
if the next generated sequence is "wastefully high"
to get us over this hurdle. Do you think I could
just set them (?) all to 60000 (production DB where
this data came from has 47000 tickets, so that is
surely the largest id)?
Sequence stuff out of whack:
Jul 12 23:02:37 rtdev1 RT: DBD::Pg::st execute failed: ERROR: duplicate
key violates unique constraint "principals_pkey" at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
Jul 12 23:02:37 rtdev1 RT: RT::Handle=HASH(0x2b2602b19a70) couldn't
execute the query 'INSERT INTO Principals (ObjectId, Disabled,
PrincipalType) VALUES (?, ?, ?)' at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x2b2602b19a70)',
'INSERT INTO Principals (ObjectId, Disabled, PrincipalType) VA...', 0,
0, 'Group') called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x2b2602b19a70)',
'Principals', 'ObjectId', 0, 'Disabled', 0, 'PrincipalType', 'Group')
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm
line 66
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x2b2602b19a70)',
'Principals', 'ObjectId', 0, 'PrincipalType', 'Group', 'Disabled', 0)
called at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm
line 1293
DBIx::SearchBuilder::Record::Create('RT::Principal=HASH(0x2b2608435340)', 'ObjectId',
0, 'Disabled',
Jul 12 23:02:37 rtdev1 RT: DBD::Pg::st execute failed: ERROR: currval
of sequence "groups_id_seq" is not yet defined in this session at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 78.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm:78)
Jul 12 23:02:37 rtdev1 RT: DBD::Pg::st fetchrow_array failed: no
statement executing at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 79.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm:79)
Jul 12 23:02:37 rtdev1 RT: Couldn't create a ticket group of type
'Requestor' for ticket 4: Could not create group
(/apps/rt/bin/../lib/RT/Ticket_Overlay.pm:989)
Jul 12 23:02:37 rtdev1 RT: Couldn't create ticket groups for ticket 4.
aborting Ticket creation. (/apps/rt/bin/../lib/RT/Ticket_Overlay.pm:509)
Jul 12 23:02:37 rtdev1 RT: Ticket could not be created due to an
internal error (/apps/rt/bin/../lib/RT/Interface/Email.pm:244)
Jul 12 23:02:37 rtdev1 RT: Could not record email: Ticket creation
failed: Ticket could not be created due to an internal error
(/apps/rt/share/html/REST/1.0/NoAuth/mail-gateway:75)
--------
2011 Training: http://bestpractical.com/services/training.html
