Do you mean autorestarting your application or firebird service?

Mario


De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] En nombre de Mr. John
Enviado el: miércoles, 18 de mayo de 2011 8:33
Para: firebird-support@yahoogroups.com
Asunto: Re: [firebird-support] Internal gds software consistency check(cannot start thread)



I solved this problem autorestarting application after 30 connections,now it
works fine.

________________________________
From: Helen Borrie <helebor@...<mailto:helebor%40iinet.net.au>>
To: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com>
Sent: Mon, May 16, 2011 11:17:04 AM
Subject: Re: [firebird-support] Internal gds software consistency check(cannot
start thread)

At 07:05 PM 16/05/2011, you wrote:

>Hi Mario and thanks for your answer!
>There is a optimal value for this ? What is the MIN I should set to avoid other

>problems,this time there is such a line : #DefaultDbCachePages = 2048
>What I don't understand is why FB is acting this way as long I create a single
>connection one time,I run scrips then closing the connection,then the same with

>next fdb file

Don't forget, a "fdb file" is a receptacle for a database, not simply a file
that you write something in.

The SS cache is for *each* database, not for all connections to all databases.

"Closing the connection" doesn't necessarily close the database, either, since
the engine will still be busy completing the work requested by your DDL script
and possibly taking the opportunity to do some garbage collection.

So your Firebird server is using a lot of resources that you didn't think it
ought to because, in your mind, all these databases are just a collection of
files.

106 databases on one 32-bit XP box with 2GB RAM...and the server actually
survives until you have 90 of them open...that's pretty amazing! ;-)

./heLen

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


________________________________
Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente.
Evite imprimir este mensaje si no es estrictamente necesario.

This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address.
Avoid printing this message if it is not absolutely necessary.


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