Skip to main content

Search

Welcome to Tibero GTS!

BOOT_WITH_AUTO_DOWN_CLEAN Parameter

Document Type | Technical Information

Category | Administration

Applicable Product Versions | 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS

Document Number | TADTI056

 

Overview

If the server shuts down abnormally, shared memory or semaphore resources used during operation may not be properly released, causing the database (DB) to fail to restart.
Whether resource cleanup is incomplete can be checked by whether the .proc.list file remains undeleted.
Tibero requires the .proc.list file to be cleaned with tbdown before running tbboot if the file exists.
This explains the BOOT_WITH_AUTO_DOWN_CLEAN parameter that resolves this issue.
 
 
 

Method

How to Apply the BOOT_WITH_AUTO_DOWN_CLEAN Parameter

When running tbboot after an abnormal server shutdown, a message prompting to run the tbdown clean command is displayed. 

[tibero@localhost ~]$ tbboot
***********************************************************
*                     BOOT FAILED.
* Garbage files have not been deleted.
* Please run "tbdown clean" and try again.
***********************************************************
[t6@localhost ~]$ tbdown clean
[t6@localhost ~]$ tbboot
Listener port = 8629

Tibero 6


TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Tibero instance started up (NORMAL mode).

 

Set BOOT_WITH_AUTO_DOWN_CLEAN to Y in the tip file.
  • Tip file path: $TB_HOME/config/$TB_SID.tip
[test@localhost config]$ cd $TB_HOME/config
[test@localhost config]$ vi $TB_SID.tip
DB_NAME=tibero
LISTENER_PORT=8629
CONTROL_FILES="/home/test/tibero6/database/tibero/c1.ctl"
#CERTIFICATE_FILE="/home/test/tibero6/config/tb_wallet/tibero.crt"
#PRIVKEY_FILE="/home/test/tibero6/config/tb_wallet/tibero.key"
#WALLET_FILE="/home/test/tibero6/config/tb_wallet/WALLET"
#ILOG_MAP="/home/test/tibero6/config/ilog.map"

MAX_SESSION_COUNT=20
TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G


BOOT_WITH_AUTO_DOWN_CLEAN=Y

 

Note
Default BOOT_WITH_AUTO_DOWN_CLEAN settings by version
  • Tibero 7: The default setting is Y, so after abnormal shutdown, the following message will be confirmed during restart.
"tbdown clean" is executed automatically.
  • Tibero 6: Depending on the version, the default setting may not be Y, so after connecting to Tibero, run the following SQL to check.
-- Parameter name, current setting, default value
select name, value, dflt_value from _vt_parameter where name = 'BOOT_WITH_AUTO_DOWN_CLEAN';

 

 

 

 

Related to