- Community - mailweb.opengauss.org

生成 uuid 的函数
by qinhao＠newland.com.cn 09 Mar '22

09 Mar '22

Hi OG有没有生成uuid的函数？原来PG里用pgcrypto扩展，OG也支持这个扩展吗？或是有别的函数？新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

3 2

支持SATA 机械硬盘
by LoFi 08 Mar '22

08 Mar '22

 Hi, 请问opengauss 在机械硬盘上部署的性能怎么样？与mysql 对比过么？谢谢！

1 0

opengauss 时间线没有变化
by qinhao＠newland.com.cn 08 Mar '22

08 Mar '22

Hi 我们在测试 opengauss 时，发现 wal 日志的时间线从来不会改变，无论主备切换还是人为产生的主机故障，恢复后 timeline 仍然是 1， opengauss的 wal 日志的时间线是不会变化的吗？还是我的配置有问题呢？新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

1 0

开源版 Opengauss 不支持 MOT？
by qinhao＠newland.com.cn 04 Mar '22

04 Mar '22

Hi 今天在使用从开源代码编译出的opengauss时，发现没有MOT的功能和相关的文件，请问一下，开源代码里没有MOT吗？开源版opengauss不支持MOT吗？新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 2

【openGauss Knowledge Graph SIG组筹备邀约】
by xuezhongbin 25 Feb '22

25 Feb '22

各位开发者，社区准备筹备成立Konwledge Graph SIG组，当前筹备组成员有北大的邹磊教授及部分企业成员，各位若感兴趣可以进一步报名，欢迎大家积极参与！薛忠斌

1 0

运行日志狂打 LOG: Invalid channel id: 0.
by qinhao＠newland.com.cn 24 Feb '22

24 Feb '22

我的opengauss运行日志狂打 Invalid channel id: 0.是怎么回事？主机上没有打印，猜测是replication心跳相关，但是文档找不到，谁能给科普一下。 2022-02-23 17:39:55.558 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.559 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.560 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.561 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.562 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.563 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.564 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.565 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.567 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.568 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.569 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.570 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.571 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.572 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.573 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.574 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.576 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.577 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.578 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.579 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.580 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.581 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.582 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.583 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.585 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.586 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.587 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.588 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.589 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.590 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.591 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.592 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.594 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.595 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.596 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 2022-02-23 17:39:55.597 [unknown] [unknown] localhost 140362097026816 0[0:0#0] 0 [BACKEND] LOG: Invalid channel id: 0. 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

1 0

函数 pg_last_xlog_replay_location() 的详细描述？
by qinhao＠newland.com.cn 24 Feb '22

24 Feb '22

Hi，在opengauss上pg_catalog.pg_last_xlog_replay_location()返回的结果是： pg_last_xlog_replay_location ------------------------------ (1,0/2250D10) (1 row) 与postgresql对应的函数返回结果的格式不一样，(1,0/2250D10) 是个复合类型吗？如果是，那么复合类型的成员都是什么名字？如何在SQL中只获得 0/2250D10 这部分？我找不到opengauss关于pg_last_xlog_replay_location()函数的详细文档。新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 4

关于PR的审批
by LeYi Zhang 19 Feb '22

19 Feb '22

Hi community 如下一些提交的PR，有些已经过了较长时间了，PR如果长期无法审核通过，并且也没有提供修改建议，会阻塞后续的相关代码研发工作。还请拥有代码合入权限的相关committer关注一下，非常感谢。 PR所在仓库 PR链接 PR说明 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1273 绑核参数解析错误 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1300 修复t_thrd.shemem_ptr_cxt.XLogCtl中的一些变量未被info_lck锁包含问题 openGauss-connector-go-pq https://gitee.com/opengauss/openGauss-connector-go-pq/pulls/6 1. 支持SM3密码认证 2. 解决多IP连接Bug 3. 增加target_session_attrs属性值 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1301 修复truncate分区时出现的死锁问题 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1352 修复快排算法缺陷，导致某些场景下的栈溢出 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1457 修改问题：初始化后，系统表pg_proc的provariadic为无效值 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1473 解决配置用户限额时，truncate等不能减低使用空间的问题 openGauss-server https://gitee.com/opengauss/openGauss-server/pulls/1517 修正SPI受自定义解析器影响而导致PL/pgSQL在启用自定义解析器时可能导致非逾期结果的问题 openGauss-tools-onlineMigration https://gitee.com/opengauss/openGauss-tools-onlineMigration/pulls/9 鲲鹏众智-opengauss-oracle 在线迁移DDL1 需求代码 -- Kamus <kamusis(a)gmail.com>

3 2

Re: gsql输入时，不支持左右移动光标？
by qinhao＠newland.com.cn 10 Feb '22

10 Feb '22

很管用，谢谢！新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

1 0

gsql输入时，不支持左右移动光标？
by qinhao＠newland.com.cn 10 Feb '22

10 Feb '22

我编译的opengauss，登入gsql，怎么不支持左右移动输入光标？怎样才能支持？只能支持backspace 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 1

2025

2024

2023

2022

2021

2020

Community