ID: 36895 Updated by: [EMAIL PROTECTED] Reported By: jsschuetz at knapheide dot com -Status: Open +Status: Feedback Bug Type: ODBC related Operating System: server2003/WinXP Pro PHP Version: 5.1.2 New Comment:
Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2006-04-12 13:30:47] jsschuetz at knapheide dot com I narrowed down the code causing the problem. The below is the entire program that will cause the error at random. I am connecting to a DB2 database on an AS400 Iseries with ODCB drivers provided by IBM client access software. --------------------------------------------------------- $con = odbc_connect('as400','username','password'); ?> <META HTTP-EQUIV="Refresh" CONTENT="2;URL=nester.php"> <BR /> Version 6 <br /> <? $SSnestfiles = "Select * from pdatalib.nestsumpf where nesalpha = 'D' order by NESDTE DESC, NESTIME DESC"; $SRnestfiles = odbc_exec($con,$SSnestfiles); while($nestfilearray = odbc_fetch_array($SRnestfiles)) { } The issue occurs with the odbc_fetch array call. If the "while($nestfilearray = odbc_fetch_array($SRnestfiles))" is commented out the code will run fine forever, with the statement in, there will be random crashes as described previously. The Meta refresh is simply there to keep executing the code because the error occurs at random. In a test environment I opened 6 instances of the program and allowed them to sit refreshing every 2 secs. The error would occur every 2 to 20 mins. With IIS, it would crash and need to be restarted with a PHP Access Violation, with Apache there would just be an event log and the Apache service would restart. ------------------------------------------------------------------------ [2006-03-28 17:22:24] jsschuetz at knapheide dot com Description: ------------ IIS and/or Apache on Server 2003 faulting application error and PHP has encountered an Access Violation at 000224b2 When running IIS with PHP 5.1.2.2 I get random crashes with the message PHP has encountered an Access Violation at 000224b2 and an error message in event viewer throws the message: Faulting application w3wp.exe, version 6.0.3790.1830, faulting module ntdll.dll, version 5.2.3790.1830, fault address 0x000224b2. I tried reinstalling IIS and PHP with no luck. To tried to fix the problem by installing Apache 2.0.55 instead thinking it might be an IIS problem. Now I don't see the Access Violation message, but I still get messages in event viewer that saying: Faulting application Apache.exe, version 2.0.55.0, faulting module ntdll.dll, version 5.2.3790.1830, fault address 0x000224b2. and Faulting application Apache.exe, version 2.0.55.0, faulting module cwbrw.dll, version 0.0.0.0, fault address 0x00007fbd. Reproduce code: --------------- I have not been able to isolate specific code that is causing this problem. The error seems to come at random and this is on a production server running many PHP apps. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36895&edit=1
