Skip to Content

Cannot kill process in send sleep more ASE 15.7

Trying to kill spid in send sleep mode, the kill semm to do nothing, the spid is doing select on a big table. ASE version 15.7 SP52. Is there a way without having to reboot ASE ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 02 at 07:34 PM

    ASE's KILL command doesn't do much itself, it just sets a bit (named "PKILLYOURSELF") in the spid's PSS structure.
    The spid will check the state of this bit when it wakes up, and if it finds the bit set will then proceed with cleaning itself up.
    However, if the event the spid is sleeping on never occurs, it doesn't wake up and check the bit and just keeps sleeping.
    And in that case, there isn't much you can do but reboot.

    ASE 16 introduced a stronger "kill with force" option that is more effective on sleeping processes, but you'd have to upgrade.

    http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00641.1600/doc/html/mas1380302724978.html

    -bret

    Add comment
    10|10000 characters needed characters exceeded

    • Use with caution

      One observation I can share about "kill <spid> with force". --- we are at ASE 16 SP02 PL05

      It results in a stack trace. And in one case we could load a development database when this command was used to terminate a long running query. Server reboot was needed to clear up the scene.

      HTH

      Avinash

  • May 07 at 12:06 PM

    Hello Yves,

    Please be aware that ASE 15.7 has an end of life date in 2020. You should consider to upgrade to ASE 16.0 soon.

    Best regards, Matthias

    Add comment
    10|10000 characters needed characters exceeded