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
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
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.