Hello Gustavo, There are 2 reasons for "freezing" - inefficient SQLs and wrong transactions/garbage strategy. These reasons cover 99,9% of problems with "freezing". Consider to have support from some knowledgeable Brazil professionals http://www.firebirdsql.org/en/firebase-brazil/ or learn how Firebird works with transactions and maintains garbage.
Regards, Alexey Kovyazin IBSurgeon Ltd (www.ib-aid.com) > 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] > > [Non-text portions of this message have been removed]
