RE: connection problem

Jonathan Leffler wrote: > Csom Gyula wrote: > > > Hi everyone, > > did someone meet the following issue? > > > > We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V > > Release 4.0). Currently only 91 users can connect to the database. > > Afterwards no new user can login - till someone logs out > and the user > > can connect to the server, Informix fires error messages > (see below). > > Problem 1: 5.00 OnLine has been out of date for a decade, and > formally > totally unsupported since 2000-01-01. You need to upgrade - urgently > - preferably before you have a crash and need to recover from > backups. > You might be OK, but you might not. > > What do you have set in the TBCONFIG file for number of users? I > would suspect 100; and with a few administrative processes around, 91 > represents the number of usable connections. Set that parameter > higher and restart the server. > > > We tried to tune the operating system according to a 7.23 machine > notes > (http://www-3.ibm.com/software/data/informix/pubs/library/note > s/machnote/ncr/723uc1nc.htm). > However this didn't resolve the issue. > > No great surprise - the connection mechanisms in 5 and 7+ are > completely different. In 5, each connection has its own sqlturbo > process, which communicate with a shared tbinit (and the odd tbpgcl > and tbundo processes - the administrative processes to which I > referred). In 7, you have a (small) collection of oninit processes > serving all the clients that connect. > We tried to tune such kernel parameters as STRTHRESH, semaphore and shmem params, SDATLIM, HDATLIM, SVMMLIM, HVMMLIM. This settngs seemed to be orthogonal to the connection mechanism used by Informix (eg. whether it's is multithreaded as in 7+ or not as in Online 5). However our trial/fail in kernel tuning contradicts with this concept... > > The following error message is sent by Informix Star: > > > > sqAU0BPQAAsqlexec Szoszi kkieg -p > > sqAU0BPQAAsqlexec Szoszi kkieg -p > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > 25519 The sqlexecd daemon cannot open the network device.: > System error: No space left on device > > sqAU0BPQAAsqlexec Szoszi kkieg -p > > > > Any hint, help would be highly appriciated. > > The other possibility is that the sqlexecd has run out of file > descriptors, or some other network resource. Not sure about > why - the > master daemon should be closing them as it goes, and the child > sqlturbos it forks off should only be using a few file descriptors > (primarily standard input and standard output - usually to the same > socket) plus any chunks etc it uses. > Regarding the v. 7 release notes I mentioned, the SFNOLIM and HFNOLIM kernel params are dealing with file resources, plus, the STRTHRESH directly deals with the number of open connections. However tuning these params didn't help... Thank you for your response. Regards, Gyula sending to informix-list

Csom Gyula wrote: > Jonathan Leffler wrote: >>Csom Gyula wrote: >>> We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM >>> V Release 4.0). Currently only 91 users can connect to the >>> database. Afterwards no new user can login - till someone logs >>> out and the user can connect to the server, Informix fires >>> error messages >> >> Problem 1: 5.00 OnLine has been out of date for a decade, and >> formally totally unsupported since 2000-01-01. You need to >> upgrade - urgently - preferably before you have a crash and need >> to recover from backups. You might be OK, but you might not. >> >> What do you have set in the TBCONFIG file for number of users? I >> would suspect 100; and with a few administrative processes >> around, 91 represents the number of usable connections. Set that >> parameter higher and restart the server. >> >> >>>We tried to tune the operating system according to a 7.23 machine >> >>notes >>(http://www-3.ibm.com/software/data/informix/pubs/library/note >>s/machnote/ncr/723uc1nc.htm). >>However this didn't resolve the issue. >> >>No great surprise - the connection mechanisms in 5 and 7+ are >>completely different. In 5, each connection has its own sqlturbo >>process, which communicate with a shared tbinit (and the odd tbpgcl >>and tbundo processes - the administrative processes to which I >>referred). In 7, you have a (small) collection of oninit processes >>serving all the clients that connect. >> > > > We tried to tune such kernel parameters as STRTHRESH, semaphore and shmem > params, SDATLIM, HDATLIM, SVMMLIM, HVMMLIM. This settngs seemed to be > orthogonal to the connection mechanism used by Informix (eg. whether it's > is multithreaded as in 7+ or not as in Online 5). However our trial/fail > in kernel tuning contradicts with this concept... Let's start with the easy stuff - what's in your TBCONFIG? Specifically, how many users does your TBCONFIG file configure? [...] >>>Any hint, help would be highly appriciated. >> >>The other possibility is that the sqlexecd has run out of file >>descriptors, or some other network resource. Not sure about >>why - the >>master daemon should be closing them as it goes, and the child >>sqlturbos it forks off should only be using a few file descriptors >>(primarily standard input and standard output - usually to the same >>socket) plus any chunks etc it uses. >> > > > Regarding the v. 7 release notes I mentioned, the SFNOLIM and HFNOLIM > kernel params are dealing with file resources, plus, the STRTHRESH > directly deals with the number of open connections. However tuning > these params didn't help... If you're sure it is strictly a kernel configuration issue, then you are beyond my help. I confess, the errors (which I've deleted) do sound more like system errors than Informix errors, so you may be on the right track. Has this problem started recently? What changed? That's always a key question if something starts misbehaving. If it is simply "we added another 30 users" (or any other number), then that's one thing. If it always used to work but doesn't now, find out who changed what. I still think you should upgrade instantaneously to OnLine 5.20. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/