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
Security database remains locked after replacing database [CORE2859] #3244
Comments
Commented by: Sean Leyne (seanleyne) Are you using SuperServer or Classic engine? |
Commented by: prenosil (prenosil) SuperServer, Firebird-2.5.0.25920-0_Win32_RC2.zip |
Commented by: Sean Leyne (seanleyne) It seems logical that the security database would be "locked", since the engine would have a open connection to validate any new incoming user connections. You would need to shutdown the Firebird service using "NET STOP ..." before the file could be available to be renamed. |
Commented by: @dyemanov Sean, it shouldn't be the case. The security database gets disconnected as soon as the last user attachment goes away. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff I remember there was some problem with this, but I could not reproduce this before. I confirm an issue for SC / linux. |
Commented by: @AlexPeshkoff No need frontporting to HEAD - used in it method of caching security database connection makes it impossible to have such bugs as this. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC3 [ 10381 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: prenosil (prenosil)
Example:
GBAK -B "C:\Program Files\Firebird\Firebird_2_5\help\help.fdb" "C:\Program Files\Firebird\Firebird_2_5\help\help.fbk"
GBAK -C "C:\Program Files\Firebird\Firebird_2_5\help\help.fbk" "C:\Program Files\Firebird\Firebird_2_5\help\tmp.fdb"
GBAK -C -REP "C:\Program Files\Firebird\Firebird_2_5\help\help.fbk" "C:\Program Files\Firebird\Firebird_2_5\help\tmp.fdb"
RENAME "C:\Program Files\Firebird\Firebird_2_5\security2.fdb" security2_X.fdb
The RENAME command will fail, although no users are connected to any database nor fb service.
Commits: 5098340
The text was updated successfully, but these errors were encountered: