R. S. Patil wrote:

>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.
>
>

Firebird server only crashes *after* partition space is exausted?
User applications works ok while there is disk space?

>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
>
>

errono = 9 means 'invalid file number/descriptor'. Since it's a
INET error, it means Firebird passed a invalid socket descriptor
to Linux on a read operation. The reason? No idea.

>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 ?
>
>

There isn't level configuration for log messages on Firebird. On a
normal setup, log file grows very slowly, since only very important
events are logged. Since you have the source code you could redirect
log file to /dev/nul, making it disapear, but it's not something
I whould advice.

Ultil somebody produces a better response, plese tell us:

CPU?
Firebird version?
Classic, Superserver?
You can nottice log file growth with no client connections?
Log growth accelerates as more client connects?

>Thanks and Best regards
>
>R. S. Patil
>
>

Ivan.