从源码解析MogDB/openGauss容器制作教程(三)

本文涉及的产品
容器服务 Serverless 版 ACK Serverless,952元额度 多规格
容器服务 Serverless 版 ACK Serverless,317元额度 多规格
容器镜像服务 ACR,镜像仓库100个 不限时长
简介: 从源码解析MogDB/openGauss容器制作教程

二、容器打包

1. 下载安装包

[root@ecs-lee 3.0.1]# wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/MogDB-3.0.1-CentOS-x86_64.tar.gz  ^C
[root@ecs-lee 3.0.1]# tar -xf MogDB-3.0.1-CentOS-64bit.tar.gz

2. 打包

[root@ecs-lee enmotech-docker-mogdb]# ls
1.0.0  1.0.1  1.1.0  2.0.0  2.0.1  2.0.3  2.1.0  2.1.1  3.0.0  3.0.1  buildDockerImage.sh  create_master_slave.sh  LICENSE  origin-opengauss-text.png  README.md
[root@ecs-lee enmotech-docker-mogdb]# ./buildDockerImage.sh -v 3.0.1 -i
Ignored MD5 checksum.
==========================
DOCKER info:
Client:
 Context:    default
 Debug Mode: false
 Plugins:
  app: Docker App (Docker Inc., v0.9.1-beta3)
  buildx: Docker Buildx (Docker Inc., v0.7.1-docker)
  scan: Docker Scan (Docker Inc., v0.12.0)
Server:
 Containers: 54
  Running: 26
  Paused: 0
  Stopped: 28
 Images: 65
 Server Version: 20.10.12
 Storage Driver: overlay2
  Backing Filesystem: extfs
  Supports d_type: true
  Native Overlay Diff: true
  userxattr: false
 Logging Driver: json-file
 Cgroup Driver: cgroupfs
 Cgroup Version: 1
 Plugins:
  Volume: local
  Network: bridge host ipvlan macvlan null overlay
  Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog
 Swarm: inactive
 Runtimes: io.containerd.runc.v2 io.containerd.runtime.v1.linux runc
 Default Runtime: runc
 Init Binary: docker-init
 containerd version: 7b11cfaabd73bb80907dd23182b9347b4245eb5d
 runc version: v1.0.2-0-g52b36a2
 init version: de40ad0
 Security Options:
  seccomp
   Profile: default
 Kernel Version: 3.10.0-1160.15.2.el7.x86_64
 Operating System: CentOS Linux 7 (Core)
 OSType: linux
 Architecture: x86_64
 CPUs: 4
 Total Memory: 15.51GiB
 Name: ecs-lee
 ID: GYME:4QYA:D4QF:RJOT:FBO3:CGBJ:BWCT:7IMP:3TIU:4TUA:R33L:6W3Z
 Docker Root Dir: /var/lib/docker
 Debug Mode: false
 Username: 15501059069
 Registry: https://index.docker.io/v1/
 Labels:
 Experimental: false
 Insecure Registries:
  127.0.0.0/8
 Registry Mirrors:
  http://hub-mirror.c.163.com/
  https://registry.docker-cn.com/
  https://pee6w651.mirror.aliyuncs.com/
 Live Restore Enabled: false
==========================
Building image 'swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb:3.0.1_amd' ...
Sending build context to Docker daemon  107.2MB
Step 1/15 : FROM ubuntu:18.04 as builder
 ---> dcf4d4bef137
Step 2/15 : RUN set -eux;     apt-get update && apt-get install -y     wget &&     wget https://gitee.com/lee1002/gosu/attach_files/943635/download/gosu-amd64  &&     wget https://cdn-mogdb.enmotech.com/mogdb-media/3.0.1/Plugins-3.0.1-CentOS-x86_64.tar.gz &&     wget https://gitee.com/enmotech/compat-tools/attach_files/1110114/download/compat-tools-v2022.06.28.tar &&     wget https://gitee.com/enmotech/mogila/attach_files/954052/download/mogila-v1.0.0.bz2
 ---> Running in 2c9fa8155580
