请教一下，高斯数据库报如下错误，如何解决？[ConsumeMessageThread_1] ERROR OmsOrderStatusConsumer:69 - requestContextHolder.begin_error org.apache.ibatis.exceptions.PersistenceException:  ### Error updating database.  Cause: com.huawei.opengauss.jdbc.util.PSQLException: [X.X.X.X] ERROR: cannot execute UPDATE in a read-only transaction

请帮忙看一下，oracle new_time函数转高斯写进SP后报错：function new_time(timestamp without time zone, unknown, unknown) does not exist需要怎么处理？

openGauss有这个函数的替代吗？TO_DATE('AUG-22','MON-YY','nls_date_language = American')

openGauss新建的存储过程客户端看不到内容，这个是要授什么权限吗？

opengauss有行转列的函数吗？

openGauss应急恢复最佳实践，技术分享精彩来袭啦~

因图片加载等问题，具体详细的流程，请在最下方附件部分进行下载。一、购买项目管理ProjectMan服务登录华为云官网：cid:link_0，输入账号及密码，登录。进入控制台，选择区域，例如“华北-北京四”，在“开发与运维”中选择“项目管理ProjectMan”.单击“购买DevCloud”。按如下配置购买免费使用的基础版软件开发平台。单击“确认付款”完成购买。单击“返回控制台”。二、批量创建IAM用户选择“立即使用”阅读声明后，勾选 “我已阅读并同意以上使用声明”后，单击“确定”。鼠标移动至右上角个人帐号，单击“租户设置”。单击“批量导入子帐号”选择“下载模板”。在模板中填写子账号名和帐户邮箱。模板单次最大支持100个成员的批量导入。模板填写完成后，勾选“我已阅读并同意……”后单击上传模板按钮进行上传。在控制台选择IAM服务，检查IAM是否已成功创建。IAM 用户创建成功后，其邮箱将收到登录信息，首次登录需修改密码。

