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

Jump to bottom

fbsvcmgr info_svr_db_info does not see active attachments and databases in use (CLASSIC only) [CORE5413] #5686

Open
firebird-automations opened this issue Dec 4, 2016 · 3 comments
Open

fbsvcmgr info_svr_db_info does not see active attachments and databases in use (CLASSIC only) [CORE5413] #5686

firebird-automations opened this issue Dec 4, 2016 · 3 comments
Labels
affect-version: 2.5.6 affect-version: 3.0.1 component: svcmgr priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

1) ensure that FB 2.5 instance works as Classic:
REG.EXE query HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FirebirdServerfb25cs | findstr /i /c:"ImagePath"

Output:
----------
ImagePath REG_EXPAND_SZ C:\MIX\firebird\fb25Cs\bin\fb_inet_server.exe -s FB25Cs

(OK, there is no '-m' switch' ==> this is Classic)

2) connect to any database using this FB instance and stay in ISQL prompt:

C:\MIX\firebird\fb25Cs>C:\MIX\firebird\fb25Cs\bin\isql localhost/3249:e25 -z
ISQL Version: WI-V2.5.7.27027 Firebird 2.5
Server version:
WI-V2.5.7.27027 Firebird 2.5
WI-V2.5.7.27027 Firebird 2.5/tcp (csprog)/P12
WI-V2.5.7.27027 Firebird 2.5/tcp (csprog)/P12
Database: localhost/3249:e25
SQL>

3) try to get number of active databases and attachments:

C:\MIX\firebird\fb25Cs>C:\MIX\firebird\fb25Cs\bin\fbsvcmgr localhost:service_mgr info_svr_db_info -z
Firebird services manager version WI-V2.5.7.27027 Firebird 2.5
Databases:
Number of attachments: 0 <<< ???
Number of databases: 0 <<< ???

The same on FB 3.0.x & 4.0.
@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

This was the case since the very beginning, the service manager returns only info about the server process you are connected to.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

IMO, it will be good to warn user not to use such option (' info_svr_db_info') against Classic - I mean when issue 'fbsvcmgr -?'

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

fbsvcmgr is a trivial interface over the Services API. IMHO, it shouldn't be smarter than the underlying API.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.5.6 affect-version: 3.0.1 component: svcmgr priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations