New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Using GBAK to restore a 3GB+ database infinite "restoring privilege for user SYSDBA gbak" [CORE5486] #5756
Comments
Commented by: Sean Leyne (seanleyne) Was the backup file created by Firebird v3.x or previous version? How many metadata objects are in the database? Is the SYSDBA the database "owner"? |
Commented by: Chau Chee Yang (cheeyang) The backup is created by Firebird WI-V3.0.1.32609 Firebird 3.0 x64 running on Windows in service mode. Tables: 179 All objects owner are SYSDBA. |
Commented by: Sean Leyne (seanleyne) Please try to reproduce by restoring a "metadata only" backup. If successful, please consider posting a copy of the "metadata only" backup for the developers to review/test with. |
Commented by: Chau Chee Yang (cheeyang) I have attached a zip file as requested: database.fdb - database with meta data only after restore |
Modified by: Chau Chee Yang (cheeyang)Attachment: CORE5486.zip [ 13071 ] |
Commented by: Sean Leyne (seanleyne) Since the restore completed, though with an extremely long section of "restoring privileges". How long did the restore take? Are you waiting a similar length of time for the "restoring privileges" in your normal restore? |
Commented by: Chau Chee Yang (cheeyang) The restore took about 5 minutes to finish without -v (verbose output). It took more than 1 hour If using -v switch. |
Commented by: @hvlad Could you show us gbak command line ? |
Commented by: Chau Chee Yang (cheeyang) GBAK with -v take very long time to restore (1 hour ++):
GBAK without -v take restore time is normal (less than 5 minutes): gbak -c backup.fbk new.fdb |
Submitted by: Chau Chee Yang (cheeyang)
Attachments:
CORE-5486.zip
I am trying to restore a firebird 3 backup file of size 3GB++, the restore goes smooth by restoring table, create index. When i reach "restoring privilege" stage, it keep showing unstop
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
....
I don't know when it will end. It have run for more than 1 hour.
The text was updated successfully, but these errors were encountered: