Subject | Re: [IBO] Drop Connection |
---|---|
Author | Fabian Mario Kruszelnicki |
Post date | 2013-07-19T11:51:10Z |
Thank you Marcin. I do your solution and this works perfectly. I have tried with other solutions (Linux System variables tcp_keepalive_* and powersaved) but the problem continous.
Thank you for your help.
________________________________
De: Fabian Mario Kruszelnicki <fabianmariok@...>
Para: "IBObjects@yahoogroups.com" <IBObjects@yahoogroups.com>
Enviado: martes, 16 de julio de 2013 11:32
Asunto: Re: [IBO] Drop Connection
Thanks for your answer.
I have root on the linux server, anyone know how I can do so that the server does not disable network cards or firebird service disconnect (Suse Linux Enterprise Server 11 SP2). I'm check the power Management is default.
Fabian. Kruszelnicki
________________________________
De: Marcin Bury <marcin.bury@...>
Para: IBObjects@yahoogroups.com
Enviado: lunes, 15 de julio de 2013 12:57
Asunto: Re: [IBO] Drop Connection
Fabian
W dniu 15.07.2013 16:57, Fabian Mario Kruszelnicki pisze:
I'm facing same problems with certain Firebird instances on Linux (but
not all). My linux/network administrator has given up long time ago. For
certain reason the established connection is dropped but on the network
layer level not by Firebird, and as I has observed, it is dropped after
certain time of "inactivity". So I solved this problem setting a timer
that every 60 seconds it execute some dummy query (like select 1 from
rdb$database) just to "ping" the firebird server. And problems are gone...
HTH
Marcin
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Thank you for your help.
________________________________
De: Fabian Mario Kruszelnicki <fabianmariok@...>
Para: "IBObjects@yahoogroups.com" <IBObjects@yahoogroups.com>
Enviado: martes, 16 de julio de 2013 11:32
Asunto: Re: [IBO] Drop Connection
Thanks for your answer.
I have root on the linux server, anyone know how I can do so that the server does not disable network cards or firebird service disconnect (Suse Linux Enterprise Server 11 SP2). I'm check the power Management is default.
Fabian. Kruszelnicki
________________________________
De: Marcin Bury <marcin.bury@...>
Para: IBObjects@yahoogroups.com
Enviado: lunes, 15 de julio de 2013 12:57
Asunto: Re: [IBO] Drop Connection
Fabian
W dniu 15.07.2013 16:57, Fabian Mario Kruszelnicki pisze:
> I need help, I have a connection with IB_Query, IB_Transaction and IB_Connection (Windows Client Server 11 SP2 Suse Linux and Firebird 2.5) but at some point disconnected from the server and then fails loss of connectivity to the server. How I can solve this problem?Your last name suggests Polish roots, so greetings from Poland.
> Thank you.
> Fabian Kruszelnicki
>
> [Non-text portions of this message have been removed]
>
I'm facing same problems with certain Firebird instances on Linux (but
not all). My linux/network administrator has given up long time ago. For
certain reason the established connection is dropped but on the network
layer level not by Firebird, and as I has observed, it is dropped after
certain time of "inactivity". So I solved this problem setting a timer
that every 60 seconds it execute some dummy query (like select 1 from
rdb$database) just to "ping" the firebird server. And problems are gone...
HTH
Marcin
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]