Informix SE on Linux => Zombie
Hello, I have a problem using Informix SE on a Linux system. Each 'sqlexec'-process the sqlexecd spawns remains in the system until the 'sqlexecd'-process itself exits. After some time, all these zombie-processes use all available resources, so the system can do no more 'fork's. How can I tell the sqlexecd to ignore the SIGCHLD-signal so the zombies can terminate? I am using SuSE 6.0 with Kernel 2.2.4 and SMP enabled and Informix SE 7.24. Thanx for any help, LARS -- _______________________________________________________________________ Lars Sitzmann phone: +49 441- 9722-222 OFFIS fax: -202 Escherweg 2 sekr.: -101 D-26121 Oldenburg Germany _______________________________________________________________________ mailto:sitzmann@offis.uni-oldenburg.de WWW: http://www.offis.uni-oldenburg.de _______________________________________________________________________
check out www.informix.com/idn-secure/Linux/WebPages/note0025.html In comp.os.linux.misc Lars Sitzmann <sitzmann@offis.uni-oldenburg.de> wrote: : Hello, : I have a problem using Informix SE on a Linux system. : Each 'sqlexec'-process the sqlexecd spawns remains in the system : until the 'sqlexecd'-process itself exits. : After some time, all these zombie-processes use all available : resources, so the system can do no more 'fork's. : How can I tell the sqlexecd to ignore the SIGCHLD-signal so the : zombies can terminate? : I am using SuSE 6.0 with Kernel 2.2.4 and SMP enabled and : Informix SE 7.24. : Thanx for any help, : LARS : -- : _______________________________________________________________________ : Lars Sitzmann phone: +49 441- 9722-222 : OFFIS fax: -202 : Escherweg 2 sekr.: -101 : D-26121 Oldenburg : Germany : _______________________________________________________________________ : mailto:sitzmann@offis.uni-oldenburg.de : WWW: http://www.offis.uni-oldenburg.de : _______________________________________________________________________ -- The wealth of reality, cannot be seen from your locality.
Lars Sitzmann wrote: > > Hello, > I have a problem using Informix SE on a Linux system. > Each 'sqlexec'-process the sqlexecd spawns remains in the system > until the 'sqlexecd'-process itself exits. > After some time, all these zombie-processes use all available > resources, so the system can do no more 'fork's. > How can I tell the sqlexecd to ignore the SIGCHLD-signal so the > zombies can terminate? > > I am using SuSE 6.0 with Kernel 2.2.4 and SMP enabled and > Informix SE 7.24. This is about the oldest problem in the Informix on Linux book. It has been extensively discussed numerous times over the last year or so. The best bet is to upgrade to the glibc version of the SE, or to IDS. There are workarounds of greater or lesser apallingness in the Linux and D4GL corners of the IDN web site at http://www.informix.com/idn/ Also check out the Linux info at the IIUG web site (iiug.org). -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>
Hi Rick, > check out www.informix.com/idn-secure/Linux/WebPages/note0025.html > Please post the answers. Not everyone has access-rigths to that side. :-( Dirk > In comp.os.linux.misc Lars Sitzmann <sitzmann@offis.uni-oldenburg.de> wrote: > : Hello, > : I have a problem using Informix SE on a Linux system. > : Each 'sqlexec'-process the sqlexecd spawns remains in the system > : until the 'sqlexecd'-process itself exits. > : After some time, all these zombie-processes use all available > : resources, so the system can do no more 'fork's. > : How can I tell the sqlexecd to ignore the SIGCHLD-signal so the > : zombies can terminate? > > : I am using SuSE 6.0 with Kernel 2.2.4 and SMP enabled and > : Informix SE 7.24. > > : Thanx for any help, > : LARS > : -- > : _______________________________________________________________________ > : Lars Sitzmann phone: +49 441- 9722-222 > : OFFIS fax: -202 > : Escherweg 2 sekr.: -101 > : D-26121 Oldenburg > : Germany > : _______________________________________________________________________ > : mailto:sitzmann@offis.uni-oldenburg.de > : WWW: http://www.offis.uni-oldenburg.de > : _______________________________________________________________________ > > -- > The wealth of reality, cannot be seen from your locality.
Lars Sitzmann wrote: > > Hello, > I have a problem using Informix SE on a Linux system. > Each 'sqlexec'-process the sqlexecd spawns remains in the system > until the 'sqlexecd'-process itself exits. > After some time, all these zombie-processes use all available > resources, so the system can do no more 'fork's. > How can I tell the sqlexecd to ignore the SIGCHLD-signal so the > zombies can terminate? This is Ye Olde Zombie problem. It has been fixed in a later release and there are workarounds posted. Best bet, download the newer release. Art S. Kagel
Dirk Niemeier wrote: > > check out www.informix.com/idn-secure/Linux/WebPages/note0025.html > Please post the answers. > Not everyone has access-rights to that side. :-( Dirk If you look at the IDN web site (http://www.informix.com/idn), then you can sign up to get access to the secure part of the site. Siging up is free. You get maybe an email a month as a result of signing up. You get access to the Linux and D4GL and other areas of the IDN web site. > > In comp.os.linux.misc Lars Sitzmann <sitzmann@offis.uni-oldenburg.de> wrote: > > : I have a problem using Informix SE on a Linux system. > > : Each 'sqlexec'-process the sqlexecd spawns remains in the system > > : until the 'sqlexecd'-process itself exits. > > : After some time, all these zombie-processes use all available > > : resources, so the system can do no more 'fork's. > > : How can I tell the sqlexecd to ignore the SIGCHLD-signal so the > > : zombies can terminate? > > > > : I am using SuSE 6.0 with Kernel 2.2.4 and SMP enabled and > > : Informix SE 7.24. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>