Edit report at http://bugs.php.net/bug.php?id=47077&edit=1
ID: 47077
Comment by: sales at itpdiesel dot com
Reported by: w dot purrer at lenzing dot com
Summary: mysql + PHP crashes IIS worker process and
application pool
Status: Bogus
Type: Bug
Package: MySQL related
Operating System: Windows 2008 sp1
PHP Version: 5.2.8
New Comment:
I'm having this problem with IIS 7, PHP 5.3.2 and MySQL
5.1.45-community. I'm sorry, but I'm no programmer so this is difficult
for me. I have the following in my php.ini, which seems to me to mean
that I'm using the php library that came with my PHP installation...but
maybe I'm wrong???
extension_dir = "c:\php\ext"
extension=php_mysql.dll
To me, that says to look in c:\php\ext for the extensions and to use the
mysql extension that is in that directory...am I wrong? This issue
keeps bringing my website down and I just don't know what to do
THANKS!!!
Previous Comments:
------------------------------------------------------------------------
[2009-01-13 10:21:49] w dot purrer at lenzing dot com
I haven't changed any libmysql stuff => but i checked the path variables
and the path to c:\mysql was before c:\php => it used the wrong file!
after changing this it worked!
------------------------------------------------------------------------
[2009-01-12 14:13:42] paj...@php.net
Never use mysql's library (even not 5.1) with php. We bundle a libmysql
client and it has to be used.
NB: 5.3+ does not rely anymore on libmysql.
Not a php issue > bogus
------------------------------------------------------------------------
[2009-01-12 14:00:50] w dot purrer at lenzing dot com
In the C:\Mysql -> Directory is the one which is deliviered with mysql
in the c:\php -> Directory is the one which is deliviviered with php
In the phpinfo.php => is the following!
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.1.30
I didn't remember if I install php or mysql first, but a week a go i
installed mysql 5.1.30 with copy / paste Deployment into the c:\mysql
directory.
And today i upgraded from 5.2.6 => 5.2.8 (also with copy and paste
deployment)
The Problem exist since End of November (thats why i installed the
apache webserver on the iis) => but now I'd like to solve this problem
without apache!
------------------------------------------------------------------------
[2009-01-12 13:42:46] paj...@php.net
Which libmysql.dll do you use? Did you install mysql 5.1 after php for
example?
------------------------------------------------------------------------
[2009-01-12 12:37:01] w dot purrer at lenzing dot com
The same failure with apache.
But as a apache module the error happnes only the first few reqeuest
after a restart of the http - server, then it works => with the iis the
failure occours at every request (with a few expceptions).
=> i have the same combination (php Version, mysql Version) active at a
windows 2003 Server and there is no problem.
httpd__PID__3676__Date__01_12_2009__Time_01_28_45PM__206__Second_Chance_Exception_C0000005.dmp
Type of Analysis Performed Crash Analysis
Machine Name RGSPSM1
Operating System Windows Vista Service Pack 1
Number Of Processors 2
Process ID 3676
Process Image C:\Program Files\Apache Software
Foundation\Apache2.2\bin\httpd.exe
System Up-Time 44 day(s) 21:32:50
Process Up-Time 00:00:50
Thread 2 - System ID 5220
Entry point msvcrt!_endthreadex+6f
Create time 12.01.2009 13:27:55
Time spent in user mode 0 Days 0:0:0.0
Time spent in kernel mode 0 Days 0:0:0.0
Function Arg 1 Arg 2 Arg 3 Source
ntdll!RtlpCoalesceFreeBlocks+6ef 00180000 01be63e0 0147f838
ntdll!RtlpExtendHeap+40 00180000 000003c8 91d4233e
ntdll!RtlpAllocateHeap+7db 000003c0 000003c8 01be53e0
ntdll!RtlAllocateHeap+1e3 00180000 00000000 000003c0
msvcrt!malloc+8d 000003c0 02c07d20 02c07d20
php_mysql!php_mysql_do_connect+358 02bfe478 02bfe598
00000000
php_mysql!zif_mysql_pconnect+25 00000003 02bfe598 00000000
php5ts!zend_do_fcall_common_helper_SPEC+7d9 0147fac4 01b6d978
02bfdb00
php5ts!ZEND_DO_FCALL_SPEC_CONST_HANDLER+e5 00000000 01b6d978
0147fb78
php5ts!execute+1c5 02bfdb00 01b6d978 02bfbcd6
php5ts!ZEND_INCLUDE_OR_EVAL_SPEC_CONST_HANDLER+330 02bfbc18
00000000 01b6d978
php5ts!execute+1c5 02bfbc18 01b6d978 00000000
php5ts!zend_execute_scripts+107 00000008 01b6d978 00000000
php5ts!php_execute_script+20d 0147fe68 01b6d978 00000005
php5apache2_2!php_handler+5cd 00e147f8 00dc7cd0 00e147f8
libhttpd!ap_run_handler+21 00e147f8 00e147f8 00e147f8
libhttpd!ap_invoke_handler+ae 00000000 01b82a68 0147ff00
libhttpd!ap_die+24e 00e147f8 00000000 00e010d0
libhttpd!ap_get_request_note+1c9c 01b82a68 01b82a68 01b82a68
libhttpd!ap_run_process_connection+21 01b82a68 00d44e58
0147ff48
libhttpd!ap_process_connection+33 01b82a68 00e0c7e8 00000000
libhttpd!ap_regkey_value_remove+c7c 01b82a60 35450e04
00000000
msvcrt!_endthreadex+44 0147ff94 76424911 01b75a00
msvcrt!_endthreadex+ce 01b75a00 0147ffd4 779ce4b6
kernel32!BaseThreadInitThunk+e 01b75a00 91d425c2 00000000
ntdll!__RtlUserThreadStart+23 76952da8 01b75a00 ffffffff
ntdll!_RtlUserThreadStart+1b 76952da8 01b75a00 00000000
NTDLL!RTLPCOALESCEFREEBLOCKS+6EF
Detailed Info For Corrupt Heap
Heap 1 - 0x00230000
Heap Name Default process heap
Heap Description This heap is created by default and shared by all
modules in the process
Reserved memory 5.244.720,03 TBytes
Committed memory 5.243.920,02 TBytes (99,98% of reserved)
Uncommitted memory 800,01 TBytes (0,02% of reserved)
Number of heap segments 1 segments
Number of uncommitted ranges 108 range(s)
Size of largest uncommitted range 29.440,41 TBytes
Calculated heap fragmentation -3.579,99%
Segment Information
Base Address Reserved Size Committed Size Uncommitted Size Number of
uncommitted ranges Largest uncommitted block Calculated heap
fragmentation
0x4a802e05 105.908.016,03 TBytes 105.907.216,02 TBytes 800,01 TBytes 108
29.440,41 TBytes -3.579,99%
Back to Top
In
httpd__PID__3676__Date__01_12_2009__Time_01_28_45PM__206__Second_Chance_Exception_C0000005.dmp
the assembly instruction at ntdll!RtlpCoalesceFreeBlocks+6ef in
C:\Windows\System32\ntdll.dll from Microsoft Corporation has caused an
access violation exception (0xC0000005) when trying to read from memory
location 0x00000004 on thread 2
Heap corruption was detected in heap 0x00230000, however pageheap was
not enabled in this dump. Please follow the instructions in the
recommendation section for troubleshooting heap corruption issues.
Current NTGlobalFlags value: 0x0 Module Information
Image Name: C:\Windows\System32\ntdll.dll Symbol Type: PDB
Base address: 0x77990000 Time Stamp: Sat Jan 19 08:32:54 2008
Checksum: 0x00135d86 Comments:
COM DLL: False Company Name: Microsoft Corporation
ISAPIExtension: False File Description: NT Layer DLL
ISAPIFilter: False File Version: 6.0.6001.18000
(longhorn_rtm.080118-1840)
Managed DLL: False Internal Name: ntdll.dll
VB DLL: False Legal Copyright: © Microsoft Corporation. All rights
reserved.
Loaded Image Name: ntdll.dll Legal Trademarks:
Mapped Image Name: Original filename: ntdll.dll
Module name: ntdll Private Build:
Single Threaded: False Product Name: Microsoft® Windows® Operating
System
Module Size: 1,15 MBytes Product Version: 6.0.6001.18000
Symbol File Name:
c:\symcache\ntdll.pdb\B958B2F91A5A46B889DAFAB4D140CF252\ntdll.pdb
Special Build: &
Report for
httpd__PID__3676__Date__01_12_2009__Time_01_28_40PM__628__First chance
exception 0XC0000005.dmp
Report for
httpd__PID__3676__Date__01_12_2009__Time_01_28_40PM__628__First chance
exception 0XC0000005.dmp
Type of Analysis Performed Crash Analysis
Machine Name RGSPSM1
Operating System Windows Vista Service Pack 1
Number Of Processors 2
Process ID 3676
Process Image C:\Program Files\Apache Software
Foundation\Apache2.2\bin\httpd.exe
System Up-Time 44 day(s) 21:32:45
Process Up-Time 00:00:45
Thread 2 - System ID 5220
Entry point msvcrt!_endthreadex+6f
Create time 12.01.2009 13:27:55
Time spent in user mode 0 Days 0:0:0.0
Time spent in kernel mode 0 Days 0:0:0.0
Function Arg 1 Arg 2 Arg 3 Source
ntdll!RtlpCoalesceFreeBlocks+6ef 00180000 01be63e0 0147f838
ntdll!RtlpExtendHeap+40 00180000 000003c8 91d4233e
ntdll!RtlpAllocateHeap+7db 000003c0 000003c8 01be53e0
ntdll!RtlAllocateHeap+1e3 00180000 00000000 000003c0
msvcrt!malloc+8d 000003c0 02c07d20 02c07d20
php_mysql!php_mysql_do_connect+358 02bfe478 02bfe598
00000000
php_mysql!zif_mysql_pconnect+25 00000003 02bfe598 00000000
php5ts!zend_do_fcall_common_helper_SPEC+7d9 0147fac4 01b6d978
02bfdb00
php5ts!ZEND_DO_FCALL_SPEC_CONST_HANDLER+e5 00000000 01b6d978
0147fb78
php5ts!execute+1c5 02bfdb00 01b6d978 02bfbcd6
php5ts!ZEND_INCLUDE_OR_EVAL_SPEC_CONST_HANDLER+330 02bfbc18
00000000 01b6d978
php5ts!execute+1c5 02bfbc18 01b6d978 00000000
php5ts!zend_execute_scripts+107 00000008 01b6d978 00000000
php5ts!php_execute_script+20d 0147fe68 01b6d978 00000005
php5apache2_2!php_handler+5cd 00e147f8 00dc7cd0 00e147f8
libhttpd!ap_run_handler+21 00e147f8 00e147f8 00e147f8
libhttpd!ap_invoke_handler+ae 00000000 01b82a68 0147ff00
libhttpd!ap_die+24e 00e147f8 00000000 00e010d0
libhttpd!ap_get_request_note+1c9c 01b82a68 01b82a68 01b82a68
libhttpd!ap_run_process_connection+21 01b82a68 00d44e58
0147ff48
libhttpd!ap_process_connection+33 01b82a68 00e0c7e8 00000000
libhttpd!ap_regkey_value_remove+c7c 01b82a60 35450e04
00000000
msvcrt!_endthreadex+44 0147ff94 76424911 01b75a00
msvcrt!_endthreadex+ce 01b75a00 0147ffd4 779ce4b6
kernel32!BaseThreadInitThunk+e 01b75a00 91d425c2 00000000
ntdll!__RtlUserThreadStart+23 76952da8 01b75a00 ffffffff
ntdll!_RtlUserThreadStart+1b 76952da8 01b75a00 00000000
NTDLL!RTLPCOALESCEFREEBLOCKS+6EF
Detailed Info For Corrupt Heap
Heap 1 - 0x00230000
Heap Name Default process heap
Heap Description This heap is created by default and shared by all
modules in the process
Reserved memory 5.244.720,03 TBytes
Committed memory 5.243.920,02 TBytes (99,98% of reserved)
Uncommitted memory 800,01 TBytes (0,02% of reserved)
Number of heap segments 1 segments
Number of uncommitted ranges 996432412780 range(s)
Size of largest uncommitted range 29.440,41 TBytes
Calculated heap fragmentation -3.579,99%
Segment Information
Base Address Reserved Size Committed Size Uncommitted Size Number of
uncommitted ranges Largest uncommitted block Calculated heap
fragmentation
0x4a802e05 105.908.016,03 TBytes 105.907.216,02 TBytes 800,01 TBytes
996432412780 29.440,41 TBytes -3.579,99%
Back to Top
In httpd__PID__3676__Date__01_12_2009__Time_01_28_40PM__628__First
chance exception 0XC0000005.dmp the assembly instruction at
ntdll!RtlpCoalesceFreeBlocks+6ef in C:\Windows\System32\ntdll.dll from
Microsoft Corporation has caused an access violation exception
(0xC0000005) when trying to read from memory location 0x00000004 on
thread 2
Heap corruption was detected in heap 0x00230000, however pageheap was
not enabled in this dump. Please follow the instructions in the
recommendation section for troubleshooting heap corruption issues.
Current NTGlobalFlags value: 0x0 Module Information
Image Name: C:\Windows\System32\ntdll.dll Symbol Type: PDB
Base address: 0x77990000 Time Stamp: Sat Jan 19 08:32:54 2008
Checksum: 0x00135d86 Comments:
COM DLL: False Company Name: Microsoft Corporation
ISAPIExtension: False File Description: NT Layer DLL
ISAPIFilter: False File Version: 6.0.6001.18000
(longhorn_rtm.080118-1840)
Managed DLL: False Internal Name: ntdll.dll
VB DLL: False Legal Copyright: © Microsoft Corporation. All rights
reserved.
Loaded Image Name: ntdll.dll Legal Trademarks:
Mapped Image Name: Original filename: ntdll.dll
Module name: ntdll Private Build:
Single Threaded: False Product Name: Microsoft® Windows® Operating
System
Module Size: 1,15 MBytes Product Version: 6.0.6001.18000
Symbol File Name:
c:\symcache\ntdll.pdb\B958B2F91A5A46B889DAFAB4D140CF252\ntdll.pdb
Special Build: &
Report for
httpd__PID__2740__Date__01_12_2009__Time_01_28_30PM__878__First chance
exception 0X80000003.dmp
Report for
httpd__PID__2740__Date__01_12_2009__Time_01_28_30PM__878__First chance
exception 0X80000003.dmp
Type of Analysis Performed Hang Analysis
Machine Name RGSPSM1
Operating System Windows Vista Service Pack 1
Number Of Processors 2
Process ID 2740
Process Image C:\Program Files\Apache Software
Foundation\Apache2.2\bin\httpd.exe
System Up-Time 44 day(s) 21:32:36
Process Up-Time 00:00:36
Top 5 Threads by CPU time
Note - Times include both user mode and kernel mode for each thread
Thread ID: 0 Total CPU Time: 00:00:00.108 Entry Point for
Thread: 0x7ffdf000
Thread ID: 2 Total CPU Time: 00:00:00.00 Entry Point for Thread:
libhttpd!ap_get_scoreboard_lb+360
Thread ID: 3 Total CPU Time: 00:00:00.00 Entry Point for Thread:
advapi32!ScSvcctrlThreadW
Thread ID: 4 Total CPU Time: 00:00:00.00 Entry Point for Thread:
ntdll!DbgUiRemoteBreakin
Thread ID: 1 Total CPU Time: 00:00:00.00 Entry Point for Thread:
libhttpd!ap_mpm_run+16a0
------------------------------------------------------------------------
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/bug.php?id=47077
--
Edit this bug report at http://bugs.php.net/bug.php?id=47077&edit=1
