> I`m not sure if running a 24/7 trace is a good idea (database is under > relatively heavy load). Anything else I could do to help?
It might be ok with a proper include filter at service level from a Trace API POV. The following trace configuration should be fully dedicated to sweeping only: <database yourdatabasealias> enabled true print_perf true log_sweep true exclude_filter %RDB$% time_threshold 0 </database> <services> enabled true log_services true include_filter "Repair Database" </services> -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > btw I am noticing that the unexpected sweep is about 27000-30000 > transactions after the scheduled one. I could send a log if that helps > in any way. I set the interval to 100000 and in a day or two I`ll know > if it still runs by its own. > > 2014-10-27 21:46 GMT+02:00 Thomas Steinmaurer [email protected] > <mailto:[email protected]> [firebird-support] > <[email protected] > <mailto:[email protected]>>: > > __ > > > 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. > > > > >
