Subject Re: [firebird-support] INET/inet_error:
Author Milan Babuskov
danez1974 wrote:
> we have a web platform using firebird 1.5.4 on linux fedora 3
> whit php4.

Running any kind of production server on Fedora 3 (which *is*
experimental, i.e. beta software) is a sure way to learn about it's
quirks. I've seen too many problems with Fedora to count them,
especially with versions 1, 2 and 3.

If you want to sleep tight at night, and really want RedHat type of
system, either buy RHEL or use free CentOS.


> fedora (Server) Fri Mar 30 10:19:51 2007
> Database:
> I/O error for file "/dati/DB.FDB"
> Error while trying to write to file
> Bad file descriptor

I'm puzzled with BIG CHARACTERS in file name. What is the filesystem?
Did you by any chance put database on FAT32 or something similar?


> After this type of error the db crash and we have to restart firebird
> service.

Database is a file, it cannot crash. Either PHP/Apache crashes or
Firebird crashes. It FB crashed, it should "restart" itself. I guess
you're using Super Server, so fbguard should be restarting it. What does:

$ pstree | grep fb

give you?

> We are I can find a specific description of firebird's error (111,88,etc)

These are not Firebird errors, but network errors by TCP/IP stack.

Here's a list for Linux:
http://corz.org/public/scripts/docs/php/php.TCP-IP.socket.error.codes.txt

You can also find it on your Linux box in:
/usr/include/asm/errno.h


Here's a list for Windows:
http://www.sockets.com/err_lst1.htm



--
Milan Babuskov
http://www.guacosoft.com