|
View:
New views
1 Messages
—
Rating Filter:
Alert me
|
|
|
GET LAST ERROR STACK()Error #: 15;
Source: srvr; Text: "Postponed session expired." Can anyone elaborate on what this means? I'm getting these, among others, in my attempt to track down and eliminate client disconnects. My best interpretation is that a connection put into standby mode (see below) has been timed out, but, if that's the case, by which, client or server? I'm trying to "protect" client/server connections by using the Idle Connections, 4D Server timeout and 4D Client timeout DB parameters. Here's my logic: `---------------------------------------- `1. Protect all connections if they have been idle for more than 10 minutes--use DB parameter "Idle Connections Timeout" `2. Clients never "voluntarily" disconnect from server except when user quits 4D--use DB Parameter "4D Server Timeout" `3. Server disconnects clients if they have been idle for more than 3 hours--use DB Parameter "4D Remote Mode Timeout" `---------------------------------------- Here is the code in Server startup: SET DATABASE PARAMETER(4D Remote Mode Timeout ;60*3) `Disconnect a Client if it's been idle more than 3 hours. (The second parameter, ` duration , for Remote Mode Timeout is expressed in minutes.) SET DATABASE PARAMETER(Idle Connections Timeout ;60*10) `put the connections started by this machine on standby if they have been `idle for more than 10 minutes. (The second parameter, duration, for idle connections timeout is expressed in seconds.) Here's the code in Client startup: SET DATABASE PARAMETER(4D Server Timeout ;0) `never intentionally disconnect server. SET DATABASE PARAMETER(Idle Connections Timeout ;60*10) `put the connections started by this machine on standby if they have been `idle for more than 10 minutes. (The second parameter, duration, for idle connections timeout is expressed in seconds.) I *think* I'm using the correct timeout parameters in the correct locations, based on a post Josh made some time ago. Is anyone using Error Stack info? It seems as if it should be helpful but I've seen virtually no mention of it here. Thanks for *any* insight. Bill William W. Weale, III Business Owners Support, LLC. Operations Analysis MIS Advising Decision Support Systems ********************************************************************** Get the speed and power of 4D v11 SQL before upgrade prices increase - http://www.4d.com 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4D.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4D_Tech-Unsubscribe@... ********************************************************************** |
| Free embeddable forum powered by Nabble | Forum Help |