摘要在编译完成openGauss或者已download了openGauss的bin后，想要做简易安装，官方给的使用方法是使用simpleInstall。本文主要介绍simpleInstall的脚本的功能，来了解一下简易安装内部实现原理。openGauss简易安装postgres初始化数据库了解openGauss安装之前简单说一下postgres的安装过程，postgres没有提供安装脚本，但是初始化数据库集簇的命令很简单：initdb -D $PGDATA 会在指定的PGDATA目录下创建数据库，可以参考之前的一篇文章postgresql 15源码浅析（1）—— postgres中的1号数据库 。openGauss脚本安装openGauss简易安装是使用simpleInstall下面的install.sh脚本。simpleInstall源码解析step1获取命令行参数（get_param）先看一下需要那些参数function usage() { echo " Usage: sh $0 -w password Arguments: -w login password -p datanode port, default 5432 --multinode if specify, will install master_slave cluster. default install single node. -h, --help Show this help, then exit " }主要有3个参数：-w 设置超级用户的源码，这个是必选项，如不设置后续初始化流程无法完成，这也是和postgres的一个区别，postgres不强制要求超级用户密码。且使用-W（大写）设置密码，设置形式是交互的。-w（小写）是openGauss引入的新参数；-p 设置服务端口，非必选，默认是5432；--multinode 初始化数据库提供两种形式，及单节点和主备两种；-w 和 -W的区别两个参数的功能是一样的，但是-W是postgres保留的功能，是交互是的，需要手动数据密码；-w 是自动的方式将密码通过命令行传入程序，我猜openGauss是为了兼容原有的用法，所以新加了-w的参数，且出于安全性考虑，是必须设置的。step2 检查参数（check_param）主要检查一下几项：-w参数必须填写，且不能为空密码必须大于8个字符不能使用root用户安装如不设置-p，怎使用默认端口5432，否则使用-p的设置如果设置了--multinode，则备节点的端口为主节点端口+200step3 检查安装环境（check_install_env）检查目录是否存在，如果是单节点模式，检查data下是否存在single_node目录，是否为空目录，如果是主备检查 master 和 slave是否存在，是否为空；检查端口是否被占用；检查unix sock是否有权限，是否被占用step4 检查操作系统参数（check_os）检查系统共享内存和页大小x86下还要检查rdtscp，应该是和指令顺序有关这块有留个坑吧，不是很了解，后续有机会在填上。step5 修改应用目录的属组和权限（change_gausshome_owner）修改属组：chown omm:dbgrp $app修改权限：chmod 700 $appstep6 设置omm用户的环境变量设置的环境变量包括：PATH、GAUSSHOME、LD_LIBRARY_PATH、GS_CLUSTER_NAME、ulimit -n 1000000上图是omm用户的.bashrc的内容step7-1 初始化数据库（single_install）初始化数据库集簇，参考postgresql 15源码浅析（1）—— postgres中的1号数据库 基本流程没有太大区别；第二个坑，后续会对比一下initdb过程postgres和openGauss的有哪些差别。gs_initdb -w $password -D $app/data/single_node --nodename "sgnode" --locale="en_US.UTF-8"修改配置文件postgres.conf中的端口sed -i "/^#port =/c\port = $port" $app/data/single_node/postgresql.conf启动数据库gs_ctl start -D $app/data/single_node -Z single_nodestep7-2 初始化数据库（master_standby_install）init_dbfunction init_db() { info "[init primary datanode.]" gs_initdb -D $app/data/master --nodename=datanode1 -E UTF-8 --locale=en_US.UTF-8 -U $user -w $password info "[init slave datanode.]" gs_initdb -D $app/data/slave --nodename=datanode2 -E UTF-8 --locale=en_US.UTF-8 -U $user -w $password }分别对主备两个库进行初始化。config_dbfunction config_db() { info "[config datanode.]" local -a ip_arr local -i index=0 for line in $(/sbin/ifconfig -a|grep inet|grep -v 127.0.0.1|grep -v inet6|awk '{print $2}'|tr -d "addr:") do ip_arr[index]=$line let index=$index+1 done sed -i "/^#listen_addresses/c\listen_addresses = 'localhost,${ip_arr[0]}'" $app/data/master/postgresql.conf sed -i "/^#listen_addresses/c\listen_addresses = 'localhost,${ip_arr[0]}'" $app/data/slave/postgresql.conf sed -i "/^#port/c\port = $port" $app/data/master/postgresql.conf sed -i "/^#port/c\port = $slave_port" $app/data/slave/postgresql.conf sed -i "/^#replconninfo1/c\replconninfo1 = 'localhost=${ip_arr[0]} localport=$(($port+1)) localheartbeatport=$(($port+5)) localservice=$(($port+4)) remotehost=${ip_arr[0]} remoteport=$(($slave_port+1)) remoteheartbeatport=$(($slave_port+5)) remoteservice=$(($slave_port+4))'" $app/data/master/postgresql.conf sed -i "/^#replconninfo1/c\replconninfo1 = 'localhost=${ip_arr[0]} localport=$(($slave_port+1)) localheartbeatport=$(($slave_port+5)) localservice=$(($slave_port+4)) remotehost=${ip_arr[0]} remoteport=$(($port+1)) remoteheartbeatport=$(($port+5)) remoteservice=$(($port+4))'" $app/data/slave/postgresql.conf echo "remote_read_mode = non_authentication" | tee -a $app/data/master/postgresql.conf $app/data/slave/postgresql.conf echo "host all all ${ip_arr[0]}/32 trust" | tee -a $app/data/master/pg_hba.conf $app/data/slave/pg_hba.conf }主要修改主备的服务提供端口、主备通信端口 和 客户端登录权限等，涉及配置文件postgres.conf和pg_hba.conf。start_db-b, --mode=MODE the mode of building the datanode or coordinator.MODE can be "full", "incremental", "auto", "standby_full", "copy_secure_files", "copy_upgrade_file", "cross_cluster_full", "cross_cluster_incremental", "cross_cluster_standby_full" -M the database start as the appointed mode -D, --pgdata=DATADIR location of the database storage areastep8 导入范例SQL（import_sql）read -p "Would you like to create a demo database (yes/no)? " input接收输入，是否要建立范例数据库导入两个sql文件中的内容function fn_load_demoDB() { cd $shell_path gsql -d postgres -p $port -f school.sql gsql -d postgres -p $port -f finance.sql }结束以上步骤执行成功后，即完成了数据库集簇的初始化和启动过程。如果大家在启动本地安装过程中遇到问题，可以对照以上步骤进行排查。启动日志[omm@host-10-208-88-234 simpleInstall]$ sh install.sh -w xk.xmx190035 [step 1]: check parameter [step 2]: check install env and os setting [step 3]: change_gausshome_owner [step 4]: set environment variables /home/omm/.bashrc: line 13: ulimit: open files: cannot modify limit: Operation not permitted [step 6]: init datanode 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 "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/omm/git/openGauss-server/data/single_node ... 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 /home/omm/git/openGauss-server/data/single_node/base/1 ... The core dump path is an invalid directory 2022-05-23 12:30:32.064 [unknown] [unknown] localhost 281459036192784 0[0:0#0] [BACKEND] WARNING: macAddr is 64022/1056020634, sysidentifier is 4195761905/2560264540, randomNum is 246122844 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 hdfs 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/omm/git/openGauss-server/data/single_node --single_node or gs_ctl start -D /home/omm/git/openGauss-server/data/single_node -Z single_node -l logfile [step 7]: start datanode [2022-05-23 12:30:51.410][991625][][gs_ctl]: gs_ctl started,datadir is /home/omm/git/openGauss-server/data/single_node [2022-05-23 12:30:51.446][991625][][gs_ctl]: waiting for server to start... .0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: host-10-208-88-234 0 LOG: [Alarm Module]Host IP: 10.208.88.234 0 LOG: [Alarm Module]Cluster Name: dbCluster 0 LOG: [Alarm Module]Get real path of alarmItem.conf 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 is an invalid directory 2022-05-23 12:30:51.581 [unknown] [unknown] localhost 281460165246992 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-05-23 12:30:51.587 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2022-05-23 12:30:51.587 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: host-10-208-88-234 2022-05-23 12:30:51.636 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: 10.208.88.234 2022-05-23 12:30:51.636 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2022-05-23 12:30:51.636 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Get real path of alarmItem.conf failed! 2022-05-23 12:30:51.641 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2022-05-23 12:30:51.642 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2022-05-23 12:30:51.642 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] WARNING: No explicit IP is configured for listen_addresses GUC. 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 11027 MB 2022-05-23 12:30:51.645 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: shared memory 400 Mbytes, memory context 11375 Mbytes, max process memory 12288 Mbytes 2022-05-23 12:30:51.681 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2022-05-23 12:30:51.726 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [CACHE] LOG: set metadata cache size(134217728) 2022-05-23 12:30:51.741 [unknown] [unknown] localhost 281460165246992 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-05-23 12:30:51.755 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/home/omm/git/openGauss-server/data/single_node/gaussdb.state.temp" success 2022-05-23 12:30:51.755 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1) 2022-05-23 12:30:51.834 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: max_safe_fds = 976, usable_fds = 1000, already_open = 14 The core dump path is an invalid directory 2022-05-23 12:30:51.839 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created. 2022-05-23 12:30:51.842 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: the configure file /home/omm/git/openGauss-server/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2022-05-23 12:30:51.842 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 2022-05-23 12:30:51.862 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-05-23 12:30:51.862 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-05-23 12:30:51.862 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-05-23 12:30:51.862 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. 2022-05-23 12:30:51.863 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] WARNING: Failed to obtain environment value $GAUSSLOG! 2022-05-23 12:30:51.863 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] DETAIL: N/A 2022-05-23 12:30:51.863 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] CAUSE: Incorrect environment value. 2022-05-23 12:30:51.863 [unknown] [unknown] localhost 281460165246992 0[0:0#0] 0 [EXECUTOR] ACTION: Please refer to backend log for more details. [2022-05-23 12:30:52.460][991625][][gs_ctl]: done [2022-05-23 12:30:52.460][991625][][gs_ctl]: server started (/home/omm/git/openGauss-server/data/single_node) import sql file Would you like to create a demo database (yes/no)? yes Load demoDB [school,finance] success. [complete successfully]: You can start or stop the database server using: gs_ctl start|stop|restart -D $GAUSSHOME/data/single_node -Z single_node备注上面留下两个坑，待后续填上。没填上的坑挖坑的时间x86下的rdtscp2022-05-23initdb过程postgres和openGauss的有哪些差别2022-05-23

优秀的开发者们，9月19日，华为云数据库【GaussDB入门级开发者认证】活动开始啦！活动时间：2022/9/19 - 2022/10/30活动流程：报名现已开启>>>点击此处了解详情欢迎进入“心得分享”环节 历经了沙箱实验的玩耍，通过了开发者认证的关卡，一路上披荆斩棘，想必感悟甚多，那就来参与“心得分享”吧，让你的文字成为后来者的灯塔。“心得分享”奖品激励名次（专家打分）奖品第1名（85分+）华为云手环4（曜石黑）第2~3名（80分+）HUAWEI minni蓝牙音箱_绮境森林/折叠烧水壶第4~6名（70分+）罗技鼠标第7~X名（60分+）手机支架分享方向：基于自己的实际操作，分享本次活动中GaussDB开发者入门级认证考证过程中的实战经验、使用感受及内容需改进点等。评奖规则说明华为云数据库社区、华为云HCSD将联合评审此次征文。评分依据 ：可读性、原创度、文章篇幅、技术含金量、排版美观度、阅读量等指标综合评分。参与方式：登录华为云账号，进入【我的博客】页面，点击右上角【写博客】，即可写文章。文章需为原创，每篇文章要求不少于600字，图文并茂，排版工整。在发布博客时，需要勾选文章创作类型：原创文章一项。用户承诺，发表的文章不存在任何知识产权问题并自行承担全部责任 3. 回复格式：在本帖下方回复：“华为云ID+博客文章链接”投稿要求：内容要求为投稿人原创，如存在洗稿、转载或抄袭等行为一经发现将取消活动资格。内容分享后，华为云数据库拥有该内容的使用权、修改权等。相关奖项由数据库社区专家进行评选，如发布的内容不符合征稿内容要求时，奖项可空缺。只有在活动期内，在数据库社区首发的原创内容，才可获奖励。通过违规手段或恶意作 弊等行为参与活动的，如有发现，回收奖励并取消活动资格。注意事项请务必使用个人账号参与活动（IAM、企业账号等账号参与无效）。所有获得华为奖项的获奖用户，请于获奖后3日内完成实名认证，否则视为放弃奖励。本次活动如一个实名认证对应多个账号，只有一个账号可领取奖励；一个实名认证账号只能对应一个收件人，如同一账号填写多个不同收件人或不同账号填写同一收件人，均不予发放奖励。活动结束且用户填写完成领奖信息后，30个工作日内发放奖品，发放时间根据实际情况动态调整，如有延期敬请见谅。其他事宜请参考【华为云社区常规活动规则】，本活动最终解释权归活动主办方所有。

优秀的开发者们，9月19日，华为云数据库【GaussDB入门级开发者认证】活动开始啦！报名现已开启>>>点击此处了解详情福利来袭GaussDB入门级开发者认证原价500元，完成任意一个沙箱实验，就可1元购！参与认证打卡，就有机会赢取下方礼品活动时间：2022/9/19 - 2022/10/30活动流程活动奖励：考过GaussDB开发者入门级认证以后，下方回帖即可享受如下奖励：【GaussDB开发者入门级认证】奖励奖励名次奖品数量1名猎人战甲背包12-3名HUAWEI FreeLace无线耳机活力版曜石黑24-10名折叠烧水壶711-20名荣耀体脂称210开发者认证权益：官方认证证书华为云产品优惠使用权华为云新产品体验权华为全联接大会嘉宾名额加入线上人才库成为华为云云享专家成为华为云MVP成为华为云开发者学堂讲师 如何考《GaussDB入门级开发者认证》？ 完成5个沙箱实验中任意一个沙箱实验打卡后，填写完问卷，小助手会给填写问卷的账户进行499元代金券发放。参与活动：回复到本帖下方评论区即可回复内容：完成认证时间+华为云账号+姓名+证书编号+证书名称 +证书截图举个栗子：2022.10.1（认证时间）+hw12312312（华为云账号）+小明（姓名）+xxxxx（证书编号）+证书回帖已设置仅小助手可见，请大家按要求回复哦，不会外泄大家的隐私~注意事项请务必使用个人账号参与活动（IAM、企业账号等账号参与无效）。所有获得华为奖项的获奖用户，请完成实名认证，否则视为放弃奖励。本次活动如一个实名认证对应多个账号，只有一个账号可领取奖励；一个实名认证账号只能对应一个收件人，如同一账号填写多个不同收件人或不同账号填写同一收件人，均不予发放奖励。活动结束且用户填写完成领奖信息后，30个工作日内发放奖品，发放时间根据实际情况动态调整，如有延期敬请见谅。其他事宜请参考【华为云社区常规活动规则】，本活动最终解释权归活动主办方所有。

优秀的开发者们，9月19日，华为云数据库【GaussDB入门级开发者认证】活动开始啦！报名现已开启>>>点击此处了解详情恭喜你进入“沙箱实验”环节玩沙箱实验，送499元代金券周周赢礼品活动时间：2022年9月19日-10月30日活动流程：沙箱实验奖励：【沙箱实验】奖励奖励中奖数量奖品每周随机抽取5位手机支架u盘公牛插排活动结束随机抽取5位罗技鼠标活动内容：完成以下任意一个沙箱实验，即可参与抽奖沙箱实验1：GaussDB 部署 沙箱实验2：GaussDB 客户端实践 沙箱实验3：GaussDB SQL及常规操作沙箱实验4：GaussDB基础操作编程-Java 沙箱实验5：金融场景下GaussDB编程综合实践-Java参与方式：本帖下方回帖即可。回复内容：沙箱实验名称+华为云账号+实验进度100%截图完成沙箱实验打卡以后，请填写问卷，小助手帮忙配置499元代金券哦！领到代金券以后，请点击《GaussDB入门级开发者认证-Java》进行认证购买！回帖已设置仅小助手可见，请大家按要求回复哦，不会外泄大家的隐私~注意事项请务必使用个人账号参与活动（IAM、企业账号等账号参与无效）。所有获得华为奖项的获奖用户，请完成实名认证，否则视为放弃奖励。本次活动如一个实名认证对应多个账号，只有一个账号可领取奖励；一个实名认证账号只能对应一个收件人，如同一账号填写多个不同收件人或不同账号填写同一收件人，均不予发放奖励。活动结束且用户填写完成领奖信息后，30个工作日内发放奖品，发放时间根据实际情况动态调整，如有延期敬请见谅。其他事宜请参考【华为云社区常规活动规则】，本活动最终解释权归活动主办方所有。

2022/9/19-10/30华为云官方特别推出GaussDB开发者入门级认证线上理论学习+沙箱上云实践玩转数据库，为你的求职之路保驾护航 超级福利 原价500元，完成沙箱的前200名，可1元购还有HUAWEI智能手表、HUAWEI FreeBuds 4无线耳机、华为手环4、荣耀体脂称2、hilink保温杯、罗技鼠标等万元奖励等你来！参与沙箱实验打卡，领到499元代金券以后，请点击《GaussDB入门级开发者认证-Java》进行认证购买！直播回放直播主题直播链接直播1云数据库时代，DBA将走向何方？https://bbs.huaweicloud.com/live/cloud_live/202210101900.html直播2《GaussDB入门级开发者认证》技术解读1https://bbs.huaweicloud.com/live/cloud_live/202210111901.html直播3《GaussDB入门级开发者认证》技术解读2https://bbs.huaweicloud.com/live/cloud_live/202210171900.html1.活动对象适合人群：高校学生、0基础对数据库感兴趣的用户2.活动流程▶报名活动：- 活动报名入口： 点此报名活动▶加入活动社群？加入社群，回复：开发者认证。“学习&打卡进度、奖品激励、499元代金券”，有问题随时沟通，组织在这里！ 3.阶段任务安排表  ▶开发者认证计划进度表：▶数据库学习任务配置：点击图片放大查看详细打卡标准（课程开启后按要求回复到指定活动帖中）序号打卡项对应阶段任务详情奖励及参与入口1邀请“好友”任务完成方式：活动报名以后，点击“分享有礼”，将生成的专属链接/邀请二维码，即可邀请好友 点击参与2玩沙箱实验任务完成方式：活动期间，完成“沙箱实验”，后截图回复到指定帖子中回复格式：华为云账号+截图（露出右上角华为云ID，且有效提交次数≥1）点击参与回帖3晒开发者证书任务完成方式：活动期间，通过“开发者认证”考试，完成后截图回复到指定帖子中回复格式：华为云账号+截图（露出右上角华为云ID，且有效提交次数≥1）点击参与回帖4分享心得任务完成方式：活动期间，完成“分享心得”，后截图回复到指定帖子中回复格式：华为云账号+博客链接（露出右上角华为云ID，且有效提交次数≥1）点击参与回帖5.活动其他事宜通知 ○所有活动奖品将在活动结束后20个工作日内完成发放；○活动奖品颜色随机，且部分奖品数量有限发完即止，如对应奖品无库存会更换等价奖品；○活动奖品需要进行华为云账号实名认证后领取；○为保证活动的公平公正，华为云有权对恶意刷活动资源（“恶意”是指为获取资源而异常注册账号等破坏活动公平性的行为），利用资源从事违法违规行为的用户收回抽奖及奖励资格。○本活动规则由华为云在法律规定范围内进行解释。华为云保留不时更新、修改或删除本活动规则的权利。○本次活动回帖内容需满足华为云论坛发帖规范：cid:link_5 

高斯数据库的primary key 支持多个字段吗？

GaussDB删除存储过程报错： ERROR: function prmecat.insert_copy_partprice asks parameters，请问是什么情况？

我把log复制一下：2022-09-14 09:43:07.613 632131aa.1 [unknown] 139667022593088 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  start create thread! 2022-09-14 09:43:07.613 632131aa.1 [unknown] 139667022593088 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  create thread end! 2022-09-14 09:43:07.613 632131aa.1 [unknown] 139667022593088 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  could not fork new process for connection due to PMstate PM_STARTUP 2022-09-14 09:43:07.614 632131ab.10000 [unknown] 139661201106688 dn_6002 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]alarm checker started. 2022-09-14 09:43:07.614 632131ab.10000 [unknown] 139661184325376 dn_6002 0 dn_6001_6002 00000  0 [BACKEND] LOG:  reaper backend started. 2022-09-14 09:43:07.615 [MOT] [INFO]                 Startup: Loading configuration from /opt/huawei/install/data/dn01/mot.conf 2022-09-14 09:43:07.647 [MOT] [INFO]          Configuring total memory for relative memory values to: 5120 MB 2022-09-14 09:43:07.648 [MOT] [INFO]          Loading max_connections from envelope into MOTEngine: 5000 2022-09-14 09:43:07.648 [MOT] [WARNING]        Adjusted maximum number of threads to 4096 due to maximum limit 2022-09-14 09:43:07.648 [MOT] [INFO]          Configuring asynchronous redo-log handler due to synchronous_commit=off 2022-09-14 09:43:07.648 [MOT] [WARNING]        Adjusting MOT memory limits: global = 2586 MB, local = 486 MB, session large store = 0 MB, total = 3072 MB 2022-09-14 09:43:07.648 [MOT] [INFO]                 Global Memory Limit is configured to: 0 MB --> 2586 MB 2022-09-14 09:43:07.648 [MOT] [INFO]                 Local Memory Limit is configured to: 0 MB --> 486 MB 2022-09-14 09:43:07.648 [MOT] [INFO]                 Session Memory Limit is configured to: 0 KB --> 0 KB (maximum 5000 sessions) 2022-09-14 09:43:07.648 [MOT] [INFO]                 Configured automatic chunk allocation policy to 'LOCAL' on single node machine 2022-09-14 09:43:14.473 632131aa.1 [unknown] 139667022593088 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  could not fork new process for connection due to PMstate PM_STARTUP ======================================================================================================2022-09-14 09:38:27.291 63213092.1 [unknown] 139870423477312 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  start create thread! 2022-09-14 09:38:27.291 63213092.1 [unknown] 139870423477312 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  create thread end! 2022-09-14 09:38:27.292 63213092.1 [unknown] 139870423477312 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  could not fork new process for connection due to PMstate PM_STARTUP 2022-09-14 09:38:27.293 63213093.10000 [unknown] 139864603817728 dn_6002 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]alarm checker started. 2022-09-14 09:38:27.294 63213093.10000 [unknown] 139864583829248 dn_6002 0 dn_6001_6002 00000  0 [BACKEND] LOG:  reaper backend started. 2022-09-14 09:38:27.295 [MOT] [INFO]                 Startup: Loading configuration from /opt/huawei/install/data/dn01/mot.conf 2022-09-14 09:38:27.328 [MOT] [INFO]          Configuring total memory for relative memory values to: 5120 MB 2022-09-14 09:38:27.328 [MOT] [INFO]          Loading max_connections from envelope into MOTEngine: 5000 2022-09-14 09:38:27.328 [MOT] [WARNING]        Adjusted maximum number of threads to 4096 due to maximum limit 2022-09-14 09:38:27.328 [MOT] [INFO]          Configuring asynchronous redo-log handler due to synchronous_commit=off 2022-09-14 09:38:27.328 [MOT] [WARNING]        Adjusting MOT memory limits: global = 2586 MB, local = 486 MB, session large store = 0 MB, total = 3072 MB 2022-09-14 09:38:27.328 [MOT] [INFO]                 Global Memory Limit is configured to: 0 MB --> 2586 MB 2022-09-14 09:38:27.328 [MOT] [INFO]                 Local Memory Limit is configured to: 0 MB --> 486 MB 2022-09-14 09:38:27.328 [MOT] [INFO]                 Session Memory Limit is configured to: 0 KB --> 0 KB (maximum 5000 sessions) 2022-09-14 09:38:27.328 [MOT] [INFO]                 Configured automatic chunk allocation policy to 'LOCAL' on single node machine