安装报错[gauss-51615]欧拉、麒麟、等系统一样的报错。CPU型号FT2000

CREATE OR REPLACE FUNCTION WC.dsc_trg_wc_t_index_reportoniom_wc_t_index_reportoniom_1d() RETURN TRIGGER ASBEGINselect SEQ_WC_T_INDEX_REPORTONIOM.nextval into new.OID from dual;IF ((TG_OP = 'INSERT') OR (TG_OP = 'UPDATE')) THEN RETURN NEW; ELSE RETURN OLD; END IF; END;DROP TRIGGER if exists TRG_WC_T_INDEX_REPORTONIOM on WC.WC_T_INDEX_REPORTONIOM;CREATE TRIGGER TRG_WC_T_INDEX_REPORTONIOM BEFORE INSERT ON WC.WC_T_INDEX_REPORTONIOM FOR EACH ROW EXECUTE PROCEDURE WC.dsc_trg_wc_t_index_reportoniom_wc_t_index_reportoniom_1d();上面是Oracle12C语句，之前报错dual表找不到，查了一下，gauss要自己建立类似的create or replace view dual as select NULL::“unknown” where 1=1;alter table dual owner to 连接用户名;grant all on table dual to 连接用户名;grant select on table dual to public;然后不报找不到dual错了，在手动迁移数据时创建报错[ERR] 1> ERROR: missing FROM-clause entry for table "seq_wc_t_index_reportoniom" LINE 1: INSERT INTO "wc"."wc_t_index_reportoniom" ("eventid", "oid",... ^ CONTEXT: referenced column: nextval是用navicat16.3.9从oracle12c数据传输迁移gaussdb3.2分布式版，先手动建表结构，再迁移数据，别的全都成功了，这个请教大神是哪的问题，怎么改？

求解，发现GaussDB有好多版本，有没有官方解释各个版本有什么区别有什么关系。

oracle的"CONSTRAINT "CK_AZ_ITF_DATA_PARTITION" CHECK (ITF_DATA IS JSON(STRICT)) ENABLE"在gaussdb集中式中如何实现同等转换， json(strict) 这个在gaussdb中不支持，在gaussdb是用函数替代吗。类似如下：1. 创建一个检查 JSON 格式的函数: CREATE OR REPLACE FUNCTION is_json(p_data TEXT) RETURNS BOOLEAN AS $$ BEGIN     -- 尝试将输入的数据解析为 JSON     EXECUTE 'SELECT CAST(' || quote_literal(p_data) || ' AS JSON);';     RETURN TRUE; EXCEPTION WHEN others THEN     RETURN FALSE; END; $$ LANGUAGE plpgsql; 2. 使用该函数创建 CHECK 约束: ALTER TABLE your_table_name ADD CONSTRAINT CK_AZ_ITF_DATA_PARTITION CHECK (is_json(ITF_DATA)); 问题：我这个函数和oracle那个json（strict）是完全等价的吗，如果不符合要求，应该怎样解决呢

在执行一个查询语句中，包含case语句，是以前oracle的sql，迁移到高斯执行报错：SELECT CASE WHEN dep_start_date > '2024-11-01 00:00:00' THEN ( to_date( dep_start_date, 'yyyy-mm-dd' ) - to_date( '2024-11-30 23:59:59', 'yyyy-mm-dd' ) + 0 ) + 1 ELSE 30 END days_calFROM fa_cardhistory;报错信息：

版本信息数据库版本：GaussDB 24.1.31.10问题现象通过 TPOPS 部署 GaussDB 主备版，2节点。提示：DBS.280240：所选规格不存在。请问这个是什么规格？

[2024-11-08 14:55:03.779026][2112074][gs_install][DEBUG]:The /data/huawei/tmp/install_step/install_step.dat does not exits.[2024-11-08 14:55:03.779169][2112074][gs_install][DEBUG]:gs_install execution takes 7 steps in total[2024-11-08 14:55:03.779264][2112074][gs_install(initGlobals:112)][gs_install][LOG][Step1]:Parsing the configuration file.[2024-11-08 14:55:03.883092][2112074][gs_install(initGlobals:128)][gs_install][DEBUG][Step1]:Successfully parsed the configuration file.[2024-11-08 14:55:03.964952][2112074][gs_install][LOG]:Successfully checked gs_uninstall on every node.[2024-11-08 14:55:03.966058][2112074][gs_install][DEBUG]:{'localhost.localdomain': 6001}[2024-11-08 14:55:03.966161][2112074][InstallImpl.py(checkGaussenvFlag:218)][gs_install][LOG][Step2]:Check preinstall on every node.[2024-11-08 14:55:04.134942][2112074][InstallImpl.py(checkGaussenvFlag:221)][gs_install][LOG][Step2]:Successfully checked preinstall on every node.[2024-11-08 14:55:04.135140][2112074][InstallImplOLAP.py(checkClusterStatus:584)][gs_install][DEBUG][Step3]:Checking the cluster status.[2024-11-08 14:55:04.339370][2112074][InstallImplOLAP.py(checkClusterStatus:591)][gs_install][DEBUG][Step3]:Successfully checked the cluster status.[2024-11-08 14:55:04.339598][2112074][InstallImpl.py(prepareBackDir:253)][gs_install][LOG][Step4]:Creating the backup directory.[2024-11-08 14:55:04.345916][2112074][InstallImpl.py(prepareBackDir:265)][gs_install][LOG][Step4]:Successfully created the backup directory.[2024-11-08 14:55:04.346082][2112074][gs_install][LOG]:begin deploy..[2024-11-08 14:55:04.346167][2112074][gs_install][DEBUG]:Installing application[2024-11-08 14:55:04.430154][2112074][gs_install][DEBUG]:The /data/huawei/tmp/install_step/install_step.dat does not exits.[2024-11-08 14:55:04.430296][2112074][gs_install][DEBUG]:The /data/huawei/tmp/install_step/install_step.dat does not exits.[2024-11-08 14:55:04.438140][2112074][InstallImpl.py(doInstall:439)][gs_install][LOG][Step5]:Installing the cluster.[2024-11-08 14:55:04.438331][2112074][InstallImplOLAP.py(checkNodeInstall:167)][gs_install][DEBUG][Step5]:Checking node's installation.[2024-11-08 14:55:04.438421][2112074][InstallImplOLAP.py(checkNodeInstall:169)][gs_install][LOG][Step5]:Checking the installation environment on all nodes.[2024-11-08 14:55:04.438971][2112074][gs_install][DEBUG]:Command for checking installation: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/CheckInstall.py' -U omm:dbgrp -R /data/huawei/install/app -l /data/huawei/log/omm/omm/om/gs_local.log -X /data/software/openGauss60/cluster_config.xml.[2024-11-08 14:55:09.776087][2112074][InstallImplOLAP.py(checkNodeInstall:186)][gs_install][DEBUG][Step5]:Successfully checked node's installation.[2024-11-08 14:55:09.776306][2112074][gs_install][LOG]:begin install Cluster..[2024-11-08 14:55:09.776411][2112074][gs_install][LOG]:Installing applications on all nodes.[2024-11-08 14:55:09.777045][2112074][gs_install][DEBUG]:Command for installing application: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/Install.py' -t install_cluster -U omm:dbgrp -X /data/software/openGauss60/cluster_config.xml -R /data/huawei/install/app -c dbCluster -l /data/huawei/log/omm/omm/om/gs_local.log --alarm=/opt/huawei/snas/bin/snas_cm_cmd --time_out=300[2024-11-08 14:55:27.702419][2112074][gs_install][LOG]:Successfully installed APP.[2024-11-08 14:55:27.702631][2112074][gs_install][LOG]:begin init Instance..[2024-11-08 14:55:27.702723][2112074][gs_install][LOG]:encrypt cipher and rand files for database.[2024-11-08 14:55:27.702828][2112074][gs_install][DEBUG]:Encrypting cipher and rand files.[2024-11-08 14:56:36.898105][2112074][gs_install][DEBUG]:Successfully encrypted cipher and rand files.[2024-11-08 14:56:36.898323][2112074][gs_install][LOG]:begin to create CA cert files[2024-11-08 14:56:36.898430][2112074][gs_install][DEBUG]:Generating CA files.[2024-11-08 14:56:36.986110][2112074][gs_install][DEBUG]:The ca file dir is: /data/huawei/install/app/share/sslcert/om.[2024-11-08 14:56:36.986246][2112074][gs_install][DEBUG]:Create CA file directory.[2024-11-08 14:56:57.301114][2112074][gs_install][DEBUG]:Add hostname to config file.[2024-11-08 14:56:57.301274][2112074][gs_install][LOG]:The sslcert will be generated in /data/huawei/install/app/share/sslcert/om[2024-11-08 14:56:57.818703][2112074][gs_install][DEBUG]:Scp CA files to all nodes.[2024-11-08 14:56:57.818853][2112074][gs_install][DEBUG]:Successfully generated server CA files.[2024-11-08 14:56:57.819002][2112074][gs_install][LOG]:NO cm_server instance, no need to create CA for CM.[2024-11-08 14:56:57.819103][2112074][gs_install][LOG]:Non-dss_ssl_enable, no need to create CA for DSS[2024-11-08 14:56:57.819183][2112074][gs_install][DEBUG]:Start check grpc.conf file.[2024-11-08 14:56:57.819411][2112074][gs_install][DEBUG]:Does not exist openssl.cnf file [/data/huawei/install/app_aee4abd5/share/sslcert/grpc/openssl.cnf].[2024-11-08 14:56:57.819518][2112074][InstallImpl.py(doInstall:472)][gs_install][LOG][Step5]:Cluster installation is completed.[2024-11-08 14:56:57.827814][2112074][InstallImpl.py(doConfig:567)][gs_install][LOG][Step6]:Configuring.[2024-11-08 14:56:57.828007][2112074][gs_install][LOG]:Deleting instances from all nodes.[2024-11-08 14:56:59.231885][2112074][gs_install][LOG]:Successfully deleted instances from all nodes.[2024-11-08 14:56:59.232093][2112074][gs_install][DEBUG]:The mode is non-dss, no need to clear the disk.[2024-11-08 14:56:59.232181][2112074][gs_install][DEBUG]:The mode is non-dss, no need to create the dss vg.[2024-11-08 14:56:59.232269][2112074][gs_install][LOG]:Checking node configuration on all nodes.[2024-11-08 14:56:59.232898][2112074][gs_install][DEBUG]:Command for checking node configuration: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/CheckConfig.py' -U omm -l /data/huawei/log/omm/omm/om/gs_local.log .[2024-11-08 14:57:00.986324][2112074][gs_install][DEBUG]:Successfully checked node configuration.[2024-11-08 14:57:00.986573][2112074][gs_install][LOG]:Initializing instances on all nodes.[2024-11-08 14:57:00.987588][2112074][gs_install][DEBUG]:Command for initializing instances: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/InitInstance.py' -U omm -P *** -l /data/huawei/log/omm/omm/om/gs_local.log[2024-11-08 14:57:30.080081][2112074][gs_install][DEBUG]:Successfully initialized node instance.[2024-11-08 14:57:30.080329][2112074][gs_install][LOG]:Updating instance configuration on all nodes.[2024-11-08 14:57:30.080438][2112074][gs_install][DEBUG]:create tmp_guc file.[2024-11-08 14:57:30.298239][2112074][gs_install][DEBUG]:Create tmp_guc file successfully.[2024-11-08 14:57:30.298442][2112074][gs_install][DEBUG]:get master datanode number : 1[2024-11-08 14:57:30.302815][2112074][gs_install][DEBUG]:get physic memory value : 15.09597396850586[2024-11-08 14:57:30.302939][2112074][gs_install][DEBUG]:get min datanode number : 1[2024-11-08 14:57:30.303010][2112074][gs_install][DEBUG]:Write value in tmp_guc file.[2024-11-08 14:57:30.309189][2112074][gs_install][DEBUG]:Write tmp_guc file successfully.[2024-11-08 14:57:30.309902][2112074][gs_install][LOG]:Check consistence of memCheck and coresCheck on database nodes.[2024-11-08 14:57:30.309994][2112074][gs_install][DEBUG]:Check whether the memory and CPU cores of database nodes meet the requirements.[2024-11-08 14:57:30.310071][2112074][gs_install][DEBUG]:If all database nodes meet follows :[2024-11-08 14:57:30.310145][2112074][gs_install][DEBUG]:memory=128G and CPU logic_cores=16[2024-11-08 14:57:30.310217][2112074][gs_install][DEBUG]:Then we don't use default guc set xmlFile : guc_list.xml[2024-11-08 14:57:30.310397][2112074][gs_install][DEBUG]:Command for updating instances configuration: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/ConfigInstance.py' Kj09U1lNQk9MPT0qLVUqPT1TWU1CT0w9PSpvbW0qPT1TWU1CT0w9PSotRCo9PVNZTUJPTD09KmF1dG92YWN1dW09b24qPT1TWU1CT0w9PSotLWFsYXJtPS9vcHQvaHVhd2VpL3NuYXMvYmluL3NuYXNfY21fY21kKj09U1lNQk9MPT0qLWwqPT1TWU1CT0w9PSovZGF0YS9odWF3ZWkvbG9nL29tbS9vbW0vb20vZ3NfbG9jYWwubG9nKj09U1lNQk9MPT0qLVgqPT1TWU1CT0w9PSovZGF0YS9zb2Z0d2FyZS9vcGVuR2F1c3M2MC9jbHVzdGVyX2NvbmZpZy54bWw=[2024-11-08 14:57:31.258707][2112074][gs_install][DEBUG]:Successfully configured node instance.[2024-11-08 14:57:31.258961][2112074][gs_install][LOG]:Configuring pg_hba on all nodes.[2024-11-08 14:57:31.259501][2112074][gs_install][DEBUG]:Command for configuring Hba instance: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/ConfigHba.py' -U omm -X '/data/software/openGauss60/cluster_config.xml' -l '/data/huawei/log/omm/omm/om/gs_local.log'[2024-11-08 14:57:31.780642][2112074][gs_install][DEBUG]:Successfully configured HBA.[2024-11-08 14:57:31.780992][2112074][InstallImpl.py(doConfig:583)][gs_install][LOG][Step6]:Configuration is completed.[2024-11-08 14:57:31.793047][2112074][InstallImpl.py(doStart:691)][gs_install][DEBUG][Step7]:Start the cluster.[2024-11-08 14:57:31.936338][2112074][gs_install][DEBUG]:No CM configuration, start cluster with openGauss om.[2024-11-08 14:57:31.937011][2112074][gs_install][DEBUG]:Command for start cluster: source /home/gauss/.bashrc;python3 '/data/huawei/install/om/script/local/Install.py' -t start_cluster -U omm:dbgrp -X /data/software/openGauss60/cluster_config.xml -R /data/huawei/install/app -c dbCluster -l /data/huawei/log/omm/omm/om/gs_local.log --alarm=/opt/huawei/snas/bin/snas_cm_cmd --time_out=300[2024-11-08 14:57:38.435824][2112074][gs_install][ERROR]:Using omm:dbgrp to install database.Using installation program path : /data/huawei/install/app_aee4abd5$GAUSSHOME points to /data/huawei/install/app_aee4abd5, no need to create symbolic link.Traceback (most recent call last):File "/data/huawei/install/om/script/local/Install.py", line 843, infunctionDict[g_opts.action]()File "/data/huawei/install/om/script/local/Install.py", line 774, in startClusterdn.start(self.time_out)File "/data/huawei/install/om/script/local/../gspylib/component/Kernel/Kernel.py", line 105, in startraise Exception(ErrorCode.GAUSS_516["GAUSS_51607"] % "instance"Exception: [GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.[2024-11-08 14:57:32.372][2157478][][gs_ctl]: gs_ctl started,datadir is /data/huawei/install/data/dn[2024-11-08 14:57:32.408][2157478][][gs_ctl]: waiting for server to start....0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.0 LOG: [Alarm Module]Host Name: localhost.localdomain0 LOG: [Alarm Module]Host IP: localhost.localdomain. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain0 LOG: [Alarm Module]Cluster Name: dbCluster0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 580 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.0 LOG: SSE4.2 is not supported, disable codegen.0 LOG: bbox_dump_path is set to /data/huawei/corefile/2024-11-08 14:57:32.470 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: base_page_saved_interval is 400, ori is 400.2024-11-08 14:57:32.475 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 4, max = 4, actual = 42024-11-08 14:57:32.475 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4gaussdb.state does not exist, and skipt setting since it is optional.2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: localhost.localdomain2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: localhost.localdomain. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster2024-11-08 14:57:32.485 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 582024-11-08 14:57:32.490 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"2024-11-08 14:57:32.497 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2024-11-08 14:57:32.497 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2024-11-08 14:57:32.535 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2024-11-08 14:57:32.536 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (4482 Mbytes) is larger.2024-11-08 14:57:32.536 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory that key is 9523001 is owned by pid 18105132024-11-08 14:57:32.956 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)2024-11-08 14:57:33.570 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 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: 5122024-11-08 14:57:33.664 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/data/huawei/install/data/dn/gaussdb.state.temp" success2024-11-08 14:57:33.664 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)2024-11-08 14:57:33.684 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16bbox_dump_path is set to /data/huawei/corefile/2024-11-08 14:57:33.686 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: user configure file is not found, it will be created.[2024-11-08 14:57:38.414][2157478][][gs_ctl]: gaussDB state is Coredump[2024-11-08 14:57:38.414][2157478][][gs_ctl]: stopped waiting[2024-11-08 14:57:38.414][2157478][][gs_ctl]: could not start serverExamine the log output.[GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.[2024-11-08 14:57:32.372][2157478][][gs_ctl]: gs_ctl started,datadir is /data/huawei/install/data/dn[2024-11-08 14:57:32.408][2157478][][gs_ctl]: waiting for server to start....0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.0 LOG: [Alarm Module]Host Name: localhost.localdomain0 LOG: [Alarm Module]Host IP: localhost.localdomain. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain0 LOG: [Alarm Module]Cluster Name: dbCluster0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 580 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.0 LOG: SSE4.2 is not supported, disable codegen.0 LOG: bbox_dump_path is set to /data/huawei/corefile/2024-11-08 14:57:32.470 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: base_page_saved_interval is 400, ori is 400.2024-11-08 14:57:32.475 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 4, max = 4, actual = 42024-11-08 14:57:32.475 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4gaussdb.state does not exist, and skipt setting since it is optional.2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: localhost.localdomain2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: localhost.localdomain. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain2024-11-08 14:57:32.484 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster2024-11-08 14:57:32.485 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 582024-11-08 14:57:32.490 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"2024-11-08 14:57:32.497 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2024-11-08 14:57:32.497 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets2024-11-08 14:57:32.535 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2024-11-08 14:57:32.536 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (4482 Mbytes) is larger.2024-11-08 14:57:32.536 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory that key is 9523001 is owned by pid 18105132024-11-08 14:57:32.956 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)2024-11-08 14:57:33.570 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 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: 5122024-11-08 14:57:33.664 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/data/huawei/install/data/dn/gaussdb.state.temp" success2024-11-08 14:57:33.664 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)2024-11-08 14:57:33.684 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16bbox_dump_path is set to /data/huawei/corefile/2024-11-08 14:57:33.686 672db65c.1 [unknown] 140536861837760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: user configure file is not found, it will be created.[2024-11-08 14:57:38.414][2157478][][gs_ctl]: gaussDB state is Coredump[2024-11-08 14:57:38.414][2157478][][gs_ctl]: stopped waiting[2024-11-08 14:57:38.414][2157478][][gs_ctl]: could not start serverExamine the log output.

线下GaussDB(DWS) 8115版本中，查询pg_resource_pool，只有一个default_pool一个资源池， 但是查询pgxc_stat_activity 这个视图的时候，发现有的SQL使用的资源池是root，该用户是普通用户，并非管理员执行运维操作。 请问一下，root资源池是什么，资源分配比率是多少？以及什么时候普通用户也会使用root资源池（没有set resource_pool='root'）？ 

max_dynamic_memory，dynamic_used_memory和process memory allocation三者有什么区别和关联？在执行任务时的前后顺序是怎样的？

为什么嵌套case when 会非常消耗内存？

安装部署单节点的GaussDB管理平台失败了，请帮忙给看看，谢谢[2024-10-25 08:27:33.880]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:184]-[install]-[common-base]===>[Start to install common-base.] [2024-10-25 08:27:33.896]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:186]-[install]-[common-base]===>[Service status: [error]] [2024-10-25 08:27:33.916]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:193]-[install]-[common-base]===>[The rest retry times: 1.] [2024-10-25 08:27:33.951]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:196]-[install]-[common-base]===>[Upgrade retry num successful. rest retry times: 0] [2024-10-25 08:27:33.973]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:197]-[install]-[common-base]===>[Status:[running], update successful.] [2024-10-25 08:27:33.988]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[ERROR]-[common-base-install.sh:209]-[install]-[common-base]===>[Get and decrypt ca_key_phrase from render_args.yml error.] [2024-10-25 08:27:34.005]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[common-base-install.sh:210]-[install]-[common-base]===>[Status:[error], update successful.] [2024-10-25 08:27:34.022]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[crontab_file.sh:346]-[main]-[install]===>[sleep 10 second wait for all [install] done.] [2024-10-25 08:27:44.045]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[process_level.sh:56]-[update_remote_manifest]-[manifest]===>[start to update level status for ip=10.203.13.57] [2024-10-25 08:27:44.054]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[process_level.sh:68]-[update_level_manifest]-[manifest]===>[Updates the level status based on the microservice status. remote_manifest=/data/docker-service/config/manifest.yaml] [2024-10-25 08:27:44.208]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[process_level.sh:122]-[update_level_manifest]-[manifest]===>[update level=CommonbaseData status to error] [2024-10-25 08:27:44.515]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[ERROR]-[process_level.sh:274]-[check_exit]-[]===>[ip=10.203.13.57, level=CommonbaseData, ['install'] error.] [2024-10-25 08:27:44.560]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[process_level.sh:299]-[check_exit]-[]===>[del_flag=1] [2024-10-25 08:27:44.567]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[INFO]-[process_level.sh:301]-[check_exit]-[]===>[some nodes[0] occured error. Exit.] [2024-10-25 08:27:47.901]-[de6baf00-09b8-4a12-8e87-f2092f4c29d1]-[WARNING]-[appctl.sh:454]-[deploy_monitor_crontab]-[monitor]===>[The main process is abnormal.] 

