ID: 36634
User updated by: zhang_yinshu at yahoo dot com
Reported By: zhang_yinshu at yahoo dot com
-Status: Bogus
+Status: Open
Bug Type: OCI8 related
Operating System: Gentoo Linux
PHP Version: 5.1.2
New Comment:
v$process only show active sessions, use v$session please, and run your
test again.
Previous Comments:
------------------------------------------------------------------------
[2006-03-17 10:00:36] [EMAIL PROTECTED]
1) Set oci8.persistent_timeout to 10 seconds.
2) Restart Apache.
3) Open several persistent connections and check if they are present in
v$process.
4) Wait for 10 seconds.
5) Run _empty_ PHP script with just <?php ?> several times.
6) Check v$process.
7) Voila - connections are not there anymore!
No bug -> bogus.
------------------------------------------------------------------------
[2006-03-17 05:16:15] zhang_yinshu at yahoo dot com
can anybody look at this issue, anybody, whoever have knoweldge of
oracle database.
------------------------------------------------------------------------
[2006-03-07 18:02:14] zhang_yinshu at yahoo dot com
OMG, I was such a fool, I didnt wait 60sec. after that script use the
connection, ....oh, wait, i did wait. Actually no matter how long i
wait, connection hungup there as idel.
------------------------------------------------------------------------
[2006-03-07 08:38:07] [EMAIL PROTECTED]
oci_pconnect() means you're using these connections in a script, so
they do not timeout because of that.
No bug here.
------------------------------------------------------------------------
[2006-03-06 21:27:28] zhang_yinshu at yahoo dot com
a test script of course, use class:
<?
include ('db.class.php');
$db=new db('xxxxx','xxxx','xxxxxx');
$db->query("select * from tab");
echo $db->to_string();
?>
part of db.class.php:
function db_open($user,$pass,$db)
{
if (!$this -> _connection = oci_pconnect($user,$pass,$db)) {
err ("Can not open database connection user:$user,db:$db,
error:".print_r(ocierror()));
$this->__destruct();
}
}
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/36634
--
Edit this bug report at http://bugs.php.net/?id=36634&edit=1
