Francisco,
We had a similar problem. We were running an NT Server with Oracle 7.3.
Our US based users had no trouble with timeouts but our users in Paris were
experiencing a timeout like you described. This only occured on very large
queries with 8-15 tables and several hundred rows returned.
Our solution on that box was simple. Set your CF timeout higher - Like 5
minutes.
Since that time we have moved to a new Sun box running Oracle 8.0i with no
timeout issues for anyone.
Your second and third queries run because Oracle is caching the query and
re-using it even though Cold Fusion timed out the first time.
Wally Randall
Gaithersburg MD USA
----- Original Message -----
From: "Francisco Montes; Spain on Line" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 12:15 PM
Subject: Weird page timeouts with Oracle
| Hi,
|
| We have been getting a series of very weird error messages with CF lately.
We have got two servers, one with CF and another with the Oracle database.
|
| The CF server page request timeout is set to 30 seconds. When we request a
page for the first time, it always goes beyond this threshold for some
reason (it should not take that long anyway) and we get the CF page timeout
error message. However if we request the page again, chances are that
everything will go ok.
|
| Another scenario:
|
| 1. We request a page for the first time with a browser, and it is
starting to take too long to deliver...
| 2. If in that time (within the 30 seconds threshold) we request that
very same page with another browser (on another machine) the page in browser
the first browser gets finally delivered while the one in the second one
starts taking a long time to deliver.
|
| It looks like if Oracle is not passing control back to CF unless this is
forced somehow by another request done by someone else. We are trying to
work out why are we still getting this erratic behaviour.
|
| We are using: Solaris 5.8, Apache 1.3.9, Oracle client 8.1.6.3
|
| Any ideas or comments about what could be going wrong would be greatly
appreciated.
|
| Francisco Montes
| Spain on Line
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
