Issue Details (XML | Word | Printable)

Key: CORE-1683
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Zahari Shoylev
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Firebird tools sometimes fail when scripted in single-user mode

Created: 10/Jan/08 08:43 PM   Updated: 04/May/11 06:06 PM
Component/s: Engine, GBAK, GFIX
Affects Version/s: 2.0.0
Fix Version/s: None

Environment:
Windows XP 32bit Pro SP2
2gb ram; duo-core
firebird 2.0.0 superserver


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Stan Kaushanskiy added a comment - 04/May/11 06:06 PM
This issue still happens with firebird 2.1.3 on many Windows operating system versions.