Bug #71708 [Fbk->Asn]: Oracle queries using oci_fetch_all causes Core Dumps

Edit report at https://bugs.php.net/bug.php?id=71708&edit=1 ID: 71708 User updated by: jodybrabec at gmail dot com Reported by: jodybrabec at gmail dot com Summary: Oracle queries using oci_fetch_all causes Core Dumps -Status: Feedback +Status: Assigned Type: Bug Package: OCI8 related Operating System: RHEL 6.7 PHP Version: 7.0.4 Assigned To: sixd Block user comment: N Private report: N New Comment: function my_oci_fetch_all($statement, &$output) { /*** * Workaround for oci_fetch_all - very similar to http://php.net/manual/en/function.oci-fetch-all.php * Uses oci_fetch_array iteratively (instead of oci_fetch_all which currently has problems whith 2+ query result set) * Fills &$output. Returns the number of rows in &$output. * ##### Needs More Testing - let us know if problems ##### * 2016-03-04 jodybrabec@gmail.com */ $rows = 0; $allCols = oci_num_fields($statement); $colNames = array(); for ($i_c = 1; $i_c <= $allCols; $i_c++) { $aColName = oci_field_name($statement, $i_c); $colNames[$aColName] = $aColName; // force unique via key } while (($row = oci_fetch_array($statement, OCI_RETURN_LOBS)) != false) { $rows++; foreach ($colNames as $i_c=>$aColName) $output[$aColName][] = $row[$aColName]; } return $rows; } Previous Comments: ------------------------------------------------------------------------ [2016-03-04 00:31:02] sixd@php.net What query/queries crash? Can you post some DDL to create a table that is known to crash - what data types are you using? Can you create a backtrace? Does PHP 5.6 / OCI8 2.0 also crash? ------------------------------------------------------------------------ [2016-03-03 20:21:08] jodybrabec at gmail dot com Description: ------------ Oracle queries using oci_fetch_all causes Core Dumps sometimes if more than one record result set. My setup: oracle-instantclient12.1-basic, OCI8 2.1.0, PHP 70, php70-php-cli (7.0.4-1.el6.remi - 2016-03-02), Red Hat EL 6.7, HTTPD 24 Observations on oci_fetch_all queries: 1. If the query return set contains only one record, no problems. 2. For more than one records return: Sometimes causes core dump (browser Error 500 Internal server error). a. If total return bytes is large, core dump probability increases (possible cap on rows * bytes per record per clumn cell) b. Or sometimes error on only 2+ records - yet removing various columns reduces error probability. c. Queries with "joins" increase error probability. Test script: --------------- // Cor dumps on many random queries - see Observations above $statement= oci_parse($connID, $query); oci_execute($statement) // ================= BAD, CORE DUMP: $numRows = oci_fetch_all($statement, $results); Expected result: ---------------- yum php70-php-cli (remi) was updated last night, but still no work. POSSIBLE WORKAROUND: // *********** (THIS DOES NOT WORK RIGHT NOW!!!!) ********** $allCols = oci_num_fields($st); $colNames = array(); for ($i_c = 1; $i_c <= $allCols; $i_c++) { $aColName = oci_field_name($statement, $i_c); $colNames[] = $aColName; } $numRows = 0; while (($row = oci_fetch_array($statement, OCI_BOTH)) != false) { $numRows++; foreach ($colNames as $i_c=>$aColName) $results[$aColName][] = $row[$aColName]; } Actual result: -------------- //~~~~~~~~~~~~~~~~~~~ CORE DUMP #> tail /var/log/messages Mar 2 22:17:17 node6 abrtd: Directory 'ccpp-2016-03-02-22:17:17-32306' creation detected Mar 2 22:17:17 node6 abrt[32307]: Saved core dump of pid 32306 (/opt/remi/php70/root/usr/bin/php-cgi) to /var/spool/abrt/ccpp-2016-03-02-22:17:17-32306 (11370496 bytes) Mar 2 22:17:17 node6 abrtd: Package 'php70-php-cli' isn't signed with proper key Mar 2 22:17:17 node6 abrtd: 'post-create' on '/var/spool/abrt/ccpp-2016-03-02-22:17:17-32306' exited with 1 Mar 2 22:17:17 node6 abrtd: Deleting problem directory '/var/spool/abrt/ccpp-2016-03-02-22:17:17-32306' ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=71708&edit=1