RE: [PHP] Oracle Database keeps disconnecting - or something

Thies, Thanks for your reply. So far I've been unable to further investigate my problem and send to you a toy script to demonstrate it. For since Monday both applications have been working fine. Yipee! They began working again after the server was rebooted - which the Administrator claimed he had already done one evening, but he had actually just restarted apache, this I had to point out to him in the log files. However, when the new application was rolled out, initially it worked for a couple of days before the errors showed their ugly faces, so I my not have seen the last of them yet. And obviously I'd like to find out exactly what caused the errors in the first place - it was a little embarrassing releasing a new high profile company wide application that I had nutured since it's birth, only for it to stab me in the back after a couple of days in use. However I have noticed in the test servers log the message PHP Warning: failed to rollback outstanding transactions!: also but without noticeably causing any ill effects (unlike for the live apps which caused people to loose their session information and be logged out etc). I've asked my Administrator to apply the your suggested fix below to the test server to see what happens and I'll let you know the results after he gets round to doing it. Best regards, -Stewart -----Original Message----- From: Thies C. Arntzen [mailto:thies@thieso.net] Sent: 22 June 2001 19:11 To: Taylor, Stewart; Zeev Suraski Cc: php-general@lists.php.net; 'phplib@lists.netuse.de' Subject: Re: [PHP] Oracle Database keeps disconnecting - or something On Fri, Jun 22, 2001 at 02:23:14PM +0100, Taylor, Stewart wrote: > Hello, > > Just in case anyones got any ideas. > > I've been testing an application for a few weeks on a test server without > any problems. > After releasing it onto the live server, which is - according to the > administrator - setup exactly the same as the test server I've been running > into problems. > > Apparently the database seems to be disconnecting randomly see log file > extract below. > > I already had a application on the live server which has been working > perfectly for a year or so. Now the new application is live it is having > the same problem as well. > > The test version of the already live application is also on the same test > server and both databases on live and test are setup exactly the same way. > > > My administrator tells me that we have a license for unlimited connections > to the database etc.. > > My setup us > OCI8 Revision 1.96 > Oracle Version 8.1 > Apache Apache/1.3.11 > Redhat Linux 6.2 > php 4.0.2 > I'm also using phplib 7.2c to manage authentication/sessions and database > access. i've found somebody in hamburg (which is where i live) who could show me the problem. his setup is rather complex - so if you could send me a _short_ testcase (_without_ phplib) that reproduces you problem i would be very happy to work on it! are you using oracle-MTS by any chance? BTW: could you please comment out the call to php_config_ini_shutdown() in main/main.c and see if it makes any difference for you? (zeev: the call to php_config_ini_shutdown is too early, if a module calls php_error in the MSHUTDOWN core_globals->error_log is already freed - i think we need to fix this!) regards, 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