怎么单独给grant权限？grant usage on schema xx to username吗？然后存量表 grant select all tables in schame xx to username;增量表 ALTER DEFAULT PRIVILEGES IN SCHEMA tpcds GRANT SELECT ON TABLES TO username;设置后就可以对其他用户授权select权限了吗？对于新建schema有什么方法没？

$ gs_install -X /opt/software/openGauss/cluster_config.xml --gsinit-parameter="--locale=zh_CN.UTF-8"Parsing the configuration file.Check preinstall on every node.Successfully checked preinstall on every node.Creating the backup directory.Successfully created the backup directory.begin deploy..Installing the cluster.begin prepare Install Cluster..Checking the installation environment on all nodes.begin install Cluster..Installing applications on all nodes.Successfully installed APP.begin init Instance..encrypt cipher and rand files for database.Please enter password for database:Please repeat for database:begin to create CA cert filesThe sslcert will be generated in /opt/huawei/install/app/share/sslcert/omNO cm_server instance, no need to create CA for CM.Non-dss_ssl_enable, no need to create CA for DSSCluster installation is completed.Configuring.Deleting instances from all nodes.Successfully deleted instances from all nodes.Checking node configuration on all nodes.Initializing instances on all nodes.Updating instance configuration on all nodes.Check consistence of memCheck and coresCheck on database nodes.Configuring pg_hba on all nodes.Configuration is completed.Using omm:dbgroup to install database.Using installation program path : /opt/huawei/install/app_33b035fd$GAUSSHOME points to /opt/huawei/install/app_33b035fd, no need to create symbolic link.Traceback (most recent call last):  File "/opt/huawei/install/om/script/local/Install.py", line 812, in <module>    functionDict[g_opts.action]()  File "/opt/huawei/install/om/script/local/Install.py", line 743, in startCluster    dn.start(self.time_out)  File "/opt/huawei/install/om/script/local/../gspylib/component/Kernel/Kernel.py", line 104, in start    raise Exception(ErrorCode.GAUSS_516["GAUSS_51607"] % "instance"Exception: [GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.[2024-10-16 10:32:52.678][21933][][gs_ctl]: gs_ctl started,datadir is /opt/huawei/install/data/dn [2024-10-16 10:32:52.740][21933][][gs_ctl]: waiting for server to start....0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.0 LOG:  [Alarm Module]Host Name: tims-ai-6-1 0 LOG:  [Alarm Module]Host IP: tims-ai-6-1. 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: 580 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.0 LOG:  bbox_dump_path is set to /opt/huawei/corefile/2024-10-16 10:32:52.869 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 DB010  0 [REDO] LOG:  Recovery parallelism, cpu count = 8, max = 4, actual = 42024-10-16 10:32:52.869 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 DB010  0 [REDO] LOG:  ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4gaussdb.state does not exist, and skipt setting since it is optional.2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Host Name: tims-ai-6-1 2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Host IP: tims-ai-6-1. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: dbCluster 2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 582024-10-16 10:32:52.918 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  loaded library "security_plugin"2024-10-16 10:32:52.923 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets2024-10-16 10:32:52.923 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets2024-10-16 10:32:52.932 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  reserved memory for backend threads is: 340 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 320 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  Set max backend reserve memory is: 660 MB, max dynamic memory is: 4079 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  shared memory 4476 Mbytes, memory context 4739 Mbytes, max process memory 10240 Mbytes2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  shared memory that key is 5432001 is owned by pid 122722024-10-16 10:32:53.927 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [CACHE] LOG:  set data cache  size(805306368)2024-10-16 10:32:55.039 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  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: 5122024-10-16 10:32:55.206 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  gaussdb: fsync file "/opt/huawei/install/data/dn/gaussdb.state.temp" success2024-10-16 10:32:55.206 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)2024-10-16 10:32:55.236 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  max_safe_fds = 974, usable_fds = 1000, already_open = 16bbox_dump_path is set to /opt/huawei/corefile/2024-10-16 10:32:55.240 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  user configure file is not found, it will be created.[2024-10-16 10:32:58.748][21933][][gs_ctl]:  gaussDB state is Coredump[2024-10-16 10:32:58.748][21933][][gs_ctl]: stopped waiting[2024-10-16 10:32:58.748][21933][][gs_ctl]: could not start serverExamine the log output.[GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.[2024-10-16 10:32:52.678][21933][][gs_ctl]: gs_ctl started,datadir is /opt/huawei/install/data/dn [2024-10-16 10:32:52.740][21933][][gs_ctl]: waiting for server to start....0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.0 LOG:  [Alarm Module]Host Name: tims-ai-6-1 0 LOG:  [Alarm Module]Host IP: tims-ai-6-1. 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: 580 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.0 LOG:  bbox_dump_path is set to /opt/huawei/corefile/2024-10-16 10:32:52.869 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 DB010  0 [REDO] LOG:  Recovery parallelism, cpu count = 8, max = 4, actual = 42024-10-16 10:32:52.869 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 DB010  0 [REDO] LOG:  ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4gaussdb.state does not exist, and skipt setting since it is optional.2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Host Name: tims-ai-6-1 2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Host IP: tims-ai-6-1. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: dbCluster 2024-10-16 10:32:52.892 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 582024-10-16 10:32:52.918 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  loaded library "security_plugin"2024-10-16 10:32:52.923 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets2024-10-16 10:32:52.923 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets2024-10-16 10:32:52.932 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  reserved memory for backend threads is: 340 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 320 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  Set max backend reserve memory is: 660 MB, max dynamic memory is: 4079 MB2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  shared memory 4476 Mbytes, memory context 4739 Mbytes, max process memory 10240 Mbytes2024-10-16 10:32:52.933 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  shared memory that key is 5432001 is owned by pid 122722024-10-16 10:32:53.927 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [CACHE] LOG:  set data cache  size(805306368)2024-10-16 10:32:55.039 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  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: 5122024-10-16 10:32:55.206 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  gaussdb: fsync file "/opt/huawei/install/data/dn/gaussdb.state.temp" success2024-10-16 10:32:55.206 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)2024-10-16 10:32:55.236 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  max_safe_fds = 974, usable_fds = 1000, already_open = 16bbox_dump_path is set to /opt/huawei/corefile/2024-10-16 10:32:55.240 670f25d4.1 [unknown] 139861824102464 [unknown] 0 dn_6001 00000  0 [BACKEND] LOG:  user configure file is not found, it will be created.[2024-10-16 10:32:58.748][21933][][gs_ctl]:  gaussDB state is Coredump[2024-10-16 10:32:58.748][21933][][gs_ctl]: stopped waiting[2024-10-16 10:32:58.748][21933][][gs_ctl]: could not start serverExamine the log output.安装环境：系统是NAME="openEuler"   VERSION="22.03 (LTS-SP3）下载的gauss版本：openGauss-5.0.1-openEuler-64bit-all.tar.gz系统32GB内存

GaussDB 200 8.1.1.5版本集群，如何加速VACUUM FULL ANALYZE 系统表脏页释放？set那些参数有效果？80节点集群是否有办法控制在半小时内？

在线下Gaussdb 8115版本中，如何处理json字符串，获取json字符串中的某个key的value值，有对应的函数吗？