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

Can't complete operations (get full statistics, change FW, make backup) on database when FB works in embedded mode [CORE4938] #5229

Closed
firebird-issue-importer opened this issue Sep 18, 2015 · 11 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Attachments:
database-when-fbsvcmgr-actions-hang-on-completition.7z

Database in attached file can not be handled in embedded mode (see actions in the subj).
FBSVCMGR hangs just before completition - it can be easily checked when doing:

%FB30_HOME%\fbsvcmgr service_mgr action_db_stats sts_data_pages sts_idx_pages sts_record_versions dbname <path_to\database_file.fdb>

-- output is stopped just before statistics is about finish.

WI-V3.0.0.32033

Commits: aa8d717 FirebirdSQL/fbt-repository@8e73ffc

====== Test Details ======

Test machine has no FB instance running in embedded mode.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 18, 2015

Modified by: @pavel-zotov

Attachment: database-when-fbsvcmgr-actions-hang-on-completition.7z [ 12813 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 25, 2015

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 8, 2015

Modified by: @hvlad

assignee: Alexander Peshkov [ alexpeshkoff ] => Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 8, 2015

Modified by: @hvlad

Version: 3.0 Beta 2 [ 10586 ]

Version: 3.0 Beta 1 [ 10332 ]

Version: 3.0 Alpha 2 [ 10560 ]

Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0 RC 1 [ 10584 ]

environment: WIndows only

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 8, 2015

Commented by: @hvlad

Please, confirm

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 8, 2015

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 11, 2015

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

Test Details: Test machine has no FB instance running in embedded mode.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 11, 2015

Modified by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 11, 2015

Commented by: @pavel-zotov

> Vlad Khorsun added a comment - 08/Oct/15 07:42 AM
> Please, confirm

Window #⁠1 (when FB service was stopped)

C:\FBTESTING\qa\fbt-repo\tmp>C:\1INSTALL\FIREBIRD\fb30sC\isql.exe core_4938.fdb
Database: core_4938.fdb, User: SYSDBA
SQL> set list on;
SQL> select * from mon$attachments;

MON$ATTACHMENT_ID 40
MON$SERVER_PID 1996
MON$STATE 1
MON$ATTACHMENT_NAME C:\FBTESTING\QA\FBT-REPO\TMP\CORE_4938.FDB
MON$USER SYSDBA
MON$ROLE NONE
MON$REMOTE_PROTOCOL <null>
MON$REMOTE_ADDRESS <null>
MON$REMOTE_PID <null>
MON$CHARACTER_SET_ID 0
MON$TIMESTAMP 2015-10-11 10:05:11.7030
MON$GARBAGE_COLLECTION 1
MON$REMOTE_PROCESS <null>
MON$STAT_ID 2
MON$CLIENT_VERSION <null>
MON$REMOTE_VERSION <null>
MON$REMOTE_HOST <null>
MON$REMOTE_OS_USER <null>
MON$AUTH_METHOD User name in DPB
MON$SYSTEM_FLAG 0

Window #⁠2

run-1:
C:\1INSTALL\FIREBIRD\fb30sS\fbsvcmgr service_mgr action_db_stats sts_data_pages sts_idx_pages sts_record_versions dbname C:\FBTESTING\qa\fbt-repo\tmp\core_4938.fdb

run-2:
C:\1INSTALL\FIREBIRD\fb30sS\fbsvcmgr service_mgr action_properties prp_sweep_interval 222222 dbname C:\FBTESTING\qa\fbt-repo\tmp\core_4938.fdb

run-3:
C:\1INSTALL\FIREBIRD\fb30sS\fbsvcmgr service_mgr action_properties prp_write_mode prp_wm_async dbname C:\FBTESTING\qa\fbt-repo\tmp\core_4938.fdb

Result for all three commands:

I/O error during "CreateFile (open)" operation for file "C:\FBTESTING\QA\FBT-REPO\TMP\CORE_4938.FDB"
-Error while trying to open file
-The process cannot access the file because it is being used by another process

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 11, 2015

Commented by: @hvlad

Pavel,

seems you do not understand what are you doing.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Oct 11, 2015

Commented by: @pavel-zotov

Yes, sorry: could not recall what I've tested here initially :-[
Checked again, single attachment for each run1...run3 (no ISQL, of course) - all OK.

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