ID: 22519 Updated by: [EMAIL PROTECTED] Reported By: thomas dot mieslinger at gls-germany dot com Status: Feedback Bug Type: Informix related Operating System: Solaris PHP Version: 4.3.2 New Comment:
And no, we're not interestedin apache2 mpm-worker, it's experimental at best anyway. Use apache 1.3.28 which actually works. Previous Comments: ------------------------------------------------------------------------ [2003-08-20 17:44:33] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2003-08-20 12:02:31] thomas dot mieslinger at gls-germany dot com Hi, I think the following helps with the -439 problem. Art S. Kagel wrote in comp.databases.informix: Your app probably has a SIGALARM() timeout handler that is trying to detach from the engine before exiting with a DISCONNECT statement but the engine cannot respond because it is busy with the long running statement that caused the timeout. The timeout handler has to execute the sqlbreak() ESQL/C function to terminate the current statement which will return with a -613 error. Then either the handler can DISCONNECT directly or just return and let the mainline code handle the -613 as a timeout and exit gracefully. Your choice. And our Problem only happens when there are very long select run by php. I recently compiled 4.3.2 with apache 2.0.47 (mpm-worker) and had also Problems with longer running statements (3-7 seconds) and alarm signals delivered to the wrong thread.... Are you interessted in debugging php 4 with apache 2 mpm-worker? Thanks for your time Thomas ------------------------------------------------------------------------ [2003-07-12 23:41:58] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip And copy paste the errors you get in Apache error_log here. (not all of them, just those with different line numbers..:) ------------------------------------------------------------------------ [2003-03-20 02:19:19] thomas dot mieslinger at gls-germany dot com Trust me, we didn't change a bit with php, php.ini, apache or httpd.conf. OK the database grew and we changed some PHP scripts, but the bug appears on any page even if it worked for two weeks. In some situations the -439 appears more often espeially when one or more really large selects are running (result set > 1M). Now whats this when I say we see -439. When a php page is opened it first checks for some entries in the database. These calls die with error -439. I am sure that it is an php problem because with dbaccess or perl I can connect to the databases and work with it. Please tell me which Client SDK and Dynamic Server you use for the development of php/informix. ------------------------------------------------------------------------ [2003-03-19 11:28:28] [EMAIL PROTECTED] So what changed during the 2 weeks that made it to fail again? Are you absolutely sure this is PHP problem at all? And what do you mean with "Now we see -439 again." ?? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/22519 -- Edit this bug report at http://bugs.php.net/?id=22519&edit=1
