> I did some reconfiguration on a database yesterday, so I`m monitoring
> the logs for any issues and I noticed something strange :
>
> Mon Oct 27 16:54:25 2014
> Sweep is started by SYSDBA
> Database "orbis-aton"
> OIT 21080, OAT 21081, OST 20456, Next 44177
>
> (yes, I know it`s a bad idea but all database connections are by SYSDBA)
>
> I don`t remember running a sweep (logs say I wasn`t even logged in at
> the time) and nobody else has access (or knowledge, for that matter) to
> run a sweep on that machine so I got curious.
> Logs say an unexpected sweep has been running basically every day
> (sometime between 5 and 10 pm, which is apparently when it hits the
> number of transactions). I have a manual sweep at 5:40am in cron and I
> checked - configuration is correct and runs as expected. I also
> double-checked gstat :
>
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 51454
> Page size 16384
> ODS version 11.2
> Oldest transaction 21357
> Oldest active 50561
> Oldest snapshot 49520
> Next transaction 51318
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 130
> Implementation ID 24
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Oct 26, 2014 12:28:26
> Attributes force write
>
> Variable header data:
> Sweep interval: 0
> *END*
>
>
> Shouldn`t automatic sweep be disabled or have I misread the
> documentation? FB version is 2.5.3.

Yes, by setting the sweep interval to 0, automatic sweeping should be
disabled. There is also: http://tracker.firebirdsql.org/browse/CORE-4100
(marked as fixed in 2.5.3) but you are mentioning that you are using
2.5.3, although I'm not entirely sure if CORE-4100 applies to sweep
interval = 0 anyway.

You could use the Trace API to trace services API requests to get a
clearer picture on what client application is causing the sweep in case
it has been triggered manually.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.