Bug #5062 zeos + libmysq.dll
Submitted: 16 Aug 2004 13:19 Modified: 18 Aug 2004 23:30
Reporter: Nico de Groot Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.16 + 4.0.20 OS:Windows (Win2K / red-hat 7.3)
Assigned to: Assigned Account CPU Architecture:Any

[16 Aug 2004 13:19] Nico de Groot
Description:
http://sourceforge.net/tracker/index.php?func=detail&atid=415824&aid=999206&group_id=35994

I had contact with the the devellopers of the zeos-mysql-components about an error I get when using several dll's (that call each other).

Their reaktion was specified to our libmysql.dll so hopefully u can solve the problem. (in cooperation with zeoslib.net)

answer zeos : 

I run your test and found that you stepped on the known
problem. It is related mostly to libmysql.dll. When you
establish connections from dlls, each dll loads
libmysql.dll. But physically libmysql.dll is loaded into the
memory just onces and shared by all modules. Each module
gets own handler to libmysql.dll which points to the same
dll. When you unload the first dll it also unloads
associated instance of libmysql.dll. Although there are
still two references to libmysql.dll active, libmysql.dll on
the first unload event automatically closes _all_ opened
connections, including connections from other application
modules.

How to repeat:
..
[16 Aug 2004 14:34] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

It's already reported as ttp://bugs.mysql.com/4039
[18 Aug 2004 16:15] Nico de Groot
estimated time till fix.. 
i'm re-writing a program to my-sql and i'm getting al lot of av's caused by this error.  
I can call all my dll's statically but this slow my program down, I also can quit connection-pooling but these work-arounds would be a (bad) temperary solution ! 
 so my question is in what kind of period will this problem be fixed (original bug stands for a while http://bugs.mysql.com/bug.php?id=4039 (version 3.23 !!))
thanks in advance
[18 Aug 2004 23:30] Sergei Golubchik
check the latest posting for

http://bugs.mysql.com/bug.php?id=4039

please
[24 Aug 2004 8:54] Nico de Groot
19 Aug 12:40am - added test-files for delphi7 + zeoslib components 6.1.5
[24 Aug 2004 8:57] Nico de Groot
correction zeoslib 6.5.0 alpha