PHP 4.0 Bug #3910: persistent connections persist even after a kill session has been done on them.

From: guage@usa.net Operating system: Linux - Redhat 6.1 PHP version: 4.0 Beta 4 Patch Level 1 PHP Bug Type: Oracle related Bug description: persistent connections persist even after a kill session has been done on them. In reading the source code in Beta 4.0 it states that OCILogoff doesn't do anything anymore. This is a problem because when a session is killed on the database side the connection remains for ever on the server and you receive ORA-0028 errors when ever you hit an httpd server which has that particular session. The only solution is to restart the httpd server. To reproduce: 1. create a script which does an ociplogon and then executes a statement. 2. hit reload several times to increase the chance you will hit an httpd after you kill a session which has already established a connection to the database. 3. on the server type: select username,sid,serial# from v$session where username = '<username you connected with in ociplogon>'; 4. do a: alter system kill session '<sid>,<serial#>'; for each of the sessions. 5. hit reload on your browser.