Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

local protocol event event notification to multiple local clients not working correctly under Firebird 2.x [CORE1472] #1889

Closed
firebird-automations opened this issue Sep 19, 2007 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Bryan Skellern (bskellern)

Duplicates CORE1456

Attachments:
events.zip

Summary:
Where multiple client DBEvent listeners reside on the same local PC as the database (local protocol), not ALL clients receive event notification they have registered interest in when these multiple instances of the same client register interest in the same events.

Example of it NOT working
e.g. Open two concurrent instances of the Delphi (version 7) Event Alerter Demo program C:\Program Files\Borland\Delphi7\Demos\Db\IBX\IBXEvents\Events.exe). Open Database in first instance and register two events ("hello" & "world"). Use UI to generate event "hello" or "world" and you can see in the event log control provided that either event is received as expected. Next repeat exercise in the second instance while the first instance is still connected to the DB and still registered in receiving notification for both of the before mentioned events. Note only one client now receives notification of either event (hello or world)

Example of it working
When Firebird 1.5.1.4481 is used BOTH instances of the Event Alerter Demo applications receive DB event notification (of either event) initiated by user action (Generate Event) in UI of either DB client app as expected. That is I can register both "hello" & "world" events in both clients & BOTH clients receive notification of either event.

What does work in Firebird 2.x
If client 1 registers interest in only the "hello" event and client 2 registers interest in only the "world" event then regardless of where the "hello" event is initiated (client 1 or 2) ONLY client 1 receives notification of the event. Conversly if the "world" event is iniated (client 1 or 2) then ONLY client 2 receives notification of teh event.

Please note:
The generate Event functionality in the example Delphi event demo simply runs a DB stored proc passing to it the event name provided in the UI. The DB stored proc simply posts the event name parameter (to all listening registered client apps).

I can provide simple client app demo (if required) together with db.

I must stress using the same client apps and db with Firebird 1.5 the system works as expected. It is only when used with Firebird 2.x that it is problematic and then specifically with the local protocol. The same symptoms occur whent the older Events.exe client demo application (not using Interbase express Delphi vcl components) is used. I have tried many version of FB 2.x - all exibit the same behaviour in local protocol. I have NOT yet tried the remote TCP protocol client db connection.

Bryan Skellern

@firebird-automations
Copy link
Collaborator Author

Commented by: Bryan Skellern (bskellern)

Enclosed zip file contains Delphi (7) example event reception client app program together with example database. Note both the example client app & associated database must reside in the same folder - can be any folder.

@firebird-automations
Copy link
Collaborator Author

Modified by: Bryan Skellern (bskellern)

Attachment: events.zip [ 10580 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE1456 [ CORE1456 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 13103 ] => Firebird [ 13956 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant