Re: Bug #4468: random ifx_pconnect code -439 with ifx_connect

As there are no signal handling routines in the php_ifx driver (it is all strictly synchronous) I am beginning to suspect a problem in the ESQL/C libraries when a lot of connecting/disconnecting is going on. Perhaps internal ESQL/C data structures are not getting released immediately and make the ESQL/C libraries complain when the *same process* tries to reopen the same connection that was closed only milliseconds ago. I have several production sites running Apache/modphp3/Informix on SVR4.0 Unix machines and have never experienced this error. They use both local databases (using Streams Pipes IPC connections) and databases on other machines (using TLI TCP connections ). But we *always* use persistent connections and force freeing of all result sets (the ifx_ functions are wrapped in database/recordset classes and are never called directly). As an aside, I can see no obvious reasons for not using persistent connections. We have the same apps running on Windows NT 4 / IIS 4 with php 3.0.14 as CGI too, no problems there either. But in CGI mode it is of course *another* process that is opening that connection again. Perhaps our load is not big enough ? Or the Informix libraries (IDS 7.22, IDS 7.23, or IDS 7.31, all with CSDK 2.30) on Windows and NCR MP-RAS Unix do not have this problem ? Danny --- ----- Original Message ----- From: "Andrej Falout" <afalout@xtra.co.nz> To: <pgrenier@framfab.fr>; <php-dev@lists.php.net> Cc: <Danny.Heijl@cevi.be> Sent: Sunday, May 21, 2000 8:46 AM Subject: RE: [PHP-DEV] Bug #4468: random ifx_pconnect code -439 with ifx_connect > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > I was stress testing our installation, and on heavy CPU load we do get > this too. > > - -439 > > Database server is currently processing an SQL task. > > You attempted to call an SQL routine or attempted to execute an SQL > statement within a signal handling function/routine or a callback > function/procedure. Use only the sqldone() and sqlbreak() library > functions inside your INFORMIX-ESQL/C callback function. In addition, > if you want to unregister your callback function in INFORMIX-ESQL/C, > you can invoke the sqlbreakcallback() callback registration function > within your callback procedure. > > I went trough all the usual suspects in ONCONFIG, but did not manage > to get rid of it. From code description, it would look like problem in > ESQL code of PHP Informix interface. > > ifx.allow_persistent seems to reduce this, so I was playing with > NETTYPE, but nothing definitive. Granted, I was really STRESSING the > box. Are you closing your connections when finished, and freeing the > results? > > Yours, Andrej Falout, http://www.falout.com ICQ 7628616 > #----------------------------------------------------------------- > globals "std_disclaimer.4gl" > > "Venus is still under construction. Thank you for your patience > and we apologize for the inconvenience." - Match.com online dating > site. > > > > > -----Original Message----- > > From: pgrenier@framfab.fr [mailto:pgrenier@framfab.fr] > > Sent: Wednesday, 17 May 2000 1:24 > > To: php-dev@lists.php.net > > Subject: [PHP-DEV] Bug #4468: random ifx_pconnect code -439 with > > ifx_connect > > > > > > From: pgrenier@framfab.fr > > Operating system: linux red hat 6.0 > > PHP version: 3.0.14 > > PHP Bug Type: Other > > Bug description: random ifx_pconnect code -439 with ifx_connect > > > > configure php : > > #!/bin/bash > > CC="gcc" OPTIM="-O2" \ > > ./configure \ > > --includedir=/opt/informix/incl/esql \ > > --with-apache=/www/install/apache_1.3.11 \ > > --with-informix=/opt/informix \ > > --with-zlib \ > > --enable-sysvsem \ > > --enable-sysvshm \ > > --enable-track-vars \ > > --enable-magic-quotes > > > > a piece of php3.ini : > > [Informix] > > ifx.default_host = ; default host > > for ifx_connect() (doesn't apply in safe mode) > > ifx.default_user = ; default user > > for ifx_connect() (doesn't apply in safe mode) > > ifx.default_password = ; default > > password for ifx_connect() (doesn't apply in safe mode) > > ifx.allow_persistent = Off ; allow or > > prevent persistent link > > ifx.max_persistent = -1 ; maximum number > > of persistent links. -1 means no limit > > ifx.max_links = -1 ; maximum number > > of links (persistent+non persistent). -1 means no limit > > ifx.textasvarchar = 0 ; if set on, > > select statements return the contents of a text blob instead of it's > id > > ifx.byteasvarchar = 0 ; if set on, > > select statements return the contents of a byte blob instead of it's > id > > ifx.charasvarchar = 0 ; trailing blanks > > are stripped from fixed-length char columns. May help the life > > ; of Informix SE > users. > > ifx.blobinfile = 0 ; if set on, the > > contents of text&byte blobs are dumped to a file instead of > > ; keeping them in > memory > > ifx.nullformat = 0 ; NULL's are > > returned as empty strings, unless this is set to 1. In that case, > > ; NULL's are > > returned as string 'NULL'. > > > > > > -- > > PHP Development Mailing List <http://www.php.net/> > > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > > For additional commands, e-mail: php-dev-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > -----BEGIN PGP SIGNATURE----- > Version: PGPfreeware 6.0.2i > > iQA/AwUBOSbbXhZH34ibpTRkEQLY0ACeKqbSSbhz1Zi72wRqwcY9X3bYKHwAoO+h > MD3Nnjqf4JvYySOsce/0LKkF > =0D7N > -----END PGP SIGNATURE----- > >