Subject Re: [firebird-support] Re: Database file modified shortly after NBACKUP -L
Author Kjell Rilbe
Den 2018-04-05 09:13, skrev hvlad@... [firebird-support]:
>
> ---In firebird-support@yahoogroups.com, <kjell.rilbe@...> wrote :
>
> ...
> >
> > It seems like the original database file is touched about a half to one
> > minute after being locked with NBACKUP -L.
> >
> > Why is the locked database file touched?
> >
> > I'm not sure if it's actually modified, but the timestamp is
> certainly updated.
>
>   Firebird itself doesn't update file timestamp directly.
> But filesystem often does it in lazy\background mode (for performance
> reason).
>
>   You may know for sure using ProcessMonitor tool, if you wish

After testing a bit more, I notice that the locked database file has its
timestamp updated when firebird.exe does a "FlushBuffersFile" operation,
which can occur several minutes after the NBACKUP -L operation.

Isn't that a bug? Everything should be flushed to file immediately when
(before?) the database file is locked, shouldn't it?

I'd appreciate some feedback on this.

Regards,
Kjell