Subject Re: Huge Log file size crashing server
Author Adam
--- In firebird-support@yahoogroups.com, "R. S. Patil"
<kpr.rspatil@g...> wrote:
>
> Dear friends,
>
> We have following setup
>
> One Win 2003 server acting as PDC
> Another Win 2000 server
> A Linux (FC4 samba) Firebird Server.
>
> OFC Backbone 10/100baseT Lan with about
> 35 to 40 win 9x/xp nodes. Some are using
> SQL server based application on 2k3 server
> and some are using Firebird based application
> on Linux server.
>
> The Firebird server has been recently added to
> port a application which was earlier in paradox.
> For Firebird application D-5/IBO is used.
>
> We are facing a peculiar problem of very huge
> Firebird log file getting almost 6/7 GB
> which occupies whole partition and server
> crashes or application gets blocked.
>
> following line repeats thousand/million ... times
> to make the log file to such size
>
> rsp.com (Server) Sat Jan 28 10:24:57 2006
> INET/inet_error: read errno = 9
>
> Can somebody tell me what could be reason for this
> and how shall i overcome that. Is there any way to
> limit size of log file or reduce level of log in Firebird
> or time being eliminate log file altogether ?

Can I suggest you don't shoot the messenger. I have a production
server which has been in operation since May 2004 with a log file <
100KB, and this includes errors caused by a faulty UDF we had a while
back. I have no idea what that error code means, but the only
important events are logged are server crashes, server starts and
important messages.

It is a far better approach to stop these errors (which are probably
causing your users some grief given the amount of time the server
must spend restarting) than to bury your head in the dev/null and
pretend there is no error. Whether you choose to keep the log or not,
the errors will still occur. Deleting or trimming the log is sort of
like installing a drain under a leaking roof rather than repairing
the roof.

Adam