IBCAlerter seem to lose connection

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Comed
Posts: 7
Joined: Mon 23 Mar 2015 13:19

IBCAlerter seem to lose connection

Post by Comed » Mon 19 Sep 2016 08:45

Hi,

I have an Issue with the IBCAlerter.
Using FB 3.0 & IBDAC 5.7.25

When connecting and reconnecting to the Database everything works fine. But after some time the ibcalerter doesn't respond to any event anymore. But i don't get any exceptions or causes for this. It just stopped to fire any events.
Active property is still "Active" and Event list is still filled. Autoregister does not help with this issue.

To call Stop and Start or Disconnect and reconnect solves this problem, but i cannot get any information about the state of the alerter. So calling every hour start & Stop is not a solution for me. In worst case important events will be missed.

To reproduce this, just connect a ibcconnection with a alerter to an db and register "TEST".
With a timer call a procedure wich just calls POST_EVENT "TEST" in the Database.

After some time (20 minutes to 6 hours) the IBCAlerter does'nt call any event, but keeps being "Active".
No Exception is raised or Information about the connection state of the ibcalerter is given.

19.09.2016 10:00:17|DEBUG |Last Timer: 2016-09-19 10:00:17
19.09.2016 10:00:17|INFO |Altert active: -1
19.09.2016 10:00:17|INFO |Event erhalten
19.09.2016 10:00:27|DEBUG |Last Timer: 2016-09-19 10:00:27
19.09.2016 10:00:27|INFO |Altert active: -1
19.09.2016 10:00:27|INFO |Event erhalten
19.09.2016 10:00:37|DEBUG |Last Timer: 2016-09-19 10:00:37
19.09.2016 10:00:37|INFO |Altert active: -1
19.09.2016 10:00:37|INFO |Event erhalten
19.09.2016 10:00:47|DEBUG |Last Timer: 2016-09-19 10:00:47
19.09.2016 10:00:47|INFO |Altert active: -1
19.09.2016 10:00:47|INFO |Event erhalten
19.09.2016 10:00:57|DEBUG |Last Timer: 2016-09-19 10:00:57
19.09.2016 10:00:57|INFO |Altert active: -1
19.09.2016 10:01:07|DEBUG |Last Timer: 2016-09-19 10:01:07
19.09.2016 10:01:07|INFO |Altert active: -1
19.09.2016 10:01:17|DEBUG |Last Timer: 2016-09-19 10:01:17
19.09.2016 10:01:17|INFO |Altert active: -1
19.09.2016 10:01:27|DEBUG |Last Timer: 2016-09-19 10:01:27
19.09.2016 10:01:27|INFO |Altert active: -1
19.09.2016 10:01:37|DEBUG |Last Timer: 2016-09-19 10:01:37
19.09.2016 10:01:37|INFO |Altert active: -1

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

Re: IBCAlerter seem to lose connection

Post by ViktorV » Mon 19 Sep 2016 09:31

Unfortunately, we could not reproduce the issue.
In order to get a detailed answer, please compose a small sample demonstrating the described behavior and send it to viktorv*devart*com, including scripts for creating database objects.

Comed
Posts: 7
Joined: Mon 23 Mar 2015 13:19

Re: IBCAlerter seem to lose connection

Post by Comed » Fri 30 Sep 2016 08:09

After some investigation it seems to be a Bug in the Firebird Server and FBClient.dll

Since FB 3.0.1 is now released the problem doesn't occour anymore

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

Re: IBCAlerter seem to lose connection

Post by ViktorV » Fri 30 Sep 2016 08:40

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.

Post Reply