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

Restore database with large page buffer - connection lost to database [CORE5240] #5519

Closed
firebird-automations opened this issue May 16, 2016 · 17 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: David Kroll (dkroll)

I've got a 13GB Firebird database, running FB 2.5.5 x64. The page buffers are set at 800,000, page size 16384. When trying to restore from a backup with these buffers and page size, the restore gets to the "finishing, closing, and going home" part, then returns a "connection lost" error. Checking Windows event viewer shows "Firebird Server Default Instance service terminated unexpectedly". I'm unable to connect to the database at this point.

I can, however, restore the database with page buffers of 60,000 and page size of 16384, and the restore will work.

Thank you.

Commits: ce211eb

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Do you have 13GB of memory available on machines? Any errors in firebird.log?

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Yes, I have 32GB of RAM with over 20GB free. Sometimes firebird.log shows ""C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)", sometimes no error.

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Forgot to mention I'm running SuperServer.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The ussue is at our internal allocator which is unable to track memory blocks bigger than 4GB.
Simplest patch is committed into v2.5.6, please test next snaphot build.
For v3 and v4 there could be more complex solution

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Vlad, the last snapshot build is from 5/13. Will there be a new one today?

Sorry for my ignorance, I'm new to getting snapshot builds.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

New snapshots will be available tomorrow.

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Thank you for your quick attention to this issue. I truly appreciate it.

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

The 2.5.6 snapshot build fixed the problem. Thanks!

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Will there be an official 2.5.6 release in the future?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Yes, within a month.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

David,

thanks for testing

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Allocator in v3 is not affected

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.6 [ 10721 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: David Kroll (dkroll)

Great, I'm looking forward to getting the next release. Thank you for your quick assistance gentlemen!

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Not enough information

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

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