[PHP-DEV] PHP as ISAPI module crashes but...
Hi: I've discovered something very interesting: perhaps you already know that using PHP + IIS in ISAPI mode is not recommended, because of the: "PHP has encountered an Access Violation at 73342C83" and so errors. So CGI use is recommended. But I have found that this happens whenever I make a MSSQL query. If I run a script with no queries, it works fine, and no matter how much I bash the server, no crashes. Now, I tried to do the same with Oracle8i. Using php_oci8 module, I made a query: and it never crashes even if I bash the server with many requests!!! (this sadly makes scripts using MSSQL crash miserably). Now: could it be that, for some reason, the code of php_mssql has reentrancy problems with multiple server threads? Maybe we could test some other modules (php_odbc or other DB modules) looking for the same problem? I find this issue important, because many people (including me) are expectant about using PHP as an ISAPI filter. The performance boost is very important to be looked upon, and this clearly prevents people from running heavily loaded production websites with NT+IIS. Greetings, ___ Francisco Javier Ortiz Torre ComuNET,S.A. mailto:[EMAIL PROTECTED] ComuNET, S.A Gral. Concha 39,6 48012 Bilbao Espaa Tel: +34 944 700 101 Fax: +34 944 700 185 http://www.comunet.es ___
Re: [PHP-DEV] PHP as ISAPI module crashes but...
I'm a keen as you are for the PHP ISAPI module to work reliably, but before we start sorting out the extension modules, we need to sort out the core itself. For me (on my NT4/IIS4/SP6 setup), php 'straight out of the box' falls over with server 500 errors on the simplest of scripts - even with only a single request being made to the server (which may rule out the problem being anything to do with thread safety?). Perhaps we could get together a few simple and a few more complicated scripts and try them on a range of machines and see if we can start to make any conclusions. My suggestions for starters are: --- ?php echo('hello'); ? --- ?php phpinfo(); ? (which will probably start up simultaneous threads at it fetches the images) --- ?php /*something simple which takes a long time so that we get a chance to fire off multiple simultaneous requests to it*/ ? --- Any other thoughts? Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP as ISAPI module crashes but...
Hi: 3/7/01 11:33:18 AM, "Phil Driscoll" [EMAIL PROTECTED] wrote: I'm a keen as you are for the PHP ISAPI module to work reliably, but before we start sorting out the extension modules, we need to sort out the core itself. For me (on my NT4/IIS4/SP6 setup), php 'straight out of the box' falls over with server 500 errors on the simplest of scripts - even with only a single request being made to the server (which may rule out the problem being anything to do with thread safety?). are you trying with 4.0.4pl1? Try, please. I had the same problems with previous versions, but since I installed 4.0.4pl1 in a development server (one week ago, not much time...) I've had no problems, (if I only care about disabling the directories with scripts using MSSQL .) For example, I've tried to bash the server with the typical scripts, including the 3 examples you point in your post, from 4 clients making several requests at a time. No problem at all. The same happened with queries against Oracle8i. Perhaps we could get together a few simple and a few more complicated scripts and try them on a range of machines and see if we can start to make any conclusions. I'm with you, heavier testing must be carried out. I have limited time, but I'll post more results here as they come along. Any other thoughts? just more testing ... if you or anybody wants me to test more scripts, just send them to me. Greetings, Paco -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP as ISAPI module crashes but...
Paco wrote: are you trying with 4.0.4pl1? Try, please. I had the same problems with previous Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong for me. Are you using NT4 or W2K? Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DEV] PHP as ISAPI module crashes but...
Hi: Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong for me. Are you using NT4 or W2K? I'm using NT4, SP6 and IIS 4. I have the MSSQL 2000 client libraries installed (MDAC 2.6) but I can't think they have any influence (the db API used by php_mssql is backwards compatible with MDAC 2.x AFAIK). Some more "casual" information in case it helps: with earlier versions, whenever the IIS server crashed, both .PHP and .ASP pages stopped working . However, static content was served fine, as I pointed in a bug report. Now with 4.0.4pl1, when a script using MSSQL queries crashes, the other .PHP or .ASP scripts keep working. Other scripts using MSSQL fail. Strange, isn't it? It's all I can say now. When I have some more tests done (other servers maybe) I'll make you know. Ask me whatever you might find useful. Greetings, Paco 3/7/01 2:31:30 PM, "Phil Driscoll" [EMAIL PROTECTED] wrote: Paco wrote: are you trying with 4.0.4pl1? Try, please. I had the same problems with previous Yes, I've been using 4.0.4pl1 since day '0', and it 'reliably' goes wrong for me. Are you using NT4 or W2K? Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org ___ Francisco Javier Ortiz Torre ComuNET,S.A. mailto:[EMAIL PROTECTED] ComuNET, S.A Gral. Concha 39,6 48012 Bilbao Espaa Tel: +34 944 700 101 Fax: +34 944 700 185 http://www.comunet.es ___ -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]