Hello!
Our company has had web application for like 5 years running on
firebird - no problems at all(one time I had a bad plan with left
join =D). Thanks, great job.

Well like few days ago we had kind of weird problem. Nothing bad
happened. Just 15mins offline and few calls from clients ;)

I tried to backup, but I got same info. So finally we just turned
firebird off ja back online again. After that it just worked fine as
nothing happened.

I read that somebody had same kind of "SCH_validate -- not entered"
error after about 1 years online. Is it advisable to boot firebird
say every 3-4 months to avoid these kind of situations? (We are
upgrading to FB 2.01 or 2.1(?) at near future)

BTW, I am using SYSDBA(only user) logging in with my PHP. Is that bad
thing?

Problem:
When I tried to open web page, it said:
I/O error for file "...fdb" Error while trying to write to file
Illegal
seek in [php file] on line ..


(Occasional errno = 9 and errno = 111, just usual stuff)

firebird.msg
... (Server) Tue Feb 27 12:58:44 2007
INET/inet_error: read errno = 9

... (Server) Tue Feb 27 14:26:07 2007
SCH_validate -- not entered

... (Server) Tue Feb 27 14:28:07 2007
INET/inet_error: read errno = 88

... (Server) Tue Feb 27 14:28:07 2007
INET/inet_error: send errno = 88
... (Server) Tue Feb 27 14:28:07 2007
Database:
I/O error for file "..database.fdb"
Error while trying to write to file
Illegal seek

***
Many times...
***
... (Server) Tue Feb 27 14:42:08 2007
Database:
I/O error for file "..database.fdb"
Error while trying to write to file
Illegal seek

... (Client) Tue Feb 27 14:42:09 2007
/opt/firebird/bin/fbguard: bin/fbserver normal shutdown.


... (Client) Tue Feb 27 14:42:14 2007
INET/inet_error: connect errno = 111
... (Client) Tue Feb 27 14:42:14 2007
/opt/firebird/bin/fbguard: guardian starting bin/fbserver




We are running:
P4 3GHz HT
1G Memory
Fedora core 4
RAID 1?(mirrored?) 12G / 120G used
Load could been around 0.22 0.09 0.03 (shouldn't be problem :))
Apache 2.2.0
PHP 5.1.2 (Only user of firebird / IBExpert but not then)
LI-V6.3.3.4870 Firebird 1.5(.3?) (SS)
DB Filesize 248MB (63649 pages)
3 UDFs registered, but we don't use them at all.

Database header page information:
Flags 0
Checksum 12345
Generation 497185
Page size 4096
ODS version 10.1
Oldest transaction 497174
Oldest active 497175
Oldest snapshot 497175
Next transaction 497176
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 8192
Next header page 0
Database dialect 3
Creation date Nov 15, 2006 23:49:33
Attributes force write, no reserve

Variable header data:
Sweep interval: 10000
*END*

-Jarkko