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
HI，
在PostgreSQL 早期（V10后这个函数改名为pg_last_wal_replay_lsn）版本中，pg_last_xlog_replay_location返回的结果是pg_lsn,也就是LSN位置。
以目前我所见来说：
在OG pg_last_xlog_replay_location返回的后面数字也是lsn，前面数字是内部term信号标记（目前来看这个信号的标记的其中一个作用是主备切换时候的判断）。
建议使用select * from pg_last_xlog_replay_location() 而非select pg_last_xlog_replay_location(),这样可以单独取到lsn列。
刘伟 云和恩墨
联系我
------------------ Original ------------------ From: "qinhao@newland.com.cn"<qinhao@newland.com.cn>; Date: Thu, Feb 17, 2022 01:51 PM To: "community"<community@opengauss.org>;
Subject: [Community] 函数 pg_last_xlog_replay_location() 的详细描述？
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
_______________________________________________ Community mailing list -- community@opengauss.org To unsubscribe send an email to community-leave@opengauss.org
感谢刘伟
pg_last_xlog_replay_location() 返回的是复合类型（term，lsn），(pg_last_xlog_replay_location()).lsn 这样正好得到我所需要的lsn部分。
openGauss=# select * from pg_last_xlog_replay_location(); term | lsn ------+----------- 1 | 0/2228040 (1 row)
openGauss=# select (pg_last_xlog_replay_location()).lsn; lsn ----------- 0/2228040 (1 row)
新大陆软件 秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn
发件人： 刘伟 发送时间： 2022-02-17 14:14 收件人： qinhao@newland.com.cn; community 主题： Re: [Community] 函数 pg_last_xlog_replay_location() 的详细描述？ HI，
在PostgreSQL 早期（V10后这个函数改名为pg_last_wal_replay_lsn）版本中，pg_last_xlog_replay_location返回的结果是pg_lsn,也就是LSN位置。
以目前我所见来说：
在OG pg_last_xlog_replay_location返回的后面数字也是lsn，前面数字是内部term信号标记（目前来看这个信号的标记的其中一个作用是主备切换时候的判断）。
建议使用select * from pg_last_xlog_replay_location() 而非select pg_last_xlog_replay_location(),这样可以单独取到lsn列。
刘伟 云和恩墨 联系我
------------------ Original ------------------ From: "qinhao@newland.com.cn"qinhao@newland.com.cn; Date: Thu, Feb 17, 2022 01:51 PM To: "community"community@opengauss.org; Subject: [Community] 函数 pg_last_xlog_replay_location() 的详细描述？
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
_______________________________________________ Community mailing list -- community@opengauss.org To unsubscribe send an email to community-leave@opengauss.org
我的opengauss运行日志狂打 Invalid channel id: 0.是怎么回事？
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
发件人： qinhao@newland.com.cn 发送时间： 2022-02-17 13:50 收件人： community 主题： 函数 pg_last_xlog_replay_location() 的详细描述？ 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
opengauss流复制备机，运行日志狂打 Invalid channel id: 0.是怎么回事？
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
-
qinhao＠newland.com.cn -
刘伟