We have a report generation feature in our application which processes millions of records. The SQL query that retrieves these records typically takes 8-10 min to return the result :roll:
Now, the problem is when my servlet calls the data access object to execute the query, I see a thread being started for this process(in the weblogic logs), but after about 4-5 min I get the following error in Apache logs
READ_TIMEOUT [os error=0, line 202 of ../nsapi/Reader.cpp]: no read after 300 seconds
and a new thread is started which starts the execution from the beginning (As if a new request has been made). And it goes into an endless loop.
I tried increasing the Timeout and the ConnectTimeoutSecs parameters in the httpd.conf file, but it did not solve the problem.
Ideas, anyone ?? Any help in this regard will be appreciated.
Thanks in advance.
posted 10 years ago
Found the solution ...
I needed to put the HungServerRecoverSecs entry in the IfModule tag of httpd.conf file