- AI - mailweb.opengauss.org

openGauss6.0极简版集群搭建问题咨询
by 何立冬 03 Sep '24

03 Sep '24

Hi 我这边在搭建gauss集群使用 openGauss-6.0.0-RC1-CentOS-64bit.tar.bz2包，部署上后启动日志一直输出： 0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 0 LOG: [Alarm Module]Host Name: apptrace127 0 LOG: [Alarm Module]Host IP: apptrace127. 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-09-03 10:51:30.798 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: when starting as multi_standby mode, we couldn't support data replicaton. 2024-09-03 10:51:30.798 [unknown] [unknown] localhost 139677113678464 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-09-03 10:51:30.879 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env. 2024-09-03 10:51:30.879 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host Name: apptrace127 2024-09-03 10:51:30.879 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Host IP: apptrace127. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP> 2024-09-03 10:51:30.879 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster 2024-09-03 10:51:30.880 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57 2024-09-03 10:51:30.902 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: loaded library "security_plugin" 2024-09-03 10:51:30.903 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2024-09-03 10:51:30.903 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2024-09-03 10:51:30.906 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2024-09-03 10:51:30.907 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: reserved memory for backend threads is: 220 MB 2024-09-03 10:51:30.907 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: reserved memory for WAL buffers is: 128 MB 2024-09-03 10:51:30.907 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: Set max backend reserve memory is: 348 MB, max dynamic memory is: 8141 MB 2024-09-03 10:51:30.907 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: shared memory 3286 Mbytes, memory context 8489 Mbytes, max process memory 12288 Mbytes 2024-09-03 10:51:30.975 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [CACHE] LOG: set data cache size(402653184) 2024-09-03 10:51:31.024 [unknown] [unknown] localhost 139677113678464 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-09-03 10:51:31.057 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file "/opt/openGauss/data/single_node/gaussdb.state.temp" success 2024-09-03 10:51:31.058 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1) 2024-09-03 10:51:31.084 [unknown] [unknown] localhost 139677113678464 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 2024-09-03 10:51:31.086 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: user configure file is not found, it will be created. 2024-09-03 10:51:31.093 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: the configure file /opt/openGauss/etc/gscgroup_apptrace.cfg doesn't exist or the size of configure file has changed. Please create it by root user! 2024-09-03 10:51:31.093 [unknown] [unknown] localhost 139677113678464 0[0:0#0] 0 [BACKEND] LOG: Failed to parse cgroup config file. 我想问下这些输出的日志会影响流复制吗？目前搭建集群执行./gs_basebackup -h 我的IP -U repl -Fp -P -D /opt/apptrace/openGauss/data/single_node -p 5432 -WAdmin123! 方式流复制，一直关联不上，需要修改的相关流复制配置 listen_addresses = '*' port = 5432 wal_level = logical archive_mode = on wal_log_hints = on max_wal_senders= 10 wal_sender_timeout = 120s log_directory = '/opt/apptrace/openGauss/logs' password_encryption_type=1 hot_standby = on均已修改，我想问下极简版支持这种流复制方式吗？目前已经跑通了企业版，极简版调查了所有资源，发现仍然还有问题。

1 0

20240816 openGauss TC会议
by openGauss conference 13 Aug '24

13 Aug '24

您好！ TC 邀请您参加 2024-08-16 11:00 召开的zoom会议(自动录制) 会议主题：20240816 openGauss TC会议会议内容： 8月份TC会议，请大家积极申报议题会议链接：https://us06web.zoom.us/j/89263706385?pwd=eg7CxDHeq346MheoY7g1dOKOAZy88I.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-08-16 11:00, The subject of the conference is 20240816 openGauss TC会议, Summary: 8月份TC会议，请大家积极申报议题 You can join the meeting at https://us06web.zoom.us/j/89263706385?pwd=eg7CxDHeq346MheoY7g1dOKOAZy88I.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

2024-7-17 openGauss TC会议
by openGauss conference 12 Jul '24

12 Jul '24

您好！ TC 邀请您参加 2024-07-17 11:00 召开的zoom会议(自动录制) 会议主题：2024-7-17 openGauss TC会议会议内容：请各位委员积极申报议题，谢谢。会议链接：https://us06web.zoom.us/j/82615120198?pwd=WdTyeoujxjpyxDvmNJQTBvcdp7Zgar.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-07-17 11:00, The subject of the conference is 2024-7-17 openGauss TC会议, Summary: 请各位委员积极申报议题，谢谢。 You can join the meeting at https://us06web.zoom.us/j/82615120198?pwd=WdTyeoujxjpyxDvmNJQTBvcdp7Zgar.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

2024-6-20 openGauss TC会议
by openGauss conference 06 Jun '24

06 Jun '24

您好！ TC 邀请您参加 2024-06-20 10:00 召开的zoom会议会议主题：2024-6-20 openGauss TC会议会议内容：诚邀各位委员现场参加6月20日上午10:00-12:00的技术委员会例会。请大家积极准备议题，高效参会。会议链接：https://us06web.zoom.us/j/86583530252?pwd=SaXLaPYUnB1MaPvJMyuVe57EzG5Byi.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference will be held at 2024-06-20 10:00, The subject of the conference is 2024-6-20 openGauss TC会议, Summary: 诚邀各位委员现场参加6月20日上午10:00-12:00的技术委员会例会。请大家积极准备议题，高效参会。 You can join the meeting at https://us06web.zoom.us/j/86583530252?pwd=SaXLaPYUnB1MaPvJMyuVe57EzG5Byi.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

[Update] openGauss 2024-5-22 TC例会
by openGauss conference 20 May '24

20 May '24

您好！ TC 邀请您参加 2024-05-22 11:00 召开的zoom会议(自动录制) 会议主题：[Update] openGauss 2024-5-22 TC例会会议链接：https://us06web.zoom.us/j/89827307604?pwd=gUDUo3Kpj4Z2fjI2R6nYR0svLb9srC.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-05-22 11:00, The subject of the conference is [Update] openGauss 2024-5-22 TC例会, You can join the meeting at https://us06web.zoom.us/j/89827307604?pwd=gUDUo3Kpj4Z2fjI2R6nYR0svLb9srC.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

openGauss 2024-5-21 TC例会
by openGauss conference 17 May '24

17 May '24

您好！ TC 邀请您参加 2024-05-21 11:00 召开的zoom会议(自动录制) 会议主题：openGauss 2024-5-21 TC例会会议内容：请大家积极申报议题会议链接：https://us06web.zoom.us/j/89827307604?pwd=gUDUo3Kpj4Z2fjI2R6nYR0svLb9srC.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-05-21 11:00, The subject of the conference is openGauss 2024-5-21 TC例会, Summary: 请大家积极申报议题 You can join the meeting at https://us06web.zoom.us/j/89827307604?pwd=gUDUo3Kpj4Z2fjI2R6nYR0svLb9srC.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

2024-4-23 openGauss TC会议
by openGauss conference 18 Apr '24

18 Apr '24

您好！ TC 邀请您参加 2024-04-23 16:00 召开的zoom会议(自动录制) 会议主题：2024-4-23 openGauss TC会议会议内容：请大家积极申报议题。会议链接：https://us06web.zoom.us/j/89109464581?pwd=QwgbTFUaz3AIDbuEqSBUBduUaNx861.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-04-23 16:00, The subject of the conference is 2024-4-23 openGauss TC会议, Summary: 请大家积极申报议题。 You can join the meeting at https://us06web.zoom.us/j/89109464581?pwd=QwgbTFUaz3AIDbuEqSBUBduUaNx861.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

2024.3.13 TC会议
by openGauss conference 05 Mar '24

05 Mar '24

您好！ TC 邀请您参加 2024-03-13 10:00 召开的zoom会议(自动录制) 会议主题：2024.3.13 TC会议会议内容：欢迎大家参加openGauss TC会议，如有议题请发送至 tc(a)opengauss.org 会议链接：https://us06web.zoom.us/j/85155825564?pwd=coNbOPPlYSZDRRsqrtPWbrWGbY9z0b.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-03-13 10:00, The subject of the conference is 2024.3.13 TC会议, Summary: 欢迎大家参加openGauss TC会议，如有议题请发送至 tc(a)opengauss.org You can join the meeting at https://us06web.zoom.us/j/85155825564?pwd=coNbOPPlYSZDRRsqrtPWbrWGbY9z0b.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

[Update] 智能参数调优插件评审
by openGauss conference 28 Feb '24

28 Feb '24

您好！ AI 邀请您参加 2024-02-29 15:00 召开的zoom会议会议主题：[Update] 智能参数调优插件评审会议链接：https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1 会议纪要：https://etherpad.opengauss.org/p/AI-meetings 更多资讯尽在：{portal_zh} Hello! AI invites you to attend the zoom conference will be held at 2024-02-29 15:00, The subject of the conference is [Update] 智能参数调优插件评审, You can join the meeting at https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1. Add topics at https://etherpad.opengauss.org/p/AI-meetings. More information: {portal_en}

1 0

[Update] 智能参数调优插件评审
by openGauss conference 28 Feb '24

28 Feb '24

您好！ AI 邀请您参加 2024-02-29 15:00 召开的zoom会议会议主题：[Update] 智能参数调优插件评审会议链接：https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1 会议纪要：https://etherpad.opengauss.org/p/AI-meetings 更多资讯尽在：{portal_zh} Hello! AI invites you to attend the zoom conference will be held at 2024-02-29 15:00, The subject of the conference is [Update] 智能参数调优插件评审, You can join the meeting at https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1. Add topics at https://etherpad.opengauss.org/p/AI-meetings. More information: {portal_en}

1 0

智能参数调优插件评审
by openGauss conference 27 Feb '24

27 Feb '24

您好！ AI 邀请您参加 2024-02-29 10:00 召开的zoom会议会议主题：智能参数调优插件评审会议内容：评审智能参数调优插件会议链接：https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1 会议纪要：https://etherpad.opengauss.org/p/AI-meetings 更多资讯尽在：{portal_zh} Hello! AI invites you to attend the zoom conference will be held at 2024-02-29 10:00, The subject of the conference is 智能参数调优插件评审, Summary: 评审智能参数调优插件 You can join the meeting at https://us06web.zoom.us/j/81103362334?pwd=hGknJfi25574SJArpRTIKNqilWXip9.1. Add topics at https://etherpad.opengauss.org/p/AI-meetings. More information: {portal_en}

1 0

2024/2/1 openGauss TC会议
by openGauss conference 30 Jan '24

30 Jan '24

您好！ TC 邀请您参加 2024-02-01 16:00 召开的zoom会议(自动录制) 会议主题：2024/2/1 openGauss TC会议会议内容：欢迎大家参加本次TC会议，已收集到一下议题，如有新增议题，请发送至tc(a)opengauss.org 1. openGauss SIG组运作规则对齐，汇报人：梅相如 2. openGauss社区Q1交付需求分工，汇报人：冯伟/熊小军 3. openGauss 24年版本需求规划，汇报人：杨艳明会议链接：https://us06web.zoom.us/j/84990843720?pwd=axtOobEsmTCPIcfcVJbjwno9QYRznO.1 会议纪要：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：{portal_zh} Hello! TC invites you to attend the zoom conference(auto recording) will be held at 2024-02-01 16:00, The subject of the conference is 2024/2/1 openGauss TC会议, Summary: 欢迎大家参加本次TC会议，已收集到一下议题，如有新增议题，请发送至tc(a)opengauss.org 1. openGauss SIG组运作规则对齐，汇报人：梅相如 2. openGauss社区Q1交付需求分工，汇报人：冯伟/熊小军 3. openGauss 24年版本需求规划，汇报人：杨艳明 You can join the meeting at https://us06web.zoom.us/j/84990843720?pwd=axtOobEsmTCPIcfcVJbjwno9QYRznO.1. Add topics at https://etherpad.opengauss.org/p/TC-meetings. More information: {portal_en}

1 0

2023-9-11 TC会议
by openGauss conference 05 Sep '23

05 Sep '23

您好！ openGauss TC SIG 邀请您参加 2023-09-11 09:30 召开的zoom会议(自动录制) 会议主题：2023-9-11 TC会议会议内容：会议议题： 1. 新增技术委员会成员评审；（南大通用吴明远、中国联通柴鹏、华为王磊） 2. 金融行业SIG成立评审； - （兴业银行李斌、熊小军）如果有新增议题，请发邮件至tc(a)opengauss.org 会议链接：https://us06web.zoom.us/j/87529603646?pwd=SEprRjRiSExUd0IwRGZ3NlFoVjFsdz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the zoom conference(auto recording) will be held at 2023-09-11 09:30, The subject of the conference is 2023-9-11 TC会议, Summary: 会议议题： 1. 新增技术委员会成员评审；（南大通用吴明远、中国联通柴鹏、华为王磊） 2. 金融行业SIG成立评审； - （兴业银行李斌、熊小军）如果有新增议题，请发邮件至tc(a)opengauss.org You can join the meeting at https://us06web.zoom.us/j/87529603646?pwd=SEprRjRiSExUd0IwRGZ3NlFoVjFsdz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

DeepSQL相关问题咨询
by coffeeandmilk 13 Jun '23

13 Jun '23

您好！我们根据openGauss 1.1.0官方文档，在实现其AI特性——DeepSQL的环境部署时，遇到了以下问题，想向您求教：将Madlib算法库安装到数据库，执行该命令时，提升-p platform没有openGauss选项./madpack -s <SCHEMA_NAME> -p opengauss -c <USER_NAME>(a)127.0.0.10.1:<PORT>/<DATABASE_NAME> install 我们对华为openGauss的DeepSQL有着浓厚的兴趣，希望您能对此有所答复，谢谢！

1 0

tc
by openGauss conference 25 May '23

25 May '23

您好！ openGauss TC SIG 邀请您参加 2023-05-25 14:00 召开的zoom会议(自动录制) 会议主题：tc 会议内容：欢迎大家参加5.25下午14:00 ~ 15:30号在openGauss开发者大会线下TC例会，收到海量晓涛总提交议题如下： 1、CM容器化部署问题：https://gitee.com/opengauss/openGauss-OM/issues/I65RJI#note_150… 2、支持固定Error Code的需求：https://gitee.com/opengauss/openGauss-server/issues/I717J5?from=pro… 3、社区文档缺失问题讨论如果有其他想讨论事项，欢迎继续申报会议链接：https://us06web.zoom.us/j/86786465809?pwd=SFpvY1RSR3d1Y0lUQ1l0Q1JvWmlKQT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the zoom conference(auto recording) will be held at 2023-05-25 14:00, The subject of the conference is tc, Summary: 欢迎大家参加5.25下午14:00 ~ 15:30号在openGauss开发者大会线下TC例会，收到海量晓涛总提交议题如下： 1、CM容器化部署问题：https://gitee.com/opengauss/openGauss-OM/issues/I65RJI#note_150… 2、支持固定Error Code的需求：https://gitee.com/opengauss/openGauss-server/issues/I717J5?from=pro… 3、社区文档缺失问题讨论如果有其他想讨论事项，欢迎继续申报 You can join the meeting at https://us06web.zoom.us/j/86786465809?pwd=SFpvY1RSR3d1Y0lUQ1l0Q1JvWmlKQT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

【邀请函】诚邀您参加 AI SIG 版本规划工作会议
by opengauss 24 May '23

24 May '23

尊敬的openGauss社区开发者，大家好 openGauss Developer Day 2023将在5月26日在北京昆泰嘉瑞文化中心召开。届时，AI SIG 将线下组织SIG版本规划工作会议，集中讨论用户需求、未来技术发展、工作任务分工等，在此诚邀您的参与。如想增加会议议题，请在此填写： https://etherpad.opengauss.org/p/2023ODD-sig-planning-AISIG SIG组版本规划工作会议@openGauss Developer Day2023 时间：2023年5月26日 16:00-17:30 地址：北京·昆泰嘉瑞文化中心参会请务必提前报名注册（https://e-campaign.huawei.com/m/6vaqiy），以便为您制作入场胸牌。现场闭门会议、各大技术论坛、SIG组会议、开发者派对、大会展区都需凭注册信息入场参与。温馨提醒：北京天气早晚温差较大，请注意及时增减衣物，健康工作，愉悦参会。

1 0

opengauss的问题
by 孙明慧 13 Mar '23

13 Mar '23

你好，希望能收到您的回复。我想问问opengauss3.1.1企业版，是不是不再有dbmind了，我发现app目录下没有这个目录。想利用那些ai工具，却不知道如何使用。

2 1

2023.3.14 TC会议
by openGauss conference 08 Mar '23

08 Mar '23

您好！ openGauss TC SIG 邀请您参加 2023-03-14 09:30 召开的Zoom会议(自动录制) 会议主题：2023.3.14 TC会议会议内容：请大家积极申报议题，谢谢会议链接：https://us06web.zoom.us/j/84749039722?pwd=aFhIbWt5M2M0WDkwblkzL0srQ1N1UT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2023-03-14 09:30, The subject of the conference is 2023.3.14 TC会议, Summary: 请大家积极申报议题，谢谢 You can join the meeting at https://us06web.zoom.us/j/84749039722?pwd=aFhIbWt5M2M0WDkwblkzL0srQ1N1UT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

fence模式配置 plpython 报错
by qinhao＠newland.com.cn 14 Feb '23

14 Feb '23

尝试 "全流程AI" 中的 "PLPython Fenced模式" 时，我编译opengauss（版本3.1.1）时已经加了 --with-python选项： ./configure --gcc-version=7.3.0 CC=g++ CFLAGS="-O2 -g3" --prefix=/mnt/disk01/OpenGauss/release-opengauss-server --3rd=/mnt/disk01/OpenGauss/openGauss-third_party_binarylibs_3.1.0 --enable-thread-safety --with-readline --without-zlib --enable-mot --with-python 然后也配置了 unix_socket_directory 启动后也看到了 ”gaussdb fenced UDF master process“ 使用python是从源码编译的3.8.2 ，安装了opengauss的3.1.1的psycopg2 但是尝试create extension时，报下面的错误，编译opengauss时，没有指定plpython为python2还是python3，也不知道怎么指定请问是还有哪一步我没做吗？ [postgres@qinh154 hadb-opengauss]$ ps -ef|grep gaussdb postgres 22400 1 3 15:27 ? 00:00:18 /mnt/disk01/hadb-opengauss/opengauss/bin/gaussdb -D _pg_root postgres 22448 22400 0 15:27 ? 00:00:00 gaussdb fenced UDF master process postgres 24957 19062 0 15:36 pts/0 00:00:00 grep --color=auto gaussdb [postgres@qinh154 hadb-opengauss]$ gsql -p5432 -h127.0.0.1 -WPostgres123 -r gsql ((openGauss 3.1.1 build 6eeaae6b) compiled at 2023-02-13 19:26:56 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. openGauss=# create extension plpython3u; ERROR: new language is not yet supported. openGauss=# create extension plpythonu; ERROR: could not open extension control file: No such file or directory openGauss=# 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 1

执行 gs_dbmind component xtuner train 报错
by qinhao＠newland.com.cn 11 Feb '23

11 Feb '23

你好，之前的错误是因为numpy的版本错误，纠正版本后，仍然有报错，如下：（一定要安装cuda库吗？我的机器是云上虚拟机，没有cuda设备） 2023-02-11 05:01:10.764147: E tensorflow/compiler/xla/stream_executor/cuda/cuda_driver.cc:267] failed call to cuInit: CUDA_ERROR_NO_DEVICE: no CUDA-capable device is detected 2023-02-11 05:01:10.764322: I tensorflow/compiler/xla/stream_executor/cuda/cuda_diagnostics.cc:156] kernel driver does not appear to be running on this host (qinh154): /proc/driver/nvidia/version does not exist numpy() is only available when eager execution is enabled. Traceback (most recent call last): File "/mnt/disk01/hadb-opengauss/opengauss/bin/dbmind/components/xtuner/tuner/main.py", line 262, in main return procedure_main(mode, db_info, config) File "/mnt/disk01/hadb-opengauss/opengauss/bin/dbmind/components/xtuner/tuner/xtuner.py", line 130, in procedure_main rl_model('train', env, config) File "/mnt/disk01/hadb-opengauss/opengauss/bin/dbmind/components/xtuner/tuner/xtuner.py", line 174, in rl_model rl = RLAgent(env, alg=config['rl_algorithm']) File "/mnt/disk01/hadb-opengauss/opengauss/bin/dbmind/components/xtuner/tuner/algorithms/rl_agent.py", line 33, in __init__ self.agent = self._build_ddpg(nb_actions, nb_states) File "/mnt/disk01/hadb-opengauss/opengauss/bin/dbmind/components/xtuner/tuner/algorithms/rl_agent.py", line 94, in _build_ddpg ddpg.compile(Adam(), metrics=['mae']) File "/mnt/disk01/hadb-opengauss/python3/lib/python3.8/site-packages/rl/agents/ddpg.py", line 79, in compile critic_optimizer = clone_optimizer(optimizer) File "/mnt/disk01/hadb-opengauss/python3/lib/python3.8/site-packages/rl/util.py", line 25, in clone_optimizer params = {k: v for k, v in optimizer.get_config().items()} File "/mnt/disk01/hadb-opengauss/python3/lib/python3.8/site-packages/keras/optimizers/optimizer_experimental/adam.py", line 207, in get_config "learning_rate": self._serialize_hyperparameter( File "/mnt/disk01/hadb-opengauss/python3/lib/python3.8/site-packages/keras/optimizers/optimizer_experimental/optimizer.py", line 718, in _serialize_hyperparameter return hyperparameter.numpy() 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

1 0

找不到libcudart.so.11.0、libnvinfer.so.7
by qinhao＠newland.com.cn 10 Feb '23

10 Feb '23

我在按照文档使用示例 61 (opengauss.org) 使用 x-tuner参数调优，执行train时打印下面错误，查网上的文章说要下载cuda库，但是好像很大有4G，要下载其它关联库，请问必须这样做吗？不使用GPU能不能不下载cuda库？ [postgres@qinh154 dbmind]$ gs_dbmind component xtuner train --db-name postgres --db-user postgres --port 5432 --host 172.32.148.154 --host-user postgres Please input the password of database: Please input the password of host: Start to recommend knobs. Just a moment, please. WARN: The database may restart several times during tuning, continue or not [yes|no]:yes The benchmark will start to run iteratively. This process may take a long time. Please wait a moment. 2023-02-10 11:51:59.940951: W tensorflow/compiler/xla/stream_executor/platform/default/dso_loader.cc:64] Could not load dynamic library 'libcudart.so.11.0'; dlerror: libcudart.so.11.0: cannot open shared object file: No such file or directory; LD_LIBRARY_PATH: /mnt/disk01/hadb-opengauss/opengauss/lib:/usr/lib/oracle/12.2/client64/lib:/mnt/disk01/install-R-dir/lib64/R/lib:/mnt/disk01/ogg-for-pg-21:/mnt/disk01/ogg-for-pg-21/lib:/mnt/disk01/milvus/lib: 2023-02-10 11:51:59.941060: I tensorflow/compiler/xla/stream_executor/cuda/cudart_stub.cc:29] Ignore above cudart dlerror if you do not have a GPU set up on your machine. 2023-02-10 11:52:02.460544: W tensorflow/compiler/xla/stream_executor/platform/default/dso_loader.cc:64] Could not load dynamic library 'libnvinfer.so.7'; dlerror: libnvinfer.so.7: cannot open shared object file: No such file or directory; LD_LIBRARY_PATH: /mnt/disk01/hadb-opengauss/opengauss/lib:/usr/lib/oracle/12.2/client64/lib:/mnt/disk01/install-R-dir/lib64/R/lib:/mnt/disk01/ogg-for-pg-21:/mnt/disk01/ogg-for-pg-21/lib:/mnt/disk01/milvus/lib: 2023-02-10 11:52:02.460982: W tensorflow/compiler/xla/stream_executor/platform/default/dso_loader.cc:64] Could not load dynamic library 'libnvinfer_plugin.so.7'; dlerror: libnvinfer_plugin.so.7: cannot open shared object file: No such file or directory; LD_LIBRARY_PATH: /mnt/disk01/hadb-opengauss/opengauss/lib:/usr/lib/oracle/12.2/client64/lib:/mnt/disk01/install-R-dir/lib64/R/lib:/mnt/disk01/ogg-for-pg-21:/mnt/disk01/ogg-for-pg-21/lib:/mnt/disk01/milvus/lib: 2023-02-10 11:52:02.461025: W tensorflow/compiler/tf2tensorrt/utils/py_utils.cc:38] TF-TRT Warning: Cannot dlopen some TensorRT libraries. If you would like to use Nvidia GPU with TensorRT, please make sure the missing libraries mentioned above are installed properly. 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 1

