Timeout occurred while waiting for a secondary connection for event processing

[Karol Bieniaszewski]

Hi

 

We got below error in Firebird log nad noone can work in our system.

 

                Unable to complete network request to host "FB-PROD".

                Timeout occurred while waiting for a secondary connection for event processing

 

 

Connection to serwer can be establisched but any query to Firebird by gds32 stopped working from all workstations ~400.

Connections by fbclient work ok.

What can be a cause of the problem? We do not use Firebird events at all.

Only restart of the serwer helped.

 

Regards,

Karol Bieniaszewski

 

[Karol Bieniaszewski]

Forgot to say that this is Firebird 3

 

Regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4Q0KBf27m7zlMZ%40smtp.poczta.onet.pl.

 

[Tomasz Dubiel]

It looks like something indeed uses Firebird events. Do you have set RemoteAuxPort in firebird.conf and this port is allowed in the firewall?

[Karol Bieniaszewski]

We have this port set. But it is not allowed in Firewall.

But after this log in Firebird.log even from local network (outside of firewall) it do not allow to work in our system.

And we do not use Firebird events at all in any system but this is legacy Delphi IBX connection, so maybe somewhere IBX itself use events somehow…

 

Regards,

Karol Bieniaszewski

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/2aee4010-d4c3-4e68-a576-9a15bf9f329en%40googlegroups.com.

 

[Mark Rotteveel]

On 17-04-2023 09:56, Karol Bieniaszewski wrote:
> We got below error in Firebird log nad noone can work in our system.
>
>                 Unable to complete network request to host "FB-PROD".
>
>                 Timeout occurred while waiting for a secondary
> connection for event processing
>
> Connection to serwer can be establisched but any query to Firebird by
> gds32 stopped working from all workstations ~400.
>
> Connections by fbclient work ok.

So, when you use gds32.dll, it doesn't work, and when you use
fbclient.dll it does work? What is the version of gds32.dll?

Mark
--
Mark Rotteveel

[Karol Bieniaszewski]

 

Regards,

Karol Bieniaszewski

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/08c7efdb-e18c-3cf4-a29e-45336bda041e%40lawinegevaar.nl.

 

[Karol Bieniaszewski]

After investigating deeper i found that we have old IBX IBEvents.

We do not have code handle on it, but there was 3 old event names and the AutoRegister was set to True.

But i still do not know why our application stop on any SQL request from the application when this log in Firebird.log was present.

I have checked any even simple select like SELECT COUNT(*) FROM RDB$DATABASE and then app stop on the request.

 

Regards,

Karol Bieniaszewski

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4Q0MBC2dMSzgMy%40smtp.poczta.onet.pl.

 

[Karol Bieniaszewski]

Hi

 

Again same problem

 

FB-PROD             Tue Aug 06 13:42:19 2024

                Unable to complete network request to host "FB-PROD".

                Timeout occurred while waiting for a secondary connection for event processing

 

The question is why it say about SECONDARY connections?

And is there a way to fix problem without restarting the server?

 

Regards,

Karol Bieniaszewski

 

Od: Karol Bieniaszewski
Wysłano: poniedziałek, 17 kwietnia 2023 11:26
Do: firebird...@googlegroups.com

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4Q0MBC2dMSzgMy%40smtp.poczta.onet.pl.

 

[Mark Rotteveel]

On 06/08/2024 13:44, 'Karol Bieniaszewski' via firebird-support wrote:
> Hi
>
> Again same problem
>
> FB-PROD             Tue Aug 06 13:42:19 2024
>
>                 Unable to complete network request to host "FB-PROD".
>
>                 Timeout occurred while waiting for a secondary
> connection for event processing
>
> The question is why it say about SECONDARY connections?

If you listen for events, the client library signals that it wants to
create a secondary connection (for the events), and the server then
sends back information for the client to connect and waits until the
client creates that secondary connection. If that doesn't happen in a
timely fashion, it results in a timeout

> And is there a way to fix problem without restarting the server?

Impossible to tell without a reproducible case. Contrary to your
assertion, it sounds like some application is creating an event connection.

Mark
--
Mark Rotteveel

[Karol Bieniaszewski]

>> it sounds like some application is creating an event connection.

 

Yes, in our application we use AutoRegister with TIBEvents.

So, every application uses events by default.

 

>> If that doesn't happen in a timely fashion, it results in a Timeout

 

What could be the cause? Restarting the Firebird service resolves the problem.

It seems like an issue with Firebird, not the external system.

But I do not know how I can dig deeper into this case.

 

Regards,

Karol Bieniaszewski

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/5c7de480-9c9f-4d01-b8f1-88719d91aca7%40lawinegevaar.nl.