Subject | Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend |
---|---|
Author | Mark Rotteveel |
Post date | 2018-01-11T13:24:24Z |
On 11-1-2018 13:21, jonatan.lauritsen@... [firebird-support] wrote:
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html#d0e30354:
"""
This causes the corruptions in data records to be ignored. While this
sounds like a good thing, it is not. Subsequent database actions (such
as taking a backup) will not include the corrupted records, **leading to
data loss**.
"""
Mark
--
Mark Rotteveel
> I checked the system again - we use 3.0.2 indeed.Use of gfix -mend can lead to data loss, see
>
> There is no particular reason why we use -mend. We use it routinely
> between backup/restore operations to prevent the situation that any
> corruption errors my intervene in our operations. My understanding is
> that mend can not and it should not cause any troubles.
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html#d0e30354:
"""
This causes the corruptions in data records to be ignored. While this
sounds like a good thing, it is not. Subsequent database actions (such
as taking a backup) will not include the corrupted records, **leading to
data loss**.
"""
Mark
--
Mark Rotteveel