Subject | 2 clients' IB_Event RegisterEvents to Firebird 1.5 cause database hung! |
---|---|
Author | Kadee |
Post date | 2005-09-23T13:04:18Z |
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
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