I have a process that has been running for more than 7080 seconds and
have sent a kill signal to the process more than 30 minutes ago.
kill query id#.
Is there something I'm missing?
Show full processlist:
3294878 user gpiexp01 sea 7207 Killed UPDATE
parts SET prtStocked = (CASE WHEN (prtstkqty = 0 AND prtordpnt = 0)
THEN 'N' ELSE 'Y'
3303487 domdef exapps3:43461 sea 31 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303490 domdef exapps2:36706 sea 30 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303493 domdef exapps2:36709 sea 30 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303494 domdef exapps3:43484 sea 28 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303498 domdef exapps3:43528 sea 24 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303502 domdef exapps3:43566 sea 20 Query
UPDATE parts SET prtHstCur = prtHstCur - (1/POWER(10, (0-prtVQ))),
prtHstYTD = prtHstYTD - (1
3303503 domdef exapps2:36797 sea 20 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303504 domdef exapps2:36808 sea 19 Query
UPDATE parts SET prtStkQty = prtStkQty - (1/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (1
3303505 domdef exapps2:36809 sea 19 Query
UPDATE parts SET prtStkQty = prtStkQty - (2/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (2
3303506 domdef exapps2:36820 sea 18 Query
UPDATE parts SET prtStkQty = prtStkQty - (6/POWER(10, (0-prtVQ))),
prtRsvQty = prtRsvQty + (6
3303382 domdef exapps2:35930 sea 15 Query
UPDATE pobdy LEFT JOIN parts ON pobPNID = prtPNID SET pobRecvQty =
CASE WHEN (prtStkQty < 0)
Thanks in advance
***********************
Clyde Lewis
Database Administrator
General Parts, Inc.
919-227-5100