February 2022 - Community - mailweb.opengauss.org

【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

编译最简版本的OpenGauss
by qinhao＠newland.com.cn 08 Feb '22

08 Feb '22

大家好我们最近在尝试使用Opengauss，但是编译时有太多第三方依赖，复杂的编译过程，对于开发者极不友好，我们并不需要那么全面的功能，能否给用户一个最简版本的编译指导，包括线程和64位事务id特性，其它需要的时候再增加？如何做？新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 3

2024

2023

2022

2021

2020

Community February 2022