Network / TCP problem (?) - sorry for Mime, can't send as text

Posted in 2004

Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration

Dirk Moolman — Fri, 23 Jan 2004 09:50:26 +0200 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C3E185.908943D4 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We've been battling with network problems over here, and will install = BMC next week to help us find the problem. Maybe you can help me with = this one. Solaris 8 IDS7.31FD3 =20 I am getting the following errors in my online.log. I monitored this, = and my poll threads are ok as I am not getting this on a regular basis. = But is does affect very important applications, which we cannot afford = to drop. =20 Any ideas ? Anyone had a similar experience ? We work ok most of the = time, but drop sessions (telnet AND odbc) every now and then, and we = can't pinpoint the problem - it's like it keeps moving around. =20 =20 We tested the network by plugging a user directly into our SUN server = with a spare network card (peer-to-peer). She worked fine and didn't = drop session anymore. BUT - to make things weird - I have a cron running on this same server = opening tcp connections to Informix, and this will be unable to open the = tcp connection about once or twice a week - doesn't make any sense. =20 =20 =20 Extract from online.log - =20 08:34:26 listener-thread: err =3D -25582: oserr =3D 9: errstr =3D : =Network connectio n is broken. System error =3D 9. =20 =20 =20 -25582 Network connection is broken. =20 This error might indicate that the database server has terminated, or a problem might exist on the network itself. Check that the network is functioning and that the server is still running. =20 =20 -9 Bad file number. =20 An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information. If the error recurs, please note all circumstances and contact Informix Technical Support. ________________________________ << ella for Spam Control >> has removed 839 Spam messages and set aside = 124 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com=09 ------_=_NextPart_001_01C3E185.908943D4 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)"> <style>  </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> We’ve been battling with network problems over here, and = will install BMC next week to help us find the problem.   Maybe you = can help me with this one. Solaris 8 IDS7.31FD3   I am getting the following errors in my online.log.   = I monitored this, and my poll threads are ok as I am not getting this on a regular basis. But is does affect very important applications, which we = cannot afford to drop.   Any ideas ?  Anyone had a similar experience ?   = We work ok most of the time, but drop sessions (telnet AND odbc) every now and = then, and we can’t pinpoint the problem – it’s like it keeps = moving around.     We tested the network by plugging a user directly into our SUN = server with a spare network card (peer-to-peer). She worked fine and = didn’t drop session anymore. BUT – to make things weird - I have a cron running on this = same server opening tcp connections to Informix, and this will be unable to = open the tcp connection about once or twice a week – doesn’t make any = sense.       Extract from online.log -   08:34:26  listener-thread: err =3D -25582: = oserr =3D 9: errstr =3D : Network connectio n is broken. <font size=3D2 fa

↪ replying to Dirk Moolman

TBP — Fri, 23 Jan 2004 10:19:35 +0000 — source: Usenet: comp.databases.informix

Dirk Moolman wrote: > This is a multi-part message in MIME format. > > We've been battling with network problems over here, and will install = > BMC next week to help us find the problem. Maybe you can help me with = > this one. > > Solaris 8 > > IDS7.31FD3 > > I am getting the following errors in my online.log. I monitored this, = > and my poll threads are ok as I am not getting this on a regular basis. = > But is does affect very important applications, which we cannot afford = > to drop. > > Any ideas ? Anyone had a similar experience ? We work ok most of the = > time, but drop sessions (telnet AND odbc) every now and then, and we = > can't pinpoint the problem - it's like it keeps moving around. > > We tested the network by plugging a user directly into our SUN server = > with a spare network card (peer-to-peer). She worked fine and didn't = > drop session anymore. > > BUT - to make things weird - I have a cron running on this same server = > opening tcp connections to Informix, and this will be unable to open the = > tcp connection about once or twice a week - doesn't make any sense. > > Extract from online.log - > > 08:34:26 listener-thread: err = -25582: oserr = 9: errstr = : => Network connection is broken. > > System error = 9. > > > -25582 Network connection is broken. > > This error might indicate that the database server has terminated, or a > problem might exist on the network itself. Check that the network is > functioning and that the server is still running. > > -9 Bad file number. > > An operating-system error code with the meaning shown was unexpectedly > returned to the database server. Look for other operating-system error > messages that might give more information. If the error recurs, please > note all circumstances and contact Informix Technical Support. Check your open file limits : run sar -v 5 5 and see if there are any entries under "ov".

Network / TCP problem (?) - sorry for Mime, can't send as text

Related threads

Your privacy choices