BULK shredding?

I’ve just been looking into using RTx-Shredder to kill off our deleted
tickets (55000 tickets now, and probably 80% deleted).
However using the obvious incantation from the documentation:

./rtx-shredder --sqldump unshred.2005-12-21.B.sql --plugin 

‘Tickets=status,deleted’

it offers to delete 10 tickets. Running it again deletes another 10. Is
there an option to shred ALL the matching tickets? I couldn’t see one in
the docs… From the web interface, there’s a limit you can set, but if
you set it high then the URI is too long for the RT web dispatcher
(‘high’ seems to be <500).

Can I specify a limit on the CLI version (bypassing any URI problems)?

I don’t mind if it takes a while, just so long as it doesn’t require
poking every 10 minutes :slight_smile:

Best Regards,

Howard Jones

(Incidentally, the Shredder Web UI didn’t work in IE6 at all - the
show/hide for the plugin options didn’t trigger. I used Firefox and it
worked fine).

At Thursday 12/22/2005 12:07 PM, Howard Jones wrote:

(Incidentally, the Shredder Web UI didn’t work in IE6 at all - the
show/hide for the plugin options didn’t trigger. I used Firefox and it
worked fine).


This doesn’t work in Opera either.

Steve

I’ve just been looking into using RTx-Shredder to kill off our deleted
tickets (55000 tickets now, and probably 80% deleted).
However using the obvious incantation from the documentation:

./rtx-shredder --sqldump unshred.2005-12-21.B.sql --plugin

‘Tickets=status,deleted’

it offers to delete 10 tickets. Running it again deletes another 10. Is
there an option to shred ALL the matching tickets? I couldn’t see one in
the docs… From the web interface, there’s a limit you can set, but if
you set it high then the URI is too long for the RT web dispatcher
(‘high’ seems to be <500).

Can I specify a limit on the CLI version (bypassing any URI problems)?
Yes, you can. CLI has the same set of options for plugins.
./rtx-shredder --sqldump unshred.2005-12-21.B.sql --plugin
‘Tickets=status,deleted;limit,500’

I wouldn’t suggest you to delete more then 1000 tickets at once.

I don’t mind if it takes a while, just so long as it doesn’t require
poking every 10 minutes :slight_smile:

Best Regards,

Howard Jones

(Incidentally, the Shredder Web UI didn’t work in IE6 at all - the
show/hide for the plugin options didn’t trigger. I used Firefox and it
worked fine).


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html

Best regards, Ruslan.

At Thursday 12/22/2005 12:07 PM, Howard Jones wrote:

(Incidentally, the Shredder Web UI didn’t work in IE6 at all - the
show/hide for the plugin options didn’t trigger. I used Firefox and it
worked fine).


This doesn’t work in Opera either.
Oh, that’s bad. I don’t have access to IE :frowning: I’ll try with opera.

Steve


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at http://bestpractical.com/services/training.html

Best regards, Ruslan.