Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

zombi process

2 posts in Windows NT Last posting was on 2000-12-07 12:31:58.0Z
Andrey V. Kolchanov Posted on 2000-12-07 11:01:00.0Z
Sender: andrey@orion.int.fct.ru
Subject: zombi process
From: andrey@fct.ru (Andrey V. Kolchanov)
Date: 07 Dec 2000 14:01:00 +0300
Message-ID: <m37l5ca42b.fsf@orion.int.fct.ru>
Lines: 35
User-Agent: Gnus/5.0807 (Gnus v5.8.7) XEmacs/21.2 (Nike)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: FCT Ltd
Cache-Post-Path: gatekeeper.fct.ru!unknown@orion.int.fct.ru
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gatekeeper.fct.ru 212.113.103.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1423
Article PK: 1088888

Hello.

We have ASE 11.9.2.3 on WinNT server with 4 processors.
version-
Adaptive Server Enterprise/11.9.2.3/1156/P/SWR 9160 ESD 2/NT
(IX86)/OS 3.51,4.0/FBU/Thu Jul 27 05:46:21 2000

And we have locks held by killed and unexisting processes, and we
have to reboot server.

Is there any solutions for the problem ?

The're sybase errorlog
02:00000:00098:2000/12/07 12:23:50.79 server Process id 27 killed by Hostname , Host process id 17757.
00:00000:00027:2000/12/07 12:23:51.12 server Error: 1205, Severity: 13, State: 1
00:00000:00027:2000/12/07 12:23:51.12 server Your server command (family id #0, process id #27) was deadlocked with another process and has been chosen as deadlock victim. Re-run your command.
00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open sdes. pspid 27, psuid 200, pcurdb 2, system table entry 0, sdesp 0x22d190c0, objid 1475278150
00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open sdes. pspid 27, psuid 200, pcurdb 2, system table entry 1, sdesp 0x22d190c0, objid 1475278150
00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open sdes. pspid 27, psuid 200, pcurdb 2, system table entry 2, sdesp 0x22e01720, objid 8
00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open sdes. pspid 27, psuid 200, pcurdb 2, system table entry 3, sdesp 0x22e00460, objid 2
00:00000:00027:2000/12/07 12:23:51.12 server Error: 6103, Severity: 17, State: 1
00:00000:00027:2000/12/07 12:23:51.12 server Unable to do cleanup for the killed process; received Msg 1205.
00:00000:00027:2000/12/07 12:23:51.12 server WARNING: spid 27, with suid 200 and curdbid 2 has active XDES #1 with xactid (317149, 14).
03:00000:00098:2000/12/07 12:24:00.93 server Process id 117 killed by Hostname , Host process id 17760.
03:00000:00098:2000/12/07 12:24:11.06 server Process id 113 killed by Hostname , Host process id 17763.
00:00000:00082:2000/12/07 12:25:40.13 kernel Cannot send, host process disconnected: 162 spid: 82
00:00000:00082:2000/12/07 12:25:40.15 server Error: 1608, Severity: 18, State: 4
00:00000:00082:2000/12/07 12:25:40.15 server A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
00:00000:00000:2000/12/07 12:27:15.23 kernel kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2000/12/07 12:27:15.23 kernel ueshutdown: exiting
00:00000:00000:2000/12/07 12:27:15.45 kernel Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.


--
~= Andrey V. Kolchanov =~


George Saylor Posted on 2000-12-07 12:31:58.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <m37l5ca42b.fsf@orion.int.fct.ru>
Subject: Re: zombi process
Date: Thu, 7 Dec 2000 07:31:58 -0500
Lines: 82
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <3BJRWvEYAHA.202@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust73.tnt3.baltimore.md.da.uu.net 63.16.12.73
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1422
Article PK: 1088891

You may want to call tech support to make certain about whether this is
addressed in the most recent SWR

This may or may not be your problem but 11.9.2.4 has this fix on cover
letter, and it is similar but doesn't mention deadlocks. Your problems are
in tempdb but different circumstances. Perhaps someone from Sybase will
read this and confirm/deny a relationship. The last time i saw "zombies"
was 11.5.1, and that got fixed.



9317 219381 When a query involving temporary tables is being
executed in parallel and the task is being killed by
the user, then under rare circumstances error 6103
may be reported "Unable to do cleanup for the killed
process; received Msg 1289." in the error log. The
stack trace generated will contain a reference to
tmp_alldrop().

Andrey V. Kolchanov <andrey@fct.ru> wrote in message
news:m37l5ca42b.fsf@orion.int.fct.ru...
> Hello.
>
> We have ASE 11.9.2.3 on WinNT server with 4 processors.
> version-
> Adaptive Server Enterprise/11.9.2.3/1156/P/SWR 9160 ESD 2/NT
> (IX86)/OS 3.51,4.0/FBU/Thu Jul 27 05:46:21 2000
>
> And we have locks held by killed and unexisting processes, and we
> have to reboot server.
>
> Is there any solutions for the problem ?
>
> The're sybase errorlog
> 02:00000:00098:2000/12/07 12:23:50.79 server Process id 27 killed by
Hostname , Host process id 17757.
> 00:00000:00027:2000/12/07 12:23:51.12 server Error: 1205, Severity: 13,
State: 1
> 00:00000:00027:2000/12/07 12:23:51.12 server Your server command (family

id #0, process id #27) was deadlocked with another process and has been
chosen as deadlock victim. Re-run your command.
> 00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open
sdes. pspid 27, psuid 200, pcurdb 2, system table entry 0, sdesp
0x22d190c0, objid 1475278150
> 00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open
sdes. pspid 27, psuid 200, pcurdb 2, system table entry 1, sdesp
0x22d190c0, objid 1475278150
> 00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open
sdes. pspid 27, psuid 200, pcurdb 2, system table entry 2, sdesp
0x22e01720, objid 8
> 00:00000:00027:2000/12/07 12:23:51.12 server WARNING: Pss found with open
sdes. pspid 27, psuid 200, pcurdb 2, system table entry 3, sdesp
0x22e00460, objid 2
> 00:00000:00027:2000/12/07 12:23:51.12 server Error: 6103, Severity: 17,
State: 1
> 00:00000:00027:2000/12/07 12:23:51.12 server Unable to do cleanup for the
killed process; received Msg 1205.
> 00:00000:00027:2000/12/07 12:23:51.12 server WARNING: spid 27, with suid
200 and curdbid 2 has active XDES #1 with xactid (317149, 14).
> 03:00000:00098:2000/12/07 12:24:00.93 server Process id 117 killed by
Hostname , Host process id 17760.
> 03:00000:00098:2000/12/07 12:24:11.06 server Process id 113 killed by
Hostname , Host process id 17763.
> 00:00000:00082:2000/12/07 12:25:40.13 kernel Cannot send, host process
disconnected: 162 spid: 82
> 00:00000:00082:2000/12/07 12:25:40.15 server Error: 1608, Severity: 18,
State: 4
> 00:00000:00082:2000/12/07 12:25:40.15 server A client process exited
abnormally, or a network error was encountered. Unless other errors
occurred, continue processing normally.
> 00:00000:00000:2000/12/07 12:27:15.23 kernel kisignal: SQL Server
terminated by system shutdown.
> 00:00000:00000:2000/12/07 12:27:15.23 kernel ueshutdown: exiting
> 00:00000:00000:2000/12/07 12:27:15.45 kernel Abnormal exit detected - SQL
Server process level execution bindings will be cleared on startup.
>
>
> --
> ~= Andrey V. Kolchanov =~