Submitted by: @pavel-zotov

Duplicates CORE6399

#⁠#⁠#⁠#⁠#⁠#⁠#⁠ 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