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@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Sven Sternberger
Gesendet: Dienstag, 10. November 2009 13:57
An: Ruslan Zakirov
Cc: rt-users@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, 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’);