search

FirebirdSQL / firebird

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

Firebird tools sometimes fail when scripted in single-user mode [CORE1683] #2108

Open firebird-automations opened 16 years ago

firebird-automations commented 16 years ago

Submitted by: Zahari Shoylev (zack)

Switch database to single user mode, like gfix dbalias -user SYSDBA -pass ***** -shut single -force 0

Then run this batch file:

:test gfix dbalias -user SYSDBA -pass ***** -mend gbak -b -ig -g -l "127.0.0.1:dbalias" "C:\backup.fbk" -user SYSDBA -password ***** del "c:\backup.fbk" goto test

In 16 runs I get 3 instances of either gbak or gfix reporting that the database is offline. This makes it hard to run gfix/gbak and perhaps other tools sequentially in a script. It would seem that sometimes the engine does not release the SYSDBA connection in a timely manner.

firebird-automations commented 16 years ago
Modified by: Zahari Shoylev (zack) description: Switch database to single user mode, like gfix dbalias \-user SYSDBA \-pass \*\*\*\*\* \-shut single \-force 0 Then run this batch file: :test gfix dbalias \-user SYSDBA \-pass masterkey \-mend gbak \-b \-ig \-g \-l "127\.0\.0\.1:dbalias" "C:\\backup\.fbk" \-user SYSDBA \-password \*\*\*\*\* del "c:\\backup\.fbk" goto test In 16 runs I get 3 instances of either gbak or gfix reporting that the database is offline\. This makes it hard to run gfix/gbak and perhaps other tools sequentially in a script\. It would seem that sometimes the engine does not release the SYSDBA connection in a timely manner\. =\> Switch database to single user mode, like gfix dbalias \-user SYSDBA \-pass \*\*\*\*\* \-shut single \-force 0 Then run this batch file: :test gfix dbalias \-user SYSDBA \-pass \*\*\*\*\* \-mend gbak \-b \-ig \-g \-l "127\.0\.0\.1:dbalias" "C:\\backup\.fbk" \-user SYSDBA \-password \*\*\*\*\* del "c:\\backup\.fbk" goto test In 16 runs I get 3 instances of either gbak or gfix reporting that the database is offline\. This makes it hard to run gfix/gbak and perhaps other tools sequentially in a script\. It would seem that sometimes the engine does not release the SYSDBA connection in a timely manner\.
firebird-automations commented 16 years ago
Modified by: @pcisar Workflow: jira \[ 13809 \] =\> Firebird \[ 13968 \]
firebird-automations commented 13 years ago

Commented by: Stan Kaushanskiy (sokaush)

This issue still happens with firebird 2.1.3 on many Windows operating system versions.