| Subject | Re: [firebird-support] FB 2.5 and lock |
|---|---|
| Author | John vd Waeter |
| Post date | 2014-11-22T23:08:16Z |
On 22-11-2014 18:55, 'Leyne, Sean' Sean@...
[firebird-support] wrote:
SuperClassic, most databases have sweepinterval=0 (it's handled in a
batch nightly, just before backup). 3 have the default of 20000.
But the occurring sweep of a database should not freeze other clients to
other databases?
John
[firebird-support] wrote:
>Hi Sean,
>
>> Ok, rephrased:
>>
>> Is it possible that a deadlock causes all connections to all databases to freeze?
>>
>> And if not, is there a known cause for all connections to all databases to
>> freeze?
>
> What Firebird engine type (Classic, SuperServer)?
>
> What does the database page header details for the databases show for "sweep interval"?
>
>
> Sean
>
>
SuperClassic, most databases have sweepinterval=0 (it's handled in a
batch nightly, just before backup). 3 have the default of 20000.
But the occurring sweep of a database should not freeze other clients to
other databases?
John