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.

virtual socket

6 posts in Windows NT Last posting was on 2001-03-28 15:58:43.0Z
Andrew Samykin Posted on 2001-03-26 10:51:22.0Z
Reply-To: "Andrew Samykin" <andy@office.east.ru>
From: "Andrew Samykin" <andy@office.east.ru>
Subject: virtual socket
Date: Mon, 26 Mar 2001 14:51:22 +0400
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <o5FFoUetAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: andy.east.ru 195.170.33.37
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1039
Article PK: 1087646

Hello!

The second problem is :
2000/03/26 00:07:46.29 server Failed to open virtual socket for new
connections

this string is from errorlog

It occures very often :(
Whats up?
What should I do?


Server:
Sybase Adaptive Server Enterprise/11.9.2.4/1170/P/SWR 9453 ESD 2/NT
(IX86)/OS 3.51,4.0/FBU/Tue Jan 16 03:52:44 2001

Platform: Win2k 5.00.2195 SP 1


Jim Egan Posted on 2001-03-26 21:15:11.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: virtual socket
Date: Mon, 26 Mar 2001 14:15:11 -0700
Message-ID: <MPG.15295f4b50b2c11b98b1fa@forums.sybase.com>
References: <o5FFoUetAHA.198@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 84
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:1036
Article PK: 1087643

Error 1605 indicates:
====================

Failed to open virtual socket for new connections

Explanation:

Error 1605 occurs when a failure occurs in the process of opening the new socket. There are
a number of things that can cause this:

1) Exceeding the number of configured user connections
2) Exceeding the number of configured sockets
3) Network configuration problems such as using the same IP address for two different
clients

Error 1605 error can be raised at the following times:
=========================================

1) At startup time, when the network is initialized.
2) At creation of a process, when a new connection request comes in and Adaptive Server is
unable to handle it.
3) At the forced termination of a process, when a new connection request comes in and
Adaptive Server is unable to handle it.

Solution
=========
These are the possible ways to rectify the problem
==================================================
1) Increase user or network connections and possibly increase the maximum number of file
descriptors per process

a.Determine the current value for cnsocket.
Use dbcc resource (this command requires sybase_ts_role and dbcc tracecon(3604) to
determine the current configuration for sockets.

b.Determine the current value for the maximum number of network connections:
1> select @@max_connections
2> go

If the value of cnsocket is greater than the value of @@max_connections, a problem may
occur. Step 5 provides details.

c.Determine the current value for number of devices (the number of database devices that
Adaptive Server can use,
excluding dump devices):
1> sp_configure "number of devices"
2> go

d.Determine an appropriate value for @@max_connections, based on the number of users
expected to be logged on at any given time, and the number of devices. Remember that each
device takes up a user connection. @@max_connections is the kernel resource value rmaxuconn
and is calculated using the following information:

number of Server listener ports configured (in your interfaces file, additional Server
listener ports are listed as clones of the "master" line for the Adaptive Server, one
additional line for each interface you want Adaptive Server to listen on).

maximum value for user connections. It is calculated by: @@max_connections = kimaxfd -
ksnmstprts - 4 (5 on OpenVMS). The pool of four is reserved for:
stdout error log console dump/load device (debug on OpenVMS)

e.Compare the appropriate value for sockets to the current value for sockets, as determined
in step 1. (Remember that the maximum number of virtual sockets = number of userß
connections + number of remoteß sites + 3.) If the current value is too low, use
sp_configure to increase the value of number of user connections and/or number of remote
sites so that the calculated value for sockets will be correct. This will probably correct
the error. If the error still occurs, call Sybase Technical Support.


2) This error indicates CR214706 is fixed in 11.5.1.2 ESD1 and 11.5.1.2 ESD#2 for the ebf's
9227 and 9233.

You may want to apply the latest EBF.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

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


Andrew Samykin Posted on 2001-03-27 09:22:39.0Z
Reply-To: "Andrew Samykin" <andy@office.east.ru>
From: "Andrew Samykin" <andy@office.east.ru>
References: <o5FFoUetAHA.198@forums.sybase.com> <MPG.15295f4b50b2c11b98b1fa@forums.sybase.com>
Subject: Re: virtual socket
Date: Tue, 27 Mar 2001 13:22:39 +0400
Lines: 146
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <Ro$IoHqtAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: andy.east.ru 195.170.33.37
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1030
Article PK: 1087637

Hello , Jim!
Thanks for your help, but the first thing I did was to read the manual...
Ok, lets repeat it again step by step :

"Jim Egan" <dbaguru@eganomics.com> wrote in message
news:MPG.15295f4b50b2c11b98b1fa@forums.sybase.com...
> Error 1605 indicates:
> ====================
>
> Failed to open virtual socket for new connections
>
> Explanation:
>
> Error 1605 occurs when a failure occurs in the process of opening the new
socket. There are
> a number of things that can cause this:
>
> 1) Exceeding the number of configured user connections
> 2) Exceeding the number of configured sockets
> 3) Network configuration problems such as using the same IP address for
two different
> clients
>
> Error 1605 error can be raised at the following times:
> =========================================
>
> 1) At startup time, when the network is initialized.
> 2) At creation of a process, when a new connection request comes in and
Adaptive Server is
> unable to handle it.
> 3) At the forced termination of a process, when a new connection request
comes in and
> Adaptive Server is unable to handle it.
>
> Solution
> =========
> These are the possible ways to rectify the problem
> ==================================================
> 1) Increase user or network connections and possibly increase the maximum
number of file
> descriptors per process
>
> a.Determine the current value for cnsocket.

cnsocket=117

