ID: 47463
Comment by: fabio dot scala at swisscom dot com
Reported By: fabio dot scala at swisscom dot com
Status: Feedback
Bug Type: PDO related
Operating System: Windows Server 2003 SP2
PHP Version: 5.2CVS-2009-02-20 (CVS)
New Comment:
I managed to fix the problem by using XDebug. Anyway, it seems that we
used bindValue() more than once on the same prepared statement with the
same parameter. Once I removed the redundant bindValue() it seemed to
work.
$stmt->bindValue(":dateEnd", create_mssql_date_day($dateEnd));
$stmt->bindValue(":dateEnd", create_mssql_date_day($someOtherDate));
Executing works, but PHP crashes after the first fetch().
So actually at least this PHP Access Violation problem is resolved for
us (we usually get some in other apps, but I have no clue why yet)
I hope you guys will be able to reproduce this somehow.
Previous Comments:
------------------------------------------------------------------------
[2009-02-21 11:15:25] fel...@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.
------------------------------------------------------------------------
[2009-02-20 11:35:33] fabio dot scala at swisscom dot com
Description:
------------
Environment:
Microsoft Windows Server 2003 SP2
PHP 5.2.9RC3-dev (cli) (built: Feb 19 2009 11:40:00)
IIS 6 with ISAPI (already tried FastCGI)
Changes Made to php.ini-dist:
extension=php_pdo.dll
extension=php_pdo_mssql.dll
Error:
Browser Output: PHP has encountered an Access Violation at <Address>
CLI: No output at all, the process just ends/crashes.
Description:
Unfortunately I'm not sure when this happens exactly, I've been able to
reproduce it in our web application by always using certain parameters
for the same action. It seems to happen when the data fetched from the
MSSQL Server increases (more rows fetched = crash).
Sadly we have been having these kind of problems for a year now.
Earlier with 5.1.6, now it's 5.2.8. They just seem to pop out of nowhere
randomly and most of the times a restart of the IIS is necessary. This
Access Violation here is the only one I've been able to *reproduce*
(well kinda).
Reproduce code:
---------------
As it's not really a what you can call a *small* web application and it
only happens when the SQL statement changes (to return more rows), I
wasn't able to reproduce this Error with a small PHP Script.
Expected result:
----------------
-
Actual result:
--------------
DebugDiag CrashHang Report:
http://homepage.hispeed.ch/fabioscala/CrashHang_Report__PID_4012__02202009120132378.htm
DebugDiag Memory_Report:
http://homepage.hispeed.ch/fabioscala/Memory_Report__PID_4012__02202009120056456.htm
Created on our integration server, the production has different
hardware but the same OS. (PHP crashes on both servers of course,
meaning it's not a defect RAM/hardware issue.)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=47463&edit=1
