#18933 [Com]: MSSQL issues under stress
ID: 18933 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: win2k PHP Version: 4.2.2 New Comment: Looks like two separate bugs. #1 - this would be a problem with your MS SQL server settings. Not a PHP issue. #2, #3, #4 - are you running as an ISAPI or CGI? There are issues with PHP ISAPI under stress. Previous Comments: [2002-08-15 20:43:32] [EMAIL PROTECTED] The MSSQL extension seems to have a few issues under heavy stress. Running a similar test with a mysql server produces no errors: Running the above test script produces the following error log entries: 1. MS SQL: Unable to connect to server: 127.0.0.1 --> mysql doesn't fail taking new connections, but that error could be a server config setting. 2. Corrupt Log file Entries e.g. : ndex.php on line 3 2 ine 8 tdocs\php\index.php on line 8 3. Failure connecting to server "null": MS SQL: Unable to connect to server: (null) (should be 127.0.0.1) 4. Attempting to connect as a null user: MS SQL message: Login failed for user '(null)'. (should be "1") Paul -- Edit this bug report at http://bugs.php.net/?id=18933&edit=1
#17563 [Com]: PHP has encountered an Access Violation at 77XXXXX
ID: 17563 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: WIN2K PHP Version: 4.2.1 New Comment: Can you please be very specific about your table and column names. The ODBC driver doesn't handle odd names very well. There's a big difference between: SELECT * FROM froo SELECT * FROM [FR oO] Previous Comments: [2002-08-25 23:54:30] [EMAIL PROTECTED] Yes, try that first, after recreate the data field, I have no problem afterwards. You can use the mssql.dll if you want~ I use that in all time, I don't like ODBC, [2002-08-25 00:51:28] [EMAIL PROTECTED] Hi I Have this problem Too I use an Odbc conennection on Win2000 prof and IIS ver 5 I try to fetch some data from my database by this lines : $query="Select username,name,family,Sex,pic,pic_type ,about from [users]"; ... ... $username = odbc_result($result, 1); $name = odbc_result($result, 2); this page is work probebly at first time but after some refreshing I recive "PHP has encountered an Access Violation at X" only at this page and other .php page is work probebly; I install PHP on my computer in ISAPI mode in my users table "Pic_type" and "about" allow null I rename these fieldes but not effect . you say I remove this field's and add them again ? is it effective? I try it but not sure thank's [2002-06-08 20:28:34] [EMAIL PROTECTED] Server Version: MSSQL Server 2000 Operating System: WIN2K Server Database Details: The error field is smallmoney, allow null. Error Solution: I've tried rename it with other field which is also 'smallmoney' and 'allow null', but problem does not solve this way. The only way to solve this problem is to remove that field and create another new field again. Notice: Notice that the field works fine inside the MSSQL server's 'Query Analyzer', no error occur inside MSSQL server itself, but it produce error with the PHP engine. How does the bug act like: This error might not hang the whole php engine in first few times you recieve the message "PHP has encountered an Access Violation at ", but it will eventually hang when you load that page few more times. [2002-06-08 05:05:19] [EMAIL PROTECTED] That's a start (and probably not a duplicte). But we need more information. What vrsion of MSSQL ? And type was this field of ? Can you reproduce this by creating a second field exactly as the first which crashes, which crashes too ? Please be as detailed as possible about the database setup and the field in general (so someone with the appropriate environment can rebuild this scenery), thx. [2002-06-08 04:54:26] [EMAIL PROTECTED] GUYS!! Found it, as I said, there is one field have error, I remove that field and add another field that is exactly the same datatype and everything and the problem solved. Try it out. 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/17563 -- Edit this bug report at http://bugs.php.net/?id=17563&edit=1
#16411 [Com]: CGI application misbehaved by not returning a complete set of
ID: 16411 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: What are you doing with your database connections? Are they persistant (mssql_pconnect) or transient (mssql_connect)? Do you close your connections explicitly (mssql_close) before the end of your script? vielina, your connections will be closed each time as you are running under the CGI. Previous Comments: [2002-11-21 03:29:36] [EMAIL PROTECTED] I have this problem too. [2002-06-20 15:19:45] [EMAIL PROTECTED] Same problem, slightly different case... win2000 running php.exe 4.2.1 (and mssql 2000) seems to happen mostly during redrects like... header("Method: GET"); header("Status: 302 Moved"); header("Location: ". $ABSOLUTE_URL); some claim they solved this problem by applying the workaround by microsoft (Q160422). others say they have fixed this by blanking out the doc_root in php.ini I still have this problem [2002-06-02 22:14:18] [EMAIL PROTECTED] I did that but it still did not work. I further tested another way: I left every thing as it was, except that I did not open an MSSQL connection. The script worked pretty well. When I changed it back, the same type of bug happened. When looking at phpinfo, even with the latest php version (4.2.1) I saw that in the MSSQL support section, the MSSQL library version was 7.0. Is this a potential source of that bug? Loi Le V. [2002-06-02 17:53:17] [EMAIL PROTECTED] Please try it again with a right header like Location: http://www.domain.tld/some.php. Location header needs a complete absolute URI. Regards, Kai [2002-04-03 09:46:44] [EMAIL PROTECTED] I have the same set of php scripts, php 4.0.6 CGI running on: 1-Windows NT 4.0 with IIS4, MySQL, MS-SQL 7; this works fine; 2-Windows 2000 server with IIS5, MySQL, MS-SQL 7; this works fine; 3-Windows 2000 advanced server with IIS5, MySQL, MS-SQL 7; this works fine; 4-Windows 2000 advanced server with IIS5, MySQL, MS-SQL 2000; this still works except that a curious error occurs: Im using a lot of Header ("location: some.php") for redirections. In this particular installation, right after the call of header function, the browser still gets the right URI, but then it issues the following error (a copy again here): CGI ERROR CGI application misbehaved by not returning a complete set of headers.The headers that it did return are: The funny thing was that if I refresh the page then it works just fine. When I look back at the 4 installations, the only difference was the installation 4: MS-SQL 2000. I later made another test: from the installation 3, I made an upgrade of MS SQL from 7.0 to 2000. The same problem happened. I have tested with php 4.1.2 and 4.0.6. I had the same symptoms with both versions Is there anything in php_mssql that does the job with MS-SQL 2000 but has some sort of side-effect that causes the above strange bug? Would any one spend time looking into the code? It would help us a lot. Thank you very much! Loi Le V. -- Edit this bug report at http://bugs.php.net/?id=16411&edit=1
Bug #12184 Updated: PHP has encountered an Access Violation at 0129E68A
ID: 12184 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: IIS related Operating System: Windows 2000 Server PHP Version: 4.0.6 New Comment: 1. Make sure "Cache applications" is ticked. It's when PHP gets unloaded that it has Access Violations. 2. Run iisreset.exe Previous Comments: [2001-07-16 04:55:59] [EMAIL PROTECTED] I'm following this step " Under 'Home Directory', click on the 'Configuration' button. Add a new entry to the Application Mappings. Use the path to the php4isapi.dll as the Executable, supply .php as the extension, leave Method exclusions blank, and check the Script engine checkbox." and when I get "PHP has encountered an Access Violation at 0129E68A" in my Web browser -- Edit this bug report at http://bugs.php.net/?id=12184&edit=1
Bug #16773 Updated: ISAPI application dies
ID: 16773 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: IIS related Operating System: Windows 2000 Server PHP Version: 4.2.0 New Comment: Loaded modules are php_mssql.dll and php_socket.dll Under the Home Directory tab, clicking "Unload" will return things to normal. As this appears to be a flaw in the memory management, would unticking "Cache ISAPI Applications" help? Previous Comments: [2002-04-23 18:33:26] [EMAIL PROTECTED] Sorry for the unhelpful title, but the PHP ISAPI filter dies, leaving the below messages in the logs. One page would not load, and then subsequent pages were "PHP has encountered an Access Violation at 77FCB2A7". The page always loads fast - all it does are a couple of MS SQL queries via an abstraction library (namdal-ms.php). open_database() calls mssql_pconnect() Application protection is "Low" as recommended in bug #15333. PHP error log: [24-Apr-2002 10:21:54] PHP Fatal error: Cannot redeclare open_database() (previously declared in namdal-ms.php:39) in namdal-ms.php on line 38 [24-Apr-2002 10:22:16] PHP Fatal error: Maximum execution time of 30 seconds exceeded in namdal-ms.php on line 68 Windows Event Viewer (System): Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_request_startup + 0x1F0 + 0xFBBE824 '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' ntdll!RtlSizeHeap + 0x78 ntdll!RtlFreeHeap + 0x100 php4ts!shutdown_memory_manager + 0x1BC '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:22:16 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. -- Edit this bug report at http://bugs.php.net/?id=16773&edit=1
Bug #16773: ISAPI application dies
From: [EMAIL PROTECTED] Operating system: Windows 2000 Server PHP version: 4.2.0 PHP Bug Type: IIS related Bug description: ISAPI application dies Sorry for the unhelpful title, but the PHP ISAPI filter dies, leaving the below messages in the logs. One page would not load, and then subsequent pages were "PHP has encountered an Access Violation at 77FCB2A7". The page always loads fast - all it does are a couple of MS SQL queries via an abstraction library (namdal-ms.php). open_database() calls mssql_pconnect() Application protection is "Low" as recommended in bug #15333. PHP error log: [24-Apr-2002 10:21:54] PHP Fatal error: Cannot redeclare open_database() (previously declared in namdal-ms.php:39) in namdal-ms.php on line 38 [24-Apr-2002 10:22:16] PHP Fatal error: Maximum execution time of 30 seconds exceeded in namdal-ms.php on line 68 Windows Event Viewer (System): Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_request_startup + 0x1F0 + 0xFBBE824 '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:21:54 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' ntdll!RtlSizeHeap + 0x78 ntdll!RtlFreeHeap + 0x100 php4ts!shutdown_memory_manager + 0x1BC '. Event Type: Error Event Source: WAM Event Category: None Event ID: 204 Date: 24/04/2002 Time: 10:22:16 a.m. User: N/A Computer: ... Description: The HTTP server encountered an unhandled exception while processing the ISAPI Application ' php4ts!php_execute_script + 0x16A '. -- Edit bug report at http://bugs.php.net/?id=16773&edit=1 -- Fixed in CVS:http://bugs.php.net/fix.php?id=16773&r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=16773&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16773&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16773&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16773&r=support Expected behavior: http://bugs.php.net/fix.php?id=16773&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16773&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16773&r=submittedtwice
Bug #15333 Updated: strndup access violation
ID: 15333 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Critical Bug Type: IIS related Operating System: Windows 2000 Pro PHP Version: 4.2.0 RC2 New Comment: There is a tool called "tkill" / kill / tlist that will let you terminate processes. Get the PID from tlist or Task Manager and then run kill with the PID for the argument. inetinfo.exe will be running under a different user that Administrator does not have the power to kill the processes of, so using Task Manager to kill inetinfo.exe is a waste of time. Previous Comments: [2002-04-21 06:32:35] [EMAIL PROTECTED] I tried setting the app protection to 'Low (IIS Process)' and still get the error. And I tried killing inetinfo.exe and running the net stop commands from the command line, but Windows won't kill the process. This issue has turned out to be the biggest reason my I haven't embraced PHP yet -- because I hate rebooting my machine all of the time. I would love to hear of a workaround that works, and better yet, see a published fix. Any more ideas out there? [2002-04-17 15:19:04] [EMAIL PROTECTED] I am getting this error with 4.2.0 RC2. I upgraded from 4.1.2 to 4.2.0 RC2 (both ISAPI) because 4.1.2 wasn't handling sessions correctly. I tried setting the app protection to 'Low (IIS Process)' and all I received were 'Invalid access to memory location' errors. PHP 4.2.0 RC2 (ISAPI) IIS5 Win2K Pro SP2 PIII 733MHz 384 MB RAM [2002-04-17 01:29:45] [EMAIL PROTECTED] I am also receiving this error with: Win2k Server SP2 w/all security patches But I am running PHP 4.1.2 ISAPI under IIS 5.0 Thanks. [2002-04-09 08:14:55] [EMAIL PROTECTED] I have been super busy lately, but, since I switched the app protection down to 'Low (IIS Process)' a week ago I haven't gotten a single error or lock up. Thanks for your persistance. Still using 4.1.2. [2002-04-08 12:04:38] [EMAIL PROTECTED] Ok. It definitely happens with RC2. You can restart IIS without rebooting, you've got to perform the following: kill the inetinfo.exe process using the task manager run from command line: net stop w3svc net stop iisadmin net start iisadmin net start w3svc Marking this bug critical because it should be fixed before 4.2.0 release. Still looking for fix. 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/15333 -- Edit this bug report at http://bugs.php.net/?id=15333&edit=1
Bug #16325: Memory leak causes DLLHOST to become large
From: [EMAIL PROTECTED] Operating system: Windows 2000 Server PHP version: 4.1.2 PHP Bug Type: IIS related Bug description: Memory leak causes DLLHOST to become large The setup: IIS5 has an ISAPI application mapping to php4isapi.dll Steps to reproduce: - Start IIS - Generate heavy load (~40+ hits / second) - Watch DLLHOST in the Task Manager. It takes more and more memory (40 - 45MB) - PHP error log begins reporting spurious errors (the page has no errors, but under heavy load it starts complaining about duplicate function definitions) Bug: #13324 - IIS stops serving PHP files but still serves static content DLLHOST disappears from the task list at this point. Other times it may begin taking 100% CPU and need to be terminated by hand. Killing DLLHOST usually causes it to be restarted and requests continue being served. Otherwise you may end up alternating between the two errors on bug #13324. -- Edit bug report at http://bugs.php.net/?id=16325&edit=1 -- Fixed in CVS:http://bugs.php.net/fix.php?id=16325&r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=16325&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16325&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16325&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16325&r=support Expected behavior: http://bugs.php.net/fix.php?id=16325&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16325&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16325&r=submittedtwice
Bug #13324 Updated: Access violations / memory problems
ID: 13324 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: IIS related Operating System: Windows 2000 SP2 PHP Version: 4.0.6 New Comment: I've reproduced this without Zend Optimizer. Under heavy load (45 requests / second) I received a number of errors about being unable to redeclare functions. Under low load there were no complaints. PHP 4.2.0 / IIS 5 / Windows 2000 Previous Comments: [2002-02-19 08:55:18] [EMAIL PROTECTED] Are you using Zendencoder? I have the same problem on a machine running Zendoptimizer with some pages that were Zendencoded. The server crashed every 20-30 request or so. I took off the pages Zendencoded and its working fine now... Seems that the problem stands there...It is not the Zendoptimizer, cause it is still in the php.ini and it works fine. [2001-09-15 20:50:27] [EMAIL PROTECTED] After further investigation, this seems to be a hint to a higher IIS threading problem rather than a problem specific to Zend Optimizer. If I create a php page with the function getmicrotime() in it and then call this page from 5 different browser windows at about the same time, I receive the following error: Fatal error: Cannot redeclare getmicrotime() in C:\Websites\mysqlconnect.php on line 2 I've also confirmed that variables declared within the realm of the script are also available to other browser sessions. For example, creating a random number in a script and then executing a time consuming for-loop will result in more than one window ending up with the same random number. [2001-09-15 20:12:40] [EMAIL PROTECTED] As a follow-up, with ZendOptimizer.dll uncommented in the php.ini file: Each IIS restart and request to the php webpage will result in a new instance DLLHOST.exe being created in the Windows Task Manager. Older DLLHost.exe instances are not released with IIS Reset. [2001-09-15 19:45:40] [EMAIL PROTECTED] This is a fresh install of PHP 4.0.6 on a new install of Windows 2000 server with service pack 2. Zend Optimizer is installed and the site is in Medium (pooled) mode. I am using the php4isapi.dll. There are no other programs or services installed on this machine. The code executing is a single pconnect request to a MYSQL server and then a mysql_close() request. The code is not Zend optimized. If I enable ZendOptimizer.dll in the php.ini and execute the code, it operates fine. But if I reset the IIS service, the server returns the following 2 errors randomly: 1) -2147417842 (0x8001010e) 2) Invalid access to memory location. If I comment out the ZendOptimizer.dll in the PHP.ini file and then restart the web service, operation resumes as normal. I believe the IIS Web Service is not releasing the ZendOptimizer.dll from memory and then trying to reload it when PHP is called. This may be a hint to all the access violations every one is getting. -- Edit this bug report at http://bugs.php.net/?id=13324&edit=1
Bug #13098 Updated: Problems to bring up IIS after shutting it down through a command prompt.
ID: 13098 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: IIS related Operating System: Microsoft Windows 2000 PHP Version: 4.0.6 New Comment: Are you sure this is a PHP-related bug? You may have misconfigured IIS. (Close this report?) Previous Comments: [2001-09-02 18:03:11] [EMAIL PROTECTED] I read the Beginning PHP4 book from Wrox. When I got myself to page 28 which is to shut down IIS and bring it up through a command prompt. I successfully shut down IIS but I got this when I tried to bring it up again. C:\>net start w3svc The World Wide Web Publishing service is starting. The World Wide Web Publishing service cannot be started. A system error has occured. System error 1747 has occured. The authentication service is unknown. -- Edit this bug report at http://bugs.php.net/?id=13098&edit=1