RTx-Shredder question

I had a question about removing ticket from the database…

I am not a database expert so this will be a “green” question…

Instead of using RTx-Shredder why can’t I simply run a query against the
database to remove any tickets with the status of deleted? Will that leave
too many other linked tables with data that is not linked? Is that why we
should use RTx-Shredder?

On my test Installs of RT I have deleted data this way without an issue…

Just curious…

Hello,On Thu, Jul 13, 2006 at 11:48:46AM -0400, spydrrrrr@gmail.com wrote:

Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder?

Simply put, yes :slight_smile:

Sincerely,
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386

Hello,

Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder?

Simply put, yes :slight_smile:

However is this a bad thing? I mean if there is data in the database that I
do not want and is associated with an ID number that does not exitst does
that matter?

 Hello,
 <snip>
 Will that leave too many other linked tables with data that is not
 linked? Is that why we should use RTx-Shredder?
 <snip>

 Simply put, yes :)

However is this a bad thing? I mean if there is data in the database that
I do not want and is associated with an ID number that does not exitst
does that matter?

Yes, it can break the WebUI. For example, attempting to load a ticket that contains a link to another ticket that has been removed from the database causes the web interface to dump an error which prevents you from accessing the existing ticket. Ruslan would have to confirm this, but I believe that Shredder will remove the link in the existing ticket when the referenced one is deleted from the database.

Based on my experience restoring stuff from Shredder’s sql dumps, I can confidently say that when it removes a single ticket from the database, many SQL actions occur. From this, I gather there is much more complexity involved than the situation I describe above.

Sincerely,
Frank Pater
DCANet
http://www.dca.net
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386

As I remember one of users reported that shredder deletes 500 records
from different tables of his DB for four tickets only. Really the
tickets table is “la punta dell’iceberg”.On 7/13/06, spydrrrrr@gmail.com spydrrrrr@gmail.com wrote:

I had a question about removing ticket from the database…

I am not a database expert so this will be a “green” question…

Instead of using RTx-Shredder why can’t I simply run a query against the
database to remove any tickets with the status of deleted? Will that leave
too many other linked tables with data that is not linked? Is that why we
should use RTx-Shredder?

On my test Installs of RT I have deleted data this way without an issue…

Just curious…


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

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

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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

Best regards, Ruslan.

I’m trying to use RTx-Shredder on RT 3.6.0 from command line:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue, queuename’

and return this error:

[crit]: Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, line 1.
(/opt/rt3/lib/RT.pm:317)

any ideas ?

Marco

Marco Avvisano wrote:

I’m trying to use RTx-Shredder on RT 3.6.0 from command line:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue, queuename’

and return this error:

[crit]: Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, line 1.
(/opt/rt3/lib/RT.pm:317)

any ideas ?

Marco

----- Original Message ----- From: "Ruslan Zakirov"
ruslan.zakirov@gmail.com
To: spydrrrrr@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Friday, July 14, 2006 2:38 PM
Subject: Re: [rt-users] RTx-Shredder question

As I remember one of users reported that shredder deletes 500 records
from different tables of his DB for four tickets only. Really the
tickets table is “la punta dell’iceberg”.

I had a question about removing ticket from the database…

I am not a database expert so this will be a “green” question…

Instead of using RTx-Shredder why can’t I simply run a query against
the
database to remove any tickets with the status of deleted? Will that
leave
too many other linked tables with data that is not linked? Is that
why we
should use RTx-Shredder?

On my test Installs of RT I have deleted data this way without an
issue…

Just curious…


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

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

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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html


Best regards, Ruslan.


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

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

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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html


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

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

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

I’m no expert but I don’t think there is supposed to be a space between
the comma and the queuename:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue,queuename’

Mathew Snyder

Nope, no space, and i also know the error…2006/8/9, Mathew Snyder jokermjs19@comcast.net:

Marco Avvisano wrote:

I’m trying to use RTx-Shredder on RT 3.6.0 from command line:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue, queuename’

and return this error:

[crit]: Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, line 1.
(/opt/rt3/lib/RT.pm:317)

any ideas ?

Marco

----- Original Message ----- From: "Ruslan Zakirov"
ruslan.zakirov@gmail.com
To: spydrrrrr@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Friday, July 14, 2006 2:38 PM
Subject: Re: [rt-users] RTx-Shredder question

As I remember one of users reported that shredder deletes 500 records
from different tables of his DB for four tickets only. Really the
tickets table is “la punta dell’iceberg”.

On 7/13/06, spydrrrrr@gmail.com spydrrrrr@gmail.com wrote:

I had a question about removing ticket from the database…

I am not a database expert so this will be a “green” question…

Instead of using RTx-Shredder why can’t I simply run a query against
the
database to remove any tickets with the status of deleted? Will that
leave
too many other linked tables with data that is not linked? Is that
why we
should use RTx-Shredder?

On my test Installs of RT I have deleted data this way without an
issue…

Just curious…


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

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

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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html


Best regards, Ruslan.


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

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

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

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html


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

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

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

I’m no expert but I don’t think there is supposed to be a space between
the comma and the queuename:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue,queuename’

Mathew Snyder


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

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

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

MFG

Torsten Brumm

http://www.torsten-brumm.de

I’m trying to use RTx-Shredder on RT 3.6.0 from command line:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue, queuename’

and return this error:

[crit]: Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, line 1.
(/opt/rt3/lib/RT.pm:317)

Do you have Asset Tracker installed?

Is this a ticket that might of had a link at some point?

-Todd

I’m trying to use RTx-Shredder on RT 3.6.0 from command line:

