Article View: comp.os.ms-windows.nt.admin.misc
Article #56Sybase 11 NT server becoming unresponsive
From: Dave Mullen
Date: Wed, 22 Oct 1997 00:00
Date: Wed, 22 Oct 1997 00:00
37 lines
2972 bytes
2972 bytes
We are new to Sybase (developing our first application in Delphi 2.0
for Win95 clients), and have experienced the following problem:
When testing one of the functions in our new app, the client app would
suddenly seem to hang. Windows 95 would list the client app as "Not
responding". Eventually (within a few hours), *all* Sybase clients,
including WISQL, isql, etc. would all hang this way when trying to
connect to the Sybase server. Investigation showed that SQL Server
(and NT) was actually idle, apparently (see below) because the server
wasn't hearing the connect requests. So the server wasn't actually
hung or locked up, it was just unresponsive. Shutting down and
restarting SQL Server would resolve the problem.
This has been happening with version 11.0.2 on NT 4.0 (service pack
1). Sybase tech support says it's a bug in the netlib layer, and had
me apply SRW 7305, so that we're now at version 11.0.3. So far we've
been running for about a week without a recurrence. The problem is, my
developers and management are unsettled by the fact that Sybase have
been unable to tell us how we can be sure the problem is fixed, as in
"How can I see if the problem is occurring?" "You can't." "How can I
tell if the problem is fixed?" "The server keeps running."
So my question is, has anyone else had experience with this problem?
Can you tell me more about the problem? What was your solution? Are
you convinced it's fixed?
TIA!
--------------------------------------------------------------------------
David Mullen *** Any opinions expressed are mine, and not ***
Emjay Corporation *** necessarily those of Emjay Corporation. ***
Milwaukee, WI
dave.mullen@emjay.com ==> Kyrie eleison <==
Fight spam by joining CAUCE - Coalition Against Unsolicited Commercial Email
http://www.cauce.org/
Technical Details
Message-ID:
<34517c22.83384644@news.execpc.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fb9cd,ae090a6c7deae3e7,start X-Google-Attributes: gidfb9cd,public X-Google-Thread: 11152d,ae090a6c7deae3e7,start X-Google-Attributes: gid11152d,public X-Google-Thread: f799a,ae090a6c7deae3e7,start X-Google-Attributes: gidf799a,public X-Google-Thread: f782f,ae090a6c7deae3e7,start X-Google-Attributes: gidf782f,public X-Google-Thread: 115e93,ae090a6c7deae3e7,start X-Google-Attributes: gid115e93,public X-Google-Thread: 105df1,ae090a6c7deae3e7,start X-Google-Attributes: gid105df1,public X-Google-Thread: 115b46,ae090a6c7deae3e7,start X-Google-Attributes: gid115b46,public From: dave.mullen@emjay.com (Dave Mullen) Subject: Sybase 11 NT server becoming unresponsive Date: 1997/10/22 Message-ID: <34517c22.83384644@news.execpc.com> X-Deja-AN: 282506602 Organization: Emjay Corporation Newsgroups: comp.os.ms-windows.nt.admin.misc,comp.os.ms-windows.nt.misc,comp.os.ms-windows.programmer.misc,comp.os.ms-windows.nt.software.services,cz.comp.windows.nt,de.comp.os.ms-windows.nt,relcom.comp.os.windows.nt