firebird icon indicating copy to clipboard operation
firebird copied to clipboard

shadow ...shd delete from database ...fdb due to unavailability on attach

Open alemao2019 opened this issue 3 years ago • 0 comments

Hello, I have a problem with shadow. I use Firebird-3.0.8.33535_0_x64. So I saw in <firebird.log> that Firebird deletes my shadow files. The message is logged in <firebird.log> as follows: shadow ... shd delete from database ... fdb due to unavailability on attach. I don't think it's because the databases are over 300 MB !!! I tried the following: Restore with gbak database, then recreate shadow file with command: create shadow 1 auto 'path / filename.shd'; OK. After 24 hours when checking the log I find the message: shadow ... shd delete from database ... fdb due to unavailability on attach. Hhmm interesting because in RDB $ FILES the registration with the shadow file related to the database is removed. I also tested with version Firebird-3.0.9.33560_0_x64 - the problem was repeated. I did a database validation, and I didn't get an error message. I didn't see any error messages on backup and / or restore either. Observation

  • monthly and then daily incremental backup (with nBackup)
  • I also do a full monthly backup (gback) Of course, the other databases work fine and update their shadow files without any problems.

What's the matter, am I wrong somewhere?

Thank you for help !

alemao2019 avatar Feb 22 '22 09:02 alemao2019