panwei gs_sdr 之[GAUSS-51632] : Failed to checking disaster user, please confirm disaster user is exist

1、环境

操作系统： "BigCloud Enterprise Linux 8.2 (Core)"

panwei 版本： PanWeiDB_V2.0-S2.0.2_B01

2、现象

[omm@vdb1 soft]$ gs_sdr -t start -m primary -X /database/panweidb/soft/cluster_config_sdr.xml  -U sdr_test -W sdr3@test
--------------------------------------------------------------------------------
Streaming disaster recovery start dba1f700c3a211f08f4d000c29de5dfd
--------------------------------------------------------------------------------
Start create streaming disaster relationship.
Got the step for action:[start].
Start checking disaster recovery user.
[GAUSS-51632] : Failed to checking disaster user, please confirm disaster user is exist and with replication role together without superuser.Users:[('omm', '1', '1'), ('pwadmin', '1', '1'), ('pwsso', '0', '0'), ('pwaudit', '0', '0'), ('sdr_test', '1', '0')]

3、此为数据库查询出来的值与脚本中的值不匹配

[omm@vdb1 soft]$ gsql -r -c "select usename, userepl, usesuper from pg_user;"
 usename  | userepl | usesuper 
----------+---------+----------
 omm      | 1       | 1
 pwadmin  | 1       | 1
 pwsso    | 0       | 0
 pwaudit  | 0       | 0
 sdr_test | 1       | 0
(5 rows)


而代码中使用bool值作为条件的

4、解决，修改script/impl/streaming_disaster_recovery/streaming_base.py文件中第268行代码中的t 为1 ，f 为0，并删除缓存文件

修改
vim +268 /database/panweidb/tool/script/impl/streaming_disaster_recovery/streaming_base.py
if user_name == self.params.hadrUserName and repl == 'f' and superuser == 't':
为
if user_name == self.params.hadrUserName and repl == '1' and superuser == '0':


rm /database/panweidb/tool/script/impl/streaming_disaster_recovery/__pycache__/streaming_base.cpython-36.pyc

5、重试

[omm@vdb1 tool]$ gs_sdr -t start -m primary -X /database/panweidb/soft/cluster_config_sdr.xml  -U sdr_test -W sdr3@test
--------------------------------------------------------------------------------
Streaming disaster recovery start 7e1b20a6c3a311f0bf62000c29de5dfd
--------------------------------------------------------------------------------
Start create streaming disaster relationship.
Got the step for action:[start].
Start checking disaster recovery user.
Successfully check disaster recovery user.
Start generate hadr key files.
Finished generate and distribute hadr key files.
Start encrypt hadr user info.
Successfully encrypt hadr user info.
Start save hadr user info into database.
Successfully save hadr user info into database.
Successfully check cluster status is: Normal.
Successfully check instance status.
Start update pg_hba config.
Successfully update pg_hba config.
Start prepare secure files.
Start copy hadr user key files.
Successfully copy secure files.
Starting reload wal_keep_segments value: 16384.
Successfully reload wal_keep_segments value: 16384.
Successfully set [/omm/CMServer/backup_open][0].
Waiting for the main standby connection.