|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2009-02-20 11:35 UTC] 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.) PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 21:00:02 2025 UTC |
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.