Bug #34276 windows appVerifier on php fails when mysql is loaded
Submitted: 4 Feb 2008 13:15 Modified: 7 Apr 2008 13:42
Reporter: nadav avital Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connectors: mysqlnd ( PHP ) Severity:S3 (Non-critical)
Version:5.0.27 OS:Windows (any)
Assigned to: CPU Architecture:Any

[4 Feb 2008 13:15] nadav avital
Description:
when running appVerifier on php 5.2.5 with mysql.dll loaded the php crashes when the script ends and modules are unloading. Further investigation shows that libmysql.dll has locking problem("Unloading DLL containing an active critical section").
removing mysql related extensions from php resolve the 

How to repeat:
1. run appVerifier upon php.exe
2. in the appVerifier test tab select basics - handles, heaps, locks
3. run php -v
[3 Mar 2008 13:19] Tonci Grgin
Hi Navad and thanks for your report... I must admit I'm puzzled why error reported by Microsoft tool against php-compiled library is reported to us? Because of libmysql.dll? Which version of libmysql.dll is php's mysql.dll compiled against? Is it using some libmysql.dll on your machine? Did php compiled their own libmysql.dll etc... you get my point, right?
[5 Mar 2008 12:40] nadav avital
I understand why you must be wondering about this bug, but that makes the both of us ;-) To your questions:
1. I reported this bug to mysql since the backtrace indicated the crash was inside mysql code  (the dll to which I don't have access)
2. the version is the one mentioned in the bug report 
3. php is not using any "random" libmysql.dll but the one we got from mysql

I'll be happy to assist if any other questions rise
[7 Mar 2008 13:42] Tonci Grgin
Navad, can you try replacing php5-2-5dir\libmysql.dll with one from latest released community server (5.0.50a) and retest? Originally, php 5.2.5 comes with libmysql.dll 5.0.45.

C:\php-5.2.5-Win32>php --ri mysql
mysql
MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => 5.0.51a
Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.max_persistent => Unlimited => Unlimited
mysql.max_links => Unlimited => Unlimited
mysql.default_host => no value => no value
mysql.default_user => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => no value => no value
mysql.connect_timeout => 60 => 60
mysql.trace_mode => Off => Off
[7 Apr 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".