Shreddeing huge tickets

1

Hi
I have a looping ticket which increased the DB size by 6Gb.
I tried shredding it bit it stops due to out of memory .

Is there a way to shred the ticket safely either without consuming so much memory or directly from the DB?
Is there a way how to prevent future tickets from looping

2

Easiest way to ‘shred’ big tickets assuming you don’t need the parts:
In MySQL:delete from Tickets where id = REALLYBIGTICKET;
Then run rt-validator with all the standard options.
This is a last resort option and may void your warrantee. If something breaks you get to keep all the pieces.

3

Thanks Jeff
It worked fine though it took quite a while to clean them