...
2022-09-09 06:27:40 (139 KB/s) - 'mogila-v1.0.0.bz2' saved [955694/955694]
Removing intermediate container 2c9fa8155580
 ---> aec8dfcb94d4
Step 3/15 : FROM ubuntu:18.04
 ---> dcf4d4bef137
Step 4/15 : ADD  MogDB-3.0.1-CentOS-64bit.tar.gz /usr/local/mogdb
 ---> 3d918fecd300
Step 5/15 : COPY --from=builder /gosu-amd64  /usr/local/bin/gosu
 ---> 31924dad711c
Step 6/15 : COPY --from=builder /Plugins-3.0.1-CentOS-x86_64.tar.gz  /tmp
 ---> 19cf1715733c
Step 7/15 : COPY --from=builder /compat-tools-v2022.06.28.tar  /tmp
 ---> a67c2b892f92
Step 8/15 : COPY --from=builder /mogila-v1.0.0.bz2  /tmp
 ---> 629ed723ad41
Step 9/15 : COPY entrypoint.sh /usr/local/bin/
 ---> e22ac8b04195
Step 10/15 : ENV LANG en_US.utf8
 ---> Running in 449596bdbfc7
Removing intermediate container 449596bdbfc7
 ---> 4bb6adc4abbc
Step 11/15 : ENV PGDATA /var/lib/mogdb/data
 ---> Running in 90f445deb780
Removing intermediate container 90f445deb780
 ---> c64779467abb
