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: