What went wrong?
Is there a way to tell exactly what went wrong with your k1000 just before it exploded? I was working on a custom ticket rule that was limited to one specific ticket to run against (for testing purposes). The select only returned 10 rows and the update takes those rows and runs an update command with an additional parameter to limit to one specific ticket (see code below). When I looked at they mysql threads it went nuts! The web UI locked for a bit and then it was accessible so I rebooted the unit. Seems to be ok now.
where HD_TICKET.HD_QUEUE_ID = T5.HD_QUEUE_ID and HD_TICKET.ID=7825 and (HD_TICKET.ID in (<TICKET_IDS>))
There are no answers at this time