Bug with FireDAC datasets

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Bug with FireDAC datasets

Post by burdian » Wed 13 Jul 2016 04:52

Hello,

Delphi 10 Seattle win32, VirtualDAC 10.0, Win 10 x64

When using VirtualDAC with FireDAC datasets I get memory leaks, sometimes AV at memory manager. Sometimes closing main form only hide appl, appl remains in memory.

Samle appl is sent to support@devart.com with subject Sometimes closing main form only hide appl, appl remains in memory.

TIA and best regards
Branko

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Wed 13 Jul 2016 07:09

Hello,

We can't reproduce the problem. Please describe the steps to reproduce the situation. Also specify the memory manager you are using for detecting memory leaks.

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Wed 13 Jul 2016 07:18

Hello,

1) Samle appl was sent to support@devart.com. Just click on "Open / close" button and close appl.
2) Default Delphi 10 MM

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Thu 14 Jul 2016 12:18

Specify the memory manager you are using for detecting memory leaks.

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Thu 14 Jul 2016 19:01

As I have already answered - memory leaks are detecting by default Delphi 10 memory manager. Memory leaks detecting is enabled with code

Code: Select all

initialization
  System.ReportMemoryLeaksOnShutdown := True;
I get the report below:

An unexpected memory leak has occurred. The unexpected small block leaks are:
1 - 12 bytes: TObject x 1
13 - 20 bytes: TFDExpressionManager x 1, UnicodeString x 143
21 - 28 bytes: UnicodeString x 144
29 - 36 bytes: EAccessViolation x 2, UnicodeString x 42
37 - 44 bytes: TFDExpressionFunctionDesc x 119, UnicodeString x 12
45 - 52 bytes: UnicodeString x 4
61 - 68 bytes: Unknown x 162
93 - 100 bytes: TFDStringList x 2
173 - 188 bytes: UnicodeString x 2
1645 - 1804 bytes: Unknown x 1

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Fri 15 Jul 2016 09:06

As I wrote you earlier, the issue is not reproduced when using either the standard memory manager or FastMM, or EurekaLog. We use Seattle with Update 1.

P.S. Judging by the log you provided, AV and MemoryLeak occur in FireDAC

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Fri 15 Jul 2016 12:53

AlexP wrote:We use Seattle with Update 1.
Me too.
Are you launch the demo appl I sent you?
I get memory leaks and AV also with Delhi XE7 and XE4!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Mon 18 Jul 2016 12:40

The issue is not reproduced on your project in any of studios. Please provide also the dproj project file. The case may occur due to the project settings.

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Mon 18 Jul 2016 19:21

Sent to support*devart*com

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Thu 21 Jul 2016 08:25

Please send your dproj again to alexp*devar*com.

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Mon 03 Oct 2016 05:23

I found what causes memory leaks: Embarcadero\Studio\17.0\bin\SQLite3.dll

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Post by AlexP » Tue 04 Oct 2016 11:48

Check this behavior on the standard SQLite library: http://sqlite.org/download.html

burdian
Posts: 29
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Post by burdian » Fri 14 Oct 2016 13:33

Yes, with standard sqlite.dll no memory leaks. I just wanted inform you where / why memory leeks occours.

MaximG
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: Bug with FireDAC datasets

Post by MaximG » Mon 24 Apr 2017 09:07

When developing and testing our products to work with SQLite we use only standard SQLite library available on the official project site : http://sqlite.org

Post Reply