12.15 TC例会
by openGauss conference 12 Dec '22

12 Dec '22

您好！ openGauss TC SIG 邀请您参加 2022-12-15 10:00 召开的Zoom会议(自动录制) 会议主题：12.15 TC例会会议内容：议题1：ogtop工具介绍及发布形态 - 民生银行朱彬会议链接：https://us06web.zoom.us/j/88685745284?pwd=dkRnREpQVlFYcXozZzJBVks3ejg5dz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-12-15 10:00, The subject of the conference is 12.15 TC例会, Summary: 议题1：ogtop工具介绍及发布形态 - 民生银行朱彬 You can join the meeting at https://us06web.zoom.us/j/88685745284?pwd=dkRnREpQVlFYcXozZzJBVks3ejg5dz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

2022.9.14 openGauss TC例会
by openGauss conference 14 Sep '22

14 Sep '22

您好！ openGauss TC SIG 邀请您参加 2022-09-14 10:50 召开的Zoom会议(自动录制) 会议主题：2022.9.14 openGauss TC例会会议链接：https://us06web.zoom.us/j/83392226982?pwd=NXdPbVhlbGtWcFFsMUVBTWY2UmRIZz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-14 10:50, The subject of the conference is 2022.9.14 openGauss TC例会, You can join the meeting at https://us06web.zoom.us/j/83392226982?pwd=NXdPbVhlbGtWcFFsMUVBTWY2UmRIZz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

