|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-10-12 15:57 UTC] tony2001@php.net
[2004-10-13 12:14 UTC] csecret at free dot fr
[2004-10-23 11:38 UTC] tony2001@php.net
[2004-10-28 23:17 UTC] bobsledbob at yahoo dot com
[2004-10-29 00:12 UTC] csecret at free dot fr
[2004-10-29 00:16 UTC] derick@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 23 14:00:02 2025 UTC |
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)