Subject internal gds software consistency check (Error: can't lock database on llRead)
Author Thomas Woinke
Hi all,

I already posted this a while before without getting a reply. I'm
still stuck, so I'll ask again, and try to be more specific.

I'm using FB 2.1.1 SuperServer on Debian Etch/AMD64. The file system
used is XFS on Raid1 MD devices.

Occasionally, I encounter messages in the firebird.log file like the following:

s15267566 (Server) Wed Nov 12 00:05:19 2008
Database: /usr/local/firebird/security2.fdb I/O error
for file "/usr/local/firebird/security2.fdb"
Error while trying to read from file Bad file descriptor
internal gds software consistency check (Error: can't lock
database on llRead)

s15267566 (Server) Wed Nov 12 00:05:19 2008
I/O error for file "/usr/local/firebird/security2.fdb"


s15267566 (Server) Wed Nov 12 00:05:19 2008
Error while trying to read from file


s15267566 (Server) Wed Nov 12 00:05:19 2008
Bad file descriptor

s15267566 (Server) Wed Nov 12 00:05:19 2008
internal gds software consistency check (Error: can't lock
database on llRead)

then, later again
s15267566 (Server) Wed Nov 12 00:39:23 2008
I/O error for file "/usr/local/firebird/security2.fdb"
s15267566 (Server) Wed Nov 12 00:39:23 2008
Error while trying to read from file


s15267566 (Server) Wed Nov 12 00:39:23 2008
Bad file descriptor


s15267566 (Server) Wed Nov 12 00:39:23 2008
INET/inet_error: read errno = 88


s15267566 (Server) Wed Nov 12 00:39:23 2008
INET/inet_error: send errno = 88


s15267566 (Server) Wed Nov 12 00:39:23 2008
Database:
I/O error for file "/usr/local/firebird/security2.fdb"
Error while trying to write to file
Bad file descriptor

This last message is repeated 15 times.

The web application this server is hosting does run without any problems.
Suspecting database file corruption, I recreated security2.fdb with
gbak, but that didn't seem to be the problem.

My last guess would be filesystem corruption, but I thought I'd ask
here if there might be other things to consider.

So, thanks in advance for any hints.

Cheers,
Thomas