Subject Re: FB Service Shuts Down during High Load
Author anchovies
>
> From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of anchovies00
> Sent: Tuesday, 8 March 2011 4:02 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] FB Service Shuts Down during High Load
>
>
>
> Hi,
>
> We are running 64bit FB 2.1.3 on Windows Server 2008.
> During high connection load/query from app.servers, the FB service seems to shut down and guardian will restart it. We have another infra. setup using 32bit Windows 2003 - same issue.
>
> ODS Version - 11.1
> Page size -16384
> Pages - 4635791
> Size on disk - 70.74GB
> Page buffers - 2048
> Read only - false
> Dialect - 3
> Sweep interval - 200000
> Forced writes - ON
>
> The error seen is
> Unable to complete network request to host "". Reason: Unable to complete network request to host "". at
>
> We have not tried to simulate these yet, but this is the 2nd time we have encountered this. Connections are pooled in C3P0 via hibernate.
>
> Was just wondering if any of you have encountered the above before. Query load shd be about hundreds.
>
> Much thanks,
> John
>
>
>
> [Non-text portions of this message have been removed]
>
--- In firebird-support@yahoogroups.com, Paul Lopez <paul.lopez@...> wrote:
>
> Hi John,
>
> I've encountered similar issues before and a couple of things came out of the investigation:
>
> Some blob handling (with FB 2.5) caused memory leaks when we were gathering large amounts of data.
>
> AND
>
> Using a UDF function (I think originally FreeUDF.dll), sometimes with BLOBs which was causing multiple memory leaks
>
> Hope this helps and points you in the right direction.
>
> Paul.


Hi Paul,

Thanks for the reply. However, the memory consumption where FB service is running does not seem to increase as per memory leaks scenario. will check it out though on blobs.

Anybody else has experienced this before? I'm leaning towards highvolume insert stmts.

Thanks,
John