SpringBoot(2.3.5.RELEASE),Druid(1.2.23), Mybatis-Plus(3.5.3.1)对接GausDB,数据库连接正常，但是分页查询报错.GaussDB 依赖使用 8.3.1-200GaussDB 使用主备模式，1主2备，由 MySQL 迁移到 GaussDB，b_format_version = 5.7<dependency> <groupId>com.huaweicloud.dws</groupId> <artifactId>huaweicloud-dws-jdbc</artifactId> <version>8.3.1-200</version> </dependency>

GaussDB for MySQL是华为云基于开源MySQL打造的一款企业级云数据库服务，它继承了MySQL的易用性和广泛的应用生态，同时通过华为云的技术创新，提供了更高的性能、可靠性和可扩展性。以下是GaussDB for MySQL与MySQL的主要区别：性能表现GaussDB for MySQL：拥有超高性能，可达到百万级QPS，性能是开源MySQL的7倍。在复杂查询场景，支持将提取列、条件过滤、聚合运算等操作向下推给存储层处理，性能相比传统架构提升数十倍。MySQL：也能处理大量数据和高并发访问，对于一般的中小型网站开发等场景性能表现良好，但在性能上限方面相对GaussDB较低。例如，在处理大规模数据和高并发请求时，可能会面临性能瓶颈。扩展性GaussDB for MySQL：具有高扩展性，支持分钟级添加只读节点，最大支持15个只读节点。由于采用共享存储，添加只读节点所需时间与数据量大小无关，且无需增加额外存储。存储可根据数据容量自动弹性伸缩，最大支持128TB，能很好地应对海量数据问题和性能扩展需求。MySQL：扩展性相对有限，最多可添加5个只读节点，添加只读节点所需时间与数据量大小相关，并且需要增加一份存储。存储自动扩容最大支持4TB。架构特点GaussDB for MySQL：采用存算分离架构，计算节点共享一份数据，无需通过binlog同步数据。这种架构使得数据库在处理大规模数据和高并发请求时具有更好的性能和可扩展性，同时也方便了数据的管理和维护。MySQL：通常采用传统主备架构，主备通过binlog同步数据。这种架构在一定程度上保证了数据的可靠性和可用性，但在性能和扩展性方面可能会受到一些限制，特别是在处理大规模数据和高并发请求时。可用性GaussDB for MySQL：主节点和只读节点无需通过binlog进行数据同步，延时更低，故障自动切换，RTO（Recovery Time Objective，恢复时间目标）通常小于10秒，具有较高的可用性。MySQL：故障自动倒换，RTO通常小于30秒，可用性也较高，但相对GaussDB来说，在故障切换的速度和延时方面可能稍逊一筹。备份恢复GaussDB for MySQL：通过全量备份（快照）+ redo回放实现任意时间点回滚，备份恢复速度更快。MySQL：通过全量备份 + binlog回放实现任意时间点回滚。兼容性GaussDB for MySQL：具有高兼容性，100%兼容MySQL，应用上云无须改造，这使得现有基于MySQL开发的应用可以较为容易地迁移到GaussDB上，降低了迁移成本和风险。MySQL：作为广泛使用的数据库，其本身具有良好的兼容性，但对于一些特定的功能或语法，可能与其他数据库存在差异。成本GaussDB for MySQL：具有超低成本，约为十分之一的商用数据库成本，这对于对成本敏感的企业或项目来说是一个重要的优势。MySQL：分为社区版和商业版，社区版是免费的，可用于许多中小型项目；商业版则提供更多的功能和技术支持，相应的成本也会更高。对于一些大型企业或对数据库有较高要求的项目，可能需要购买商业版的MySQL并承担相应的费用。应用场景GaussDB for MySQL：广泛应用于金融、车联网、政企、电商、能源、电信等对数据安全、可靠性、性能和扩展性要求较高的多个领域。例如，金融行业对数据安全和可靠性有非常严格的要求，GaussDB既拥有商业数据库的稳定可靠性，又拥有开源数据库的灵活性和低成本；互联网行业的发展经常呈爆发性增长，业务波动变化频繁，流量高峰难以预测，GaussDB凭借其强大的弹性能力特别契合这一行业特点。MySQL：适用于各种规模的项目，尤其是中小型网站、Web应用程序、小型企业的内部系统等。由于其成本低、性能较强、简单实用且对初学者友好，在这些场景中得到了广泛应用。例如，对于一些个人站点、初创公司、小型内部系统，考虑到成本、更新频率、系统重要性等问题，系统只依赖一个单例MySQL数据库提供服务，基本上已经满足需求。

线下DWS 8115版本，针对这种使用方式有什么优化方法(数据量1亿条左右)？select a,b,array_to_string(array_agg(distinct c),',') as d from testtable group by 1,2,3;

安装报错[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有什么方法没？