Aldo wrote:

> Do you think that those error messages found in the
> /var/log/firebird.log are cause or consequence of the "lock manager
> out of room" error ? The errors reported are the following (the last
> one repeats for ever, as you see):
>
> servin (Server) Fri Feb 23 09:31:43 2007
> INET/inet_error: read errno = 9

Probably not related - I think that's a client that left
without saying good-bye.

>
> servin (Server) Fri Feb 23 09:31:43 2007
> SCH_validate -- not entered

I'm not sure what that's about but it's two minutes before the
next batch, so I doubt that it's related.

>
> servin (Server) Fri Feb 23 09:33:43 2007
> INET/inet_error: read errno = 88
>
> servin (Server) Fri Feb 23 09:33:43 2007
> INET/inet_error: send errno = 88

These two are TCP/IP errors indication that the function called
does not exist in this implementation. I don't know why.

>
> servin (Server) Fri Feb 23 09:33:43 2007
> Database:
> I/O error for file "/var/lib/firebird2/data/webhammer.fdb"
> Error while trying to write to file
> Bad file descriptor
>
> servin (Server) Fri Feb 23 09:33:43 2007
> Database:
> I/O error for file "/var/lib/firebird2/data/webhammer.fdb"
> Error while trying to write to file
> Bad file descriptor
>
> servin (Server) Fri Feb 23 09:33:43 2007
> Database:
> I/O error for file "/var/lib/firebird2/data/webhammer.fdb"
> Error while trying to write to file
> Bad file descriptor
>

Those are very likely the result of the lock table error - the most
common function of the lock table is to mediate access to the physical
database file. We may have an error condition that's not handled
correctly, leading to that loop.


Regards,


Ann