FirebirdSQL
Wrong error message when server timed out while waiting for a secondary connection for event processing
Firebird 3.0.10 64bits running on Windows Server 2022. Client app is made in Delphi + IBObjects (and FB 3.0.4 fbclient)
Server was running fine for months and suddenly applications started to present error trying to register to listen for FB events. Looking at the fb.log on server I found several of this:
VSFBD01 Fri Feb 23 10:47:23 2024 Unable to complete network request to host "vsfbd01". Timeout occurred while waiting for a secondary connection for event processing
The only way to bring things back to normal was to restart the server machine.
Talking to Vlad, he answered this:
I see that error message in this particular case is a bit wrong you should ignore first part the second one - is real error
here, client ask server to prepare secondary connection for events server creates listener socket, sends port number to the client and wait for incoming connection client doesn't respond and after timeout server stop wait, close socket and put that message into log
server have no idea why client doesn't respond, there was no error other than timeout when waiting for the incoming connection
Unable to complete network request to host "vsfbd01 this part is WRONG and you should ignore it (you may create ticket to fix it, btw)
Timeout occurred while waiting for a secondary connection for event processing this is the only correct info that we should look at
