11. Database Startup and Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 11.1. Database Shutdown . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . -at(tach) shutdown new database attachments -b(uffers) set page buffers -co(mmit) commit transaction -ca(che) shutdown cache manager -fu(ll)

the shared cache file was disabled. hdr_shutdown_mask (bit one of two) 0x1080 (bits 7 and 12) Used with bit 12 (see below) to indicate the database shutdown mode. hdr_sql_dialect_3 0x100 (bit 8) If Indicates the current backup mode. hdr_shutdown_mask (bit two of two) 0x1080 (bits 7 and 12) Used with bit 7 (see above) to indicate the database shutdown mode. The final two database flags use use a pair of bits to indicate various states of backup and shutdown. hdr_backup_mask These two bits determine the current database backup mode, as follows: Flag Value Description 0x00 (Both bits zero)

-837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database %s shutdown in %d seconds -841 335544677 version_err Too many versions -842 335544697 precision_err Precision 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -901 335740947 gfix_type_shut Must specify type of shutdown -901 335544340 infona No information of this type available for object specified -901 336330772 invalid_savepoint Unable to find savepoint with name %s in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "%s" Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT

-837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database @1 shutdown in @2 seconds -841 335544677 version_err Too many versions -842 335544697 precision_err Precision 336723986 gsec_no_usr_name No user name specified -901 335740947 gfix_type_shut Must specify type of shutdown -901 335544339 infinap Information type inappropriate for object specified -901 336723987 gsec_err_add invalid_savepoint Unable to find savepoint with name @1 in transaction context -901 335544835 bad_shutdown_mode Target shutdown mode is invalid for database "@1" -901 335544840 no_update Cannot update -901 335544842

-mysql-server default -mysql-client make unzip g++ etcd curl wget The services mysqld and etcd should be shutdown, since etcd will conflict with the etcd started in the examples, and mysqlctl will start its own aa-status | grep mysqld If this doesn’t work, you can try making sure all lurking processes are shutdown, and then restart the example again in the /tmp directory: for process in `pgrep -f '(vtdataroot|VTDATAROOT)'`; cleanup. This can delay a vttablet transition. Just closing the pools is not enough because the tablet shutdown also waits for all executing goroutines to return. • It is possible that the query timeout is much

-mysql-server default -mysql-client make unzip g++ etcd curl wget The services mysqld and etcd should be shutdown, since etcd will conflict with the etcd started in the examples, and mysqlctl will start its own aa-status | grep mysqld If this doesn’t work, you can try making sure all lurking processes are shutdown, and then restart the example again in the /tmp directory: for process in `pgrep -f '(vtdataroot|VTDATAROOT)'`; cleanup. This can delay a vttablet transition. Just closing the pools is not enough because the tablet shutdown also waits for all executing goroutines to return. • It is possible that the query timeout is much

-mysql-server default -mysql-client make unzip g++ etcd curl wget The services mysqld and etcd should be shutdown, since etcd will conflict with the etcd started in the examples, and mysqlctl will start its own aa-status | grep mysqld If this doesn’t work, you can try making sure all lurking processes are shutdown, and then restart the example again in the /tmp directory: for process in `pgrep -f '(vtdataroot|VTDATAROOT)'`; cleanup. This can delay a vttablet transition. Just closing the pools is not enough because the tablet shutdown also waits for all executing goroutines to return. • It is possible that the query timeout is much

default -mysql-client make unzip g++ etcd curl wget 21 The services mysqld and etcd should be shutdown, since etcd will conflict with the etcd started in the examples, and mysqlctl will start its own aa-status | grep mysqld If this doesn’t work, you can try making sure all lurking processes are shutdown, and then restart the example again in the /tmp directory: for process in `pgrep -f '(vtdataroot|VTDATAROOT)'`; timeouts that exist in vttablet. However, this mode should be used judiciously as it supersedes shutdown and reparent commands. The general convention is to send OLTP queries to REPLICA tablet types,

-mysql-server default -mysql-client make unzip g++ etcd curl wget The services mysqld and etcd should be shutdown, since etcd will conflict with the etcd started in the examples, and mysqlctl will start its own aa-status | grep mysqld If this doesn’t work, you can try making sure all lurking processes are shutdown, and then restart the example again in the /tmp directory: for process in `pgrep -f '(vtdataroot|VTDATAROOT)'`; cleanup. This can delay a vttablet transition. Just closing the pools is not enough because the tablet shutdown also waits for all executing goroutines to return. • It is possible that the query timeout is much

the occasional need to turn it off for some once-only condition where the server needs a forced shutdown. The gfix utility now has the -NoLinger switch, which will close the specified database immediately CHANGE_SHUTDOWN_MODE Shut down database and bring online TRACE_ANY_ATTACHMENT Trace other users' attachments MONITOR_ANY_ATTACHMENT Monitor (tables MON$) other users' attachments ACCESS_SHUTDOWN_DATABASE READ_RAW_PAGES | CREATE_USER_TYPES | USE_NBACKUP_UTILITY | CHANGE_SHUTDOWN_MODE | TRACE_ANY_ATTACHMENT | MONITOR_ANY_ATTACHMENT | ACCESS_SHUTDOWN_DATABASE | CREATE_DATABASE | DROP_DATABASE | USE_GBAK_UTILITY