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>))
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
update HD_TICKET, HD_TICKET_CHANGE as TC, HD_CATEGORY as T5, HD_STATUS as T6, USER as T8
set HD_TICKET.HD_CATEGORY_ID = T5.ID,
HD_TICKET.HD_STATUS_ID = '55',
HD_TICKET.HD_CATEGORY_ID = '116',
HD_TICKET.TIME_OPENED = IF(T6.STATE = 'opened', NOW(), HD_TICKET.TIME_OPENED),
HD_TICKET.TIME_CLOSED = IF(T6.STATE = 'closed', NOW(), HD_TICKET.TIME_CLOSED),
HD_TICKET.TIME_STALLED = IF(T6.STATE = 'stalled', NOW(), HD_TICKET.TIME_STALLED),
HD_TICKET.CUSTOM_FIELD_VALUE3 = 'Information Only',
HD_TICKET.CUSTOM_FIELD_VALUE0 = 'My Department',
HD_TICKET.CUSTOM_FIELD_VALUE1 = ' Building Center',
HD_TICKET.SUBMITTER_ID='10',
HD_TICKET.OWNER_ID = 'TC.USER_ID',
HD_TICKET.CUSTOM_FIELD_VALUE9 = ''
where
HD_TICKET.HD_QUEUE_ID = T5.HD_QUEUE_ID and
HD_TICKET.ID=7825
and
(HD_TICKET.ID in (<TICKET_IDS>)) - Jbr32 10 years ago