Attribute 'multi-user maintenance' can not be seen if 'backup-lock' was set
before this
----------------------------------------------------------------------------------------
Key: CORE-6402
URL: http://tracker.firebirdsql.org/browse/CORE-6402
Project: Firebird Core
Issue Type: Bug
Components: Engine, NBACKUP, SVCMGR
Reporter: Pavel Zotov
####### Scenario-1 #######
Create empty DB.
C:\FB\30SS\gstat -h localhost:e30 | findstr /i /c:"attributes"
Attributes
C:\FB\30SS\fbsvcmgr localhost:service_mgr user sysdba password masterkey
action_properties prp_shutdown_mode prp_sm_multi prp_shutdown_db 0 dbname
C:\FBTESTING\qa\misc\e30.fdb
C:\FB\30SS\gstat -h localhost:e30 | findstr /i /c:"attributes"
Attributes multi-user maintenance
C:\FB\30SS\nbackup -L e30
C:\FB\30SS\gstat -h localhost:e30 | findstr /i /c:"attributes"
Attributes multi-user maintenance, backup lock
Result: EXPECTED. Both attributes can be seen here.
####### Scenario-2 #######
Create empty DB.
C:\FB\30SS\nbackup -L e30
C:\FB\30SS\gstat -h localhost:e30 | findstr /i /c:"attributes"
Attributes backup lock
C:\FB\30SS\fbsvcmgr localhost:service_mgr user sysdba password masterkey
action_properties prp_shutdown_mode prp_sm_multi prp_shutdown_db 0 dbname
C:\FBTESTING\qa\misc\e30.fdb
C:\FB\30SS\gstat -h localhost:e30 | findstr /i /c:"attributes"
Attributes backup lock -- <<<-----------------------------
here only 'backup lock' is shown; where is "multi-user maintenance" ?
PS. Attribute "multi-user maintenance" actually is in work.
Check whether DB is actually in shutdown:
C:\FBTESTING\qa\misc>echo set list on;select mon$shutdown_mode from
mon$database; | C:\FB\30SS\isql /:e30
Database: /:e30, User: SYSDBA
SQL>
MON$SHUTDOWN_MODE 1
Check whether DB is multi-user maintenance
1) try to connect as non-privileged user:
C:\FBTESTING\qa\misc>echo set list on;select mon$shutdown_mode from
mon$database; | C:\FB\30SS\isql /:e30 -q -user foo -pas bar
Statement failed, SQLSTATE = HY000
database e30 shutdown
// OK, expected
2) try to connect as SYSDBA and change smth:
C:\FBTESTING\qa\misc>C:\FB\30SS\isql /:e30 -user SYSDBA -pas masterkey
Database: /:e30, User: SYSDBA
SQL> create table test(x int);
SQL> commit;
// OK, expected
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