2022-9-14 openGauss TC例会
by openGauss conference 13 Sep '22

13 Sep '22

您好！ openGauss TC SIG 邀请您参加 2022-09-14 10:45 召开的WeLink会议(自动录制) 会议主题：2022-9-14 openGauss TC例会会议内容：会议议题： 1. openGauss支持FusionOS - 毕坤阳如果有其他议题，请提前发送tc(a)opengauss.org 会议链接：https://bmeeting.huaweicloud.com:36443/#/j/984931563 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the WeLink conference(auto recording) will be held at 2022-09-14 10:45, The subject of the conference is 2022-9-14 openGauss TC例会, Summary: 会议议题： 1. openGauss支持FusionOS - 毕坤阳如果有其他议题，请提前发送tc(a)opengauss.org You can join the meeting at https://bmeeting.huaweicloud.com:36443/#/j/984931563. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

2022.8.16 openGauss TC例会
by openGauss conference 10 Aug '22

10 Aug '22

您好！ openGauss TC SIG 邀请您参加 2022-08-16 16:00 召开的Zoom会议(自动录制) 会议主题：2022.8.16 openGauss TC例会会议内容：请大家踊跃申报TC议题，谢谢。会议链接：https://us06web.zoom.us/j/84673210503?pwd=bFFSY0NQK0FIdE1hbWZTZjEyT21BQT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-08-16 16:00, The subject of the conference is 2022.8.16 openGauss TC例会, Summary: 请大家踊跃申报TC议题，谢谢。 You can join the meeting at https://us06web.zoom.us/j/84673210503?pwd=bFFSY0NQK0FIdE1hbWZTZjEyT21BQT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

2024

2023

2022

2021