[Openroad-users] App Server - Timeout Interval

Tue Oct 2 08:55:12 EST 2007

Hi Durwin, I'm ooto this week but have something similar if you can't find it in your archives. Just shout and ill send. Neil

Typed painfully slowly on my BlackBerry® wireless device

-----Original Message-----
From: Durwin Wright <Durwin.Wright at ingres.com>

Date: Mon, 1 Oct 2007 12:28:22 
To:International OpenROAD Users <openroad-users at peerlessit.com>
Subject: Re: [Openroad-users] App Server - Timeout Interval

Hello Jonathan, 

Let me dig out an example of how to detect a database lost and reconnect in the AppServer.  I have it in my archives and should be able to find it today. 

I will have to confirm this but I believe that the Timeout Inter\val affects each Slave individually.  The Timeout Interval is probably enforced at the time that the Call4Gl is initially made.  This means that the last Call4GL request will end in an error.  When ths request is made again, this will cause the ASO to be restarted. 

If you are running with SPOTrace set to on and appending the log, I would be interested in reviewing the logs.  If you are interested, then contact me directly. 

Durwin Wright | Sr. Architect | Durwin.Wright at ingres.com | Ingres | 500 Arguello Street | Suite 200 | Redwood City | CA | 94063 | USA  +1 650-587-5523 | fax: +1 650-587-5550 

----------------

From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Jonathan Barton
 Sent: Monday, October 01, 2007 3:24 AM
 To: International OpenROAD Users
 Subject: Re: [Openroad-users] App Server - Timeout Interval 

Many thanks for this Durwin. 

This is exactly what I am after - I will implement the timeout interval asap.  The reason I want it is because the ASO connection to the database has been lost and so it needs replacing.  Would 30 minutes be unreasonable bearing in mind the afore-mentioned issue we face? 

With regards to the transaction limit: 

Does the purge affect all slaves at the same time? 
And what happens to any requests that have not been completed? 

We actually stop and start the OR AppServer service every morning anyway, which would be before way before 100000 transactions (max 20000). 

Thanks again. 

Jonathan 

----------------

From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Durwin Wright
 Sent: 28 September 2007 16:35
 To: International OpenROAD Users
 Subject: Re: [Openroad-users] App Server - Timeout Interval 
I normaly set my Timeout Interval value to 60 minutes for stateless ASOs.  This is an inactivity interval.  If the Dispatcher Manager detects that an ASO has been inactive for this period of time then the ASO is scheduled for shutdown.  You will see an entry in the SPOTrace file that indicates that the ASO was shutdown due to a Timeout.  This timeout counter is reset to zero each time a new request is processed. 

After an ASO has been shutdown due to ta Timeout, the next time a Call4GL request is scheduled for the shutdown ASO, an implicit Initiate will be done.  This will result in a longer Call4GL execution time since the Initiate time is now considered part of the Call4GL request.   

While the ASO is processing a request, the timeout interval does not have any affect. 

I also typically set my Transaction Limit to 100,000 for stateless ASOs.  This will shutdown the ASO after a fixed number of requests have been processed.  An entry in the SPOTrace file will indicate that this action has been take.  When the next Call4GL request is sent to the ASO, an imiplicit Initiate will be down on behalf of the requestor. 

Durwin Wright | Sr. Architect | Durwin.Wright at ingres.com | Ingres | 500 Arguello Street | Suite 200 | Redwood City | CA | 94063 | USA  +1 650-587-5523 | fax: +1 650-587-5550 

----------------

From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Jonathan Barton
 Sent: Friday, September 28, 2007 6:09 AM
 To: International OpenROAD Users
 Subject: [Openroad-users] App Server - Timeout Interval 

Hi 

Has anyone had experience in using the timeout Interval for a signature on the OR App Server? 

What is the recommended level?
 What happens to calls that are currently being executed? 

Currently we have this set to 0, but due to a current issue with network connections dropping out the ASO slave connection becomes useless. 

So much to learn... :-) 

Many thanks. 

JONATHAN 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
”University of the West of England" 
+ Work Email:         jonathan.barton at uwe.ac.uk <mailto:Jonathan.barton at uwe.ac.uk> 
( Work No:             0117 3281075 

P Please consider the environment before printing. 

----------------

This email was independently scanned for viruses by McAfee anti-virus software and none were found 

----------------

This incoming email to UWE has been independently scanned for viruses by McAfee anti-virus software and none were detected 

----------------

This email was independently scanned for viruses by McAfee anti-virus software and none were found ________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe