search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.22k stars 213 forks source link

GBAK crashes / freeze Firebird server on restore over existing database [CORE4835] #5131

Open firebird-automations opened 9 years ago

firebird-automations commented 9 years ago

Submitted by: Darko (irdanet)

In version 2.5.4.x GBAK crashes / freeze Firebird server on restore over existing database. In combination with GFIX and FULL shutdown, if you use GBAK with -REP option and try to restore database over existing one, gbak hangs on start and freeze firebird server. You need to open Windows task manager and kill Firebird server task and after that Guardian restart Firebird Server.

That problem is happened only in combination of these conditions: 1. GFIX - full shutdown 2. GBAK - restore with -REP option

Problem does not exist in Firebird version 2.5.2.26539 or 2.5.2.26540 - other version before 2.5.4.x I did not test.

Workaround 1: 1. GFIX: shutdown full 2. GFIX: online single

Workaround 2: 1. GFIX: shutdown full 2. DELETE database file 3. Restore with GBAK with same name

firebird-automations commented 9 years ago
Modified by: Darko (irdanet) Component: GBAK \[ 10006 \] summary: CLONE \-GBAK crashes / freeze Firebird server on restore over existing database =\> GBAK crashes / freeze Firebird server on restore over existing database
firebird-automations commented 9 years ago

Commented by: @AlexPeshkoff

Did not reproduce on linux:

localhost bin #⁠ ./gfix -shut full -force 0 test2.gdb localhost bin #⁠ ./gstat -h test2.gdb

Database "test2.gdb" Attributes force write, full shutdown

localhost bin #⁠ ./gbak -replace test2.gbak test2.gdb localhost bin #⁠ ./gstat -h test2.gdb

Database "test2.gdb" Attributes force write

localhost bin #⁠