SSL+Pooling: Application close causes exceptions

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
worsoee
Posts: 13
Joined: Fri 26 Aug 2016 16:26

SSL+Pooling: Application close causes exceptions

Post by worsoee » Thu 24 Nov 2016 09:42

Hi, ...

When using SSL and Pooling=True, I get these exceptions when closing the application:
1) Lost connection to MySQL server during query"
2) Invalid pointer operation

I've tried not using SSL, then it works. I've tried setting Pooling=False, then it works. These exceptions are only created when both SSL and Pooling are on.

Can you help, please?

I'm running my application on Windows 10, it's created using MyDAC 8.7.27; SecureBridge 7.2.3; VirtualDAC 10.0.3; Delphi 10.1 update 2 and the application connects to MySQL 5.7.16 (MySQL server on Ubuntu server 14.04).

Kindly greetings :-)

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: SSL+Pooling: Application close causes exceptions

Post by ViktorV » Thu 24 Nov 2016 11:22

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

worsoee
Posts: 13
Joined: Fri 26 Aug 2016 16:26

Re: SSL+Pooling: Application close causes exceptions

Post by worsoee » Mon 28 Nov 2016 08:18

Thank you for the quick reply - looking forward to the results, as out application now isn't able to clean up memory properly after close, and thus "pollutes" client computers ...

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: SSL+Pooling: Application close causes exceptions

Post by ViktorV » Fri 02 Dec 2016 13:48

We will continue investigation of the MyDAC behavior and inform you as soon as we get any results, but we can't provide any time frame at the moment.

worsoee
Posts: 13
Joined: Fri 26 Aug 2016 16:26

Re: SSL+Pooling: Application close causes exceptions

Post by worsoee » Fri 09 Dec 2016 06:16

Hi,

As we're about to release a new version of our client software, we actually need either a timeframe or a work-round (maybe even a downgrade, if this works in prior version-combinations).

The current situation locks us to either not release software at all, or to release without SSL. None of the options are very appealing - and turning of pooling reduces performance greatly, so that's not an option either...

Best regards

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: SSL+Pooling: Application close causes exceptions

Post by ViktorV » Fri 09 Dec 2016 11:47

We have already fixed this issue. This fix will be included in the next MyDAC build.
To solve your issue you can change in the CRSSLIOHandler.pas file the string

Code: Select all

  SSLClient := TScSSLClient.Create(Self);
into

Code: Select all

  SSLClient := TScSSLClient.Create(nil);

worsoee
Posts: 13
Joined: Fri 26 Aug 2016 16:26

Re: SSL+Pooling: Application close causes exceptions

Post by worsoee » Thu 02 Feb 2017 07:16

Hello,

I can see the SecureBridge have been updated to version 7.3.4. Is a fix for this issue included in the new version?

My config is: Delphi 10.1 update 2, MyDAC 8.7.27 and VirtualDAC 10.0.3

Best regards,

Carsten

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: SSL+Pooling: Application close causes exceptions

Post by ViktorV » Thu 02 Feb 2017 08:59

As we wrote earlier, this error cause was not in SecureBridge code, but in the CRSSLIOHandler.pas file code. To solve it, you should make changes specified by us in the previous post to the CRSSLIOHandler.pas file. After that, please rebuild the package mydacsbridgeXX.dpk.

Post Reply