[step 1]: check parameter
[step 2]: check install env and os setting
[step 3]: change_gausshome_owner
[step 4]: set environment variables
[step 6]: init datanode
The files belonging to this database system will be owned by user "gzzy".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
creating directory /home/gzzy/hyj/openGuass/data/single_node ... ok
creating subdirectories ... in ordinary occasionok
creating configuration files ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1024MB
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
creating template1 database in /home/gzzy/hyj/openGuass/data/single_node/base/1 ... The core dump path is an invalid directory
2024-10-23 20:37:43.006 [unknown] [unknown] localhost 547999854608 0[0:0#0] [BACKEND] WARNING: macAddr is 21586/2226656969, sysidentifier is 1414694072/382297633, randomNum is 3190646305
ok
initializing pg_authid ... ok
setting password ... ok
initializing dependencies ... ok
loading PL/pgSQL server-side language ... ok
creating system views ... ok
creating performance views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
initialize global configure for bucketmap length ... ok
creating information schema ... ok
loading foreign-data wrapper for distfs access ... ok
loading foreign-data wrapper for log access ... ok
loading hstore extension ... ok
loading foreign-data wrapper for MOT access ... ok
loading security plugin ... ok
update system tables ... ok
creating snapshots catalog ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
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:
gaussdb -D /home/gzzy/hyj/openGuass/data/single_node --single_node
or
gs_ctl start -D /home/gzzy/hyj/openGuass/data/single_node -Z single_node -l logfile
[step 7]: start datanode
[2024-10-23 20:37:56.007][11032][][gs_ctl]: gs_ctl started,datadir is /home/gzzy/hyj/openGuass/data/single_node
[2024-10-23 20:37:56.029][11032][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: gzzy-UOSPC
0 LOG: [Alarm Module]Host IP: gzzy-UOSPC. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
0 LOG: [Alarm Module]Cluster Name: dbCluster
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
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 is an invalid directory
2024-10-23 20:37:56.088 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton.
2024-10-23 20:37:56.088 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: base_page_saved_interval is 400, ori is 400.
gaussdb.state does not exist, and skipt setting since it is optional.2024-10-23 20:37:56.097 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2024-10-23 20:37:56.097 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: gzzy-UOSPC
2024-10-23 20:37:56.097 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: gzzy-UOSPC. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
2024-10-23 20:37:56.098 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster
2024-10-23 20:37:56.098 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
2024-10-23 20:37:56.103 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin"
2024-10-23 20:37:56.104 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-10-23 20:37:56.104 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-10-23 20:37:56.108 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2024-10-23 20:37:56.108 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB
2024-10-23 20:37:56.108 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB
2024-10-23 20:37:56.108 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 8084 MB
2024-10-23 20:37:56.108 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: shared memory 3343 Mbytes, memory context 8432 Mbytes, max process memory 12288 Mbytes
2024-10-23 20:37:56.196 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184)
2024-10-23 20:37:56.233 [unknown] [unknown] localhost 548125310992 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
2024-10-23 20:37:56.264 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/home/gzzy/hyj/openGuass/data/single_node/gaussdb.state.temp" success
2024-10-23 20:37:56.264 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2024-10-23 20:37:56.330 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 971, usable_fds = 1000, already_open = 19
The core dump path is an invalid directory
2024-10-23 20:37:56.332 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created.
2024-10-23 20:37:56.337 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: the configure file /home/gzzy/hyj/openGuass/etc/gscgroup_gzzy.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2024-10-23 20:37:56.338 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file.
2024-10-23 20:37:56.362 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!
2024-10-23 20:37:56.362 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A
2024-10-23 20:37:56.362 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.
2024-10-23 20:37:56.362 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG!
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value.
2024-10-23 20:37:56.363 [unknown] [unknown] localhost 548125310992 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details.
[2024-10-23 20:37:57.030][11032][][gs_ctl]: waitpid 11036 failed, exitstatus is 256, ret is 2
[2024-10-23 20:37:57.030][11032][][gs_ctl]: stopped waiting
[2024-10-23 20:37:57.030][11032][][gs_ctl]: could not start server
Examine the log output.
import sql file
Would you like to create a demo database (yes/no)? yes
Load demoDB failed, you can check load.log for more details.
