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

yes, I close the connection each time with ifx_close and free the results with ifx_free_result. we tried too ifx_pconnect with php4 rc1 on one of the three web servers, without any change. best regards, Patrick Grenier. Systems developer Framfab France www.framfab.fr Messagerie : pgrenier@framfab.fr T. +33(0)1.55.48.11.00 - F. +33(0)1.47.35.00.00 ----- 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----- > >