问题现象
ps -ef | grep yas 查看无yasom和yasagent进程，且在{数据库安装目录}/om/{数据库名称}的目录下没有conf、data、log等目录，确定数据库不是用yasboot安装，是用脚本安装的
问题的风险及影响
非yasboot安装，ycm无法完成托管，无法监控
问题影响的版本
不涉及ycm的版本问题
问题发生原因
数据库版本太旧或安装数据库的人没有按照规范使用yasboot安装
解决方法及规避方式
将数据库先托管到yasom中，再托管到ycm中
问题分析和处理过程
（1）生成配置文件 -- ip必须是本机ip,install-path不能和安装的数据库path重重复 ./bin/yasboot package config gen --cluster yasdb -u yashan -p Cod-2024 --ip 192.168.39.70 --install-path /home/yashan/yashandb/yasdb_yasom -t se [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package config gen --cluster yasdb -u yashan -p Cod-2024 --ip 192.168.39.70 --install-path /home/yashan/yashandb/yasdb_yasom -t se 192.168.39.70 192.168.39.70:1688 is already used hostid | group | node_type | node_name | listen_addr | din_addr | replication_addr | data_path -------------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | dbg1 | db | 1-1 | 192.168.39.70:1688 | 192.168.39.70:1689 | 192.168.39.70:1690 | /home/yashan/yashandb/yasdb_yasom/data/yasdb ----------+-------+-----------+-----------+--------------------+--------------------+--------------------+---------------------------------------------- Generate config success （2）安装yasom和yasagent ./bin/yasboot package install -i yashandb-22.2.3.0-linux-aarch64.tar.gz -t hosts.toml [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package install -i yashandb-22.2.3.0-linux-aarch64.tar.gz -t hosts.toml checking install profile.toml... install version: yashandb 22.2.3.0 update host to yasom... [yashan@KylinV10 yasdb_yasom]$ ps -ef | grep yas yashan 3945392 1 0 15:04 ? 00:00:25 yasdb open -D /home/yashan/yashandb/yasdb_data root 3950422 3950243 0 15:37 pts/1 00:00:00 su - yashan yashan 3950423 3950422 0 15:37 pts/1 00:00:00 -bash root 3953443 3952376 0 15:49 pts/2 00:00:00 su - yashan yashan 3953444 3953443 0 15:49 pts/2 00:00:00 -bash yashan 3955488 1 0 16:05 ? 00:00:00 /home/yashan/yashandb/yasdb_yasom/bin/yasagent --init -c yasdb -l 192.168.39.70:1676 --host-id host0001 -k 564e9e581348c9ae -d yashan 3955503 1 0 16:06 ? 00:00:00 /home/yashan/yashandb/yasdb_yasom/bin/yasom --init -c yasdb -l 192.168.39.70:1675 -k 564e9e581348c9ae -d yashan 3955542 3950423 0 16:06 pts/1 00:00:00 ps -ef yashan 3955543 3950423 0 16:06 pts/1 00:00:00 grep yas （3）生成托管配置模版 ./bin/yasboot package config join-demo -t SE [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot package config join-demo -t SE [yashan@KylinV10 yasdb_yasom]$ ll 总用量 221716 drwxrwxr-x 6 yashan yashan 70 5月 4 2023 admin drwxrwxr-x 3 yashan yashan 220 5月 4 2023 bin drwxrwxr-x 2 yashan yashan 30 4月 17 16:05 client drwxrwxr-x 3 yashan yashan 126 4月 17 16:06 conf -rw-rw-r-- 1 yashan yashan 10974 5月 4 2023 gitmoduleversion.dat -rw------- 1 yashan yashan 386 4月 17 16:05 hosts.toml drwxrwxr-x 2 yashan yashan 65 5月 4 2023 include drwxrwxr-x 3 yashan yashan 17 5月 4 2023 java -rw-r--r-- 1 yashan yashan 527 4月 17 16:15 join_demo.toml drwxr-xr-x 2 yashan yashan 4096 5月 4 2023 lib drwxrwxr-x 2 yashan yashan 6 4月 17 16:06 log drwxrwxr-x 3 yashan yashan 38 4月 17 15:50 om drwxrwxr-x 2 yashan yashan 115 5月 4 2023 scripts -rw------- 1 yashan yashan 549 4月 17 16:05 yasdb.toml drwxrwxr-x 3 yashan yashan 22 4月 17 15:48 yashandb -rw-r--r-- 1 yashan yashan 227004643 4月 17 15:46 yashandb-22.2.3.0-linux-aarch64.tar.gz （4）修改托管配置模版 [yashan@KylinV10 yasdb_yasom]$ cat join_demo.toml cluster = "tt" sys_password = "yasdb_123" yas_type = "SE" [primary_config] manage_ip = "127.0.0.1" yasdb_home = "/opt/yasom/yashandb/tt" node_path = "/opt/yasom/yashandb/data/tt/db-1-1" node_id = "1-1:1" [[standby_config]] manage_ip = "127.0.0.1" yasdb_home = "/opt/yasom/yashandb/tt" node_path = "/opt/yasom/yashandb/data/tt/db-1-2" node_id = "1-2:1" [[standby_config]] manage_ip = "127.0.0.1" yasdb_home = "/opt/yasom/yashandb/tt" node_path = "/opt/yasom/yashandb/data/tt/db-1-3" node_id = "1-3:1" 修改后： [yashan@KylinV10 yasdb_yasom]$ cat join_demo.toml cluster = "yasdb" sys_password = "yasdb_123" yas_type = "SE" [primary_config] manage_ip = "192.168.39.70" yasdb_home = "/home/yashan/yashandb/yasdb_home" node_path = "/home/yashan/yashandb/yasdb_data" node_id = "1-1:1" （5）执行托管 ./bin/yasboot cluster join -t SE --config join_demo.toml [yashan@KylinV10 yasdb_yasom]$ ./bin/yasboot cluster join -t SE --config join_demo.toml the cluster status is as follow: |key |value |------------+------ |clusterName |yasdb |version |22.2.3.0 the cluster status is as follow: hostid | node_type | nodeid | pid | instance_status | database_status | database_role | listen_address | data_path ------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | db | 1-1:1 | 3945392 | open | normal | primary | 0.0.0.0:1688 | /home/yashan/yashandb/yasdb_data ----------+-----------+--------+---------+-----------------+-----------------+---------------+----------------+---------------------------------- Check success Are you sure you to add yasdb yasdb to yasom[yes/no]: yes type | uuid | name | hostid | index | status | return_code | progress | cost ------------------------------------------------------------------------------------------------------- task | eb0ecf155a0db5e6 | JoinYasdbCluster | - | yasdb | SUCCESS | 0 | 100 | - ------+------------------+------------------+--------+-------+---------+-------------+----------+------ task completed, status: SUCCESS （6）查看状态 yashan@KylinV10 ~]$ yasboot cluster status -c yasdb -d hostid | node_type | nodeid | pid | instance_status | database_status | database_role | listen_address | data_path -------------------------------------------------------------------------------------------------------------------------------------------------------- host0001 | db | 1-1:1 | 3945392 | open | normal | primary | 0.0.0.0:1688 | /home/yashan/yashandb/data/yasdb/db-1-1 ----------+-----------+--------+---------+-----------------+-----------------+---------------+----------------+-----------------------------------------
托管至yasom完成后，再按照流程托管至ycm即可
经验总结
安装数据库要按照规范安装，非规范安装会导致一系列问题
