Bug with FireDAC datasets

Bug with FireDAC datasets

Postby 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
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby 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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby 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
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby AlexP » Thu 14 Jul 2016 12:18

Specify the memory manager you are using for detecting memory leaks.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby 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
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby 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
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby 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!
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby 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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby burdian » Mon 18 Jul 2016 19:21

Sent to support*devart*com
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby AlexP » Thu 21 Jul 2016 08:25

Please send your dproj again to alexp*devar*com.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby burdian » Mon 03 Oct 2016 05:23

I found what causes memory leaks: Embarcadero\Studio\17.0\bin\SQLite3.dll
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby AlexP » Tue 04 Oct 2016 11:48

Check this behavior on the standard SQLite library: http://sqlite.org/download.html
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Bug with FireDAC datasets

Postby 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.
burdian
 
Posts: 27
Joined: Wed 19 Nov 2008 19:25

Re: Bug with FireDAC datasets

Postby 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
MaximG
Devart Team
 
Posts: 737
Joined: Mon 06 Jul 2015 11:34


Return to VirtualDAC