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.

everyone's computer hung at once...

3 posts in Networking Last posting was on 2007-03-09 16:12:02.0Z
Corinna Posted on 2007-02-27 14:06:04.0Z
Date: Tue, 27 Feb 2007 08:06:04 -0600
From: Corinna <corinna@vestanotes.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: everyone's computer hung at once...
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 64.6.39.170
Message-ID: <45e439c3@solutions.advantagedatabase.com>
X-Trace: 27 Feb 2007 07:01:39 -0700, 64.6.39.170
Lines: 31
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.6.39.170
Xref: solutions.advantagedatabase.com Advantage.Networking:689
Article PK: 1132108

I received a call yesterday from one of our customers. They are running
Netware on their server, and ADS 8.1 for Netware. They have 10 or 25
users (I'm not sure).

One person was running payroll with our software, which is
data-intensive, of course, but has never caused any problems before.
During this time, she said that everyone's computer screen went blank,
and at least one person received an error message from MS Error
Reporting service. (It's unclear to me if other messages were shown, or
if the screens eventually repainted.) She sent me a fax of the error
report, which included this: szModName: hungapp szModVer: 0.0.0.0
offset: 00000000

She did not report a socket error or anything that would indicate that
the database or network connections were broken, and I'm not sure that
the Error Report would say "hungapp" if it were a socket failure.

She rebooted everything -- the server and all workstations, and the
machines resumed normally.

Since ADS is designed to handle lots of traffic, I have a hard time
believing that payroll (which is just SQL statements, not stored
procedures or triggers or anything fancy) would max out the server and
cause communications to cease.

I'm wondering if anyone here has seen this kind of thing before, or if
there are any ideas as to the cause, or even ideas as to how I might go
about investigating it. I'd like to have a clue before I call them to
look for logs, ask further questions, etc. I'm pretty baffled. :)

-Corinna


Corinna Posted on 2007-03-09 15:49:02.0Z
Date: Fri, 09 Mar 2007 09:49:02 -0600
From: Corinna <corinna@vestanotes.com>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
Newsgroups: Advantage.Networking
Subject: Re: everyone's computer hung at once... - FOLLOWUP
References: <45e439c3@solutions.advantagedatabase.com>
In-Reply-To: <45e439c3@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 64.6.39.170
Message-ID: <45f18069@solutions.advantagedatabase.com>
X-Trace: 9 Mar 2007 08:42:33 -0700, 64.6.39.170
Lines: 25
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.6.39.170
Xref: solutions.advantagedatabase.com Advantage.Networking:695
Article PK: 1132113

Followup and more info:

Corinna wrote:
> One person was running payroll with our software, which is
> data-intensive, of course, but has never caused any problems before.
> During this time, she said that everyone's computer screen went blank,
> and at least one person received an error message from MS Error
> Reporting service.

I had this happen at another site, so I did a bit more digging. I looked
at the ADS server configuration at the second site and noticed that they
didn't use my recommendations for connections and work areas, etc. So
I increased the values and restarted the server.

I don't know if they've run payroll since then, but at least we haven't
received another call. I think payroll is the most intensive process our
software does, and it's possible that it's not releasing resources
correctly (like closing tables, etc). I've been gradually optimizing it
for ADS as I've had time.

So I'm wondering if it's expected behavior for ADS to lose connections
if the configured parameters are exceeded by a process?

-Corinna


Mark Wilkins Posted on 2007-03-09 16:12:02.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Networking
References: <45e439c3@solutions.advantagedatabase.com> <45f18069@solutions.advantagedatabase.com>
Subject: Re: everyone's computer hung at once... - FOLLOWUP
Date: Fri, 9 Mar 2007 09:12:02 -0700
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45f18645@solutions.advantagedatabase.com>
X-Trace: 9 Mar 2007 09:07:33 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Networking:696
Article PK: 1132115

Hi Corinna,

I really don't have any ideas as to why this occurred. Advantage would not
"freeze" if the number of configured workareas or tables was exceeded. It
would return an error in that situation. What happens next depends on the
application and how it handles the error. If you send us the error log
(assuming it still has entries from when the problem occurred), we might be
able to learn something from it. If there really is a problem with too few
configured resources, is it possible for you to re-create the problem in a
test environment by setting the number of workareas and/or tables to a very
small number?

Mark Wilkins
Advantage R&D

"Corinna" <corinna@vestanotes.com> wrote in message
news:45f18069@solutions.advantagedatabase.com...
> Followup and more info:
>
> Corinna wrote:
>> One person was running payroll with our software, which is
>> data-intensive, of course, but has never caused any problems before.
>> During this time, she said that everyone's computer screen went blank,
>> and at least one person received an error message from MS Error Reporting
>> service.
>
> I had this happen at another site, so I did a bit more digging. I looked
> at the ADS server configuration at the second site and noticed that they
> didn't use my recommendations for connections and work areas, etc. So I
> increased the values and restarted the server.
>
> I don't know if they've run payroll since then, but at least we haven't
> received another call. I think payroll is the most intensive process our
> software does, and it's possible that it's not releasing resources
> correctly (like closing tables, etc). I've been gradually optimizing it
> for ADS as I've had time.
>
> So I'm wondering if it's expected behavior for ADS to lose connections if
> the configured parameters are exceeded by a process?
>
> -Corinna
>