Skip to content
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

Open
firebird-automations opened this issue Feb 17, 2017 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

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.

@firebird-automations
Copy link
Collaborator Author

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"?

@firebird-automations
Copy link
Collaborator Author

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.
Here are rough statistics of the tables:

Tables: 179
Generators: 88
Indices: 439
Triggers: 0
Procedures: 0

All objects owner are SYSDBA.

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Chau Chee Yang (cheeyang)

I have attached a zip file as requested:

database.fdb - database with meta data only after restore
restore.log - the abnormal lengthy restore log file

@firebird-automations
Copy link
Collaborator Author

Modified by: Chau Chee Yang (cheeyang)

Attachment: CORE5486.zip [ 13071 ]

@firebird-automations
Copy link
Collaborator Author

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?

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Could you show us gbak command line ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Chau Chee Yang (cheeyang)

GBAK with -v take very long time to restore (1 hour ++):

gbak \-c \-v backup\.fbk new\.fdb

GBAK without -v take restore time is normal (less than 5 minutes):

gbak -c backup.fbk new.fdb

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant