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]