Subject 2 clients' IB_Event RegisterEvents to Firebird 1.5 cause database hung!
Author Kadee
Hi Groups,

I have FB1.5 database,on a table after update addd
a trigger:

CREATE TRIGGER JMISUSER_AU0 FOR JMISUSER
ACTIVE AFTER UPDATE POSITION 0
AS
begin
post_event 'MSG';
end

I writed a application with Delphi7.0 and ibo4.3.Aa.
with a ib_event.events.add('MSG');

When just a application run,evething is fine,
the ib_event get the alert from database as I want.
but if I run this application from another pc at same time,
when application run into
IB_Event.RegisterEvents;
the database hunged,and both 2 clients cannot get any reply
from the server.
Even I cannot stop the database server engine in the server.
I must reboot the server to let DB become normal.

Can anyone give me a hint? Thanks advance.


Kadee