From: csecret at free dot fr
Operating system: Solaris 8
PHP version: 5.0.2
PHP Bug Type: Oracle related
Bug description: exit signal Segmentation fault (11)
Description:
------------
When I ask Oracle for a query, I have sometimes (8 times out of 10) this
error :
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session OCIHandleAlloc
OCI_HTYPE_SVCCTX: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SERVER: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SESSION: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCISessionEnd:
OCI_INVALID_HANDLE in Unknown on line 0
[Tue Oct 12 15:45:35 2004] [notice] child pid 820 exit signal Segmentation
fault (11)
I tried to find everywhere on internet for the solution, but.......
The code which generate this error is :
while (OCIFetchInto ($this->query, $this->results[], OCI_ASSOC)) {}
When the results is too big, the adding to the table stop, that cause 75%
the table seen in the web !
Thanks if you can help me...
JMD
Reproduce code:
---------------
function exe_select($query)
{
$this->nbresults = 0;
$this->results=array();
// Test de la connexion à la bdd
if (($this->verif != "nok") && ($this->verif !=
"ok")){$this->verif =
"nok";}
// Si la connexion est ok, on lance la requête
else
{
// Lancement de la requête
$this->query = oci_parse($this->connection, $query);
if (oci_execute($this->query))
{
//print '********************************** OK
****************************';
// On récupère le nbre de colonne
$this->numCols = oci_num_fields($this->query);
//print '<pre>';print_r($this->query);print'</pre>';
//$jmi=0;
while (OCIFetchInto ($this->query, $this->results[], OCI_ASSOC)) {
}
$this->verif1 = "ok";
}
else
{
//print '********************************** PAS OK
****************************';
$this->verif1 = "nok";
}
}
// -- Pour le mode debug : Mettre en commentaire
//error_reporting(1);
return $this->verif1;
}
Expected result:
----------------
The fill my $this->results variable
Actual result:
--------------
When the results is too big, the adding to the table stop, that cause 75%
the table seen in the web !
and segmentation fault error !
And the log show that :
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session OCIHandleAlloc
OCI_HTYPE_SVCCTX: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SERVER: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SESSION: OCI_INVALID_HANDLE in Unknown on line 0
[client 0.0.0.0] PHP Warning: Unknown: _oci_close_session: OCISessionEnd:
OCI_INVALID_HANDLE in Unknown on line 0
[Tue Oct 12 15:45:35 2004] [notice] child pid 820 exit signal Segmentation
fault (11)
--
Edit bug report at http://bugs.php.net/?id=30410&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30410&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30410&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30410&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=30410&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=30410&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=30410&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=30410&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=30410&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=30410&r=support
Expected behavior: http://bugs.php.net/fix.php?id=30410&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=30410&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=30410&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=30410&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30410&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=30410&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=30410&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=30410&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=30410&r=float
MySQL Configuration Error: http://bugs.php.net/fix.php?id=30410&r=mysqlcfg