Re: [PHP4BETA] OCI8 persistant connections fail after database restarted

On Wed, May 10, 2000 at 09:29:04AM -0500, Kevin Hendrix wrote: > Hi. > > We are using TCP connections. It should be possible to do this ... when PLogon > is called, the auth credentials are passed back in, so they should not need to > be cached between scripts. The first real oracle interaction that failed on > the pconn (probably a parse) could trigger a single attempt at reconnect, > failing with appropriate error condition if the reconnect fails... It'd be > complex, but not impossible. what i do right now is that i close the connection and remove it from the persistent list once a fatal error has happened! that should take care of this situation mostly. this is done in ociexecute (oci8.c:1188) - maybe we just need to add 'nother error-code here to make it work for you -OR- there is some commented out code that will check the connection *before* it's returned to the script in ext/oci8/oci8.c line 2062. just uncomment the oci_ping stuff and connections will be "pinged" before returned to the script! tc > > Just an idea... > kevin > khendrix@pennypi.com > > thies@digicol.de wrote: > > > > On Mon, May 08, 2000 at 12:49:42PM -0500, Kevin Hendrix wrote: > > > The subject pretty much says it all. I've got a Redhat 6.2 box running > > > Secure Web Server 3.2 (Apache 1.3.12) and PHP4RC1 using persistant connections > > > to an Oracle 8i server on another box. > > > > > > When the 8i server is restarted, all PHP persistant connections that were > > > pinned up before the 8i reboot continue to fail. Shouldn't there be some > > > error recovery built in that wouldn't require an apache restart? > > > > that's what should happen - i'll have to dig into that. > > > > what connection Net8 connection are u using? beq, tcp, ipc > > > > > > > > kevin > > > khendrix@pennypi.com > > > > > > -- > > > PHP 4.0 Beta Mailing List > > > <http://www.php.net/version4/> > > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > > For additional commands, e-mail: php4beta-help@lists.php.net > > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > > > > -- > > > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" > > Digital Collections Phone +49 40 235350 Fax +49 40 23535180 > > Hammerbrookstr. 93 20097 Hamburg / Germany > > > > -- > > PHP 4.0 Beta Mailing List > > <http://www.php.net/version4/> > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > For additional commands, e-mail: php4beta-help@lists.php.net > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany