Hi,

We have a system developed in PHP withFirebird database and Jboss running
for a services communications with the Brazilian government's WebService.

After migrating for a new DELL server due to performance issues, Firebird is
freezing after working for sometime. The PID of firebird and fbguard is
working, but the database server rejects connections. After restarting
firebird, it works again.

See below the messages in firebird log:
INET/inet_error: read errno = 9 → Many times.
INET/inet_error: read errno = 104 → Sometimes.
INET/inet_error: connect errno = 111 → After this message, Firebird freezes.

Here are some possibilities we thought for this error to occur:
1) Database is processing request for query of design problem;
2) This version of firebird has a bug
3) Some incompatibility with S.O.
4) Some incompatibility with a library UDF RFUNC;
5) Problem with PHP 4.4.0;

We have been facing this problem for over 30 days now;


Any idea on how to solve the problem?

How cant we to verify the origem of the problem?

We're working to migrate the version for PHP 5 and Firebird 2.5, but it
takes time to stabilize the system. Meanwhile, we have to solve this
problem in which Firebird freezes.

Thanks for your help,

See below details on the server, S.O., and database file.

About Database File
--------------------------
Size: 5.4GB
Tables: 665
Views: 62
Procedures: 1113
Triggers: 268
Indexes: 3324



-----------------------------------------
About Server
-----------------------------------------
Servidor DELL
Intel Xeon E5620 @ 2.40GHz
32GB de RAM;
828GB HD
Installed XenServer 6.0


-----------------------------------------
About VM's
-----------------------------------------

1) VM for apache2 and php 4.4.0 with truck Accelator; 6GB RAM; 6 CPU and
100GB HD
S.O. CentOS 5.6 amd64

2) VM for firebird SS 2.0.6 with UDF rfunc; 6GB RAM; 1 CPU and 100GB HD
S.O. CentOS 5.6 amd64.

3) VM for Jboss 5. 6GB RAM and 100GB HD. S.O. CentOS 5.6 amd64.

Best Regards,

Gustavo Moda


[Non-text portions of this message have been removed]