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
On 11-1-2018 13:21, jonatan.lauritsen@... [firebird-support] wrote:
> I checked the system again - we use 3.0.2 indeed.
>
> 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.

Use of gfix -mend can lead to data loss, see
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