Memory leak with MyDump on embedded connection - MtDAC 570

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rsandies
Posts: 9
Joined: Mon 14 Aug 2006 12:55

Memory leak with MyDump on embedded connection - MtDAC 570

Post by rsandies » Wed 10 Dec 2008 14:36

Delphi 2009, MyDAC 570

Memory leaks are reported by the memory manager when MyDump is used to create an SQL dump with a MyEmbedded connection. No problem with MyConnection. No problem if MyDump is configured with objects set to false (tables, data, etc.).

Below is the text from the Application Error message:

Exception EAccessViolation in module libmysqld.dll at 001D2DF3
Access violation at address 101D2DF3 in module ‘libmysqld.dll’. Read of address FEEEFFFA.

Unexpected small memory leaks message:

13-20 bytes: Unicodstring x 23
21-28 bytes: Unicodstring x 12
29-36 bytes: Unicodstring x 10
37-44 bytes: Unicodstring x 5
45-52 bytes: Unicodstring x 9
53-60 bytes: Unicodstring x 9
61-68 bytes: Unicodstring x 2
69-76 bytes: Unicodstring x 3, Unknown x 1
77-84 bytes: Unicodstring x 2
85-92 bytes: Unicodstring x 1
93-100 bytes: Unicodstring x 2
269-284 bytes: TMutex x 1, TMySQLAPIEmbedded x 1
797-976 bytes: Unknown x 1

Thank you for your assistance - once again.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 11 Dec 2008 11:50

I could not reproduce the problem. Please send me a complete sample at dmitryg*devart*com to demonstrate it, including a script to create and fill table.
Also supply me the exact version of your Embedded server.

rsandies
Posts: 9
Joined: Mon 14 Aug 2006 12:55

Post by rsandies » Fri 12 Dec 2008 21:43

Dimon,

The problem seems to be solved. It appears to have been data related.

I made a demo but couldn't reproduce the leak. Then I trimmed down the problem application until it was similar to the demo - but it always leaked.

The only difference between the two was that they used different database folders. Dropping the original database and recreating it stopped the memory leak reports. Both were created using MySQL community 5.1.30 GA.

Thank you for you assistance.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 16 Dec 2008 07:42

It is good to see that this problem has been solved.

Post Reply