一、操作系统检查
[root@Euler1 mogdb]# ./ptk checkos -i A
INFO[2023-09-12T23:12:39.272] prechecking dependent tools...
INFO[2023-09-12T23:12:39.303] [192.168.11.24][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
INFO[2023-09-12T23:12:39.396] [192.168.11.24][omm] check kernel.core_pattern
INFO[2023-09-12T23:12:39.401] [192.168.11.24][omm] check removeIPC value
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(sdb) 'IO Request'=254, expect 256
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-12T23:12:39.417] [192.168.11.24][omm] device(dm-0) 'IO Request'=128, expect 256
INFO[2023-09-12T23:12:39.491] [192.168.11.24][omm] platform: openEuler_20.03_64bit
INFO[2023-09-12T23:12:39.494] [192.168.11.24][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-12T23:12:39.497] [192.168.11.24][omm] timezone: +0800
ERRO[2023-09-12T23:12:41.861] [192.168.11.24][omm] not found package: numactl
INFO[2023-09-12T23:12:41.876] [192.168.11.24][omm] swap memory 0kB, total memory 2013916kB
WARN[2023-09-12T23:12:41.882] [192.168.11.24][omm] device(sdb) readahead value=8192, expect 16384.
INFO[2023-09-12T23:12:41.899] all checkers finished
INFO[2023-09-12T23:12:41.899] write fix os script to root_fix_os.2023.0912.231241.sh success
INFO[2023-09-12T23:12:41.899] time elapsed: 3s
# Check Results
Item | Level
------------------------------------+-----------
A1.Check_OS_Version | OK
A2.Check_Kernel_Version | OK
A3.Check_Unicode | OK
A4.Check_TimeZone | OK
A5.Check_Swap_Memory_Configure | Warning
A6.Check_SysCtl_Parameter | OK
A7.Check_FileSystem_Configure | OK
A8.Check_Disk_Configure | OK
A9.Check_BlockDev_Configure | Warning
A9.Check_Logical_Block | OK
A10.Check_Asynchronous_IO_Request | OK
A10.Check_IO_Configure | OK
A10.Check_IO_Request | Warning
A11.Check_Network_Configure | OK
A12.Check_Time_Consistency | OK
A13.Check_Firewall_Status | OK
A14.Check_THP_Status | OK
A15.Check_Dependent_Package | Abnormal
A16.Check_CPU_Instruction_Set | OK
A18.Check_Selinux | OK
Total count 20, abnormal count 1, warning count 3
Failed to check os, can’t perform installation unless fix all the abnormal items.
You can use 'ptk checkos -i ITEM --detail' to get detail message
Please check root_fix_os.[TIMESTAMP].sh for commands to resolve.
二、修复
[root@Euler1 mogdb]# ./ptk checkos -i A5,A9,A10,A15 --detail
INFO[2023-09-12T23:13:38.739] prechecking dependent tools...
INFO[2023-09-12T23:13:38.771] [192.168.11.24][omm] swap memory 0kB, total memory 2013916kB
WARN[2023-09-12T23:13:38.781] [192.168.11.24][omm] device(sdb) readahead value=8192, expect 16384.
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(sdb) 'IO Request'=254, expect 256
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-12T23:13:38.800] [192.168.11.24][omm] device(dm-0) 'IO Request'=128, expect 256
ERRO[2023-09-12T23:13:40.809] [192.168.11.24][omm] not found package: numactl
INFO[2023-09-12T23:13:40.809] all checkers finished
INFO[2023-09-12T23:13:40.809] write fix os script to root_fix_os.2023.0912.231340.sh success
INFO[2023-09-12T23:13:40.809] time elapsed: 2s
# Check Results
Item | Level | Message
------------------------------------+----------+-----------------------------------------------------
A5.Check_Swap_Memory_Configure | Warning | [192.168.11.24]:
| | total memory (2013916 KB) is less than 2 GB
A9.Check_BlockDev_Configure | Warning | [192.168.11.24]:
| | device(sdb) readahead value=8192, expect 16384.
A9.Check_Logical_Block | OK |
A10.Check_IO_Configure | OK |
A10.Check_IO_Request | Warning | [192.168.11.24]:
| | Warning: device(dm-1) 'IO Request'=128, expect 256
| | Warning: device(dm-2) 'IO Request'=128, expect 256
| | Warning: device(sda) 'IO Request'=254, expect 256
| | Warning: device(sdb) 'IO Request'=254, expect 256
| | Warning: device(sr0) 'IO Request'=64, expect 256
| | Warning: device(dm-0) 'IO Request'=128, expect 256
A10.Check_Asynchronous_IO_Request | OK |
A15.Check_Dependent_Package | Abnormal | [192.168.11.24]:
| | Abnormal: not found package: numactl
Total count 7, abnormal count 1, warning count 3
Failed to check os, can’t perform installation unless fix all the abnormal items.
You can use 'ptk checkos -i ITEM --detail' to get detail message
Please check root_fix_os.[TIMESTAMP].sh for commands to resolve.
[root@Euler1 mogdb]# cat root_fix_os.2023.0914.115334.sh
#!/usr/bin/env bash
set -e
local_ips=$(ip addr | grep 'inet' | grep -v 'inet6\|127.0.0.1' | grep -v grep | awk -F '/' '{print $1}' | awk '{print $2}')
# fix suggestions for host: 192.168.11.24
for ip in ${local_ips}; do
if [[ "${ip}" == "192.168.11.24" ]]; then
sudo yum install -y numactl
exit 0
fi
done
[root@Euler1 mogdb]# ./ptk checkos --gen-warning-fix
INFO[2023-09-14T11:58:18.073] prechecking dependent tools...
INFO[2023-09-14T11:58:18.110] [192.168.11.24][omm] swap memory 0kB, total memory 3487988kB
INFO[2023-09-14T11:58:18.113] [192.168.11.24][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T11:58:18.117] [192.168.11.24][omm] timezone: +0800
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(sdb) 'IO Request'=254, expect 256
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-14T11:58:18.120] [192.168.11.24][omm] device(dm-0) 'IO Request'=128, expect 256
INFO[2023-09-14T11:58:19.948] [192.168.11.24][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
WARN[2023-09-14T11:58:20.012] [192.168.11.24][omm] vm.min_free_kbytes=112640, expect 174399
INFO[2023-09-14T11:58:20.012] [192.168.11.24][omm] check kernel.core_pattern
INFO[2023-09-14T11:58:20.016] [192.168.11.24][omm] check removeIPC value
WARN[2023-09-14T11:58:20.024] [192.168.11.24][omm] device(sdb) readahead value=8192, expect 16384.
INFO[2023-09-14T11:58:20.045] [192.168.11.24][omm] platform: openEuler_20.03_64bit
INFO[2023-09-14T11:58:20.048] all checkers finished
INFO[2023-09-14T11:58:20.048] write fix os script to root_fix_os.2023.0914.115820.sh success
INFO[2023-09-14T11:58:20.048] time elapsed: 2s
# Check Results
Item | Level
------------------------------------+----------
A1.Check_OS_Version | OK
A2.Check_Kernel_Version | OK
A3.Check_Unicode | OK
A4.Check_TimeZone | OK
A5.Check_Swap_Memory_Configure | OK
A6.Check_SysCtl_Parameter | Warning
A7.Check_FileSystem_Configure | OK
A8.Check_Disk_Configure | OK
A9.Check_Logical_Block | OK
A9.Check_BlockDev_Configure | Warning
A10.Check_IO_Request | Warning
A10.Check_Asynchronous_IO_Request | OK
A10.Check_IO_Configure | OK
A11.Check_Network_Configure | OK
A12.Check_Time_Consistency | OK
A13.Check_Firewall_Status | OK
A14.Check_THP_Status | OK
A15.Check_Dependent_Package | OK
A16.Check_CPU_Instruction_Set | OK
A18.Check_Selinux | OK
Total count 20, abnormal count 0, warning count 3
三、创建模板文件
[root@Euler1 mogdb]# ./ptk template create
✔ Please enter cluster name (default: tu): Mogdbcluster
✔ Please enter system username (default: omm):
✔ Please enter group of user (default: omm):
✔ Please enter db password (8~15 characters, 3 classes): **********
✔ Retype db password: **********
✔ Please enter db port (range 1024~65535) (default: 26000):
✔ Please enter mogdb base dir (which should be empty) (default: /opt/mogdb):
✔ Do you want to intall cm component (default=n) [y/n]: y
And then, let's add some db servers
================db server 1================
✔ Please enter server ip (IPv4 only): 172.16.220.151
✔ primary
✔ Please enter available zone name (default: AZ1):
✔ Please enter zone("AZ1") priority (default: 1):
================ end ================
✔ Do you want to add another db server (default=n) [y/n]: n
Generate /root/mogdb/config.2023-09-14T12_00_52.yaml successfully
[root@Euler1 mogdb]# ./ptk template create
✔ Please enter cluster name (default: pike):
✔ Please enter system username (default: omm):
✔ Please enter group of user (default: omm): dbgrp
✔ Please enter db password (8~15 characters, 3 classes): **********
✔ Retype db password: **********
✔ Please enter db port (range 1024~65535) (default: 26000):
✔ Please enter mogdb base dir (which should be empty) (default: /opt/mogdb): /mogdb
✔ Do you want to intall cm component (default=n) [y/n]: y
And then, let's add some db servers
================db server 1================
✔ Please enter server ip (IPv4 only): 172.16.220.151
✔ primary
✔ Please enter available zone name (default: AZ1):
✔ Please enter zone("AZ1") priority (default: 1):
================ end ================
✔ Do you want to add another db server (default=n) [y/n]: n
Generate /root/mogdb/config.2023-09-14T12_13_05.yaml successfully
四、安装
[root@Euler1 mogdb]# ./ptk install -f /root/mogdb/config.2023-09-14T12_13_05.yaml
INFO[2023-09-14T12:14:04.036] PTK Version: 1.0.7 release
INFO[2023-09-14T12:14:04.037] load config from /root/mogdb/config.2023-09-14T12_13_05.yaml
If you continue to install the software,
you are accepting the license agreement of the software.
[Y]: Accept and continue
[C]: Show content of licence agreement
[N]: Abort installation and exit
✔ Please enter (default: Y): y
Cluster Name: "pike"
+--------------+----------------+-------------+-------+---------+-------------+----------+
| az(priority) | ip | user(group) | port | role | data dir | upstream |
+--------------+----------------+-------------+-------+---------+-------------+----------+
| AZ1(1) | 172.16.220.151 | omm(dbgrp) | 26000 | primary | /mogdb/data | - |
+--------------+----------------+-------------+-------+---------+-------------+----------+
✔ Is cluster config correct (default=n) [y/n]: y
INFO[2023-09-14T12:14:17.629] start check os ...
INFO[2023-09-14T12:14:17.636] prechecking dependent tools...
WARN[2023-09-14T12:14:17.682] [172.16.220.151][omm] vm.min_free_kbytes=112640, expect 174399
INFO[2023-09-14T12:14:17.725] [172.16.220.151][omm] check kernel.core_pattern
INFO[2023-09-14T12:14:17.729] [172.16.220.151][omm] check removeIPC value
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(sdb) 'IO Request'=254, expect 256
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T12:14:17.739] [172.16.220.151][omm] device(sda) 'IO Request'=254, expect 256
INFO[2023-09-14T12:14:17.771] [172.16.220.151][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
INFO[2023-09-14T12:14:17.774] [172.16.220.151][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T12:14:17.776] [172.16.220.151][omm] platform: openEuler_20.03_64bit
INFO[2023-09-14T12:14:17.779] [172.16.220.151][omm] timezone: +0800
INFO[2023-09-14T12:14:17.779] [172.16.220.151][omm] check port 26000
INFO[2023-09-14T12:14:17.785] [172.16.220.151][omm] port 26000 is free
INFO[2023-09-14T12:14:17.788] [172.16.220.151][omm] swap memory 0kB, total memory 3487988kB
WARN[2023-09-14T12:14:17.792] [172.16.220.151][omm] device(sdb) readahead value=8192, expect 16384.
INFO[2023-09-14T12:14:19.618] all checkers finished
INFO[2023-09-14T12:14:19.618] time elapsed: 2s
INFO[2023-09-14T12:14:19.618] check os success
INFO[2023-09-14T12:14:19.618] start check distro ...
INFO[2023-09-14T12:14:19.618] check distro success
INFO[2023-09-14T12:14:19.619] start check hostname ...
INFO[2023-09-14T12:14:19.619] check hostname success
INFO[2023-09-14T12:14:19.619] start check user ...
INFO[2023-09-14T12:14:19.621] check user success
INFO[2023-09-14T12:14:19.621] start check port ...
INFO[2023-09-14T12:14:19.633] check port success
INFO[2023-09-14T12:14:19.714] start prepare installation package ...
INFO[2023-09-14T12:14:19.714] no package specified, use online package: https://cdn-mogdb.enmotech.com/mogdb-media/5.0.1/Kylin_x86_64/MogDB-5.0.1-Kylin-x86_64-all.tar.gz
INFO[2023-09-14T12:14:19.714] use cache /root/.ptk/cache/MogDB-5.0.1-Kylin-x86_64-all.tar.gz
INFO[2023-09-14T12:14:19.714] installation package is ready
INFO[2023-09-14T12:14:19.714] start validate installation package ...
INFO[2023-09-14T12:14:21.199] db product: MogDB, version: 5.0.1, number: 92.850, commit_id: ae6d2ada
INFO[2023-09-14T12:14:21.199] validate installation package success
INFO[2023-09-14T12:14:21.199] start complete the configuration ...
INFO[2023-09-14T12:14:21.199] complete the configuration success
INFO[2023-09-14T12:14:21.200] start distribute installation package ...
> To 172.16.220.151: 131.75 MiB / 131.75 MiB [--------------------------------------------------------------------------------------------------------------] 100.00% 417.01 MiB p/s 500ms
INFO[2023-09-14T12:14:21.849] distrubite packages success
INFO[2023-09-14T12:14:21.849] start setup db ...
INFO[2023-09-14T12:14:21.941] [172.16.220.151][omm] total memory(3GB) is less than 4GB, use default db config
INFO[2023-09-14T12:14:21.941] [172.16.220.151][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T12:14:22.644] [172.16.220.151][omm] extract MogDB-5.0.1-Kylin-x86_64-all.tar.gz to dir /mogdb/tool
INFO[2023-09-14T12:14:24.049] [172.16.220.151][omm] extract MogDB-5.0.1-Kylin-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T12:14:24.658] [172.16.220.151][omm] try to fix psutil python lib
INFO[2023-09-14T12:14:24.927] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T12:14:25.144] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T12:14:25.362] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T12:14:25.576] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T12:14:25.793] [172.16.220.151][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T12:14:25.882] [172.16.220.151][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T12:14:26.148] [172.16.220.151][omm] extract MogDB-5.0.1-Kylin-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T12:14:30.214] [172.16.220.151][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T12:14:30.350] [172.16.220.151][omm] change /mogdb/app owner to omm
INFO[2023-09-14T12:14:30.442] [172.16.220.151][omm] set user omm profiles
INFO[2023-09-14T12:14:31.058] [172.16.220.151][omm] validate and try to fix ld library for gs_initdb
INFO[2023-09-14T12:14:31.152] [172.16.220.151][omm] validate and try to fix ld library for mogdb
INFO[2023-09-14T12:14:31.245] [172.16.220.151][omm] change /mogdb/app owner to omm
INFO[2023-09-14T12:14:31.340] [172.16.220.151][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6001,/mogdb/log/pg_audit/dn_6001
INFO[2023-09-14T12:14:33.649] [172.16.220.151][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T12:14:33.913] [172.16.220.151][omm] save version to upgrade_version
INFO[2023-09-14T12:14:34.229] [172.16.220.151][omm] create file cluster_manual_start
INFO[2023-09-14T12:14:34.318] [172.16.220.151][omm] generate cluster_static_config file
INFO[2023-09-14T12:14:34.365] [172.16.220.151][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T12:14:34.453] [172.16.220.151][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T12:14:34.721] [172.16.220.151][omm] change /mogdb/data owner to omm
INFO[2023-09-14T12:14:34.809] [172.16.220.151][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T12:14:44.217] [172.16.220.151][omm] config postgresql.conf
INFO[2023-09-14T12:14:44.319] [172.16.220.151][omm] config pg_hba.conf
INFO[2023-09-14T12:14:44.412] setup db success
INFO[2023-09-14T12:14:44.412] generate certification files
INFO[2023-09-14T12:14:45.080] download certification files
INFO[2023-09-14T12:14:45.946] certification files setup success
INFO[2023-09-14T12:14:45.946] genetate ptkc ...
INFO[2023-09-14T12:14:46.135] start build ssh trust ...
INFO[2023-09-14T12:14:46.723] ssh trust build success
INFO[2023-09-14T12:14:46.723] start launch db ...
INFO[2023-09-14T12:14:46.723] [172.16.220.151][omm] start db using gs_ctl ...
INFO[2023-09-14T12:14:46.723] [172.16.220.151][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T12:14:47.834] [172.16.220.151][omm] start db success
INFO[2023-09-14T12:14:48.834] [172.16.220.151][omm] start alter db initial password ...
INFO[2023-09-14T12:14:48.962] [172.16.220.151][omm] alter db password success
INFO[2023-09-14T12:14:48.962] launch db success
INFO[2023-09-14T12:14:48.962] clear temp dirs ...
INFO[2023-09-14T12:14:49.058] clear temp dirs success
INFO[2023-09-14T12:14:49.058] time elapsed: 36s
cluste_name | host | user | port | status | message
--------------+----------------+------+-------+---------------+----------
pike | 172.16.220.151 | omm | 26000 | start_success | success
五、注意点：
本次使用Euler20.03安装，安装过程中很多报错，需要注意以下两点
-
1、创建配置文件时候omm用户的用户组需要手工输入位dbgrp，
-
2、创建/mogdb目录需要给权限777，775不够，但是在oracle linux8中测试这个目录会自动创建。应该是操作系统的问题
六、测试
[root@Euler1 mogdb]# ./ptk ls
cluster_name | id | addr | user | data_dir | db_version | create_time | comment
---------------+------+----------------------+------+-------------+------------------------------+---------------------+----------
pike | 6001 | 172.16.220.151:26000 | omm | /mogdb/data | MogDB 5.0.1 (build ae6d2ada) | 2023-09-14T12:14:21 |
[omm@Euler1 ~]$ gs_om -t status --detail
[ Cluster State ]
cluster_state : Normal
redistributing : No
current_az : AZ_ALL
[ Datanode State ]
node node_ip port instance state
-----------------------------------------------------------------------------
1 Euler1 172.16.220.151 26000 6001 /mogdb/data P Primary Normal
[omm@Euler1 bin]$ gsql
gsql ((MogDB 5.0.1 build ae6d2ada) compiled at 2023-08-16 09:07:39 commit 0 last mr 1804 )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
MogDB=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges | Compatibility
-----------+-------+----------+---------+-------+-------------------+---------------
postgres | omm | UTF8 | C | C | | A
template0 | omm | UTF8 | C | C | =c/omm +| A
| | | | | omm=CTc/omm |
template1 | omm | UTF8 | C | C | =c/omm +| A
| | | | | omm=CTc/omm |
(3 rows)
七、卸载
[omm@Euler1 ~]$ gs_om -t stop
Stopping cluster.
=========================================
Successfully stopped cluster.
=========================================
End stop cluster.
[omm@Euler1 ~]$ logout
[root@Euler1 mogdb]# ./ptk uninstall -n pike
INFO[2023-09-14T13:55:18.473] PTK Version: 1.0.7 release
Cluster Name: "pike"
+--------------+----------------+-------------+-------+---------+-------------+----------+
| az(priority) | ip | user(group) | port | role | data dir | upstream |
+--------------+----------------+-------------+-------+---------+-------------+----------+
| AZ1(1) | 172.16.220.151 | omm(dbgrp) | 26000 | primary | /mogdb/data | - |
+--------------+----------------+-------------+-------+---------+-------------+----------+
✔ Do you really want to uninstall this cluster? Please confirm carefully (default=n) [y/n]: y
✔ Do you want to delete db data (default=n) [y/n]: y
✔ Do you want to delete os user (default=n) [y/n]: y
INFO[2023-09-14T13:55:22.389] [172.16.220.151][omm] check db dirs owner
INFO[2023-09-14T13:55:22.591] [172.16.220.151][omm] check db process status
INFO[2023-09-14T13:55:22.701] [172.16.220.151][omm] remove files: /mogdb/app,/mogdb/tool,/mogdb/tmp,/mogdb/data,/mogdb/log
INFO[2023-09-14T13:55:22.930] [172.16.220.151][omm] kill krb5kdc service if exist
INFO[2023-09-14T13:55:23.045] [172.16.220.151][omm] clearing /etc/cron.allow
INFO[2023-09-14T13:55:23.049] [172.16.220.151][omm] clearing /etc/security/limits.conf
INFO[2023-09-14T13:55:23.052] [172.16.220.151][omm] remove base dir if empty: /mogdb
INFO[2023-09-14T13:55:23.057] [172.16.220.151][omm] kill user "omm" process
INFO[2023-09-14T13:55:23.077] [172.16.220.151][omm] delete user "omm"
INFO[2023-09-14T13:55:23.208] uninstall successfully
八、主备安装
1、报错/mogdb/app/bin/mogdb -V未发现数据
./ptk install -f config.2023-09-14T15_04_53.yaml
...
ERRO[2023-09-14T15:15:02.998] [172.16.220.153][omm] task execute failed
Host: 172.16.220.153
Task: the database is initializing, please wait a few minutes
Error: [exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env && /mogdb/app/bin/gs_initdb --nodename dn_6001_6002_6003 --no-locale --encoding=UTF-8 -D /mogdb/data --pwpasswd *** ": no data was returned by command ""/mogdb/app/bin/mogdb" -V"
INFO[2023-09-14T15:15:10.323] [172.16.220.151][omm] config postgresql.conf
INFO[2023-09-14T15:15:10.460] [172.16.220.151][omm] config pg_hba.conf
INFO[2023-09-14T15:15:11.651] [172.16.220.152][omm] config postgresql.conf
INFO[2023-09-14T15:15:11.782] [172.16.220.152][omm] config pg_hba.conf
ERRO[2023-09-14T15:15:11.899] [exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env && /mogdb/app/bin/gs_initdb --nodename dn_6001_6002_6003 --no-locale --encoding=UTF-8 -D /mogdb/data --pwpasswd *** ": no data was returned by command ""/mogdb/app/bin/mogdb" -V"
INFO[2023-09-14T15:15:11.899] start rollback ...
INFO[2023-09-14T15:15:14.156] rollback success
INFO[2023-09-14T15:15:14.157] time elapsed: 51s
cluste_name | host | user | port | status | message
--------------+----------------+------+-------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mog_cluster | 172.16.220.151 | omm | 26000 | rollback_success |
| 172.16.220.152 | omm | 26000 | rollback_success |
| 172.16.220.153 | omm | 26000 | rollback_success | [exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env && /mogdb/app/bin/gs_initdb --nodename dn_6001_6002_6003 --no-locale --encoding=UTF-8 -D /mogdb/data --pwpasswd *** ": no data was returned by command ""/mogdb/app/bin/mogdb" -V"
[exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env && /mogdb/app/bin/gs_initdb --nodename dn_6001_6002_6003 --no-locale --encoding=UTF-8 -D /mogdb/data --pwpasswd *** ": no data was returned by command ""/mogdb/app/bin/mogdb" -V"
使用本地安装包，猜测很有很能是联网下载安装包不对，安装日志中显示安装包为Kylin,实际虚拟机为IntelCpu安装Open Euler20.03。无伤大雅，选择手工下载安装包
2、报错sftp: “Failure” (SSH_FX_FAILURE)
[root@Euler1 mogdb]# ./ptk install -f config.2023-09-14T15_04_53.yaml --pkg MogDB-3.0.5-CentOS-x86_64.tar.gz
INFO[2023-09-14T15:46:01.351] PTK Version: 1.0.7 release
INFO[2023-09-14T15:46:01.351] load config from config.2023-09-14T15_04_53.yaml
If you continue to install the software,
you are accepting the license agreement of the software.
[Y]: Accept and continue
[C]: Show content of licence agreement
[N]: Abort installation and exit
✔ Please enter (default: Y): y
Cluster Name: "mog_cluster"
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
| az(priority) | ip | user(group) | port | role | data dir | upstream |
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
| AZ1(1) | 172.16.220.151 | omm(dbgrp) | 26000 | primary | /mogdb/data | - |
| | 172.16.220.152 | omm(dbgrp) | 26000 | standby | /mogdb/data | - |
| | 172.16.220.153 | omm(dbgrp) | 26000 | cascade_standby | /mogdb/data | 172.16.220.152 |
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
✔ Is cluster config correct (default=n) [y/n]: y
。。。
> To 172.16.220.151: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 38.97 MiB p/s 3.6s
> To 172.16.220.151: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 17.68 MiB p/s 7.7s
> To 172.16.220.152: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 17.68 MiB p/s 7.7s
> To 172.16.220.153: 68.59 MiB / 132.83 MiB [----------------------------------------------------------->_______________________________________________________] 51.64% 9.13 MiB p/s 7.7s
ERRO[2023-09-14T15:46:28.822] distribute package: sftp: "Failure" (SSH_FX_FAILURE)
INFO[2023-09-14T15:46:28.822] start rollback ...
INFO[2023-09-14T15:46:28.854] rollback success
INFO[2023-09-14T15:46:28.854] time elapsed: 25s
cluste_name | host | user | port | status | message
--------------+----------------+------+-------+------------------+----------
mog_cluster | 172.16.220.151 | omm | 26000 | precheck_success | success
| 172.16.220.153 | omm | 26000 | precheck_success | success
| 172.16.220.152 | omm | 26000 | precheck_success | success
distribute package: sftp: "Failure" (SSH_FX_FAILURE)
sftp: “Failure” (SSH_FX_FAILURE)，这个报错，别被忽悠，文件系统满了，清理/tmp完事
3、报错Failed to parse cgroup config file
[root@Euler1 mogdb]# ./ptk install -f config.2023-09-14T15_04_53.yaml --pkg MogDB-3.0.5-CentOS-x86_64.tar.gz
INFO[2023-09-14T15:50:46.503] PTK Version: 1.0.7 release
INFO[2023-09-14T15:50:46.503] load config from config.2023-09-14T15_04_53.yaml
If you continue to install the software,
you are accepting the license agreement of the software.
[Y]: Accept and continue
[C]: Show content of licence agreement
[N]: Abort installation and exit
✔ Please enter (default: Y): y
Cluster Name: "mog_cluster"
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
| az(priority) | ip | user(group) | port | role | data dir | upstream |
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
| AZ1(1) | 172.16.220.153 | omm(dbgrp) | 26000 | cascade_standby | /mogdb/data | 172.16.220.152 |
| | 172.16.220.151 | omm(dbgrp) | 26000 | primary | /mogdb/data | - |
| | 172.16.220.152 | omm(dbgrp) | 26000 | standby | /mogdb/data | - |
+--------------+----------------+-------------+-------+-----------------+-------------+----------------+
✔ Is cluster config correct (default=n) [y/n]: y
INFO[2023-09-14T15:50:49.826] start check os ...
INFO[2023-09-14T15:50:49.941] prechecking dependent tools...
INFO[2023-09-14T15:50:51.091] [172.16.220.153][omm] check port 26000
INFO[2023-09-14T15:50:51.091] [172.16.220.151][omm] check port 26000
INFO[2023-09-14T15:50:51.096] [172.16.220.152][omm] check port 26000
INFO[2023-09-14T15:50:51.098] [172.16.220.151][omm] port 26000 is free
INFO[2023-09-14T15:50:51.476] [172.16.220.152][omm] port 26000 is free
INFO[2023-09-14T15:50:51.476] [172.16.220.153][omm] port 26000 is free
INFO[2023-09-14T15:50:51.692] [172.16.220.153][omm] platform: openEuler_20.03_64bit
INFO[2023-09-14T15:50:51.692] [172.16.220.151][omm] platform: openEuler_20.03_64bit
INFO[2023-09-14T15:50:51.692] [172.16.220.152][omm] platform: openEuler_20.03_64bit
WARN[2023-09-14T15:50:52.347] [172.16.220.151][omm] device(sdb) readahead value=8192, expect 16384.
WARN[2023-09-14T15:50:52.644] [172.16.220.151][omm] vm.min_free_kbytes=112640, expect 174399
INFO[2023-09-14T15:50:52.724] [172.16.220.151][omm] check kernel.core_pattern
INFO[2023-09-14T15:50:52.729] [172.16.220.151][omm] check removeIPC value
WARN[2023-09-14T15:50:53.669] [172.16.220.152][omm] vm.min_free_kbytes=112640, expect 174399
INFO[2023-09-14T15:50:55.767] [172.16.220.152][omm] check kernel.core_pattern
INFO[2023-09-14T15:50:55.786] [172.16.220.153][omm] check kernel.core_pattern
INFO[2023-09-14T15:50:55.975] [172.16.220.152][omm] check removeIPC value
INFO[2023-09-14T15:50:55.993] [172.16.220.153][omm] check removeIPC value
INFO[2023-09-14T15:50:59.549] [172.16.220.151][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
INFO[2023-09-14T15:50:59.647] [172.16.220.153][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
INFO[2023-09-14T15:50:59.647] [172.16.220.152][omm] kernel version: 4.19.90-2112.8.0.0131.oe1.x86_64
INFO[2023-09-14T15:50:59.651] [172.16.220.151][omm] timezone: +0800
INFO[2023-09-14T15:50:59.749] [172.16.220.153][omm] timezone: +0800
INFO[2023-09-14T15:50:59.750] [172.16.220.152][omm] timezone: +0800
INFO[2023-09-14T15:50:59.754] [172.16.220.151][omm] swap memory 0kB, total memory 3487988kB
INFO[2023-09-14T15:50:59.851] [172.16.220.153][omm] swap memory 0kB, total memory 1489628kB
INFO[2023-09-14T15:50:59.852] [172.16.220.152][omm] swap memory 0kB, total memory 3487996kB
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(sdb) 'IO Request'=254, expect 256
WARN[2023-09-14T15:50:59.857] [172.16.220.151][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-14T15:50:59.963] [172.16.220.153][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-14T15:50:59.963] [172.16.220.153][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.963] [172.16.220.153][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.963] [172.16.220.153][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.963] [172.16.220.153][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-14T15:50:59.965] [172.16.220.152][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.965] [172.16.220.152][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T15:50:59.965] [172.16.220.152][omm] device(sda) 'IO Request'=254, expect 256
WARN[2023-09-14T15:50:59.965] [172.16.220.152][omm] device(sr0) 'IO Request'=64, expect 256
WARN[2023-09-14T15:50:59.965] [172.16.220.152][omm] device(dm-0) 'IO Request'=128, expect 256
INFO[2023-09-14T15:51:00.511] [172.16.220.151][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T15:51:00.608] [172.16.220.152][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T15:51:00.609] [172.16.220.153][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T15:51:00.609] all checkers finished
INFO[2023-09-14T15:51:00.609] time elapsed: 11s
INFO[2023-09-14T15:51:00.609] check os success
INFO[2023-09-14T15:51:00.609] start check distro ...
INFO[2023-09-14T15:51:00.609] check distro success
INFO[2023-09-14T15:51:00.609] start check hostname ...
INFO[2023-09-14T15:51:00.609] check hostname success
INFO[2023-09-14T15:51:00.609] start check user ...
INFO[2023-09-14T15:51:00.712] check user success
INFO[2023-09-14T15:51:00.712] start check port ...
INFO[2023-09-14T15:51:01.459] check port success
INFO[2023-09-14T15:51:01.459] [172.16.220.151][omm] create os user omm, group dbgrp
INFO[2023-09-14T15:51:01.489] [172.16.220.151][omm] set ulimit configs
INFO[2023-09-14T15:51:01.491] [172.16.220.151][omm] make user omm's dir(s): /mogdb
INFO[2023-09-14T15:51:02.205] start prepare installation package ...
INFO[2023-09-14T15:51:02.205] installation package is ready
INFO[2023-09-14T15:51:02.205] start validate installation package ...
INFO[2023-09-14T15:51:04.869] db product: MogDB, version: 3.0.5, number: 92.607, commit_id: 76182eb6
INFO[2023-09-14T15:51:04.869] validate installation package success
INFO[2023-09-14T15:51:04.869] start complete the configuration ...
INFO[2023-09-14T15:51:04.869] complete the configuration success
INFO[2023-09-14T15:51:04.870] start distribute installation package ...
> To 172.16.220.153: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 19.09 MiB p/s 7.2s
> To 172.16.220.151: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 19.09 MiB p/s 7.2s
> To 172.16.220.152: 132.83 MiB / 132.83 MiB [----------------------------------------------------------------------------------------------------------------] 100.00% 19.09 MiB p/s 7.2s
INFO[2023-09-14T15:51:12.236] distrubite packages success
INFO[2023-09-14T15:51:12.236] start setup db ...
INFO[2023-09-14T15:51:12.377] [172.16.220.151][omm] total memory(3GB) is less than 4GB, use default db config
INFO[2023-09-14T15:51:12.377] [172.16.220.151][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T15:51:12.378] [172.16.220.153][omm] total memory(1GB) is less than 4GB, use default db config
INFO[2023-09-14T15:51:12.378] [172.16.220.153][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T15:51:12.383] [172.16.220.152][omm] total memory(3GB) is less than 4GB, use default db config
INFO[2023-09-14T15:51:12.383] [172.16.220.152][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T15:51:13.456] [172.16.220.153][omm] extract MogDB-3.0.5-CentOS-x86_64.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:13.456] [172.16.220.152][omm] extract MogDB-3.0.5-CentOS-x86_64.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:13.466] [172.16.220.151][omm] extract MogDB-3.0.5-CentOS-x86_64.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:14.796] [172.16.220.151][omm] extract MogDB-3.0.5-CentOS-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:14.841] [172.16.220.152][omm] extract MogDB-3.0.5-CentOS-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:14.901] [172.16.220.153][omm] extract MogDB-3.0.5-CentOS-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T15:51:15.472] [172.16.220.151][omm] try to fix psutil python lib
INFO[2023-09-14T15:51:15.552] [172.16.220.152][omm] try to fix psutil python lib
INFO[2023-09-14T15:51:15.653] [172.16.220.153][omm] try to fix psutil python lib
INFO[2023-09-14T15:51:15.870] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T15:51:16.049] [172.16.220.152][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T15:51:16.196] [172.16.220.153][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T15:51:16.236] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T15:51:16.499] [172.16.220.152][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T15:51:16.551] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T15:51:16.561] [172.16.220.153][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T15:51:16.865] [172.16.220.151][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T15:51:16.905] [172.16.220.153][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T15:51:16.925] [172.16.220.152][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T15:51:17.164] [172.16.220.151][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T15:51:17.291] [172.16.220.151][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T15:51:17.297] [172.16.220.152][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T15:51:17.304] [172.16.220.153][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T15:51:17.654] [172.16.220.153][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T15:51:17.659] [172.16.220.152][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T15:51:17.675] [172.16.220.151][omm] extract MogDB-3.0.5-CentOS-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T15:51:17.791] [172.16.220.153][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T15:51:17.810] [172.16.220.152][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T15:51:18.173] [172.16.220.153][omm] extract MogDB-3.0.5-CentOS-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T15:51:18.208] [172.16.220.152][omm] extract MogDB-3.0.5-CentOS-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T15:51:20.881] [172.16.220.151][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T15:51:21.061] [172.16.220.151][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:21.188] [172.16.220.151][omm] set user omm profiles
INFO[2023-09-14T15:51:21.296] [172.16.220.152][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T15:51:21.542] [172.16.220.152][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:21.543] [172.16.220.153][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T15:51:21.688] [172.16.220.152][omm] set user omm profiles
INFO[2023-09-14T15:51:21.765] [172.16.220.153][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:21.885] [172.16.220.151][omm] validate and try to fix ld library for gs_initdb
INFO[2023-09-14T15:51:21.914] [172.16.220.153][omm] set user omm profiles
WARN[2023-09-14T15:51:22.146] [172.16.220.151][omm] try to use /usr/lib64/libreadline.so to compat libreadline.so.6 (/mogdb/app/bin/gs_initdb required)
INFO[2023-09-14T15:51:22.269] [172.16.220.151][omm] validate and try to fix ld library for mogdb
WARN[2023-09-14T15:51:22.552] [172.16.220.151][omm] try to use /usr/lib64/libnsl.so.2 to compat libnsl.so.1 (/mogdb/app/bin/mogdb required)
INFO[2023-09-14T15:51:22.552] [172.16.220.152][omm] validate and try to fix ld library for gs_initdb
INFO[2023-09-14T15:51:22.666] [172.16.220.151][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:22.709] [172.16.220.153][omm] validate and try to fix ld library for gs_initdb
INFO[2023-09-14T15:51:22.807] [172.16.220.151][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6001,/mogdb/log/pg_audit/dn_6001
WARN[2023-09-14T15:51:22.852] [172.16.220.152][omm] try to use /usr/lib64/libreadline.so.8 to compat libreadline.so.6 (/mogdb/app/bin/gs_initdb required)
WARN[2023-09-14T15:51:22.996] [172.16.220.153][omm] try to use /usr/lib64/libreadline.so.8 to compat libreadline.so.6 (/mogdb/app/bin/gs_initdb required)
INFO[2023-09-14T15:51:23.011] [172.16.220.152][omm] validate and try to fix ld library for mogdb
INFO[2023-09-14T15:51:23.138] [172.16.220.153][omm] validate and try to fix ld library for mogdb
WARN[2023-09-14T15:51:23.353] [172.16.220.152][omm] try to use /usr/lib64/libnsl.so.2 to compat libnsl.so.1 (/mogdb/app/bin/mogdb required)
WARN[2023-09-14T15:51:23.445] [172.16.220.153][omm] try to use /usr/lib64/libnsl.so.2 to compat libnsl.so.1 (/mogdb/app/bin/mogdb required)
INFO[2023-09-14T15:51:23.491] [172.16.220.152][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:23.609] [172.16.220.153][omm] change /mogdb/app owner to omm
INFO[2023-09-14T15:51:23.646] [172.16.220.152][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6002,/mogdb/log/pg_audit/dn_6002
INFO[2023-09-14T15:51:23.741] [172.16.220.153][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6003,/mogdb/log/pg_audit/dn_6003
INFO[2023-09-14T15:51:26.304] [172.16.220.151][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T15:51:26.762] [172.16.220.151][omm] save version to upgrade_version
INFO[2023-09-14T15:51:27.248] [172.16.220.151][omm] create file cluster_manual_start
INFO[2023-09-14T15:51:27.382] [172.16.220.152][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T15:51:27.397] [172.16.220.151][omm] generate cluster_static_config file
INFO[2023-09-14T15:51:27.480] [172.16.220.151][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T15:51:27.603] [172.16.220.151][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T15:51:27.689] [172.16.220.153][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T15:51:27.855] [172.16.220.152][omm] save version to upgrade_version
INFO[2023-09-14T15:51:27.975] [172.16.220.151][omm] change /mogdb/data owner to omm
INFO[2023-09-14T15:51:28.098] [172.16.220.151][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T15:51:28.143] [172.16.220.153][omm] save version to upgrade_version
INFO[2023-09-14T15:51:28.374] [172.16.220.152][omm] create file cluster_manual_start
INFO[2023-09-14T15:51:28.508] [172.16.220.152][omm] generate cluster_static_config file
INFO[2023-09-14T15:51:28.618] [172.16.220.153][omm] create file cluster_manual_start
INFO[2023-09-14T15:51:28.622] [172.16.220.152][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T15:51:28.740] [172.16.220.153][omm] generate cluster_static_config file
INFO[2023-09-14T15:51:28.752] [172.16.220.152][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T15:51:28.845] [172.16.220.153][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T15:51:28.974] [172.16.220.153][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T15:51:29.166] [172.16.220.152][omm] change /mogdb/data owner to omm
INFO[2023-09-14T15:51:29.290] [172.16.220.152][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T15:51:29.381] [172.16.220.153][omm] change /mogdb/data owner to omm
INFO[2023-09-14T15:51:29.521] [172.16.220.153][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T15:51:41.551] [172.16.220.151][omm] config postgresql.conf
INFO[2023-09-14T15:51:41.685] [172.16.220.151][omm] config pg_hba.conf
INFO[2023-09-14T15:51:43.189] [172.16.220.153][omm] config postgresql.conf
INFO[2023-09-14T15:51:43.368] [172.16.220.153][omm] config pg_hba.conf
INFO[2023-09-14T15:52:02.735] [172.16.220.152][omm] config postgresql.conf
INFO[2023-09-14T15:52:03.555] [172.16.220.152][omm] config pg_hba.conf
INFO[2023-09-14T15:52:04.301] setup db success
INFO[2023-09-14T15:52:04.301] generate certification files
INFO[2023-09-14T15:52:05.140] download certification files
INFO[2023-09-14T15:52:06.168] upload certification files to omm@172.16.220.152
INFO[2023-09-14T15:52:15.052] upload certification files to omm@172.16.220.153
INFO[2023-09-14T15:52:16.536] certification files setup success
INFO[2023-09-14T15:52:16.536] genetate ptkc ...
INFO[2023-09-14T15:52:32.248] start build ssh trust ...
INFO[2023-09-14T15:52:33.566] ssh trust build success
INFO[2023-09-14T15:52:33.566] start launch db ...
INFO[2023-09-14T15:52:33.567] [172.16.220.151][omm] start db using gs_ctl ...
INFO[2023-09-14T15:52:33.567] [172.16.220.151][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T15:52:33.567] [172.16.220.152][omm] start db using gs_ctl ...
INFO[2023-09-14T15:52:33.567] [172.16.220.152][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T15:52:33.567] [172.16.220.153][omm] start db using gs_ctl ...
INFO[2023-09-14T15:52:33.567] [172.16.220.153][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T15:52:34.819] [172.16.220.152][omm] start db success
INFO[2023-09-14T15:52:34.831] [172.16.220.151][omm] start db success
INFO[2023-09-14T15:52:35.832] [172.16.220.151][omm] start alter db initial password ...
INFO[2023-09-14T15:52:35.975] [172.16.220.151][omm] alter db password success
ERRO[2023-09-14T15:52:35.975] start db: Error: [exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env; /mogdb/app/bin/gs_ctl start -M cascade_standby -D /mogdb/data -t 600\"": [2023-09-14 16:58:24.351][176693][][gs_ctl]: gs_ctl started,datadir is /mogdb/data
[2023-09-14 16:58:24.448][176693][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: Euler3
0 LOG: [Alarm Module]Host IP: 172.16.220.153
0 LOG: [Alarm Module]Cluster Name: mog_cluster
0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING: failed to parse feature control file: gaussdb.version.
0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.652 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.
gaussdb.state does not exist, and skipt setting since it is optional.2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: Euler3
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.16.220.153
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: mog_cluster
2023-09-14 16:58:24.661 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"
2023-09-14 16:58:24.662 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 10752 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2023-09-14 16:58:24.684 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)
2023-09-14 16:58:24.698 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728)
2023-09-14 16:58:24.727 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: mogdb: fsync file "/mogdb/data/gaussdb.state.temp" success
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Cascade Standby), connection index(1)
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 976, usable_fds = 1000, already_open = 14
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.753 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: the configure file /mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.
[2023-09-14 16:58:25.449][176693][][gs_ctl]: waitpid 176696 failed, exitstatus is 0, ret is 2
[2023-09-14 16:58:25.449][176693][][gs_ctl]: stopped waiting
[2023-09-14 16:58:25.449][176693][][gs_ctl]: could not start server
Examine the log output.
Stdout: [2023-09-14 16:58:24.351][176693][][gs_ctl]: gs_ctl started,datadir is /mogdb/data
[2023-09-14 16:58:24.448][176693][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: Euler3
0 LOG: [Alarm Module]Host IP: 172.16.220.153
0 LOG: [Alarm Module]Cluster Name: mog_cluster
0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING: failed to parse feature control file: gaussdb.version.
0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.652 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.
gaussdb.state does not exist, and skipt setting since it is optional.2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: Euler3
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.16.220.153
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: mog_cluster
2023-09-14 16:58:24.661 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"
2023-09-14 16:58:24.662 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 10752 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2023-09-14 16:58:24.684 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)
2023-09-14 16:58:24.698 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728)
2023-09-14 16:58:24.727 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: mogdb: fsync file "/mogdb/data/gaussdb.state.temp" success
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Cascade Standby), connection index(1)
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 976, usable_fds = 1000, already_open = 14
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.753 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: the configure file /mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.
[2023-09-14 16:58:25.449][176693][][gs_ctl]: waitpid 176696 failed, exitstatus is 0, ret is 2
[2023-09-14 16:58:25.449][176693][][gs_ctl]: stopped waiting
[2023-09-14 16:58:25.449][176693][][gs_ctl]: could not start server
Examine the log output.
INFO[2023-09-14T15:52:35.975] clear temp dirs ...
INFO[2023-09-14T15:52:36.123] clear temp dirs success
INFO[2023-09-14T15:52:36.123] time elapsed: 1m47s
WARN[2023-09-14T15:52:36.123] host 172.16.220.153 error message too long, store to file ptk-install-172.16.220.153.err.log
cluste_name | host | user | port | status | message
--------------+----------------+------+-------+---------------+-----------------------------------------------------------
mog_cluster | 172.16.220.151 | omm | 26000 | start_success | success
| 172.16.220.152 | omm | 26000 | start_success | success
| 172.16.220.153 | omm | 26000 | start_failed | see file [ptk-install-172.16.220.153.err.log] for detail
基本安装完成，集群在正常运行，这个报错一般和依赖包及python有关。别用python了，很坑。猜测调用gs_om等命令出错
报错日志
Error: [exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env; /mogdb/app/bin/gs_ctl start -M cascade_standby -D /mogdb/data -t 600\"": [2023-09-14 16:58:24.351][176693][][gs_ctl]: gs_ctl started,datadir is /mogdb/data
[2023-09-14 16:58:24.448][176693][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: Euler3
0 LOG: [Alarm Module]Host IP: 172.16.220.153
0 LOG: [Alarm Module]Cluster Name: mog_cluster
0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING: failed to parse feature control file: gaussdb.version.
0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.652 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.
gaussdb.state does not exist, and skipt setting since it is optional.2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: Euler3
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.16.220.153
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: mog_cluster
2023-09-14 16:58:24.661 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"
2023-09-14 16:58:24.662 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 10752 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2023-09-14 16:58:24.684 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)
2023-09-14 16:58:24.698 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728)
2023-09-14 16:58:24.727 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: mogdb: fsync file "/mogdb/data/gaussdb.state.temp" success
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Cascade Standby), connection index(1)
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 976, usable_fds = 1000, already_open = 14
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.753 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: the configure file /mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.
[2023-09-14 16:58:25.449][176693][][gs_ctl]: waitpid 176696 failed, exitstatus is 0, ret is 2
[2023-09-14 16:58:25.449][176693][][gs_ctl]: stopped waiting
[2023-09-14 16:58:25.449][176693][][gs_ctl]: could not start server
Examine the log output.
Stdout: [2023-09-14 16:58:24.351][176693][][gs_ctl]: gs_ctl started,datadir is /mogdb/data
[2023-09-14 16:58:24.448][176693][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: Euler3
0 LOG: [Alarm Module]Host IP: 172.16.220.153
0 LOG: [Alarm Module]Cluster Name: mog_cluster
0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING: failed to parse feature control file: gaussdb.version.
0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version.
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.652 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.
gaussdb.state does not exist, and skipt setting since it is optional.2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: Euler3
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 172.16.220.153
2023-09-14 16:58:24.657 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: mog_cluster
2023-09-14 16:58:24.661 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"
2023-09-14 16:58:24.662 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 10752 MB
2023-09-14 16:58:24.663 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2023-09-14 16:58:24.684 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)
2023-09-14 16:58:24.698 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728)
2023-09-14 16:58:24.727 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: mogdb: fsync file "/mogdb/data/gaussdb.state.temp" success
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Cascade Standby), connection index(1)
2023-09-14 16:58:24.751 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 976, usable_fds = 1000, already_open = 14
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:|/usr/lib/systemd/
2023-09-14 16:58:24.753 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: the configure file /mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-09-14 16:58:24.756 [unknown] [unknown] localhost 140716213762496 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.
[2023-09-14 16:58:25.449][176693][][gs_ctl]: waitpid 176696 failed, exitstatus is 0, ret is 2
[2023-09-14 16:58:25.449][176693][][gs_ctl]: stopped waiting
[2023-09-14 16:58:25.449][176693][][gs_ctl]: could not start server
[omm@Euler1 lib]$ gs_om -t status
Traceback (most recent call last):
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 41, in <module>
import paramiko
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/__init__.py", line 22, in <module>
from paramiko.transport import SecurityOptions, Transport
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/transport.py", line 89, in <module>
from paramiko.dsskey import DSSKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/dsskey.py", line 37, in <module>
from paramiko.pkey import PKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/pkey.py", line 31, in <module>
import bcrypt
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/bcrypt/__init__.py", line 25, in <module>
from . import _bcrypt # type: ignore
ImportError: libffi.so.6: cannot open shared object file: No such file or directory
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 62, in <module>
import paramiko
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/__init__.py", line 22, in <module>
from paramiko.transport import SecurityOptions, Transport
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/transport.py", line 89, in <module>
from paramiko.dsskey import DSSKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/dsskey.py", line 37, in <module>
from paramiko.pkey import PKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/pkey.py", line 31, in <module>
import bcrypt
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/bcrypt/__init__.py", line 25, in <module>
from . import _bcrypt # type: ignore
ImportError: libffi.so.6: cannot open shared object file: No such file or directory
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/mogdb/tool/script/gs_om", line 31, in <module>
from gspylib.common.ParallelBaseOM import ParallelBaseOM
File "/mogdb/tool/script/gspylib/common/ParallelBaseOM.py", line 28, in <module>
from gspylib.threads.SshTool import SshTool
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 64, in <module>
raise Exception(ErrorCode.GAUSS_522["GAUSS_52200"] % str(e))
Exception: [GAUSS-52200] : Unable to import module: libffi.so.6: cannot open shared object file: No such file or directory.
解决
[root@Euler1 lib]# ln -s /usr/lib64/libffi.so.7 /usr/lib64/libffi.so.6
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/mogdb/tool/script/gs_om", line 31, in <module>
from gspylib.common.ParallelBaseOM import ParallelBaseOM
File "/mogdb/tool/script/gspylib/common/ParallelBaseOM.py", line 28, in <module>
from gspylib.threads.SshTool import SshTool
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 64, in <module>
raise Exception(ErrorCode.GAUSS_522["GAUSS_52200"] % str(e))
Exception: [GAUSS-52200] : Unable to import module: libpython3.6m.so.1.0: cannot open shared object file: No such file or directory.
又缺一个，解决
[root@Euler1 lib64]# ln -s libpython3.7m.so libpython3.6m.so.1.0
Traceback (most recent call last):
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 62, in <module>
import paramiko
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/__init__.py", line 22, in <module>
from paramiko.transport import SecurityOptions, Transport
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/transport.py", line 89, in <module>
from paramiko.dsskey import DSSKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/dsskey.py", line 37, in <module>
from paramiko.pkey import PKey
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/paramiko/pkey.py", line 31, in <module>
import bcrypt
File "/mogdb/tool/script/domain_utils/sql_handler/../../../lib/bcrypt/__init__.py", line 25, in <module>
from . import _bcrypt # type: ignore
ImportError: this module was compiled for Python 3.6
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/mogdb/tool/script/gs_om", line 31, in <module>
from gspylib.common.ParallelBaseOM import ParallelBaseOM
File "/mogdb/tool/script/gspylib/common/ParallelBaseOM.py", line 28, in <module>
from gspylib.threads.SshTool import SshTool
File "/mogdb/tool/script/gspylib/threads/SshTool.py", line 64, in <module>
raise Exception(ErrorCode.GAUSS_522["GAUSS_52200"] % str(e))
Exception: [GAUSS-52200] : Unable to import module: this module was compiled for Python 3.6.
解决
wget https://www.python.org/ftp/python/3.6.5/Python-3.6.5.tgz
mkdir -p /usr/local/python3
tar -zxvf Python-3.6.5.tgz
cd Python-3.6.5
./configure --prefix=/usr/local/python3 --enable-shared CFLAGS=-fPIC && make && make install
ln -s /usr/local/python3/bin/python3 /usr/bin/python3
ln -s /usr/local/python3/bin/pip3 /usr/bin/pip3
九、oracle linux8安装
1、环境检查
三台都检查
[root@db01 ~]# ./ptk checkos -i A
INFO[2023-09-14T21:01:24.066] prechecking dependent tools...
WARN[2023-09-14T21:01:24.162] [172.16.220.10][omm] device(nvme0n1) readahead value=8192, expect 16384.
WARN[2023-09-14T21:01:24.162] [172.16.220.10][omm] device(nvme0n2) readahead value=8192, expect 16384.
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(sr0) 'IO Request'=2, expect 256
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(nvme0n1) 'IO Request'=255, expect 256
WARN[2023-09-14T21:01:24.209] [172.16.220.10][omm] device(nvme0n2) 'IO Request'=255, expect 256
WARN[2023-09-14T21:01:24.226] [172.16.220.10][omm] device(nvme0n1) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:01:24.226] [172.16.220.10][omm] device(nvme0n2) 'IO scheduler'='none', expect 'mq-deadline'
INFO[2023-09-14T21:01:37.171] [172.16.220.10][omm] swap memory 4149244kB, total memory 3730276kB
INFO[2023-09-14T21:01:37.185] [172.16.220.10][omm] platform: ol_8.6_64bit
INFO[2023-09-14T21:01:37.193] [172.16.220.10][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T21:01:37.200] [172.16.220.10][omm] timezone: +0800
WARN[2023-09-14T21:01:37.217] [172.16.220.10][omm] net.ipv4.tcp_wmem=4096 16384 4194304, expect 8192 250000 16777216
WARN[2023-09-14T21:01:37.222] [172.16.220.10][omm] net.core.somaxconn=4096, expect 65535
WARN[2023-09-14T21:01:37.235] [172.16.220.10][omm] net.core.netdev_max_backlog=1000, expect 65535
WARN[2023-09-14T21:01:37.246] [172.16.220.10][omm] net.ipv4.tcp_syn_retries=6, expect 5
WARN[2023-09-14T21:01:37.257] [172.16.220.10][omm] net.ipv4.tcp_max_syn_backlog=256, expect 65535
WARN[2023-09-14T21:01:37.270] [172.16.220.10][omm] net.ipv4.tcp_retries2=15, expect 12
WARN[2023-09-14T21:01:37.300] [172.16.220.10][omm] net.ipv4.tcp_tw_reuse=2, expect 1
WARN[2023-09-14T21:01:37.324] [172.16.220.10][omm] vm.min_free_kbytes=7663, expect 186513
WARN[2023-09-14T21:01:37.335] [172.16.220.10][omm] net.ipv4.tcp_rmem=4096 131072 6291456, expect 8192 250000 16777216
WARN[2023-09-14T21:01:37.340] [172.16.220.10][omm] net.ipv4.tcp_retries1=3, expect 5
WARN[2023-09-14T21:01:37.367] [172.16.220.10][omm] net.ipv4.tcp_keepalive_time=7200, expect 30
WARN[2023-09-14T21:01:37.373] [172.16.220.10][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30
INFO[2023-09-14T21:01:37.373] [172.16.220.10][omm] check kernel.core_pattern
INFO[2023-09-14T21:01:37.385] [172.16.220.10][omm] check removeIPC value
INFO[2023-09-14T21:01:37.426] [172.16.220.10][omm] kernel version: 5.4.17-2136.307.3.1.el8uek.x86_64
INFO[2023-09-14T21:01:37.426] all checkers finished
INFO[2023-09-14T21:01:37.426] time elapsed: 13s
# Check Results
Item | Level
------------------------------------+----------
A1.Check_OS_Version | OK
A2.Check_Kernel_Version | OK
A3.Check_Unicode | OK
A4.Check_TimeZone | OK
A5.Check_Swap_Memory_Configure | Warning
A6.Check_SysCtl_Parameter | Warning
A7.Check_FileSystem_Configure | OK
A8.Check_Disk_Configure | OK
A9.Check_BlockDev_Configure | Warning
A9.Check_Logical_Block | OK
A10.Check_Asynchronous_IO_Request | OK
A10.Check_IO_Configure | Warning
A10.Check_IO_Request | Warning
A11.Check_Network_Configure | OK
A12.Check_Time_Consistency | OK
A13.Check_Firewall_Status | OK
A14.Check_THP_Status | OK
A15.Check_Dependent_Package | OK
A16.Check_CPU_Instruction_Set | OK
A18.Check_Selinux | OK
Total count 20, abnormal count 0, warning count 5
2、准备配置文件
[root@db02 ~]# ./ptk template create
✔ Please enter cluster name (default: villani): mog
✔ Please enter system username (default: omm): omm
✔ Please enter group of user (default: omm): dbgrp
✔ Please enter db password (8~15 characters, 3 classes): **********
✔ Retype db password: **********
✔ Please enter db port (range 1024~65535) (default: 26000):
✔ Please enter mogdb base dir (which should be empty) (default: /opt/mogdb): /mogdb
✔ Do you want to intall cm component (default=n) [y/n]: y
And then, let's add some db servers
================db server 1================
✔ Please enter server ip (IPv4 only): 172.16.220.10
✔ primary
✔ Please enter available zone name (default: AZ1):
✔ Please enter zone("AZ1") priority (default: 1):
✔ [SSH] Please enter ssh user (default: root):
✔ [SSH] Please enter ssh port (default: 22):
✔ Password
✔ [SSH] Please enter ssh password: ********
================ end ================
✔ Do you want to add another db server (default=n) [y/n]: y
================db server 2================
✔ Please enter server ip (IPv4 only): 172.16.220.20
✔ standby
✔ Please enter available zone name (default: AZ1):
================ end ================
✔ Do you want to add another db server (default=n) [y/n]: y
================db server 3================
✔ Please enter server ip (IPv4 only): 172.16.220.30
✔ cascade_standby
✔ 172.16.220.20
✔ Please enter available zone name (default: AZ1):
✔ Do you want to reuse SSH configurations from other servers (default=n) [y/n]: y
✔ 172.16.220.10
================ end ================
✔ Do you want to add another db server (default=n) [y/n]: n
Generate /root/config.2023-09-14T21_21_49.yaml successfully
3、安装
root@db01 ~]# ./ptk install -f /root/config.2023-09-14T21_21_49.yaml
INFO[2023-09-14T21:16:09.050] PTK Version: 1.0.7 release
INFO[2023-09-14T21:16:09.050] load config from /root/config.2023-09-14T21_21_49.yaml
If you continue to install the software,
you are accepting the license agreement of the software.
[Y]: Accept and continue
[C]: Show content of licence agreement
[N]: Abort installation and exit
✔ Please enter (default: Y): y
Cluster Name: "mog"
+--------------+---------------+-------------+-------+-----------------+-------------+---------------+
| az(priority) | ip | user(group) | port | role | data dir | upstream |
+--------------+---------------+-------------+-------+-----------------+-------------+---------------+
| AZ1(1) | 172.16.220.10 | omm(dbgrp) | 26000 | primary | /mogdb/data | - |
| | 172.16.220.30 | omm(dbgrp) | 26000 | cascade_standby | /mogdb/data | 172.16.220.20 |
| | 172.16.220.20 | omm(dbgrp) | 26000 | standby | /mogdb/data | - |
+--------------+---------------+-------------+-------+-----------------+-------------+---------------+
✔ Is cluster config correct (default=n) [y/n]: y
INFO[2023-09-14T21:16:12.474] start check os ...
INFO[2023-09-14T21:16:12.553] prechecking dependent tools...
INFO[2023-09-14T21:16:13.250] [172.16.220.30][omm] platform: ol_8.6_64bit
INFO[2023-09-14T21:16:13.250] [172.16.220.10][omm] platform: ol_8.6_64bit
INFO[2023-09-14T21:16:13.251] [172.16.220.20][omm] platform: ol_8.6_64bit
INFO[2023-09-14T21:16:13.261] [172.16.220.10][omm] kernel version: 5.4.17-2136.307.3.1.el8uek.x86_64
INFO[2023-09-14T21:16:13.328] [172.16.220.30][omm] kernel version: 5.4.17-2136.307.3.1.el8uek.x86_64
INFO[2023-09-14T21:16:13.337] [172.16.220.20][omm] kernel version: 5.4.17-2136.307.3.1.el8uek.x86_64
INFO[2023-09-14T21:16:13.354] [172.16.220.10][omm] timezone: +0800
INFO[2023-09-14T21:16:13.427] [172.16.220.30][omm] timezone: +0800
INFO[2023-09-14T21:16:13.429] [172.16.220.20][omm] timezone: +0800
INFO[2023-09-14T21:16:13.446] [172.16.220.10][omm] swap memory 4149244kB, total memory 3730276kB
INFO[2023-09-14T21:16:13.538] [172.16.220.30][omm] swap memory 4149244kB, total memory 3730276kB
INFO[2023-09-14T21:16:13.538] [172.16.220.20][omm] swap memory 4149244kB, total memory 7852904kB
WARN[2023-09-14T21:16:13.557] [172.16.220.10][omm] net.ipv4.tcp_retries2=15, expect 12
WARN[2023-09-14T21:16:13.578] [172.16.220.10][omm] net.ipv4.tcp_rmem=4096 131072 6291456, expect 8192 250000 16777216
WARN[2023-09-14T21:16:13.662] [172.16.220.10][omm] net.ipv4.tcp_tw_reuse=2, expect 1
WARN[2023-09-14T21:16:13.708] [172.16.220.10][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30
WARN[2023-09-14T21:16:13.782] [172.16.220.10][omm] vm.min_free_kbytes=7663, expect 186513
WARN[2023-09-14T21:16:13.818] [172.16.220.10][omm] net.ipv4.tcp_keepalive_time=7200, expect 30
WARN[2023-09-14T21:16:13.833] [172.16.220.30][omm] net.ipv4.tcp_wmem=4096 16384 4194304, expect 8192 250000 16777216
WARN[2023-09-14T21:16:13.834] [172.16.220.10][omm] net.ipv4.tcp_retries1=3, expect 5
WARN[2023-09-14T21:16:13.848] [172.16.220.20][omm] net.ipv4.tcp_keepalive_time=7200, expect 30
WARN[2023-09-14T21:16:13.858] [172.16.220.10][omm] net.core.somaxconn=4096, expect 65535
WARN[2023-09-14T21:16:14.005] [172.16.220.10][omm] net.ipv4.tcp_wmem=4096 16384 4194304, expect 8192 250000 16777216
WARN[2023-09-14T21:16:14.006] [172.16.220.20][omm] net.ipv4.tcp_retries2=15, expect 12
WARN[2023-09-14T21:16:14.014] [172.16.220.30][omm] net.ipv4.tcp_retries1=3, expect 5
WARN[2023-09-14T21:16:14.020] [172.16.220.10][omm] net.ipv4.tcp_max_syn_backlog=256, expect 65535
WARN[2023-09-14T21:16:14.035] [172.16.220.10][omm] net.ipv4.tcp_syn_retries=6, expect 5
WARN[2023-09-14T21:16:14.050] [172.16.220.10][omm] net.core.netdev_max_backlog=1000, expect 65535
INFO[2023-09-14T21:16:14.061] [172.16.220.10][omm] check kernel.core_pattern
WARN[2023-09-14T21:16:14.073] [172.16.220.20][omm] net.ipv4.tcp_wmem=4096 16384 4194304, expect 8192 250000 16777216
WARN[2023-09-14T21:16:14.079] [172.16.220.30][omm] net.ipv4.tcp_retries2=15, expect 12
INFO[2023-09-14T21:16:14.082] [172.16.220.10][omm] check removeIPC value
WARN[2023-09-14T21:16:14.331] [172.16.220.30][omm] net.ipv4.tcp_keepalive_time=7200, expect 30
WARN[2023-09-14T21:16:14.422] [172.16.220.30][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30
WARN[2023-09-14T21:16:14.530] [172.16.220.30][omm] net.ipv4.tcp_rmem=4096 131072 6291456, expect 8192 250000 16777216
WARN[2023-09-14T21:16:14.608] [172.16.220.20][omm] net.ipv4.tcp_tw_reuse=2, expect 1
WARN[2023-09-14T21:16:14.696] [172.16.220.30][omm] net.core.netdev_max_backlog=1000, expect 65535
WARN[2023-09-14T21:16:14.745] [172.16.220.20][omm] net.ipv4.tcp_retries1=3, expect 5
WARN[2023-09-14T21:16:14.836] [172.16.220.30][omm] net.ipv4.tcp_max_syn_backlog=256, expect 65535
WARN[2023-09-14T21:16:14.896] [172.16.220.30][omm] net.ipv4.tcp_syn_retries=6, expect 5
WARN[2023-09-14T21:16:14.930] [172.16.220.20][omm] net.ipv4.tcp_syn_retries=6, expect 5
WARN[2023-09-14T21:16:15.077] [172.16.220.30][omm] vm.min_free_kbytes=7663, expect 186513
WARN[2023-09-14T21:16:15.163] [172.16.220.20][omm] net.ipv4.tcp_max_syn_backlog=512, expect 65535
WARN[2023-09-14T21:16:15.194] [172.16.220.30][omm] net.ipv4.tcp_tw_reuse=2, expect 1
WARN[2023-09-14T21:16:15.307] [172.16.220.20][omm] net.core.somaxconn=4096, expect 65535
WARN[2023-09-14T21:16:15.414] [172.16.220.20][omm] net.core.netdev_max_backlog=1000, expect 65535
WARN[2023-09-14T21:16:15.599] [172.16.220.20][omm] vm.min_free_kbytes=11166, expect 392645
WARN[2023-09-14T21:16:15.798] [172.16.220.30][omm] net.core.somaxconn=4096, expect 65535
WARN[2023-09-14T21:16:15.814] [172.16.220.20][omm] net.ipv4.tcp_keepalive_intvl=75, expect 30
WARN[2023-09-14T21:16:15.906] [172.16.220.20][omm] net.ipv4.tcp_rmem=4096 131072 6291456, expect 8192 250000 16777216
INFO[2023-09-14T21:16:15.906] [172.16.220.20][omm] check kernel.core_pattern
INFO[2023-09-14T21:16:15.967] [172.16.220.30][omm] check kernel.core_pattern
INFO[2023-09-14T21:16:16.033] [172.16.220.20][omm] check removeIPC value
INFO[2023-09-14T21:16:16.112] [172.16.220.30][omm] check removeIPC value
WARN[2023-09-14T21:16:16.320] [172.16.220.10][omm] device(nvme0n1) readahead value=8192, expect 16384.
WARN[2023-09-14T21:16:16.320] [172.16.220.10][omm] device(nvme0n2) readahead value=8192, expect 16384.
WARN[2023-09-14T21:16:16.513] [172.16.220.20][omm] device(nvme0n1) readahead value=8192, expect 16384.
WARN[2023-09-14T21:16:16.514] [172.16.220.20][omm] device(nvme0n2) readahead value=8192, expect 16384.
WARN[2023-09-14T21:16:16.522] [172.16.220.30][omm] device(nvme0n1) readahead value=8192, expect 16384.
WARN[2023-09-14T21:16:16.523] [172.16.220.30][omm] device(nvme0n2) readahead value=8192, expect 16384.
INFO[2023-09-14T21:16:17.059] [172.16.220.10][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T21:16:17.112] [172.16.220.20][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T21:16:17.113] [172.16.220.30][omm] locale: LANG=en_US.UTF-8
INFO[2023-09-14T21:16:17.712] [172.16.220.30][omm] check port 26000
INFO[2023-09-14T21:16:17.712] [172.16.220.10][omm] check port 26000
INFO[2023-09-14T21:16:17.712] [172.16.220.20][omm] check port 26000
INFO[2023-09-14T21:16:17.745] [172.16.220.10][omm] port 26000 is free
INFO[2023-09-14T21:16:17.974] [172.16.220.20][omm] port 26000 is free
INFO[2023-09-14T21:16:17.978] [172.16.220.30][omm] port 26000 is free
WARN[2023-09-14T21:16:18.180] [172.16.220.10][omm] device(nvme0n1) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.180] [172.16.220.10][omm] device(nvme0n2) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.285] [172.16.220.30][omm] device(nvme0n1) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.285] [172.16.220.30][omm] device(nvme0n2) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.288] [172.16.220.20][omm] device(nvme0n1) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.288] [172.16.220.20][omm] device(nvme0n2) 'IO scheduler'='none', expect 'mq-deadline'
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(nvme0n1) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(nvme0n2) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.299] [172.16.220.10][omm] device(sr0) 'IO Request'=2, expect 256
WARN[2023-09-14T21:16:18.356] [172.16.220.30][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.357] [172.16.220.30][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.357] [172.16.220.30][omm] device(dm-2) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.357] [172.16.220.30][omm] device(nvme0n1) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.357] [172.16.220.30][omm] device(nvme0n2) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.357] [172.16.220.30][omm] device(sr0) 'IO Request'=2, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(nvme0n1) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(nvme0n2) 'IO Request'=255, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(sr0) 'IO Request'=2, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(dm-0) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(dm-1) 'IO Request'=128, expect 256
WARN[2023-09-14T21:16:18.359] [172.16.220.20][omm] device(dm-2) 'IO Request'=128, expect 256
INFO[2023-09-14T21:16:31.669] all checkers finished
INFO[2023-09-14T21:16:31.669] time elapsed: 19s
INFO[2023-09-14T21:16:31.669] check os success
INFO[2023-09-14T21:16:31.669] start check distro ...
INFO[2023-09-14T21:16:31.669] check distro success
INFO[2023-09-14T21:16:31.670] start check hostname ...
INFO[2023-09-14T21:16:31.670] check hostname success
INFO[2023-09-14T21:16:31.670] start check user ...
INFO[2023-09-14T21:16:31.743] check user success
INFO[2023-09-14T21:16:31.743] start check port ...
INFO[2023-09-14T21:16:32.246] check port success
INFO[2023-09-14T21:16:32.246] [172.16.220.10][omm] create os user omm, group dbgrp
INFO[2023-09-14T21:16:32.247] [172.16.220.30][omm] create os user omm, group dbgrp
INFO[2023-09-14T21:16:32.247] [172.16.220.20][omm] create os user omm, group dbgrp
INFO[2023-09-14T21:16:32.614] [172.16.220.10][omm] set ulimit configs
INFO[2023-09-14T21:16:32.619] [172.16.220.10][omm] make user omm's dir(s): /mogdb
INFO[2023-09-14T21:16:32.697] [172.16.220.30][omm] set ulimit configs
INFO[2023-09-14T21:16:32.719] [172.16.220.20][omm] set ulimit configs
INFO[2023-09-14T21:16:32.783] [172.16.220.30][omm] make user omm's dir(s): /mogdb
INFO[2023-09-14T21:16:32.803] [172.16.220.20][omm] make user omm's dir(s): /mogdb
INFO[2023-09-14T21:16:33.748] start prepare installation package ...
INFO[2023-09-14T21:16:33.748] no package specified, use online package: https://cdn-mogdb.enmotech.com/mogdb-media/5.0.1/Kylin_x86_64/MogDB-5.0.1-Kylin-x86_64-all.tar.gz
INFO[2023-09-14T21:16:33.748] downloading MogDB-5.0.1-Kylin-x86_64-all.tar.gz ...
> MogDB-5.0.1-Kylin-x86_64-al...: 130.98 MiB / 131.75 MiB [------------------------------------------------------------------>] 99.41% 3.98 MiB p/s ETA 0s
> MogDB-5.0.1-Kylin-x86_64-al...: 131.75 MiB / 131.75 MiB [---------------------------------------------------------------------] 100.00% 3.55 MiB p/s 37s
INFO[2023-09-14T21:17:14.299] installation package is ready
INFO[2023-09-14T21:17:14.299] start validate installation package ...
INFO[2023-09-14T21:17:16.118] db product: MogDB, version: 5.0.1, number: 92.850, commit_id: ae6d2ada
INFO[2023-09-14T21:17:16.118] validate installation package success
INFO[2023-09-14T21:17:16.118] start complete the configuration ...
INFO[2023-09-14T21:17:16.118] complete the configuration success
INFO[2023-09-14T21:17:16.119] start distribute installation package ...
> To 172.16.220.20: 131.75 MiB / 131.75 MiB [---------------------------------------------------------------------------------] 100.00% 23.54 MiB p/s 5.8s
> To 172.16.220.30: 131.75 MiB / 131.75 MiB [---------------------------------------------------------------------------------] 100.00% 23.54 MiB p/s 5.8s
> To 172.16.220.10: 131.75 MiB / 131.75 MiB [---------------------------------------------------------------------------------] 100.00% 23.54 MiB p/s 5.8s
INFO[2023-09-14T21:17:22.062] distrubite packages success
INFO[2023-09-14T21:17:22.062] start setup db ...
INFO[2023-09-14T21:17:22.139] [172.16.220.30][omm] total memory(3GB) is less than 4GB, use default db config
INFO[2023-09-14T21:17:22.139] [172.16.220.30][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T21:17:22.140] [172.16.220.20][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T21:17:22.145] [172.16.220.10][omm] total memory(3GB) is less than 4GB, use default db config
INFO[2023-09-14T21:17:22.145] [172.16.220.10][omm] make user omm's dir(s): /mogdb/tool,/mogdb/tool/ptk_tool/bin
INFO[2023-09-14T21:17:22.748] [172.16.220.30][omm] extract MogDB-5.0.1-Kylin-x86_64-all.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:22.748] [172.16.220.20][omm] extract MogDB-5.0.1-Kylin-x86_64-all.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:22.796] [172.16.220.10][omm] extract MogDB-5.0.1-Kylin-x86_64-all.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:24.207] [172.16.220.30][omm] extract MogDB-5.0.1-Kylin-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:24.219] [172.16.220.20][omm] extract MogDB-5.0.1-Kylin-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:24.297] [172.16.220.10][omm] extract MogDB-5.0.1-Kylin-64bit-om.tar.gz to dir /mogdb/tool
INFO[2023-09-14T21:17:24.741] [172.16.220.30][omm] try to fix psutil python lib
INFO[2023-09-14T21:17:24.749] [172.16.220.20][omm] try to fix psutil python lib
INFO[2023-09-14T21:17:24.873] [172.16.220.10][omm] try to fix psutil python lib
INFO[2023-09-14T21:17:24.996] [172.16.220.20][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T21:17:24.997] [172.16.220.30][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T21:17:25.138] [172.16.220.10][omm] write file /mogdb/tool/ptk_tool/bin/README.md
INFO[2023-09-14T21:17:25.218] [172.16.220.20][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T21:17:25.228] [172.16.220.30][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T21:17:25.398] [172.16.220.10][omm] write file /mogdb/tool/ptk_tool/bin/pscp
INFO[2023-09-14T21:17:25.442] [172.16.220.20][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T21:17:25.444] [172.16.220.30][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T21:17:25.642] [172.16.220.10][omm] write file /mogdb/tool/ptk_tool/bin/pssh
INFO[2023-09-14T21:17:25.667] [172.16.220.20][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T21:17:25.676] [172.16.220.30][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T21:17:25.894] [172.16.220.10][omm] write file /mogdb/tool/ptk_tool/bin/task_pool.py
INFO[2023-09-14T21:17:25.900] [172.16.220.20][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T21:17:25.900] [172.16.220.30][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T21:17:25.982] [172.16.220.30][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T21:17:25.985] [172.16.220.20][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T21:17:26.144] [172.16.220.10][omm] change /mogdb/tool owner to omm
INFO[2023-09-14T21:17:26.213] [172.16.220.30][omm] extract MogDB-5.0.1-Kylin-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T21:17:26.219] [172.16.220.20][omm] extract MogDB-5.0.1-Kylin-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T21:17:26.232] [172.16.220.10][omm] make user omm's dir(s): /mogdb/app
INFO[2023-09-14T21:17:26.479] [172.16.220.10][omm] extract MogDB-5.0.1-Kylin-64bit.tar.gz to dir /mogdb/app
INFO[2023-09-14T21:17:29.767] [172.16.220.20][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T21:17:29.794] [172.16.220.30][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T21:17:29.920] [172.16.220.20][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:29.943] [172.16.220.30][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:30.022] [172.16.220.20][omm] set user omm profiles
INFO[2023-09-14T21:17:30.034] [172.16.220.30][omm] set user omm profiles
INFO[2023-09-14T21:17:30.292] [172.16.220.10][omm] write file /mogdb/app/bin/transfer.py
INFO[2023-09-14T21:17:30.468] [172.16.220.10][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:30.563] [172.16.220.10][omm] set user omm profiles
INFO[2023-09-14T21:17:30.685] [172.16.220.30][omm] validate and try to fix ld library for gs_initdb
INFO[2023-09-14T21:17:30.732] [172.16.220.20][omm] validate and try to fix ld library for gs_initdb
WARN[2023-09-14T21:17:30.865] [172.16.220.30][omm] try to use /lib64/libreadline.so to compat libreadline.so.8 (/mogdb/app/bin/gs_initdb required)
WARN[2023-09-14T21:17:30.895] [172.16.220.20][omm] try to use /lib64/libreadline.so to compat libreadline.so.8 (/mogdb/app/bin/gs_initdb required)
INFO[2023-09-14T21:17:30.943] [172.16.220.30][omm] validate and try to fix ld library for mogdb
INFO[2023-09-14T21:17:30.988] [172.16.220.20][omm] validate and try to fix ld library for mogdb
INFO[2023-09-14T21:17:31.041] [172.16.220.30][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:31.082] [172.16.220.20][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:31.133] [172.16.220.30][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6003,/mogdb/log/pg_audit/dn_6003
INFO[2023-09-14T21:17:31.179] [172.16.220.20][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6002,/mogdb/log/pg_audit/dn_6002
INFO[2023-09-14T21:17:31.337] [172.16.220.10][omm] validate and try to fix ld library for gs_initdb
WARN[2023-09-14T21:17:31.516] [172.16.220.10][omm] try to use /lib64/libreadline.so to compat libreadline.so.8 (/mogdb/app/bin/gs_initdb required)
INFO[2023-09-14T21:17:31.620] [172.16.220.10][omm] validate and try to fix ld library for mogdb
INFO[2023-09-14T21:17:31.719] [172.16.220.10][omm] change /mogdb/app owner to omm
INFO[2023-09-14T21:17:31.826] [172.16.220.10][omm] make user omm's dir(s): /mogdb/log/gs_profile,/mogdb/log/pg_log,/mogdb/log/pg_audit,/mogdb/log/bin,/mogdb/log/pg_log/dn_6001,/mogdb/log/pg_audit/dn_6001
INFO[2023-09-14T21:17:33.259] [172.16.220.30][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T21:17:33.310] [172.16.220.20][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T21:17:33.513] [172.16.220.30][omm] save version to upgrade_version
INFO[2023-09-14T21:17:33.555] [172.16.220.20][omm] save version to upgrade_version
INFO[2023-09-14T21:17:33.865] [172.16.220.30][omm] create file cluster_manual_start
INFO[2023-09-14T21:17:33.916] [172.16.220.20][omm] create file cluster_manual_start
INFO[2023-09-14T21:17:33.957] [172.16.220.30][omm] generate cluster_static_config file
INFO[2023-09-14T21:17:33.994] [172.16.220.20][omm] generate cluster_static_config file
INFO[2023-09-14T21:17:34.045] [172.16.220.30][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T21:17:34.104] [172.16.220.20][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T21:17:34.119] [172.16.220.30][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T21:17:34.180] [172.16.220.20][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T21:17:34.232] [172.16.220.10][omm] make user omm's dir(s): /mogdb/tmp
INFO[2023-09-14T21:17:34.374] [172.16.220.30][omm] change /mogdb/data owner to omm
INFO[2023-09-14T21:17:34.434] [172.16.220.20][omm] change /mogdb/data owner to omm
INFO[2023-09-14T21:17:34.451] [172.16.220.30][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T21:17:34.514] [172.16.220.20][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T21:17:34.534] [172.16.220.10][omm] save version to upgrade_version
INFO[2023-09-14T21:17:34.919] [172.16.220.10][omm] create file cluster_manual_start
INFO[2023-09-14T21:17:34.991] [172.16.220.10][omm] generate cluster_static_config file
INFO[2023-09-14T21:17:35.068] [172.16.220.10][omm] change /mogdb/app/bin/cluster_static_config owner to omm
INFO[2023-09-14T21:17:35.139] [172.16.220.10][omm] make user omm's dir(s): /mogdb/data
INFO[2023-09-14T21:17:35.361] [172.16.220.10][omm] change /mogdb/data owner to omm
INFO[2023-09-14T21:17:35.437] [172.16.220.10][omm] the database is initializing, please wait a few minutes
INFO[2023-09-14T21:18:08.692] [172.16.220.30][omm] config postgresql.conf
INFO[2023-09-14T21:18:08.694] [172.16.220.20][omm] config postgresql.conf
INFO[2023-09-14T21:18:09.059] [172.16.220.30][omm] config pg_hba.conf
INFO[2023-09-14T21:18:09.173] [172.16.220.20][omm] config pg_hba.conf
INFO[2023-09-14T21:18:26.141] [172.16.220.10][omm] config postgresql.conf
INFO[2023-09-14T21:18:26.229] [172.16.220.10][omm] config pg_hba.conf
INFO[2023-09-14T21:18:26.333] setup db success
INFO[2023-09-14T21:18:26.333] generate certification files
INFO[2023-09-14T21:18:27.037] download certification files
INFO[2023-09-14T21:18:27.971] upload certification files to omm@172.16.220.20
INFO[2023-09-14T21:18:29.066] upload certification files to omm@172.16.220.30
INFO[2023-09-14T21:18:30.178] certification files setup success
INFO[2023-09-14T21:18:30.178] genetate ptkc ...
INFO[2023-09-14T21:18:30.745] start build ssh trust ...
INFO[2023-09-14T21:18:31.709] ssh trust build success
INFO[2023-09-14T21:18:31.710] start launch db ...
INFO[2023-09-14T21:18:31.710] [172.16.220.10][omm] start db using gs_ctl ...
INFO[2023-09-14T21:18:31.710] [172.16.220.10][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T21:18:31.710] [172.16.220.30][omm] start db using gs_ctl ...
INFO[2023-09-14T21:18:31.710] [172.16.220.20][omm] start db using gs_ctl ...
INFO[2023-09-14T21:18:31.710] [172.16.220.30][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T21:18:31.710] [172.16.220.20][omm] the database is starting, please wait a few minutes
INFO[2023-09-14T21:18:32.867] [172.16.220.30][omm] start db success
INFO[2023-09-14T21:18:36.279] [172.16.220.20][omm] start db success
INFO[2023-09-14T21:18:37.369] [172.16.220.10][omm] start db success
INFO[2023-09-14T21:18:38.370] [172.16.220.10][omm] start alter db initial password ...
INFO[2023-09-14T21:18:38.608] [172.16.220.10][omm] alter db password success
INFO[2023-09-14T21:18:38.608] build standbys ...
INFO[2023-09-14T21:18:38.608] [172.16.220.20][omm] start build db ...
INFO[2023-09-14T21:18:38.608] [172.16.220.20][omm] the database is building from upstream, please wait a few minutes
INFO[2023-09-14T21:18:49.702] [172.16.220.20][omm] build db success
INFO[2023-09-14T21:18:49.703] standbys build success
INFO[2023-09-14T21:18:49.703] build cascade standbys ...
INFO[2023-09-14T21:18:49.703] [172.16.220.30][omm] start build db ...
INFO[2023-09-14T21:18:49.703] [172.16.220.30][omm] the database is building from upstream, please wait a few minutes
INFO[2023-09-14T21:18:58.990] [172.16.220.30][omm] build db success
INFO[2023-09-14T21:18:58.990] cascade standbys build success
INFO[2023-09-14T21:18:58.990] launch db success
INFO[2023-09-14T21:18:58.990] clear temp dirs ...
INFO[2023-09-14T21:18:59.509] clear temp dirs success
INFO[2023-09-14T21:18:59.509] time elapsed: 2m49s
cluste_name | host | user | port | status | message
--------------+---------------+------+-------+---------------+----------
mog | 172.16.220.10 | omm | 26000 | start_success | success
| 172.16.220.30 | omm | 26000 | start_success | success
| 172.16.220.20 | omm | 26000 | start_success | success
十、总结
- 1、选对操作系统和python版本及安装包很重要。使用Euler20.03因为python版本问题报错很多，同时给ptk本身也报错很多。可能ptk也会以来一部分操作系统问题。使用oracle linux 8时ptk不存在报错。omm用户创建及/mogdb安装路径可以自动创建。但是在Euler 20.03中/mogdb目录无法自动创建，手工创建后需要给777权限才行。
- 2、oracle linux8默认不存在python，手工使用yum安装python36即可。
- 3、oracle linux使用–pkg指定MogDB-5.0.1-CentOS-x86_64-all.tar.gz竟然会报错
[exited status: 1] Command: "bash -c \". ~/.ptk_mogdb_env && /mogdb/app/bin/gs_initdb --nodename dn_6001_6002_6003 --no-locale --encoding=UTF-8 -D /mogdb/data --pwpasswd *** ": no data was returned by command ""/mogdb/app/bin/mogdb" -V"
取消参数–pkg自动下载为Kylin_x86_64/MogDB-5.0.1-Kylin-x86_64-all.tar.gz 可以正常安装。一路不存在报错
最后修改时间：2023-09-14 21:35:13
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
