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

Database is not restored correctly using Services API [CORE1805] #2233

Closed
firebird-automations opened this issue Mar 27, 2008 · 15 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @alexpotapchenko

Attachments:
test.zip

Using gbak with switch [-se] databases backups in most cases are not restored correctly.
Error:
gbak: ERROR:lock conflict on no wait transaction
gbak:Exiting before completion due to errors

Commits: e3d7732 71703e1 aafed20 c1e726d

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

What architecture is affected? Do you have a test case? I tried restoring various backups with SS and SC and got no problems.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

On linux (both SS/CS) I've also failed to reproduce a bug.

@firebird-automations
Copy link
Collaborator Author

Commented by: @alexpotapchenko

I built server v. 2.5.0.19089 from cvs. This error is reproduced in all architectures with my private database backup (~70 mb). If you can't reproduce this error on a backup of the similar size, I will try to make the test case.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The biggest backup I tried was 280MB but still without luck.

@firebird-automations
Copy link
Collaborator Author

Commented by: @alexpotapchenko

I reproduced this bug with backup in attachment.
I used command: gbak.exe -c c:\test.fbk c:\test.fdb -user sysdba -password masterkey -se localhost:service_mgr -v

@firebird-automations
Copy link
Collaborator Author

Modified by: @alexpotapchenko

Attachment: test.zip [ 10810 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

I've reproduced some problems, related with attached database backup.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Me too. One issue is related to the not found partner index (the FK code still seems buggy), another one is an assert with an incorrect status vector.

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Alexander, can you comment please - how did it happen that absolutely all indices (including primary keys) are marked for deferred activation in your backup? If this is due to manual modification of system tables, it's OK. But if not, this means one more bug, and I need to know - how was this backup created?

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

summary: Database is not restored correctly under using Service Api => Database is not restored correctly using Services API

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Direct reason of a bug was passing an error in status vector from service even if it processed that error itself. But it also helped to solve a lot of problems with actively running MT engine shutdown.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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

2 participants