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