#30410 [Com]: exit signal Segmentation fault (11)

ID: 30410 Comment by: bobsledbob at yahoo dot com Reported By: csecret at free dot fr Status: Feedback Bug Type: OCI8 related Operating System: Solaris 8 PHP Version: 5.0.2 New Comment: I'm having this exact problem. I'm using the latest PHP src from CVS (php5-STABLE-200410281830), with no luck or resolve to this issue. Unfortuneatly, I can't easily produce a backtrace for you. :( Previous Comments: ------------------------------------------------------------------------ [2004-10-23 11:38:45] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip ------------------------------------------------------------------------ [2004-10-13 12:14:47] csecret at free dot fr I installed PHP 4.3.9 instead of 5 and no more problem... ------------------------------------------------------------------------ [2004-10-12 15:57:47] tony2001@php.net 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