gbak does not do sweep unless sweep threshold exceeded
------------------------------------------------------
Key: CORE-6190
URL: http://tracker.firebirdsql.org/browse/CORE-6190
Project: Firebird Core
Issue Type: Bug
Components: GBAK
Affects Versions: 2.5.7
Environment: Windows
Reporter: T J C
Priority: Minor
I had understoon that a backup would reset the Oldest Interesting Transaction
(OIT) as well as
the Oldest Snapshot (OST) and had set the sweep interval to zero, and was doing
nightly backups
(see bottom for documentation issue)
I have since found that when the sweep interval is set to zero, no sweep is
done during a gbak backup
regardless of the -g parameter. I would expect the sweep functionality and
setting the OIT would be done
when garbage collection is done.
Of interest however, if the sweep interval is set below the (OST - OIT)
immediately before the
backup is done, then a gbak backup *DOES* do the sweep set the OIT value, so I
assume
the sweep is being done.
In my opinion, a gbak backup should be doing a sweep, regardless of the
sweep interval, unless the -g option is specified.
Apologies if my lack of internals knowledge makes you think I have no idea
what I am talking about... entirely possible :)
It seems to me that this is at the least this is a documentation issue
See https://firebirdsql.org/manual/gfix-housekeeping.html
"Disabling Automatic Sweeping
If you set the sweep interval to zero then automatic sweeping will be disabled.
This implies that there will be no automatic housekeeping done so your database
performance will not suffer as a result of the processing requirements of the
automatic sweep.
If you disable sweeping you are advised to run a manual sweep at regular
intervals when the database is quiet.
*Alternatively, simply make sure that you take regular backups of the database
and as this is something you should be doing anyway, it shouldn't be a
problem.*"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
