Bug #66283 [Fbk->Opn]: Segmentation fault

Edit report at https://bugs.php.net/bug.php?id=66283&edit=1 ID: 66283 User updated by: jan dot kahoun at heureka dot cz Reported by: jan dot kahoun at heureka dot cz Summary: Segmentation fault -Status: Feedback +Status: Open Type: Bug Package: MySQLi related Operating System: Centos 6.2 PHP Version: 5.4.22 Block user comment: N Private report: N New Comment: Try this new version of the test code. Just create table in MySQL and insert the test data. Then run the test script, with filled your database setting (user, password and database name) e.g. from CLI. Database setup: CREATE TABLE IF NOT EXISTS Test ( id int(10) unsigned NOT NULL AUTO_INCREMENT, parentId smallint(5) unsigned NOT NULL, seoId varchar(255) COLLATE utf8_czech_ci NOT NULL, name varchar(255) COLLATE utf8_czech_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO Test (id, parentId, seoId, name) values('1','1','seoId','name'),('2','1','seoId','name'); PHP test script: <?php ini_set('memory_limit', '1M'); $mysqli = mysqli_init(); // set your database setting here by replacing default values 'user', 'password', 'dbname' $mysqli->real_connect('127.0.0.1', 'user', 'password', 'dbname', 'port'); $sql = str_repeat("SELECT * FROM Test LIMIT 100; SELECT * FROM Test LIMIT 100;", 300); $mysqli->multi_query($sql); $retArr = array(); do { if ($res = $mysqli->store_result()) { $ret = array(); while ($row = $res->fetch_assoc()) { $ret[] = $row; } $res->free(); $retArr[] = $ret; } } while ($mysqli->next_result()); ?> Actual result: PHP Fatal error: Allowed memory size of 1048576 bytes exhausted (tried to allocate 6 bytes) in /home/web/index.php on line 16 PHP Stack trace: PHP 1. {main}() /home/web/index.php:0 PHP 2. mysqli_result->free() /home/web/index.php:16 Fatal error: Allowed memory size of 1048576 bytes exhausted (tried to allocate 6 bytes) in /home/web/index.php on line 16 Call Stack: 0.0002 234568 1. {main}() /home/web/index.php:0 0.0273 1046488 2. mysqli_result->free() /home/web/index.php:16 Segmentation fault (core dumped) Expected result: Only PHP Fatal error without "Segmentation fault (core dumped)". Previous Comments: ------------------------------------------------------------------------ [2013-12-13 18:14:23] krakjoe@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. The reproduce script provided cannot be executed outside of your environment since it contains custom code, you must provide a script that does not rely on code we cannot use, preferably a script with no dependencies. ------------------------------------------------------------------------ [2013-12-13 09:27:26] krakjoe@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2013-12-13 08:41:20] jan dot kahoun at heureka dot cz Description: ------------ Using mysqli and multi_query can sometimes lead to Segmentation fault when trying to free the result. Test script: --------------- http://codepad.org/WNxylU8G Expected result: ---------------- Just PHP Fatal error Actual result: -------------- PHP Fatal error: Allowed memory size of 96468992 bytes exhausted (tried to allocate 2 bytes) in /home/web/index.php on line 45 PHP Stack trace: PHP 1. {main}() /home/web/index.php:0 PHP 2. mysqli_result->free() /home/web/index.php:45 Fatal error: Allowed memory size of 96468992 bytes exhausted (tried to allocate 2 bytes) in /home/web/index.php on line 45 Call Stack: 0.0002 239480 1. {main}() /home/web/index.php:0 0.5828 96413160 2. mysqli_result->free() /home/web/index.php:45 Segmentation fault (core dumped) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=66283&edit=1