Subject Re: [firebird-support] 2 clients' IB_Event RegisterEvents to Firebird 1.5 cause database hung!
Author Martijn Tonies
Hello 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.

Upgrade to 1.5.2, I believe this is fixed in there.

Would I be correct if I say your server has two network cards?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com