ID: 30410 User updated by: csecret at free dot fr Reported By: csecret at free dot fr -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.0.2 New Comment:
I installed PHP 4.3.9 instead of 5 and no more problem... Previous Comments: ------------------------------------------------------------------------ [2004-10-12 15:57:47] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. ------------------------------------------------------------------------ [2004-10-12 15:54:21] csecret at free dot fr 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 this bug report at http://bugs.php.net/?id=30410&edit=1
