RE: [PHP] Oracle 8i + non perstistant database connections remain ing open.

you could move to a database that supports hot backups. postgresql perhaps ? > -----Original Message----- > From: Thies C. Arntzen [mailto:thies@thieso.net] > Sent: 10 July 2001 10:40 > To: Taylor, Stewart > Cc: php-general@lists.php.net > Subject: Re: [PHP] Oracle 8i + non perstistant database connections > remaining open. > > > On Tue, Jul 10, 2001 at 09:32:32AM +0100, Taylor, Stewart wrote: > > Hello, > > > > > > I'm using > > OCI8 Revision 1.96 > > Oracle Version 8.1 > > Apache Apache/1.3.11 > > Redhat Linux 6.2 > > php 4.0.2 > > > > I am connecting to my database using a non-persistant > connection (ocilogin). > > My applications run with no problems during the day. > However, at the end > > of the day there is about 20 database connections still > open. This has > > caused a problem because when the database is shutdown to > backup (overnight) > > and then restarted apache still retains the 20 connections. > This means > > that when users begin using the applications again in the > morning apache > > starts reusing the old connections plus creating some new > ones and causes > > users to be intermittently logged out/refused access/random > query failures > > etc.. The error messages logged when this happens are below: > > PHP Warning: failed to rollback outstanding transactions!: > ORA-01012: not > > logged on > > PHP Warning: failed to rollback outstanding transactions!: > > ORA-24324:service handle not initialized > > > > A quick fix to this problem is to shutdown apache when the > backup is run so > > all the connections are dropped/ > > > > Hovever, should these connections be remaining open in the > first place? Has > > anyone got any ideas? > > if you only use ocilogon and _not_ ociplogon the connection > will be closed at request and, and apache/php will not keep > then open - believe me! > > please triple check your setup and report back! > > tc > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >