PgAlerter cannot Stop when connection is lost

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Adrian
Posts: 4
Joined: Thu 09 Dec 2010 11:25

PgAlerter cannot Stop when connection is lost

Post by Adrian » Thu 05 Jul 2012 08:57

Hello,

How can I stop a PgAlerter when connection is lost?

Example:
...
PgConnection.Connect;
PgAlerter.Start;
... stop PG server (from PgAdmim)
now, in debugger get socket error 10054
... restart PG server
PgAlerter.Stop; // -> socket error 10054
PgConnection.Disconnect; // -> an infinite loop with socket error 10054 (debug). Looks like the listening thread doesn't terminate on error.

If the PgAlerter is not started everything is fine, Disconnect works.

Thanks,
Adrian

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

Re: PgAlerter cannot Stop when connection is lost

Post by AlexP » Fri 06 Jul 2012 10:01

hello,

Thank you for the information.
We've reproduced the problem with TPgAlerter.
We will notify you as soon as we have any results.

Adrian
Posts: 4
Joined: Thu 09 Dec 2010 11:25

Re: PgAlerter cannot Stop when connection is lost

Post by Adrian » Fri 06 Jul 2012 10:56

hello,

Thank you for your response.

Adrian

Post Reply