- AI - mailweb.opengauss.org

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

2023

2022

2021