#47491 [Fbk->Opn]: Crash when executing a PDO/MYSQL query

ID: 47491 User updated by: pascal dot fellerich at ses-engineering dot com Reported By: pascal dot fellerich at ses-engineering dot com -Status: Feedback +Status: Open Bug Type: Reproducible crash Operating System: Win XP Pro SP3 PHP Version: 5.2.8 New Comment: One line of code was missing.... $sql = "SELECT * FROM users"; --- yes, with MySQL 5.1. But the crash also happens when I revert to MySQL 5.0.67 Previous Comments: ------------------------------------------------------------------------ [2009-02-24 13:32:50] pajoye@php.net And you use mysql 5.1 right? ------------------------------------------------------------------------ [2009-02-24 13:30:03] pascal dot fellerich at ses-engineering dot com Description: ------------ PHP crashes when executing a query using PDO/Mysql. PHP is running as an Apache 2.0 handler. In the Apache error log, this line appears: [notice] Parent: child process exited with status 3221225477 -- Restarting. Sometimes, even the new PDO() call crashes already, but to reproduce the bug easily, just do a SELECT * FROM mysql.user - voila. Set up: XAMPP 1.7.0 with Apache 2.2.11, PHP 5.2.8, MySQL 5.1.30. The same crash could be reproduced in a 'bastardized' XAMPP setup with MySQL 5.0.67. Conversely, the setup Apache 2.2.11, PHP 5.2.6, MySQL 5.1.30 was OK. No crashes here. Reproduce code: --------------- $pdo = new PDO("mysql:host=localhost; dbname=mysql", 'root', $mypassword); $pdo->exec("SET NAMES 'utf8'"); $result = $pdo->query($sql, PDO::FETCH_NUM); //...bye bye! Expected result: ---------------- Obvious. Actual result: -------------- Apache Error Log: [notice] Parent: child process exited with status 3221225477 -- Restarting. Nothing more available. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47491&edit=1