Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a PHP application built with the Yii Framework, which connects to an Oracle DB and runs on Apache configured with Zend Core For Oracle. Apache also runs another application on a different port.

We have a page that makes a complex query to the DB that takes about 10 minutes to run. We are in the process of reducing the time this query takes, but for now this is a problem.

The problem is that after calling the PHP page, no other pages respond, even ones that do not query the DB. The other application that Apache runs, which doesn't use Yii and uses a different DB, also is unresponsive.

Why is this happening? Shouldn't Apache be able to handle several request at the same time even if one is still running?

The error given from Apache is the following, which should be a generic message error given when communication with the DB fails:

fcgi: Can not read response from D:\Programmi\Zend\Core For Oracle\bin\php-cgi.exe

We didn't touch much of the default Apache configuration, so the maxClients and ServerLimit should be set to 256 (default)

Any idea where to look for the problem?

share|improve this question

migrated from stackoverflow.com Nov 14 '11 at 14:10

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Anyway the problem is that, after calling the php page, all the application get "stuck", no other pages respond, even the ones without query to the DB

Do you use sessions in that DB? PHP exclusively locks session file until the script finishes executing.

share|improve this answer
    
are you talking about db or php sessions? Anyway, the problem is global and not relative a single user session, after the faulty script is run, noone can run any other page of the application –  Alessandro Terrinoni Nov 14 '11 at 15:32
    
The problem is also relative to pages which not connects to the DB, so if you meant PHP locks DB session file exclusively, still the pages without DB communication should work, but they dont. –  Alessandro Terrinoni Nov 14 '11 at 16:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.