--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 12:15 AM 27/04/2004 +0000, you wrote:
> > > we are testing one of our apps over FB 1.5 (latest)
> > > this app use extensively events, with Firebird 1.0 all
> > > works fine, under FB 1.5 after some time of good
> > > work the server run at 100% CPU use and the clients
> > > hangs waiting the server. Is this a know issue?
> > > Thx for support.
> > >
> > > (Latest FB 1.5 on Windows 2000 Server sp3).
> >
> >Not useful, but I can confirm I have this happen about once every
> >week or so, running FB 1.5 on Win 2000 SP3. Never saw it with FB
> >1.03. I also use events. Yours is the third message about this

today,

> >so it must be real.
> >
> >Is there anyway we can isolate the cause?
>
> Could it be a firewall problem? For events, Fb grabs a random port-

to-port

> channel. Perhaps sometimes you get the situation where

two "matching"

> ports (between client and server) are not available.
>
> You can configure a single port through which event traffic will

always

> flow. See RemoteAuxPort in firebird.conf. Then open that port and

disallow

> any other traffic from using it. On the client, I think all that's

needed

> is for any personal firewall to permit traffic from the server's IP

address.

>
> I don't know why you wouldn't see the same problem with Fb 1.03,

though

> (where in fact you can't configure the RemoteAuxPort). So maybe

your

> network admin has closed too many boltholes....
>
> /heLen

I tried Helen's suggestion about using a single port, but have just
had this happen again, first time in 3 weeks. I stopped and started
FB from the Control Panel without problems and the fault was gone
again.

How do you tell if a sweep is occuring? Could this be causing this
apparent (99% CPU useage) effect? I think(?) that clients are still
able to log on (slowly).

Thanks,
Steve