/opt/rt3/local/sbin/rtx-shredder --plugin ‘Tickets=queue, queuename’

and return this error:

[crit]: Couldn’t wipeout object: Can’t call method “IsLocal” on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, line 1.
(/opt/rt3/lib/RT.pm:317)

Do you have Asset Tracker installed?
no … it’s possible to download a free version?

Is this a ticket that might of had a link at some point?

may be … if i try to view the ticket, return me this error

  error:  Can't call method "IsLocal" on an undefined value at 

/opt/rt3/lib/RT/URI.pm line 247.

  context:  ...
        243:  =cut
        244:
        245:  sub IsLocal {
        246:  my $self = shift;
        247:  return $self->Resolver->IsLocal;
        248:  }
        249:
        250:
        251:  # }}}
        ...

  code stack:  /opt/rt3/lib/RT/URI.pm:247
  /opt/rt3/lib/RT/Links_Overlay.pm:159
  /opt/rt3/share/html/Elements/ShowLinks:85
  /opt/rt3/share/html/Ticket/Elements/ShowSummary:90
  /opt/rt3/share/html/Widgets/TitleBox:49
  /opt/rt3/share/html/Ticket/Elements/ShowSummary:91
  /opt/rt3/share/html/Ticket/Display.html:56
  /opt/rt3/share/html/Widgets/TitleBox:49
  /opt/rt3/share/html/Ticket/Display.html:57
  /opt/rt3/share/html/autohandler:279

raw error

Can’t call method “IsLocal” on an undefined value at /opt/rt3/lib/RT/URI.pm
line 247.

Trace begun at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception(‘Can’t call method “IsLocal” on
an undefined value at /opt/rt3/lib/RT/URI.pm line 247.^J’) called at
/opt/rt3/lib/RT/URI.pm line 247
RT::URI::IsLocal(‘RT::URI=HASH(0xa722694)’) called at
/opt/rt3/lib/RT/Links_Overlay.pm line 159
RT::Links::Next(‘RT::Links=HASH(0xa7212dc)’) called at
/opt/rt3/share/html/Elements/ShowLinks line 85
HTML::Mason::Commands::ANON(‘Ticket’, ‘RT::Ticket=HASH(0xa67c43c)’)
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm
line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa71f75c)’,
‘Ticket’, ‘RT::Ticket=HASH(0xa67c43c)’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, ‘Ticket’,
‘RT::Ticket=HASH(0xa67c43c)’) called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 90
HTML::Mason::Commands::ANON at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1315
HTML::Mason::Request::content(‘HTML::Mason::Request::CGI=HASH(0xa50ded4)’)
called at /opt/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::ANON(‘title’, ‘Collegamenti’, ‘title_href’,
’/Ticket/ModifyLinks.html?id=2’, ‘class’, ‘ticket-info-links’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa0b45d4)’,
‘title’, ‘Collegamenti’, ‘title_href’, ‘/Ticket/ModifyLinks.html?id=2’,
‘class’, ‘ticket-info-links’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Collegamenti’,
‘title_href’, ‘/Ticket/ModifyLinks.html?id=2’, ‘class’, ‘ticket-info-links’)
called at /opt/rt3/share/html/Ticket/Elements/ShowSummary line 91
HTML::Mason::Commands::ANON(‘Ticket’, ‘RT::Ticket=HASH(0xa67c43c)’,
‘Attachments’, ‘RT::Attachments=HASH(0xa5bc2c0)’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa6ba4fc)’,
‘Ticket’, ‘RT::Ticket=HASH(0xa67c43c)’, ‘Attachments’,
‘RT::Attachments=HASH(0xa5bc2c0)’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, ‘Ticket’,
‘RT::Ticket=HASH(0xa67c43c)’, ‘Attachments’,
‘RT::Attachments=HASH(0xa5bc2c0)’) called at
/opt/rt3/share/html/Ticket/Display.html line 56
HTML::Mason::Commands::ANON at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1315
HTML::Mason::Request::content(‘HTML::Mason::Request::CGI=HASH(0xa50ded4)’)
called at /opt/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::ANON(‘title’, ‘Metadati del ticket’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa0b45d4)’,
‘title’, ‘Metadati del ticket’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, undef, ‘title’, ‘Metadati del
ticket’) called at /opt/rt3/share/html/Ticket/Display.html line 57
HTML::Mason::Commands::ANON(‘id’, 2, ‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0xa4cb28c)’,
‘id’, 2, ‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, ‘id’, 2, ‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 914
HTML::Mason::Request::call_next(‘HTML::Mason::Request::CGI=HASH(0xa50ded4)’,
‘id’, 2) called at /opt/rt3/share/html/autohandler line 279
HTML::Mason::Commands::ANON(‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8c988e8)’,
‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1246
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, undef, ‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 459
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 459
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 411
HTML::Mason::Request::exec(‘HTML::Mason::Request::CGI=HASH(0xa50ded4)’)
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/CGIHandler.pm
line 192
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 192
HTML::Mason::Request::CGI::exec(‘HTML::Mason::Request::CGI=HASH(0xa50ded4)’)
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Interp.pm
line 342
HTML::Mason::Interp::exec(undef, undef, ‘id’, 2) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 123
eval {…} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 123
HTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x991d768)’,
‘HASH(0xa5a4e50)’) called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/CGIHandler.pm line 73
HTML::Mason::CGIHandler::handle_cgi_object(‘HTML::Mason::CGIHandler=HASH(0x991d768)’,
‘CGI::Fast=HASH(0xa666bfc)’) called at /opt/rt3/bin/mason_handler.fcgi line
76
eval {…} at /opt/rt3/bin/mason_handler.fcgi line 76
Marco