安装V7问题解决2

11.2学习总结

1.initdb 命令初始化：
[kingbase@localhost bin]$ ./initdb -USYSTEM -WMANAGER -b 32 --ignore-trailing-blanks --wal-file-size=200 --ssousername=SSO --ssopassword=SSO --saousername=SAO --saopassword=SAO --database=TEST -D /dbdata/data

=》
The files belonging to this database system will be owned by user “kingbase”.
…
COLLATE: C
CTYPE: C
MESSAGES: en_US.UTF-8
…
DONE: Success. You can now start the database server using:

./kingbase -D /dbdata/data
↑未注册实例时可用这种方式启动

2.问题
问题1：
[kingbase@localhost bin]$ ./kingbase --install kingbasees_instance2 -D /dbdata/data -p 55555 -U kingbase
Data directory has been installed by instance “kingbasees_instance1”.
分析：注册另一个kingbasees_instance2实例，使用了和kingbasees_instance1相同的data文件

问题2：
[kingbase@localhost bin]$ ./kingbase --install kingbasees_instance1 -D /dbdata/data -p 54322 -U kingbase
Failed to set the tcp port “54322” …
Succeed to set instance “kingbasees_instance1” as system service.
分析：注册实例端口54322不能用
看一下实例配置文件：
[kingbase@localhost KingbaseES]$ cd config/
[kingbase@localhost config]$ cat instance.conf
[*krms]
is_debug = ‘false’
krms_log = ‘krms-%w.log’
tcp = 54324
udp = 54322
log_timestamp = ‘true’
multicast_addr = ‘FF02:5432::2’
[kingbasees_instance1]
data_dir = ‘/dbdata/data’
log_dir = ‘/home/kingbase/KingbaseES/log’
log_name = ‘kingbase-kingbasees_instance1-%w.log’
kingbase_option = ‘-c enable_raise_alert=true’
krms_managed = ‘false’
version = ‘7.1.1’
allowstart = ‘Y:Y’
显然kingbasees_instance1注册成功，但端口不能用

尝试删除实例，重新注册：
[kingbase@localhost bin]$ cd …/bin/
[kingbase@localhost bin]$ ./kingbase --uninstall kingbasees_instance1
instance kingbasees_instance1 is not running [ OK ]
Succeed to uninstall the service.
[kingbase@localhost bin]$ ./kingbase --install kingbasees_instance1 -D /dbdata/data -p 54322 -U kingbase
Failed to set the tcp port “54322” …
Succeed to set instance “kingbasees_instance1” as system service.
还是报相同的错

尝试杀进程：
[kingbase@localhost bin]$ ps -ef|grep kingbase
…杀了与home/kingbase/KingbaseES下相关所有进程
重新注册实例，还是报错。。。

尝试重新 initdb 命令初始化：
[kingbase@localhost bin]cd /home/kingbase/KingbaseES/bin
[kingbase@localhost bin]$ ./initdb -USYSTEM -WMANAGER -b 32 --ignore-trailing-blanks --wal-file-size=200 --ssousername=SSO --ssopassword=SSO --saousername=SAO --saopassword=SAO --database=TEST -D /dbdata/data
…返回信息省略
连接：
[kingbase@localhost bin]$ isql -USYSTEM -WMANAGER -d TEST
Welcome to isql 7.1.2.0935 release 64 bit, the Kingbase interactive terminal.

Type: \h for help with SQL commands
? for help with isql commands
\g or terminate with semicolon to execute query
\q to quit

TEST=#