Macguy, it's time to set up a retention policy. I'm at 30 days for all tables, but 6 months may be feasible for your org. It's largely size dependent. Just that step will help in a lot of cases.
If you have a scheduled log deletion, make sure it's not the same time as your database backups. For example, I dump logs at midnight and backup at 3am.
Now, this last bit isn't a recommendation per se, but I did have a corrupted table and did solve it this way: Drop the table and re-run the JSS installer. You lose whatever was in that table, but with a 30-day retention policy in place, I was back up to normal within.... 30 days. Functionally, the required information was mostly complete far sooner, and I did lose whatever "historical" data I had for machines that hadn't checked in for 30 days or more (remember, the last record is never deleted, even if older than 30 days). But, hey - I got past the error. I AM NOT SAYING THAT YOU SHOULD DO THIS. IF YOU DO, YOU'LL LOSE DATA. But it works.
