ID: 29724 Comment by: andrej at seznam dot org Reported By: bojo at gvea dot com Status: No Feedback Bug Type: Reproducible crash Operating System: Windows 2003 Server PHP Version: 5.0.1 New Comment:
This error is following me on 3 different server configs, from php 4 version on. I encountered this error on combination of: - Windows server (XP, 2000 server, 2003 server) - IIS 5.0, 5.1 and 6.0 - PHP from 4 to latest 5.1.0b2 - MySQL from versions 4.0.x to latest 5.0.7 beta3 Finally, I was able to reproduce the bug and eliminate it! But only in one single case: This PHP code produced Access Violation; It is only weird, that the EXACT THE SAME code worked without problems for months, but then, suddenly, it begins constantly producing Access Violation error: for($i=0;$i<$rows;$i++) { $sqls="UPDATE sms_log SET delivered_date=\"$delivered_date[$i]\", send_date=\"$send_date[$i]\", delivered_status=\"$state[$i]\" WHERE msg_id=\"$msg_id[$i]\" AND to_user RLIKE $to_user[$i]"; $rs=mysql_query($sqls); } Now, I only changed the UPDATE to UPDATE LOW_PRIORITY, and Error was gone! Notise the only difference of UPDATE priorite switch: for($i=0;$i<$rows;$i++) { $sqls="UPDATE LOW_PRIORITY sms_log SET delivered_date=\"$delivered_date[$i]\", send_date=\"$send_date[$i]\", delivered_status=\"$state[$i]\" WHERE msg_id=\"$msg_id[$i]\" AND to_user RLIKE $to_user[$i]"; $rs=mysql_query($sqls); } The only concern I have is that the whole loop of queries took quite a long time to execute, even if they were executed in some other PHP application. I did tests with phpMyAdmin program, and inserted the whole bunch of about 50 queries from the mentioned loop into SQL query textbox. It took around a minute to execute! BUT if I executed the SAME bunch of queries from the command prompt, directly to MySQL, it executed in a second! THEREFORE it is NOT MySQL issue, but is related to how PHP executes MySQL statements. It might me php_mysql.dll library, might be libmysql.dll, or PHP core itself. Hope this would help with determining the cause of this wide spread and unpredictable error. Previous Comments: ------------------------------------------------------------------------ [2004-09-04 01:00:02] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2004-08-18 02:29:50] [EMAIL PROTECTED] Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2004-08-18 00:44:45] bojo at gvea dot com Description: ------------ The original bug found in PHP 5.0.0, referenced here: http://bugs.php.net/bug.php?id=29127 was never actually resolved. PHP 5.0.1 continues to give the following error under IIS 6.0 on Windows 2003 Server: PHP has encountered an Access Violation at [random memory address]. Expected result: ---------------- Page processes completely. Actual result: -------------- Program bails with the following error: PHP has encountered an Access Violation at [random memory address] ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29724&edit=1