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

Database alias is visible when trying to drop database [CORE1105] #1525

Closed
firebird-automations opened this issue Jan 22, 2007 · 7 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @cincuranet

When you try to drop database with i.e. running transaction, you get:
drop database;
Statement failed, SQLCODE = -901
lock time-out on wait transaction
-object /fbsql/marisa.fdb is in use

but I'm using only aliases and access is setted to None (DatabaseAccess param) in firebird.conf.

The show database command shows only the alias:
show database;
Owner: TESTIK
Default character set: NONE
Database: marisa
Site: cincura, cincura, x2acer
Version: LI-V6.3.0.12748 Firebird 2.0

Creation date = 2007-01-22 21:19:59.0330
Page size = 8192
Number of DB pages allocated = 31818
DB buffer pages = 0
Actual buffer pages = 2048
Database SQL dialect= 3
Sweep interval = 20000
Forced Writes are OFF
Read Only flag is OFF
Reserve flag is ON
Transaction - oldest = 232
Transaction - oldest active = 233
Transaction - oldest snapshot = 233
Transaction - Next = 233
ODS = 11.0

Commits: 8a07d31 e1d3bbc c255169 5603131 1c2de56

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Target: 2.5.0 [ 10221 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11534 ] => Firebird [ 15185 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Open [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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

2 participants