[rt-users] Problems with rt-shredder / rt-validator

Tue Nov 10 08:50:54 EST 2009

Hi Sven,
i remember this problem at our installation some years ago, a hint from Ruz was to check inside the link table for this ticket number and fix the problem directly here (hopefully i remember correctly)

@Ruz: I think this solved the problem for us, several hundret years ago ;-)
@Sven: Wie siehts mit nem Treffen Anfang Dezember bei Euch aus?

Torsten

Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne

-----Urspruengliche Nachricht-----
Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Sven Sternberger
Gesendet: Dienstag, 10. November 2009 13:57
An: Ruslan Zakirov
Cc: rt-users at lists.bestpractical.com
Betreff: Re: [rt-users] Problems with rt-shredder / rt-validator

Hello!

I'm still interested to get rid of the ticket.

Now with rt3.8.6 I still get

# /opt/rt3/sbin/rt-shredder --plugin "Tickets=query,Status ='deleted'
AND id=228186;limit,100"
SQL dump file is '/root/20091110T124735-0001.sql'
Next 1 objects would be deleted:
        RT::Ticket-228186 object
Do you want to proceed? [y/N] y
Couldn't wipeout object: Can't call method "IsLocal" on an undefined value at /opt/rt3/sbin/../lib/RT/URI.pm line 249, <STDIN> line 1.

=====================
/root/20091110T124735-0001.sql:
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483006','842057','22064','2483006');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483007','842057','22064','2483000');
INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`)
VALUES('842057','849693','22064');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483000','842057','842057','2483000');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113090',NULL,NULL,'842057','RT::Group',NULL,NULL,NULL,'0','Create');
INSERT INTO
`Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`)
VALUES(NULL,'RT::Ticket-Role','842057','228186',NULL,'Requestor');
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`)
VALUES('0','842057','842057','Group');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483004','842058','10','2483004');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483005','842058','10','2483001');
INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`)
VALUES('842058','849692','10');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483001','842058','842058','2483001');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113091',NULL,NULL,'842058','RT::Group',NULL,NULL,NULL,'0','Create');
INSERT INTO
`Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`)
VALUES(NULL,'RT::Ticket-Role','842058','228186',NULL,'Owner');
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`)
VALUES('0','842058','842058','Group');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842059','2483002','842059','842059','2483002');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113092',NULL,NULL,'842059','RT::Group',NULL,NULL,NULL,'0','Create');
INSERT INTO
`Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`)
VALUES(NULL,'RT::Ticket-Role','842059','228186',NULL,'Cc');
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`)
VALUES('0','842059','842059','Group');
INSERT INTO
`CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842060','2483003','842060','842060','2483003');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113093',NULL,NULL,'842060','RT::Group',NULL,NULL,NULL,'0','Create');
INSERT INTO
`Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`)
VALUES(NULL,'RT::Ticket-Role','842060','228186',NULL,'AdminCc');
INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`)
VALUES('0','842060','842060','Group');
INSERT INTO
`Attachments`(`content`,`contentencoding`,`contenttype`,`created`,`creator`,`filename`,`headers`,`id`,`messageid`,`parent`,`subject`,`transactionid`) VALUES('xxxx','none','text/plain','2007-07-30 12:21:57','1',NULL,'Content-Type: text/plain\nContent-Disposition: inline\nContent-Transfer-Encoding: binary\nMIME-Version: 1.0\nX-Mailer: MIME-tools 5.420 (Entity 5.420)\n','621573','','0','','1113094');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113094',NULL,NULL,'228186','RT::Ticket',NULL,NULL,NULL,'0','Create');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-09-18 14:15:43','22064',NULL,'Status','1172242',NULL,'deleted','228186','RT::Ticket',NULL,'new',NULL,'0','Status');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2009-09-10 14:13:25','22064',NULL,'Status','2215411',NULL,'open','228186','RT::Ticket',NULL,'deleted',NULL,'0','Status');
INSERT INTO
`Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2009-09-10 14:13:45','22064',NULL,'Status','2215414',NULL,'deleted','228186','RT::Ticket',NULL,'open',NULL,'0','Status');

On Thu, 2009-09-10 at 20:09 +0400, Ruslan Zakirov wrote:
> Hi Sven,
> 
> rt-validator lacks some checks regarding links and probably doesn't 
> catch many cases regarding Links table.
> 
> On Thu, Sep 10, 2009 at 12:35 PM, Sven 
> Sternberger<sven.sternberger at desy.de> wrote:
> > Hello!
> >
> > RT3.8.4/mysql5/ScientificLinux 5 (RHEL-Clone)
> >
> > I try to erease an old tickets from our RT, but this fails with the 
> > message "Couldn't wipeout object: Can't call method "IsLocal" on an 
> > undefined value at /opt/rt3/sbin/../lib/RT/URI.pm line 249, <STDIN> 
> > line 1."
> >
> > I tried rt-validator. But this don't help, the ticket can't be 
> > wipeout afterwards. *
> >
> > If I try to open the ticket in the Web-UI, the Link-Box is missing 
> > instead there is the message Can't call method "Object" on an 
> > undefined value at /opt/rt3/bin/../lib/RT/URI.pm line 232"
> >
> > I found one record in the Links table which referenced this ticket 
> > (as LocalBase). I deleted this record, but the problem remains. *
> >
> > (* on a test machine, with copy of the production data)
> >
> > Any ideas what I can do to repair the DB?
> >
> > best regards!
> >
> > sven
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com Commercial support: 
> > sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
> 
> 
> 

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales at bestpractical.com

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com