Skip to content
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

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

Open
firebird-automations opened this issue Jan 10, 2008 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 13809 ] => Firebird [ 13968 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Stan Kaushanskiy (sokaush)

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant