I know from experience that a restore can sometimes leave indexes in a
disabled state, and you would usually get an error when trying to
activate it as it was left disabled during the restore phase due to a
minor data issue. The errorlevel returned by GBAK is greater than 0 so
you can detect when this has happened without having to check all the


We see this with our firebird databases on occasion, it's preferable to
the restore just failing and having to be run again without restoring
indexes and manually identifying and dealing with the data issue then
turning all the indexes back on again. It seems to be minor data issues
that cause the index gets left disabled by GBAK, bigger issues and the
restore will just stop with an error.




Neil Pickles


From: firebird-support@yahoogroups.com
Sent: 23 February 2018 11:21
To: firebird-support@yahoogroups.com
Subject: [firebird-support] causes for disabled indexes





I'm using firebird embedded (2.5 and 3) in an on-premise solution. I get
sometimes reports of slow behaviour and when checking those databases I
can see that some or all indexes are disabled.

I can than simply enable those indexes and all seems well afterwards.
Gfix does not find any problems and backup/restore works without a
problem either then.


Are there some known causes that will result in disabled indexes without
breaking the database otherwise?

The application itself doesn't touch indexes directly they just get
created at some point.




  • [firebird-support... Ralf Jansen ralf.jan...@mailstore.com [firebird-support]
    • RE: [firebir... 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
      • [firebir... Ralf Jansen ralf.jan...@mailstore.com [firebird-support]

Reply via email to