Subject ODP: [firebird-support] Gbak restore hangs on "activating and creating deferred indexes"
Author liviuslivius
Post date 2016-06-22T04:23:53Z
hi,

two things
1. try latest FB version in part, you have 2.5.4 but there is 2.5.6 or newer
2. 20 GB is small try to restore this db on normal PC if server have only 20GB free.

ps. in FB3 transaction id is int64 - no more problems :)

regards,
Karol Bieniaszewski


-------- Oryginalna wiadomość --------
Od: "Rune Bjønness Rune.Bjonness@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 22.06.2016 02:03 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Gbak restore hangs on "activating and creating deferred indexes"

 

Hi,

 

We're trying to do a restore of a 40 GB database (FB 2.5.4 / Win 2008 Server) because it has reached its transaction limit.

During our first restore attempt it seemed to freeze after having restored all records and started activating and creating deferred indexes.

That is, the size of the restored file was not changing for several hours and the last entry in the log file from gbak ended in the middle of a sentence.

 

We lost hope and cancelled the process, which resulted in several more log entries of "activating and creating deferred indexes" being written, but we got no error messages.

The server had 20 GB of available disk space left when the restore was hanging.

 

Do you have any suggestions to what the cause of this could be, or how we can identify the cause?

 

 

--Rune Bjønness