Step 12/15 : RUN set -eux;     apt-get update && apt-get install -y     libaio-dev     libkeyutils-dev     libnuma-dev     locales     libreadline-dev     vim      procps &&     rm -rf /var/lib/apt/lists/*;     ln -s /lib/x86_64-linux-gnu/libreadline.so.7 /lib/x86_64-linux-gnu/libreadline.so.6;     groupadd -g 70 omm;      useradd -u 70 -g omm -m -s /bin/bash omm;      mkdir -p /var/lib/mogdb &&     mkdir -p /usr/local/mogdb &&     mkdir -p /var/run/mogdb  &&     mkdir /docker-entrypoint-initdb.d &&     mkdir -p  /usr/local/mogdb/share/postgresql/contrib &&     tar -xf /tmp/compat-tools-v2022.06.28.tar -C /home/omm &&     mv /home/omm/compat-tools-v2022.06.28 /home/omm/compat-tools &&     tar -xf /tmp/mogila-v1.0.0.bz2 -C /home/omm &&     tar -xf /tmp/Plugins-3.0.1-CentOS-x86_64.tar.gz -C /usr/local/mogdb &&     rm -rf /usr/local/mogdb/plugin/postgis &&     rm -f /tmp/compat-tools-v2022.06.28.tar &&     rm -f /tmp/Plugins-3.0.1-CentOS-x86_64.tar.gz &&     rm -f /tmp/mogila-v1.0.0.bz2 &&     chown omm:omm /var/lib/mogdb /home/omm /var/run/mogdb /docker-entrypoint-initdb.d /usr/local/mogdb/ /usr/local/mogdb/lib /usr/local/mogdb/lib/postgresql /usr/local/mogdb/share/postgresql/contrib /usr/local/mogdb/share/postgresql/extension /usr/local/mogdb/bin &&     locale-gen en_US.UTF-8 &&     echo "export GAUSSHOME=/usr/local/mogdb"  >> /home/omm/.bashrc &&     echo "export PATH=\$GAUSSHOME/bin:\$PATH " >> /home/omm/.bashrc &&     echo "export LD_LIBRARY_PATH=\$GAUSSHOME/lib:\$LD_LIBRARY_PATH" >> /home/omm/.bashrc &&     echo "export GAUSSLOG=/var/lib/mogdb/data/pg_log" >> /home/omm/.bashrc &&     echo "export PGDATA=/var/lib/mogdb/data" >> /home/omm/.bashrc &&     echo "\set PROMPT1 'MogDB%R%#'" >> /home/omm/.gsqlrc &&     echo "\set PROMPT2 '#'" >> /home/omm/.gsqlrc &&     echo "\set PROMPT3 '>'" >> /home/omm/.gsqlrc &&     chown -R omm:omm /home/omm &&     chmod +x /usr/local/bin/gosu &&     chmod 755 /usr/local/bin/entrypoint.sh /usr/local/mogdb/plugins &&     cp `find /usr/local/mogdb/plugins -name *.so` /usr/local/mogdb/lib/postgresql/ &&     cp `find /usr/local/mogdb/plugins -name "*.control" -or -name "*.sql"` /usr/local/mogdb/share/postgresql/extension/ &&     cp `find /usr/local/mogdb/plugins -name pg_repack -type f -or -name pg_bulkload -type f -or -name postgresql` /usr/local/mogdb/bin/ &&     cp `find /usr/local/mogdb/plugins -name pg_timestamp.sql -or -name uninstall_pg_timestamp.sql` /usr/local/mogdb/share/postgresql/contrib/ &&     rm -rf /usr/local/mogdb/plugins &&     chmod 755 /usr/local/mogdb/lib/postgresql/* /usr/local/mogdb/share/postgresql/extension/* /usr/local/mogdb/bin/pg_repack /usr/local/mogdb/share/postgresql/contrib/pg_timestamp.sql &&     ln -s /usr/local/bin/entrypoint.sh /
 ---> Running in a323b79e8ad3
...
Removing intermediate container a323b79e8ad3
 ---> f55ce41f7e90
Step 13/15 : ENTRYPOINT ["entrypoint.sh"]
 ---> Running in cf2e22f83941
Removing intermediate container cf2e22f83941
 ---> 12272e02e627
Step 14/15 : EXPOSE 5432
 ---> Running in 6effe6ad1ee8
Removing intermediate container 6effe6ad1ee8
 ---> 969e80e978c1
Step 15/15 : CMD ["mogdb"]
 ---> Running in cdf7bc12e544
Removing intermediate container cdf7bc12e544
 ---> 98be66283571
Successfully built 98be66283571
Successfully tagged swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb:3.0.1_amd
  MogDB Docker Image  3.0.1 is ready to be extended:
    --> swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb:3.0.1_amd
  Build completed in 180 seconds.

三、容器验证

[root@ecs-lee enmotech-docker-mogdb]# docker image ls 
REPOSITORY                                      TAG     IMAGE ID     CREATED SIZE 
swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb 3.0.1_amd 2a74132455e2 36 seconds ago 727MB 
[root@ecs-lee enmotech-docker-mogdb]# docker image ls 
REPOSITORY                                      TAG     IMAGE ID     CREATED SIZE 
swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb 3.0.1_amd 2a74132455e2 36 seconds ago 727MB 
[root@ecs-lee enmotech-docker-mogdb]# docker run --name mogdb --privileged=true -d swr.cn-north-4.myhuaweicloud.com/mogdb/mogdb:3.0.1_amd 12b8ed3e37e874bde7c0df5c247e43dda0eb1b72a13e247aa4d70f533fed9670 
[root@ecs-lee 3.0.1]# docker logs -f mogdb
                        Message: The supplied GS_PASSWORD is meet requirements.
The files belonging to this database system will be owned by user "omm".
This user must also own the server process.
The database cluster will be initialized with locale "C".
The default text search configuration will be set to "english".
fixing permissions on existing directory /var/lib/mogdb/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
creating template1 database in /var/lib/mogdb/data/base/1 ... The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
2022-09-08 02:56:56.938 [unknown] [unknown] localhost 139708980549824 0[0:0#0]  [BACKEND] WARNING:  macAddr is 578/2886795268, sysidentifier is 37923857/284257, randomNum is 3140245089
ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
initializing pg_authid ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
setting password ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
initializing dependencies ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading PL/pgSQL server-side language ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating system views ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating performance views ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading system objects' descriptions ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating collations ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating conversions ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating dictionaries ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
setting privileges on built-in objects ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
initialize global configure for bucketmap length ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating information schema ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading foreign-data wrapper for distfs access ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading foreign-data wrapper for hdfs access ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading foreign-data wrapper for log access ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading hstore extension ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading foreign-data wrapper for MOT access ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
loading security plugin ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
update system tables ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
creating snapshots catalog ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
vacuuming database template1 ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
copying template1 to template0 ... ok
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
copying template1 to postgres ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run gs_initdb.
Success. You can now start the database server of single node using:
    mogdb -D /var/lib/mogdb/data --single_node
or
    gs_ctl start -D /var/lib/mogdb/data -Z single_node -l logfile
[2022-09-08 02:57:11.586][182][][gs_ctl]: gs_ctl started,datadir is /var/lib/mogdb/data
[2022-09-08 02:57:11.653][182][][gs_ctl]: waiting for server to start...
.0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG:  [Alarm Module]Host Name: 12b8ed3e37e8
0 LOG:  [Alarm Module]Host IP: 172.17.0.4
0 LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!
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:/opt/mogdb/corefile/
2022-09-08 02:57:11.792 [unknown] [unknown] localhost 139814390462656 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.2022-09-08 02:57:11.799 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2022-09-08 02:57:11.799 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: 12b8ed3e37e8
2022-09-08 02:57:11.799 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: 172.17.0.4
2022-09-08 02:57:11.799 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!
2022-09-08 02:57:11.804 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2022-09-08 02:57:11.804 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-09-08 02:57:11.804 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] WARNING:  No explicit IP is configured for listen_addresses GUC.
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 11064 MB
2022-09-08 02:57:11.810 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2022-09-08 02:57:11.838 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2022-09-08 02:57:11.855 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [CACHE] LOG:  set metadata cache  size(134217728)
2022-09-08 02:57:11.894 [unknown] [unknown] localhost 139814390462656 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
2022-09-08 02:57:11.926 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  mogdb: fsync file "/var/lib/mogdb/data/gaussdb.state.temp" success
2022-09-08 02:57:11.926 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2022-09-08 02:57:11.958 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 978, usable_fds = 1000, already_open = 12
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
2022-09-08 02:57:11.960 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  user configure file is not found, it will be created.
2022-09-08 02:57:11.965 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  the configure file /usr/local/mogdb/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2022-09-08 02:57:11.965 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2022-09-08 02:57:11.988 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2022-09-08 02:57:11.988 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2022-09-08 02:57:11.988 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2022-09-08 02:57:11.988 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2022-09-08 02:57:11.989 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2022-09-08 02:57:11.989 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2022-09-08 02:57:11.989 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2022-09-08 02:57:11.989 [unknown] [unknown] localhost 139814390462656 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
[2022-09-08 02:57:12.657][182][][gs_ctl]:  done
[2022-09-08 02:57:12.657][182][][gs_ctl]: server started (/var/lib/mogdb/data)
 default user is mogdb
 default no repuser created
Execute SQL: gsql -v ON_ERROR_STOP=1 --username omm --dbname postgres
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
Execute SQL: gsql -v ON_ERROR_STOP=1 --username omm --dbname postgres
gsql:runMe.sql:152: NOTICE:
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:  -- Compat Object List:
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:     | type      | name                                                                        | version | language        | operation                        |
gsql:runMe.sql:152: NOTICE:     |-----------|-----------------------------------------------------------------------------|---------|-----------------|----------------------------------|
gsql:runMe.sql:152: NOTICE:     | function  | compat_tools.mg_sequence()                                                  | 1.0     |                 | Initial creation                 |
gsql:runMe.sql:152: NOTICE:     | view      | compat_tools.dba_sequences                                                  | 2.0     |                 | Initial creation                 |
creation                 |
gsql:runMe.sql:152: NOTICE:     | function  | pg_catalog.digits(numeric)                                                  | 1.0     | sql             | Initial creation                 |
gsql:runMe.sql:152: NOTICE:
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:  -- Test Summary:
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:     | result_type | case_count | start_time          | complete_time       |
gsql:runMe.sql:152: NOTICE:     |-------------|------------|---------------------|---------------------|
gsql:runMe.sql:152: NOTICE:     | PASSED      |        521 | 2022-09-08 02:57:13 | 2022-09-08 02:57:15 |
gsql:runMe.sql:152: NOTICE:
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:  -- Test Detail (Failed or Null):
gsql:runMe.sql:152: NOTICE:  -- =====================================================================
gsql:runMe.sql:152: NOTICE:  -- <<< ALL SUCCEED >>>
Execute SQL: gsql -v ON_ERROR_STOP=1 --username omm --dbname postgres --set passwd=Enmo@123
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
CREATE DATABASE
CREATE DATABASE
ALTER ROLE
ALTER ROLE
GS_DB = omm
Execute SQL: gsql -v ON_ERROR_STOP=1 --username omm --dbname postgres --dbname mogila
gsql:mogila-insert-data.sql:47673: WARNING:  Trigger function with non-plpgsql type is not recommended.
DETAIL:  Non-plpgsql trigger function are not shippable by default.
HINT:  Unshippable trigger may lead to bad performance.
Execute SQL: gsql -v ON_ERROR_STOP=1 --username omm --dbname postgres
 slotname | xlog_position
----------+---------------
 wal2json | 0/40E5998
(1 row)
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
ALTER TABLE
/usr/local/bin/entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
[2022-09-08 02:57:56.882][296][][gs_ctl]: gs_ctl stopped ,datadir is /var/lib/mogdb/data
waiting for server to shut down........... done
server stopped
MogDB  init process complete; ready for start up.
0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG:  [Alarm Module]Host Name: 12b8ed3e37e8
0 LOG:  [Alarm Module]Host IP: 172.17.0.4
0 LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!
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:/opt/mogdb/corefile/
2022-09-08 02:58:05.040 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
2022-09-08 02:58:05.046 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2022-09-08 02:58:05.046 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: 12b8ed3e37e8
2022-09-08 02:58:05.046 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: 172.17.0.4
2022-09-08 02:58:05.046 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!
2022-09-08 02:58:05.050 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2022-09-08 02:58:05.050 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-09-08 02:58:05.050 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] WARNING:  No explicit IP is configured for listen_addresses GUC.
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 11064 MB
2022-09-08 02:58:05.056 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  shared memory 363 Mbytes, memory context 11412 Mbytes, max process memory 12288 Mbytes
2022-09-08 02:58:05.084 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2022-09-08 02:58:05.101 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [CACHE] LOG:  set metadata cache  size(134217728)
2022-09-08 02:58:05.139 [unknown] [unknown] localhost 140198371371200 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
2022-09-08 02:58:05.172 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  mogdb: fsync file "/var/lib/mogdb/data/gaussdb.state.temp" success
2022-09-08 02:58:05.172 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2022-09-08 02:58:05.192 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 977, usable_fds = 1000, already_open = 13
The core dump path from /proc/sys/kernel/core_pattern is an invalid directory:/opt/mogdb/corefile/
2022-09-08 02:58:05.195 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  the configure file /usr/local/mogdb/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2022-09-08 02:58:05.195 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2022-09-08 02:58:05.219 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2022-09-08 02:58:05.219 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2022-09-08 02:58:05.219 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2022-09-08 02:58:05.219 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2022-09-08 02:58:05.220 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2022-09-08 02:58:05.220 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2022-09-08 02:58:05.220 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2022-09-08 02:58:05.220 [unknown] [unknown] localhost 140198371371200 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
[root@ecs-lee 3.0.1]# docker exec -it mogdb bash
root@12b8ed3e37e8:/# su - omm
omm@12b8ed3e37e8:~$ gsql -d postgres -p5432 -r
gsql ((MogDB 3.0.1 build 1a363ea9) compiled at 2022-08-05 17:31:04 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
MogDB=#select version();
                                                                     version
--------------------------------------------------------------------------------------------------------------------------------------------------
 (MogDB 3.0.1 build 1a363ea9) compiled at 2022-08-05 17:31:04 commit 0 last mr   on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
MogDB=#


目录
相关文章
|
22天前
|
监控 网络协议 Java
Tomcat源码解析】整体架构组成及核心组件
Tomcat,原名Catalina,是一款优雅轻盈的Web服务器,自4.x版本起扩展了JSP、EL等功能,超越了单纯的Servlet容器范畴。Servlet是Sun公司为Java编程Web应用制定的规范,Tomcat作为Servlet容器,负责构建Request与Response对象,并执行业务逻辑。
Tomcat源码解析】整体架构组成及核心组件
|
6天前
|
存储 缓存 Java
什么是线程池?从底层源码入手,深度解析线程池的工作原理
本文从底层源码入手,深度解析ThreadPoolExecutor底层源码,包括其核心字段、内部类和重要方法,另外对Executors工具类下的四种自带线程池源码进行解释。 阅读本文后,可以对线程池的工作原理、七大参数、生命周期、拒绝策略等内容拥有更深入的认识。
什么是线程池?从底层源码入手,深度解析线程池的工作原理
|
10天前
|
开发工具
Flutter-AnimatedWidget组件源码解析
Flutter-AnimatedWidget组件源码解析
|
6天前
|
设计模式 Java 关系型数据库
【Java笔记+踩坑汇总】Java基础+JavaWeb+SSM+SpringBoot+SpringCloud+瑞吉外卖/谷粒商城/学成在线+设计模式+面试题汇总+性能调优/架构设计+源码解析
本文是“Java学习路线”专栏的导航文章,目标是为Java初学者和初中高级工程师提供一套完整的Java学习路线。
|
20天前
|
图形学 数据可视化 开发者
超实用Unity Shader Graph教程:从零开始打造令人惊叹的游戏视觉特效,让你的作品瞬间高大上,附带示例代码与详细步骤解析!
【8月更文挑战第31天】Unity Shader Graph 是 Unity 引擎中的强大工具,通过可视化编程帮助开发者轻松创建复杂且炫酷的视觉效果。本文将指导你使用 Shader Graph 实现三种效果:彩虹色渐变着色器、动态光效和水波纹效果。首先确保安装最新版 Unity 并启用 Shader Graph。创建新材质和着色器图谱后,利用节点库中的预定义节点,在编辑区连接节点定义着色器行为。
71 0
|
29天前
|
测试技术 Python
python自动化测试中装饰器@ddt与@data源码深入解析
综上所述,使用 `@ddt`和 `@data`可以大大简化写作测试用例的过程,让我们能专注于测试逻辑的本身,而无需编写重复的测试方法。通过讲解了 `@ddt`和 `@data`源码的关键部分,我们可以更深入地理解其背后的工作原理。
24 1
|
20天前
|
Java Spring
🔥JSF 与 Spring 强强联手:打造高效、灵活的 Web 应用新标杆!💪 你还不知道吗?
【8月更文挑战第31天】JavaServer Faces(JSF)与 Spring 框架是常用的 Java Web 技术。本文介绍如何整合两者,发挥各自优势,构建高效灵活的 Web 应用。首先通过 `web.xml` 和 `ContextLoaderListener` 配置 Spring 上下文,在 `applicationContext.xml` 定义 Bean。接着使用 `@Autowired` 将 Spring 管理的 Bean 注入到 JSF 管理的 Bean 中。
30 0
|
20天前
|
JavaScript 前端开发 开发者
深入解析Angular装饰器:揭秘框架核心机制与应用——从基础用法到内部原理的全面教程
【8月更文挑战第31天】本文深入解析了Angular框架中的装饰器特性,包括其基本概念、使用方法及内部机制。装饰器作为TypeScript的关键特性,在Angular中用于定义组件、服务等。通过具体示例介绍了`@Component`和`@Injectable`装饰器的应用,展示了如何利用装饰器优化代码结构与依赖注入,帮助开发者构建高效、可维护的应用。
21 0
|
25天前
|
存储
Cmake官方教程解析
Cmake官方教程解析
30 0
|
27天前
|
监控 API 开发者
深入解析Docker容器的生命周期
【8月更文挑战第24天】
13 0

推荐镜像

更多