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]
