cannot accept connection to the port
Hi All,
We are using Informix Dynamic Server 7.31UD6 on HP-UX 11.0.
We get these error messages in our log quite often and all the new connections
comes to standstill.
14:51:47 listener-thread: err = -25573: oserr = 233: errstr = : Network driver
cannot accept a connection on the port.
System error = 233.
I mean if I issue dbaccess at that time it just takes too long to bring the
screen.
I really want to get into the root cause of this as this has been a long
outstanding issue in our environment and I don't have good idea about what
factors contribute to this.
What to look for when we face situation like this and what tuning can be done
at the os level or database level to avoid this to reocur.
Here are the entries from our onconfig file
NETTYPE soctcp,3,500,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,1,64,CPU # Configure poll thread(s) for nettype
Here is the tail of the onstat -u command
228 active, 256 total, 247 maximum concurrent ( it goes up to 350 concurrent
at times)
Here is the some kerner parameters set on the box
maxfiles 120
maxfiles_lim 1024
nfile 15341
maxdsiz 32768
maxssiz 2048
maxtsiz 16384
Also here is the typical output of sar -v on the system
00:00:00 text-sz ov proc-sz ov inod-sz ov file-sz ov
01:00:00 N/A N/A 365/8212 0 3122/9540 0 2864/15341 0
02:00:00 N/A N/A 358/8212 0 9540/9540 0 3052/15341 0
03:00:00 N/A N/A 360/8212 0 4216/9540 0 3140/15341 0
04:00:00 N/A N/A 367/8212 0 9540/9540 0 3295/15341 0
05:00:00 N/A N/A 362/8212 0 6724/9540 0 3421/15341 0
06:00:00 N/A N/A 345/8212 0 3106/9540 0 3726/15341 0
07:00:00 N/A N/A 346/8212 0 3109/9540 0 3785/15341 0
08:00:00 N/A N/A 343/8212 0 3079/9540 0 3873/15341 0
08:20:00 N/A N/A 329/8212 0 3751/9540 0 3886/15341 0
08:40:00 N/A N/A 338/8212 0 3074/9540 0 3892/15341 0
09:00:00 N/A N/A 348/8212 0 3047/9540 0 3951/15341 0
09:20:00 N/A N/A 355/8212 0 3121/9540 0 3982/15341 0
I would appreciate if someone can guide me through this problem.
The other interesting facts are that the other informix database server on the
same box and on a different port works ok at that time.
Thanks,
Vineet
what are the definitions in sqlhosts file
----- Original Message -----
From: "VINEET MEHROTRA" <vineetmehrotra@hotmail.com>
To: <ids@iiug.org>
Sent: Friday, April 30, 2004 4:01 PM
Subject: cannot accept connection to the port [2917]
> Hi All,
>
> We are using Informix Dynamic Server 7.31UD6 on HP-UX 11.0.
>
> We get these error messages in our log quite often and all the new
connections comes to standstill.
>
>
>
> 14:51:47 listener-thread: err = -25573: oserr = 233: errstr = : Network
driver
> cannot accept a connection on the port.
> System error = 233.
>
> I mean if I issue dbaccess at that time it just takes too long to bring
the screen.
>
> I really want to get into the root cause of this as this has been a long
outstanding issue in our environment and I don't have good idea about what
factors contribute to this.
>
> What to look for when we face situation like this and what tuning can be
done at the os level or database level to avoid this to reocur.
>
> Here are the entries from our onconfig file
>
> NETTYPE soctcp,3,500,NET # Configure poll thread(s) for nettype
> NETTYPE ipcshm,1,64,CPU # Configure poll thread(s) for nettype>
> Here is the tail of the onstat -u command
>
> 228 active, 256 total, 247 maximum concurrent ( it goes up to 350
concurrent at times)
>
> Here is the some kerner parameters set on the box
>
> maxfiles 120
> maxfiles_lim 1024
> nfile 15341
>
> maxdsiz 32768
> maxssiz 2048
> maxtsiz 16384
>
> Also here is the typical output of sar -v on the system
>
>
> 00:00:00 text-sz ov proc-sz ov inod-sz ov file-sz ov
> 01:00:00 N/A N/A 365/8212 0 3122/9540 0 2864/15341 0
> 02:00:00 N/A N/A 358/8212 0 9540/9540 0 3052/15341 0
> 03:00:00 N/A N/A 360/8212 0 4216/9540 0 3140/15341 0
> 04:00:00 N/A N/A 367/8212 0 9540/9540 0 3295/15341 0
> 05:00:00 N/A N/A 362/8212 0 6724/9540 0 3421/15341 0
> 06:00:00 N/A N/A 345/8212 0 3106/9540 0 3726/15341 0
> 07:00:00 N/A N/A 346/8212 0 3109/9540 0 3785/15341 0
> 08:00:00 N/A N/A 343/8212 0 3079/9540 0 3873/15341 0
> 08:20:00 N/A N/A 329/8212 0 3751/9540 0 3886/15341 0
> 08:40:00 N/A N/A 338/8212 0 3074/9540 0 3892/15341 0
> 09:00:00 N/A N/A 348/8212 0 3047/9540 0 3951/15341 0
> 09:20:00 N/A N/A 355/8212 0 3121/9540 0 3982/15341 0
>
>
> I would appreciate if someone can guide me through this problem.
>
> The other interesting facts are that the other informix database server on
the same box and on a different port works ok at that time.
>
> Thanks,
>
> Vineet
>
<html><div
style='background-color:'><P><FONT face="Times New Roman">The error -25573
indicates that the server is not able to accept any connection on the server
port accompanied by system error 233 on HP 11.0 which indicates ENOBUFS.
ENOBUFS is returned when the OS kernel is running out of buffers. Something to
do with system setting.</P>
<DIV>
<DIV>
<DIV class=RTE>
<P>The reason dbaccess takes so long to come out because it tries to establish
connection with the server for some time after which it times out.</P>
<P>It is really strange that the other servers are running without any
problems at the same time.</P>
<P>Regards,</P>
<P>Ravi</P>
<P></FONT><BR> </P>
<P> </P>
<P>> </P></DIV>
<DIV></DIV>>  
; "VINEET
MEHROTRA"
<DIV></DIV>>  
;
<vineetmehrotra@h To: &nb
sp; ids@iiug.org
<DIV></DIV>>  
;
otmail.com>
cc:
<DIV></DIV>>  
; Sent
by:  
; Subject: cannot accept connection to the
port [2917]
<DIV></DIV>>  
;
forum.subscriber@
<DIV></DIV>>  
; iiug.org
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>  
; 04/30/2004
04:01
<DIV></DIV>>  
; PM
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Hi All,
<DIV></DIV>>
<DIV></DIV>>We are using Informix Dynamic Server 7.31UD6 on HP-UX 11.0.
<DIV></DIV>>
<DIV></DIV>>We get these error messages in our log quite often and all the
new
<DIV></DIV>>connections comes to standstill.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>14:51:47 listener-thread: err = -25573: oserr = 233:
errstr = : Network
<DIV></DIV>>driver
<DIV></DIV>>cannot accept a connection on the port.
<DIV></DIV>> System error = 233.
<DIV></DIV>>
<DIV></DIV>>I mean if I issue dbaccess at that time it just takes too long
to bring the
<DIV></DIV>>screen.
<DIV></DIV>>
<DIV></DIV>>I really want to get into the root cause of this as this has
been a long
<DIV></DIV>>outstanding issue in our environment and I don't have good idea
about what
<DIV></DIV>>factors contribute to this.
<DIV></DIV>>
<DIV></DIV>>What to look for when we face situation like this and what
tuning can be
<DIV></DIV>>done at the os level or database level to avoid this to reocur.
<DIV></DIV>>
<DIV></DIV>>Here are the entries from our onconfig file
<DIV></DIV>>
<DIV></DIV>>NETTYPE
soctcp,3,500,NET # Configure poll thread(s) for nettype
<DIV></DIV>>NETTYPE
ipcshm,1,64,CPU # Configure poll thread(s) for nettype
<DIV></DIV>>
<DIV></DIV>>Here is the tail of the onstat -u command
<DIV></DIV>>
<DIV></DIV>> 228 active, 256 total, 247 maximum concurrent ( it
goes up to 350
<DIV></DIV>>concurrent at times)
<DIV></DIV>>
<DIV></DIV>>Here is the some kerner parameters set on the box
<DIV></DIV>>
<DIV></DIV>>maxfiles &nb
sp;  
; 120
<DIV></DIV>>maxfiles_lim  
; 1024
<DIV></DIV>>nfile
&n
bsp; &nbs
p; 15341
<DIV></DIV>>
<DIV></DIV>>maxdsiz &nbs
p;
32768
<DIV></DIV>>maxssiz &nbs
p;
2048
<DIV></DIV>>maxtsiz &nbs
p;
16384
<DIV></DIV>>
<DIV></DIV>>Also here is the typical output of sar -v on the system
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>00:00:00
text-sz ov proc-sz ov inod-sz &
nbsp;ov file-sz ov
<DIV></DIV>>01:00:00 N/A N/A
365/8212 0 3122/9540 0 2864/15341 0
<DIV></DIV>>02:00:00 N/A N/A
358/8212 0 9540/9540 0 3052/15341 0
<DIV></DIV>>03:00:00 N/A N/A
360/8212 0 4216/9540 0 3140/15341 0
<DIV></DIV>>04:00:00 N/A N/A
367/8212 0 9540/9540 0 3295/15341 0
<DIV></DIV>>05:00:00 N/A N/A
362/8212 0 6724/9540 0 3421/15341 0
<DIV></DIV>>06:00:00 N/A N/A
345/8212 0 3106/9540 0 3726/15341 0
<DIV></DIV>>07:00:00 N/A N/A
346/8212 0 3109/9540 0 3785/15341 0
<DIV></DIV>>08:00:00 N/A N/A
343/8212 0 3079/9540 0 3873/15341 0
<DIV></DIV>>08:20:00 N/A N/A
329/8212 0 3751/9540 0 3886/15341 0
<DIV></DIV>>08:40:00 N/A N/A
338/8212 0 3074/9540 0 3892/15341 0
<DIV></DIV>>09:00:00 N/A N/A
348/8212 0 3047/9540 0 3951/15341 0
Hi,
checking for the errno 233 on an HP-UX 11.0 machine in
/usr/include/sys/errno.h reveals :
# define ENOBUFS 233 /* No buffer space available */
I'm not exactly sure, what kind of buffer is unavailable. But it looks
like this is an operating system shortage.
I don't think one of the "file" kernel parameters is directly responsible
for the problem. It's probably a parameter that is related to some
buffer allocation (which are needed for TCP connections) ...
Unfortunately I don't know more about this,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions
"Jorge Garcia" <jgarcia@seyc.gob.mx>
Sent by: forum.subscriber@iiug.org
01.05.2004 02:01
To
ids@iiug.org
cc
Subject
Re: cannot accept connection to the port [2919]
what are the definitions in sqlhosts file
----- Original Message -----
From: "VINEET MEHROTRA" <vineetmehrotra@hotmail.com>
To: <ids@iiug.org>
Sent: Friday, April 30, 2004 4:01 PM
Subject: cannot accept connection to the port [2917]
> Hi All,
>
> We are using Informix Dynamic Server 7.31UD6 on HP-UX 11.0.
>
> We get these error messages in our log quite often and all the new
connections comes to standstill.
>
>
>
> 14:51:47 listener-thread: err = -25573: oserr = 233: errstr = : Network
driver
> cannot accept a connection on the port.
> System error = 233.
>
> I mean if I issue dbaccess at that time it just takes too long to bring
the screen.
>
> I really want to get into the root cause of this as this has been a long
outstanding issue in our environment and I don't have good idea about what
factors contribute to this.
>
> What to look for when we face situation like this and what tuning can be
done at the os level or database level to avoid this to reocur.
>
> Here are the entries from our onconfig file
>
> NETTYPE soctcp,3,500,NET # Configure poll thread(s) for nettype
> NETTYPE ipcshm,1,64,CPU # Configure poll thread(s) for nettype>
> Here is the tail of the onstat -u command
>
> 228 active, 256 total, 247 maximum concurrent ( it goes up to 350
concurrent at times)
>
> Here is the some kerner parameters set on the box
>
> maxfiles 120
> maxfiles_lim 1024
> nfile 15341
>
> maxdsiz 32768
> maxssiz 2048
> maxtsiz 16384
>
> Also here is the typical output of sar -v on the system
>
>
> 00:00:00 text-sz ov proc-sz ov inod-sz ov file-sz ov
> 01:00:00 N/A N/A 365/8212 0 3122/9540 0 2864/15341 0
> 02:00:00 N/A N/A 358/8212 0 9540/9540 0 3052/15341 0
> 03:00:00 N/A N/A 360/8212 0 4216/9540 0 3140/15341 0
> 04:00:00 N/A N/A 367/8212 0 9540/9540 0 3295/15341 0
> 05:00:00 N/A N/A 362/8212 0 6724/9540 0 3421/15341 0
> 06:00:00 N/A N/A 345/8212 0 3106/9540 0 3726/15341 0
> 07:00:00 N/A N/A 346/8212 0 3109/9540 0 3785/15341 0
> 08:00:00 N/A N/A 343/8212 0 3079/9540 0 3873/15341 0
> 08:20:00 N/A N/A 329/8212 0 3751/9540 0 3886/15341 0
> 08:40:00 N/A N/A 338/8212 0 3074/9540 0 3892/15341 0
> 09:00:00 N/A N/A 348/8212 0 3047/9540 0 3951/15341 0
> 09:20:00 N/A N/A 355/8212 0 3121/9540 0 3982/15341 0
>
>
> I would appreciate if someone can guide me through this problem.
>
> The other interesting facts are that the other informix database server
on
the same box and on a different port works ok at that time.
>
> Thanks,
>
> Vineet
>