Can timeout of call to a stored procedure be set/overriden

General discussion forum for the Zend Server

Can timeout of call to a stored procedure be set/overriden

Postby bill3496 on Mon Mar 19, 2018 10:31 pm

Our applications call back to stored procedures on the production AS400 occasionally times out. The stored procedure answers an inquiry and returns data to be displayed. The call is made in by javascript Ajax. Sometimes the http_request.status is 408, indicating a timeout occurred. The 408 is returned after 60 seconds. "default_socket_timeout" and "max_execution_time" in php.ini are set to 60.

I have tried to override these two php.ini values to 120 with ini_set() in the php script called by http_request.open('GET',url,true). I have checked to set that the values were changed with ini_get. If an http_request.status of 408 is returned it still is in 60 seconds.

I am assuming the timeout is caused by the stored procedure failing to complete within 60 seconds. I could be wrong about that.

How can the timeout of the stored procedure be controlled? I want to give it 120 seconds before the 408 error is called.

I would appreciate your help and insights.

We are running Zend Server for IBM I 8.6.0.

Thank you
bill3496
 
Posts: 1
Joined: Tue Jun 06, 2017 7:54 pm

Re: Can timeout of call to a stored procedure be set/overrid

Postby zend_eyalt on Thu Mar 22, 2018 9:22 am

Hi there,

You should also change apache FastCGI settings, and increase ConnectionTimeout & RequestTimeout in your fastcgi.conf file (on ZS 8.x would usually be found at /www/zendsvr6/conf/fastcgi.conf ).

More info about this configuration file can be found here:
http://files.zend.com/help/Zend-Server- ... essing.htm
User avatar
zend_eyalt
 
Posts: 262
Joined: Thu Jan 22, 2009 3:16 pm


Return to Zend Server

Who is online

Users browsing this forum: No registered users and 3 guests