> -----Original Message----- > From: Sean A Corfield [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 30, 2003 3:35 PM > To: CF-Talk > Subject: Re: CFMX Updater 3 Available > > > Databases we connect to are: > > Oracle 8i (8.1.7) on two separate Windows NT servers (connected to > > using > > Oracle's JDBC/OCI 8.1.7.4 drivers) > > Hmm, have you tried using other drivers? We were using the 9i OCI > drivers for a while but we moved back to the 9i Thin Client drivers > because under load we saw occasional failures with the OCI drivers.
We have not tried the thin client drivers. The OCI drivers are supposed to be faster than the thin client (as they're written in C), so we went with those. I also would have expected them to be more stable, as the codebase for OCI is actually more mature I believe. We are using the very latest patch release (8.1.7.4) from Oracle, which fixed bugs in the JDBC drivers for Oracle. If problems persist I could give the thin drivers a try and see if that makes a difference. > > Also, we are trying to connect to network Access databases, > but we've > > thusfar been unable to connect to them (I have another > e-mail to this > > mailing list trying to fix this problem). We're getting errors of > > permission denied/exclusively opened by another user > > I wonder if CF is trying to open multiple connections to the > database? > I don't know too much about MS Access but from what I've read on this > list, it doesn't seem to be very reliable in any sort of multi-user > environment... The Access databases are small and simple- not worth taking up resources on an expensive Oracle server. We've always connected to them in the past in 4.5.2. I realize there are new drivers now- I just would have expected them to be just as stable as the old versions of the drivers. That apparently doesn't seem to be the case. As we've exhausted every option for connecting to them on the network, we're actually now considering copying them over locally on a nightly basis. We'll see if that makes any difference with server stability. > > Also, I'll reiterate that the site was running fine on CF 4.5.2- the > > problems with server hangups started with CF MX, and then > only once in > > production and receiving a higher amount of traffic. > > The biggest difference when moving from pre-MX to MX is the database > drivers (hence the focus in Updater 3 on improved versions of those). I'm finding that to be very true. I realize that there is a ton of code out there to rely on, and it's tough to pinpoint down the problems in these situations. However, I'll note that we did have another server hang today, so I really don't think the last one was an isolated incident. There were no errors in any of the logs leading to the hang. We have been getting errors connecting to the network Access databases, but those occur all the time, and generally do not cause a problem with the server crash, so I really don't think that's the problem here. We are also "maintaining connection over all client requests" for many of our Oracle databases. I may consider turning this off to see if it helps- but I would do so VERY reluctantly, as that would have a seriously negative impact on performance. We've had only 4 days now with updater 3, still not enough time to make a good assessment. I'll give it a few more weeks, and if crashes/hangs continue to be a serious problem, we'll rollback to 4.5.2 and consider our options from there. One piece of advice for people: if the server hangs, reboot the whole machine- don't just restart the service! I find that if I just restart the service, it'll hang again within a few hours. If I reboot the machine entirely, it tends to stay up much longer (days). This could be a coincidence, but I've noticed this behavior 3 times now- and consistently. Thanks for your help Sean. If you have any more suggestions, I'd love to hear em. Kevin Ruggiero > > Sean A Corfield -- http://www.corfield.org/blog/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
