Skip to Content
0

Cannot kill process in send sleep more ASE 15.7

May 02 at 07:06 PM

75

avatar image

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bret Halford
May 02 at 07:34 PM
1

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

Show 1 Share
10 |10000 characters needed characters left 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

0
Matthias Wild
May 07 at 12:06 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded