#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Win: php 5.0.3 + mysql 4.1.7 - ok php 5.0.3 + mysql 5.0.16 - crash php 5.0.5 + mysql 5.0.15 - crash php 5.1 + mysql 5.0.16 - crash php 5.1.2-dev + mysql 5.0.16 - crash php 5.1.2-dev + mysql 4.1.15 - ok Linux: php 5.0.5 + mysql 4.1.13 - ok Thats all I can tell u for now. Previous Comments: [2005-11-28 13:24:05] [EMAIL PROTECTED] 1) Try to downgrade MySQL on Windows and see if it changes anything. 2) Try to upgrade MySQL on Linux and see if it changes anything. This is so obvious, isn't it? [2005-11-28 13:20:21] marcing at smlw dot pl Im not sure how to help You, what else can i do? [2005-11-28 13:20:16] [EMAIL PROTECTED] Yeah, I'd appreciate if you find answers for these questions. [2005-11-28 13:18:34] marcing at smlw dot pl Maybe >= 5.0.15 mysql is required? or maybe it is only windows platform issue. [2005-11-28 13:18:26] [EMAIL PROTECTED] As you may understand, the screenshot is not a backtrace and doesn't help in any way. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Im not sure how to help You, what else can i do? Previous Comments: [2005-11-28 13:20:16] [EMAIL PROTECTED] Yeah, I'd appreciate if you find answers for these questions. [2005-11-28 13:18:34] marcing at smlw dot pl Maybe >= 5.0.15 mysql is required? or maybe it is only windows platform issue. [2005-11-28 13:18:26] [EMAIL PROTECTED] As you may understand, the screenshot is not a backtrace and doesn't help in any way. [2005-11-28 13:15:35] marcing at smlw dot pl Here's there crash itself - http://pl.maze.pl/tmp/crash.jpg It takes 100% of CPU and then the crash... [2005-11-28 13:06:12] [EMAIL PROTECTED] Works fine on Linux with MySQL 5.0.13. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Maybe >= 5.0.15 mysql is required? or maybe it is only windows platform issue. Previous Comments: [2005-11-28 13:18:26] [EMAIL PROTECTED] As you may understand, the screenshot is not a backtrace and doesn't help in any way. [2005-11-28 13:15:35] marcing at smlw dot pl Here's there crash itself - http://pl.maze.pl/tmp/crash.jpg It takes 100% of CPU and then the crash... [2005-11-28 13:06:12] [EMAIL PROTECTED] Works fine on Linux with MySQL 5.0.13. [2005-11-28 12:55:47] marcing at smlw dot pl Its not happening when using mysql ext, so im pretty sure its mysqli. [2005-11-28 12:53:17] marcing at smlw dot pl Thats the code to reproduce the crash: http://pl.maze.pl/tmp/test.php.txt Its used with this table - http://pl.maze.pl/tmp/db_table.sql But i dont think thats the only piece of code that causes the crash. just run http://localhost/test.php, then hit f5 and u should encouter it. (i can be only win platform related) ill do some further research in the meantime. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Here's there crash itself - http://pl.maze.pl/tmp/crash.jpg It takes 100% of CPU and then the crash... Previous Comments: [2005-11-28 13:06:12] [EMAIL PROTECTED] Works fine on Linux with MySQL 5.0.13. [2005-11-28 12:55:47] marcing at smlw dot pl Its not happening when using mysql ext, so im pretty sure its mysqli. [2005-11-28 12:53:17] marcing at smlw dot pl Thats the code to reproduce the crash: http://pl.maze.pl/tmp/test.php.txt Its used with this table - http://pl.maze.pl/tmp/db_table.sql But i dont think thats the only piece of code that causes the crash. just run http://localhost/test.php, then hit f5 and u should encouter it. (i can be only win platform related) ill do some further research in the meantime. [2005-11-28 12:33:02] [EMAIL PROTECTED] 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 , is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. We're still unable to reproduce it. [2005-11-28 12:29:04] marcing at smlw dot pl It seems that whole mysqli code has to be revised, since it still is very unstable, i think that other queries cause the crashes too, like some inserts for example... the SUM crash is not fixed in latest snapshot, and it seems that there r many more bugs and i still can't get my app to work (its using mysql heavily), i still get crashes and strange behaviours. If any developer is willing i can provide him with the code of this app so he can see what im talking about. Just write ur e-mail and ill contact u. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Thats the code to reproduce the crash: http://pl.maze.pl/tmp/test.php.txt Its used with this table - http://pl.maze.pl/tmp/db_table.sql But i dont think thats the only piece of code that causes the crash. just run http://localhost/test.php, then hit f5 and u should encouter it. (i can be only win platform related) ill do some further research in the meantime. Previous Comments: [2005-11-28 12:33:02] [EMAIL PROTECTED] 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 , is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. We're still unable to reproduce it. [2005-11-28 12:29:04] marcing at smlw dot pl It seems that whole mysqli code has to be revised, since it still is very unstable, i think that other queries cause the crashes too, like some inserts for example... the SUM crash is not fixed in latest snapshot, and it seems that there r many more bugs and i still can't get my app to work (its using mysql heavily), i still get crashes and strange behaviours. If any developer is willing i can provide him with the code of this app so he can see what im talking about. Just write ur e-mail and ill contact u. [2005-11-28 01:25:55] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip It's very much likely that this was already fixed. [2005-11-28 01:22:19] marcing at smlw dot pl Im sorry, but i tried for 2 hours and i cant get mysqli to work under linux, winxp will have to be enough:( [2005-11-27 23:28:31] [EMAIL PROTECTED] You don't have to *upgrade* it, you can install as much MySQL servers/clients as you want if you place it in different directories. The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: It seems that whole mysqli code has to be revised, since it still is very unstable, i think that other queries cause the crashes too, like some inserts for example... the SUM crash is not fixed in latest snapshot, and it seems that there r many more bugs and i still can't get my app to work (its using mysql heavily), i still get crashes and strange behaviours. If any developer is willing i can provide him with the code of this app so he can see what im talking about. Just write ur e-mail and ill contact u. Previous Comments: [2005-11-28 01:25:55] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip It's very much likely that this was already fixed. [2005-11-28 01:22:19] marcing at smlw dot pl Im sorry, but i tried for 2 hours and i cant get mysqli to work under linux, winxp will have to be enough:( [2005-11-27 23:28:31] [EMAIL PROTECTED] You don't have to *upgrade* it, you can install as much MySQL servers/clients as you want if you place it in different directories. [2005-11-27 23:25:32] marcing at smlw dot pl Unfortunately i cannot reproduce it on unix at the moment (have to upgrade the mysql), but ill gladly provide further information on windows. hint: it is essential to create a table with content, im not sure if i provided enough of it;) [2005-11-27 21:20:36] [EMAIL PROTECTED] I can't reproduce it. Can you try it on an *nix OS ? The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Im sorry, but i tried for 2 hours and i cant get mysqli to work under linux, winxp will have to be enough:( Previous Comments: [2005-11-27 23:28:31] [EMAIL PROTECTED] You don't have to *upgrade* it, you can install as much MySQL servers/clients as you want if you place it in different directories. [2005-11-27 23:25:32] marcing at smlw dot pl Unfortunately i cannot reproduce it on unix at the moment (have to upgrade the mysql), but ill gladly provide further information on windows. hint: it is essential to create a table with content, im not sure if i provided enough of it;) [2005-11-27 21:35:49] [EMAIL PROTECTED] Please, instead of adding "me too!" comments try to make a research and find the cause. [2005-11-27 21:24:43] dooshek at desmart dot com I have the same problem with the same script. My env: Windows XP SP2 Apache 2.0.55 MySQL 5.0.15 PHP 5.0.5 My Apache hangs during script execution. [2005-11-27 21:20:36] [EMAIL PROTECTED] I can't reproduce it. Can you try it on an *nix OS ? The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/35428 -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1
#35428 [Fbk->Opn]: using mysqli with MySQL 5.0.16 causes Apache crash
ID: 35428 User updated by: marcing at smlw dot pl Reported By: marcing at smlw dot pl -Status: Feedback +Status: Open Bug Type: MySQLi related Operating System: WinXP SP2 PHP Version: 5.1.0 New Comment: Unfortunately i cannot reproduce it on unix at the moment (have to upgrade the mysql), but ill gladly provide further information on windows. hint: it is essential to create a table with content, im not sure if i provided enough of it;) Previous Comments: [2005-11-27 21:35:49] [EMAIL PROTECTED] Please, instead of adding "me too!" comments try to make a research and find the cause. [2005-11-27 21:24:43] dooshek at desmart dot com I have the same problem with the same script. My env: Windows XP SP2 Apache 2.0.55 MySQL 5.0.15 PHP 5.0.5 My Apache hangs during script execution. [2005-11-27 21:20:36] [EMAIL PROTECTED] I can't reproduce it. Can you try it on an *nix OS ? [2005-11-27 21:12:56] marcing at smlw dot pl Description: Env: Windows XP SP2 Apache 2.0.48 / 2.0.55 (not relevant) MySQL 5.0.16 PHP 5.0.3 /5.1 (not relevant) MySQLi Important: Problem is related to MySQLi when using MySQL version 5 only, it doesn't occur with version 4. Reproduce code: --- prepare('SELECT SUM(visitors) FROM core_stats')) { $stmt->execute(); $stmt->bind_result($total); $stmt->close(); } ?> The problem occurs when using SUM() in query, endless loop seems to start when $stmt->bind_result($total) is invoked and as a result Apache crashes. Database reproduction code: -- CREATE TABLE `core_stats` ( `id` int(10) unsigned NOT NULL auto_increment, `day_of_week` int(1) unsigned NOT NULL default '0', `day_of_month` int(2) unsigned NOT NULL default '0', `m` int(2) unsigned NOT NULL default '0', `y` int(4) unsigned NOT NULL default '0', `visitors` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `core_stats` VALUES (1, 2, 5, 7, 2005, 1); INSERT INTO `core_stats` VALUES (2, 3, 6, 7, 2005, 6); INSERT INTO `core_stats` VALUES (3, 4, 7, 7, 2005, 7); INSERT INTO `core_stats` VALUES (4, 5, 8, 7, 2005, 1); Expected result: It should work as it worked on MySQL 4. Actual result: -- Internal Server Error -- Edit this bug report at http://bugs.php.net/?id=35428&edit=1