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

Comments

  • Here is my full SQL, which when I run in a development area seems to be the problem. What did I do wrong? What is adding in HD_TICKET_CHANGE and TC.USER_ID??


    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>))
  • SQL just finished on my Macbook Air, took 30 minutes and only updated one row
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share