> Hi. Today, the users of one of my Firebird 2.5 databases reported that > the database works very slow. After I checked I saw that there is an > attachment from SWEEPER user and it is doing something. The database size > is little over 500 MB. But the sweeper is working over 2 hours now, with no > other connections to the database and no signs to finish soon. What can I > do? Set the sweep interval to 0, restart the Firebird server and perform > manually backup restore? Or to wait to finish, but the users need the > database. > > The gap between Oldest transaction and Next transaction is very big - few > times bigger than Sweep interval, perhaps this is the reason why it > started. But this problem is for the developers to resolve. > > There is a bug solved in firebird 2.5.3, about sweeper that may be raleted with your case.
See http://tracker.firebirdsql.org/browse/CORE-4100
