http://www.houseoffusion.com/cf_lists/index.cfm/method=messages <http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=27718&forumid=4> &threadid=27718&forumid=4
Doug
-----Original Message-----
From: Shawn McKee [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 3:08 PM
To: CF-Server
Subject: Cursor errors
Testing MX upgrade and we are getting a lot of these.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00604: error occurred at
recursive SQL level 1 ORA-01000: maximum open cursors exceeded
Our DBA is asking about this query that he is finding in his logs.
SELECT cglobal.cfid
FROM cglobal
WHERE cglobal.lvisit < :v0
Clearly this is something the server is doing. Getting ready to clear
expired client variables? Incorrectly our MX server was set to do this as
is the CF5 server. We are resetting the MX server to not do that against
this database for now. Later we will reverse the situation. Is this the
likely culprit?
Thanks,
Shawn McKee
Manager, Web Development
NewsStand, Inc.
8620 Burnet Rd., Suite 400
Austin, TX 78757 USA
512-334-5100
NewsStand Inc. is the leader in digital delivery of newspapers, magazines
and other print publications. Our user-friendly technology and innovative
media distribution is changing the way people read. Now, we have over 50
titles (in several languages) for purchase as either single copies or
subscriptions that can be easily downloaded on your desktop, laptop or
Tablet PC. Here is a link to a free copy of The New York Times for you to
try. Select "Try a free sample" and click on "Add to cart."
http://newsstand.com/?fuseaction=signup
<http://newsstand.com/?fuseaction=signup&promo_id=2295> &promo_id=2295
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
