Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-27 Thread Lester Caine
Gustavo Moda wrote: 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. So what are you using currently? The php_interbase driver for PHP4 never had any of the extras

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-27 Thread Gustavo Moda
Hi Lester, Tnanks for answering. 2012/2/27 Lester Caine les...@lsces.co.uk So what are you using currently? Apache2 and PHP 4.4 complled for we with driver ibase_internet using library do FB 2.0.6 on Linux CentOS 5.6. Best Regards [Non-text portions of this message have been removed]

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-27 Thread Lester Caine
Gustavo Moda wrote: Hi Lester, Tnanks for answering. 2012/2/27 Lester Caineles...@lsces.co.uk So what are you using currently? Apache2 and PHP 4.4 complled for we with driver ibase_internet using library do FB 2.0.6 on Linux CentOS 5.6. You probably need to remember that PHP4 has

[firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Gustavo Moda
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

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Mercea Paul
On 2012.02.25 9:56 PM, Gustavo Moda wrote: INET/inet_error: connect errno = 111 Maybe you could have some network problems ( for VM )! Regards, -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Alexey Kovyazin
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