> Use dbcc resource (this command requires sybase_ts_role and dbcc
tracecon(3604) to
> determine the current configuration for sockets.
>
> b.Determine the current value for the maximum number of network
connections:
> 1> select @@max_connections
> 2> go

@@max_connections = 99992


>
> If the value of cnsocket is greater than the value of @@max_connections, a
problem may
> occur. Step 5 provides details.

117 ! > 99992 , hence, there's no error

>
> c.Determine the current value for number of devices (the number of
database devices that
> Adaptive Server can use,
> excluding dump devices):
> 1> sp_configure "number of devices"
> 2> go

number of devices = 50

>
> d.Determine an appropriate value for @@max_connections, based on the
number of users
> expected to be logged on at any given time, and the number of devices.
Remember that each
> device takes up a user connection. @@max_connections is the kernel
resource value rmaxuconn
> and is calculated using the following information:
>
> number of Server listener ports configured (in your interfaces file,
additional Server
> listener ports are listed as clones of the "master" line for the Adaptive
Server, one
> additional line for each interface you want Adaptive Server to listen on).
>
> maximum value for user connections. It is calculated by: @@max_connections
= kimaxfd -
> ksnmstprts - 4 (5 on OpenVMS). The pool of four is reserved for:
> stdout error log console dump/load device (debug on OpenVMS)

@@max_connections = 100000 - 4 - 4 = 99992

>
> e.Compare the appropriate value for sockets to the current value for
sockets, as determined
99992 = 99992 - that's ok

> in step 1. (Remember that the maximum number of virtual sockets = number
of userß
> connections + number of remoteß sites + 3.) If the current value is too
low, use

maximum number of virtual sockets = 100 + 10 + 3 = 113

> sp_configure to increase the value of number of user connections and/or
number of remote
> sites so that the calculated value for sockets will be correct. This will
probably correct
> the error. If the error still occurs, call Sybase Technical Support.

problem still occurs

>
>
> 2) This error indicates CR214706 is fixed in 11.5.1.2 ESD1 and 11.5.1.2
ESD#2 for the ebf's
> 9227 and 9233.

Jim, I repeat - I have SAE 11.9.2.4 + SWR 9453 !! Not 11.5.X !!
And I've rolled up the lastest EBF found on www.sybase.com - EBF 9453

@@version = Adaptive Server Enterprise/11.9.2.4/1170/P/SWR 9453 ESD 2/NT
(IX86)/OS 3.51,4.0/FBU/Tue Jan 16 03:52:44 2001

platform : Windows 2000 ver. 5.00.2195 SP1


>
> You may want to apply the latest EBF.

Any ideas ?


> --
> 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-27 16:36:37.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: virtual socket
Date: Tue, 27 Mar 2001 09:36:37 -0700
Message-ID: <MPG.152a6f7bcaaab72d98b202@forums.sybase.com>
References: <o5FFoUetAHA.198@forums.sybase.com> <MPG.15295f4b50b2c11b98b1fa@forums.sybase.com> <Ro$IoHqtAHA.53@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
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:1027
Article PK: 1087634

Are you only seeing this error message at the time the server starts up?

Are you also seeing this message?
kistartup: number of virtual sockets set to ###

The message is printed to the log where ### is the value of kimaxfd/cnsocket.

Do you have the parameter 'tcp no delay' set to 0 or 1?
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

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


Andrew Samykin Posted on 2001-03-28 08:39:38.0Z
Reply-To: "Andrew Samykin" <andy@office.east.ru>
From: "Andrew Samykin" <andy@office.east.ru>
References: <o5FFoUetAHA.198@forums.sybase.com> <MPG.15295f4b50b2c11b98b1fa@forums.sybase.com> <Ro$IoHqtAHA.53@forums.sybase.com> <MPG.152a6f7bcaaab72d98b202@forums.sybase.com>
Subject: Re: virtual socket
Date: Wed, 28 Mar 2001 12:39:38 +0400
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <rGFWNU2tAHA.276@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: andy.east.ru 195.170.33.37
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1020
Article PK: 1087627


"Jim Egan" <dbaguru@eganomics.com> wrote in message
news:MPG.152a6f7bcaaab72d98b202@forums.sybase.com...
> Are you only seeing this error message at the time the server starts up?

It happens very often during a day - 44 times on 27 of March and previous
days have the same error frequence

>
> Are you also seeing this message?
> kistartup: number of virtual sockets set to ###
> The message is printed to the log where ### is the value of
kimaxfd/cnsocket.
You mean error log message "Using ## file descriptors" ?
Here's small quoting from the file:
"2001/03/26 22:42:13.87 kernel Using 100000 file descriptors."

>
> Do you have the parameter 'tcp no delay' set to 0 or 1?
Here's small quoting from the file:
"2001/03/26 22:42:14.56 kernel SQL Server booted with TCP_NODELAY enabled."
I've changed this parametr from 0 to 1 two days ago and nothing happened -
there are a lot of error messages in errorlog.
By the way, doing that I want to solve another problem - "invalid tdslength"
... but both problems still exist.


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


Jim Egan Posted on 2001-03-28 15:58:43.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: virtual socket
Date: Wed, 28 Mar 2001 08:58:43 -0700
Message-ID: <MPG.152bb81d67fb0d8d98b214@forums.sybase.com>
References: <o5FFoUetAHA.198@forums.sybase.com> <MPG.15295f4b50b2c11b98b1fa@forums.sybase.com> <Ro$IoHqtAHA.53@forums.sybase.com> <MPG.152a6f7bcaaab72d98b202@forums.sybase.com> <rGFWNU2tAHA.276@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
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:1017
Article PK: 1087624

I would be willing to bet my paycheck (All $10 of it) that if you resolve the invalid
tdslength problem the other error may go away also. The invalid tdslength is usually a
network problem. You may need to get your network guys involved. A network sniffer would
be very handy in this situation.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

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