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-----