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.

Odd Messages In Error Log

4 posts in Windows NT Last posting was on 2001-03-22 04:41:22.0Z
Mark Maslow Posted on 2001-03-20 18:16:22.0Z
From: "Mark Maslow" <mark.maslow@sierraclub.org>
Subject: Odd Messages In Error Log
Date: Tue, 20 Mar 2001 10:16:22 -0800
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <v$bh9xWsAHA.302@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: machine001.sierraclub.org 207.90.163.1
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1063
Article PK: 1087665

We are using ASE 11.0.3.3. The error log is filling with the following
message over and over:

00:2001/03/20 09:12:14.18 kernel nast_readpost: Invalid tdslength (17256),
socket 17, listener 0

Can anyone give us a clue as to what this means, and what might be causing
it?

As far as we can tell, things are still working OK, but we really wonder
what this is about. Just started showing up about the time we installed a
new web app using Jaguar (connecting using connection cache).

TIA for any insights into this.

Mark Maslow


Jim Egan Posted on 2001-03-20 23:10:43.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Odd Messages In Error Log
Date: Tue, 20 Mar 2001 16:10:43 -0700
Message-ID: <MPG.1521915dd678a5d798b1d8@forums.sybase.com>
References: <v$bh9xWsAHA.302@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 41
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.28
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1062
Article PK: 1087664

Check the client and the server to see what the packet size is set for, but that is
unlikely to be the problem. I've also seen this when there was a problem with trusts
between NT domains. Odd, I know, and I don't know why it caused it other than one of the
reasons provided below.

Relative to TDS packet length
Description: The SQL Server does not validate the size of incoming
TDS network packets. Bad incoming data may cause waiting processes to hang as
the server waits for a very large amount of data on a network socket.

Excerpt from another case: The problem has been seen as a result of incomplete
TDS packets sent by openserver in RPC responses. (See bugids 54066 and 68087).

Bugid 54066:
Description: It is possible for open server to send only part of a TDS packet to
sql server when sending the results of a RPC. This can cause the sql server
network thread to hang because packet boundaries are lost because of this
partial packet.

Bugid 68087:
Description: Under heavy network stress (multiple clients/rpc s/result sets) on
a sitehandler, the TDS stream can become corrupted with a partial TDS packet
going to the SqlSvr, causing failure in demultiplex process for sitehandler.
Connections hang.

It is also possible that this is network I/o problems.

I recommend that you upgrade to 11.0.3.3 Latest EBF8299. You may also want to consider
moving up to 12.0 which is the current release.

--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Mark Maslow Posted on 2001-03-20 23:47:11.0Z
From: "Mark Maslow" <mark.maslow@sierraclub.org>
References: <v$bh9xWsAHA.302@forums.sybase.com> <MPG.1521915dd678a5d798b1d8@forums.sybase.com>
Subject: Re: Odd Messages In Error Log
Date: Tue, 20 Mar 2001 15:47:11 -0800
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <R3Ls0qZsAHA.258@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: machine001.sierraclub.org 207.90.163.1
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1061
Article PK: 1087663

Thanks for the reply - and sorry to bother you. Turns out one of the
operations people tried to set up some kind of monitoring software that was
sending packets to the DB server that it didn't know what to do with. Then
they come to me freaking out about the resulting messages. Turned off the
monitoring and all is now well.

"Jim Egan" <dbaguru@eganomics.com> wrote in message
news:MPG.1521915dd678a5d798b1d8@forums.sybase.com...
> Check the client and the server to see what the packet size is set for,
but that is
> unlikely to be the problem. I've also seen this when there was a problem
with trusts
> between NT domains. Odd, I know, and I don't know why it caused it other
than one of the
> reasons provided below.
>
> Relative to TDS packet length
> Description: The SQL Server does not validate the size of incoming
> TDS network packets. Bad incoming data may cause waiting processes to hang
as
> the server waits for a very large amount of data on a network socket.
>
> Excerpt from another case: The problem has been seen as a result of
incomplete
> TDS packets sent by openserver in RPC responses. (See bugids 54066 and
68087).
>
> Bugid 54066:
> Description: It is possible for open server to send only part of a TDS
packet to
> sql server when sending the results of a RPC. This can cause the sql
server
> network thread to hang because packet boundaries are lost because of this
> partial packet.
>
> Bugid 68087:
> Description: Under heavy network stress (multiple clients/rpc s/result
sets) on
> a sitehandler, the TDS stream can become corrupted with a partial TDS
packet
> going to the SqlSvr, causing failure in demultiplex process for
sitehandler.
> Connections hang.
>
> It is also possible that this is network I/o problems.
>
> I recommend that you upgrade to 11.0.3.3 Latest EBF8299. You may also
want to consider
> moving up to 12.0 which is the current release.
>
> --
> Jim Egan [TeamSybase]
> Senior Consultant
> Sybase Professional Services
>
> Get your free subscription to PowerTimes at http://www.powertimes.com


Jim Egan Posted on 2001-03-22 04:41:22.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Odd Messages In Error Log
Date: Wed, 21 Mar 2001 21:41:22 -0700
Message-ID: <MPG.15229f24cb69741998b1d9@forums.sybase.com>
References: <v$bh9xWsAHA.302@forums.sybase.com> <MPG.1521915dd678a5d798b1d8@forums.sybase.com> <R3Ls0qZsAHA.258@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 6
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1051
Article PK: 1087657

Want to borrow my 2x4 to smack them between the eyes with? <g>
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com