On 22-11-2014 18:55, 'Leyne, Sean' [email protected] [firebird-support] wrote: > > >> 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 > >
Hi 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
