Problems with rt-shredder / rt-validator
|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
 |
Problems with rt-shredder / rt-validator
by Sven Sternberger
::
Rate this Message:
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@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Kevin Falcone-2
::
Rate this Message:
On Thu, Sep 10, 2009 at 10:35:20AM +0200, Sven Sternberger wrote:
> 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? Did you search LocalTarget and LocalBase, or just LocalBase? It might be instructive to see the deleted link record, but if the error still shows up it implies that there is still a Link hiding. -kevin _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sales@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Ruslan Zakirov
::
Rate this Message:
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@...> 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@... > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > -- Best regards, Ruslan. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sales@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Sven Sternberger
::
Rate this Message:
Hello!
On Do, 2009-09-10 at 11:41 -0400, Kevin Falcone wrote: > Did you search LocalTarget and LocalBase, or just LocalBase? both > > It might be instructive to see the deleted link record, but if the > error still shows up it implies that there is still a Link hiding. mysql> select * from Links where LocalBase=228186 or LocalTarget=228186; +-------+-------------------------------------+--------+-----------+-------------+-----------+---------------+---------------------+---------+---------------------+ | id | Base | Target | Type | LocalTarget | LocalBase | LastUpdatedBy | LastUpdated | Creator | Created | +-------+-------------------------------------+--------+-----------+-------------+-----------+---------------+---------------------+---------+---------------------+ | 14381 | fsck.com-rt://desy.de/ticket/228186 | NULL | DependsOn | 0 | 228186 | 1 | 2007-07-30 12:21:58 | 1 | 2007-07-30 12:21:58 | +-------+-------------------------------------+--------+-----------+-------------+-----------+---------------+---------------------+---------+---------------------+ I configured the debug mode, but I don't get any output when I display the ticket. I just realized that the display stops exactly at the Link section. So there is no history afterwards. When I try to wipeout the ticket via Web-UI Shredder I always get: [Fri Sep 11 08:48:09 2009] [warning]: RT::CachedGroupMember-2483006 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:10 2009] [warning]: RT::CachedGroupMember-2483007 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:10 2009] [warning]: RT::GroupMember-849693 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:11 2009] [warning]: RT::CachedGroupMember-2483000 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:11 2009] [warning]: RT::Transaction-1113090 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:11 2009] [warning]: RT::Group-842057 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:12 2009] [warning]: RT::Principal-842057 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:13 2009] [warning]: RT::CachedGroupMember-2483004 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:14 2009] [warning]: RT::CachedGroupMember-2483005 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:14 2009] [warning]: RT::GroupMember-849692 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:15 2009] [warning]: RT::CachedGroupMember-2483001 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:15 2009] [warning]: RT::Transaction-1113091 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:15 2009] [warning]: RT::Group-842058 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:15 2009] [warning]: RT::Principal-842058 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:16 2009] [warning]: RT::CachedGroupMember-2483002 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:16 2009] [warning]: RT::Transaction-1113092 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:16 2009] [warning]: RT::Group-842059 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:16 2009] [warning]: RT::Principal-842059 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::CachedGroupMember-2483003 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::Transaction-1113093 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::Group-842060 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::Principal-842060 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::Attachment-621573 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:17 2009] [warning]: RT::Transaction-1113094 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-1172242 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149578 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149579 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149581 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149583 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149585 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149587 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149589 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149591 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) [Fri Sep 11 08:48:18 2009] [warning]: RT::Transaction-2149593 wiped out (/opt/rt3/bin/../lib/RT/Shredder/Record.pm:236) Best regards! sven _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sales@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Sven Sternberger
::
Rate this Message:
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@...> 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@... > > > > > > 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@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Brumm,
Torsten / Kuehne + Nagel / Ham MI-ID
::
Rate this Message:
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@... [mailto:rt-users-bounces@...] Im Auftrag von Sven Sternberger Gesendet: Dienstag, 10. November 2009 13:57 An: Ruslan Zakirov Cc: rt-users@... 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@...> 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@... > > > > > > 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@... 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@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
|
|
Re: Problems with rt-shredder / rt-validator
by Sven Sternberger
::
Rate this Message:
Hi!
On Tue, 2009-11-10 at 14:50 +0100, Brumm, Torsten / Kuehne + Nagel / Ham MI-ID wrote: > 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) yes this did the trick. I removed a entry in Links (the Target was NULL) and afterwards shredder removed the rest of the ticket without problems. best regards and thanks to Torsten sven _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sales@... Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com |
| Free embeddable forum powered by Nabble | Forum Help |
