> Well, I`ve done two things since the last post
>
> 1 I set the sweep interval to 100000 (I assume I`m far from reaching
> that on a normal day)
> No change - Yesterday, another unexpected sweep at 5:08:03 pm
>
> 2 I started a trace session with the suggested config (changing only DB
> alias, as instructed - I don`t really have much experience with the
> trace API)
> Today a sweep happened at 5:08:56 (about 28000 transactions after the
> morning manual sweep). It`s suspiciously close as a time frame, but
> looking back at the last month or so - sweeps are distributed in the
> 5-10pm range, so I guess it could be a coincidence.
>
> Trace log ti this moment is as follows :
> Trace session ID 2 started
> 2014-10-28T18:06:59.8670 (9756:0x7f5e704849e0) TRACE_INIT
> SESSION_2
>
>
> 2014-10-28T18:07:57.6530 (9768:0x7f7d2e4399e0) TRACE_INIT
> SESSION_2
>
>
> 2014-10-28T18:07:57.6530 (9768:0x7f7d2e4399e0) ATTACH_SERVICE
> service_mgr, (Service 0x7f7d2e4578d0, firebird, internal)
>
> 2014-10-28T18:07:57.6530 (9768:0x7f7d2e4399e0) DETACH_SERVICE
> service_mgr, (Service 0x7f7d2e4578d0, firebird, internal)
>
> 2014-10-28T18:07:57.6530 (9768:0x7f7d2e4399e0) TRACE_FINI
> SESSION_2
>
>
> 2014-10-28T18:08:16.7590 (9779:0x7fdb860fd9e0) TRACE_INIT
> SESSION_2
>
>
> 2014-10-28T18:08:16.7590 (9779:0x7fdb860fd9e0) ATTACH_SERVICE
> service_mgr, (Service 0x7fdb8611b8d0, firebird, internal)
>
> 2014-10-28T18:08:16.7590 (9779:0x7fdb860fd9e0) DETACH_SERVICE
> service_mgr, (Service 0x7fdb8611b8d0, firebird, internal)
>
> 2014-10-28T18:08:16.7590 (9779:0x7fdb860fd9e0) TRACE_FINI
> SESSION_2
> I assume those entries are from when I was poking around in the
> beginning. The trace session is still active but log says nothing about
> sweeping. Wasn`t it supposed to show at least the sweep by gfix (the one
> running from cron)? I`ll try fine tune it a bit on the weekend when most
> users are gone and won`t notice. If anyone has any suggestions I could
> test to help in the mean time - they`d be appreciated.

Can you show us the changed trace config and the exact gfix call in your
cron job?



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

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

>
> 2014-10-27 22:41 GMT+02:00 Thomas Steinmaurer ts@...
> <mailto:ts@...> [firebird-support]
> <firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>>:
>
> __
>
> > 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 Steinmaurerts@... <mailto:ts@...>
> > <mailto:ts@... <mailto:ts@...>>
> [firebird-support]
> > <firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>
> > <mailto:firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>>>:
> >
> > __
>
>
> >
> > > 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.
> >
> >
> >
> >
> >
>
>
>
>
>