2022-07-06 15:04:46.739 62c5279c.5068 postgres 281457772402032 WDRSnapshot 209240703 dn_6001_6002 08001 5066549580791808 [BACKEND] CONTEXT: SQL statement "insert into snapshot.snap_global_statio_all_indexes(snapshot_id, db_name, "snap_node_name" , "snap_relid" , "snap_indexrelid" , "snap_schemaname" , "snap_relname" , "snap_indexrelname" , "snap_idx_blks_read" , "snap_idx_blks_hit" ) select snapshot_id, dbname1, "snap_node_name" , "snap_relid" , "snap_indexrelid" , "snap_schemaname" , "snap_relname" , "snap_indexrelname" , "snap_idx_blks_read" , "snap_idx_blks_hit" from wdr_xdb_query('dbname=dcep_acq_db'::text, 'select 18142, ''dcep_acq_db'', t.* from dbe_perf.global_statio_all_indexes t'::text) as i(snapshot_id int8, dbname1 text, "snap_node_name" name, "snap_relid" oid, "snap_indexrelid" oid, "snap_schemaname" name, "snap_relname" name, "snap_indexrelname" name, "snap_idx_blks_read" numeric, "snap_idx_blks_hit" numeric)"
2022-07-06 15:04:46.739 62c5279c.5068 postgres 281457772402032 WDRSnapshot 209240703 dn_6001_6002 01000 5066549580791808 [BACKEND] WARNING: WDR snapshot failed
自己解决了，原因就是pg_hba.conf这里本机的这条权限给注释掉了，解注释后正常，可以生成wdr了
参考连接：
https://bbs.huaweicloud.com/forum/forum.php?mod=viewthread&tid=179717&ordertype=2&page=2
评论
有用 0
补充关键日志：
2022-07-06 14:58:46.730 62c5279c.5068 postgres 281457772402032 WDRSnapshot 209240673 dn_6001_6002 00000 5066549580791808 [BACKEND] CONTEXT: SQL statement "insert into snapshot.snap_global_statio_all_indexes(snapshot_id, db_name, "snap_node_name" , "snap_relid" , "snap_indexrelid" , "snap_schemaname" , "snap_relname" , "snap_indexrelname" , "snap_idx_blks_read" , "snap_idx_blks_hit" ) select snapshot_id, dbname1, "snap_node_name" , "snap_relid" , "snap_indexrelid" , "snap_schemaname" , "snap_relname" , "snap_indexrelname" , "snap_idx_blks_read" , "snap_idx_blks_hit" from wdr_xdb_query('dbname=dcep_acq_db'::text, 'select 18136, ''dcep_acq_db'', t.* from dbe_perf.global_statio_all_indexes t'::text) as i(snapshot_id int8, dbname1 text, "snap_node_name" name, "snap_relid" oid, "snap_indexrelid" oid, "snap_schemaname" name, "snap_relname" name, "snap_indexrelname" name, "snap_idx_blks_read" numeric, "snap_idx_blks_hit" numeric)"
2022-07-06 14:58:46.803 62c532a6.4918 dcep_acq_db 281452314695024 dn_6001 0 dn_6001_6002 28000 0 [BACKEND] FATAL: Forbid remote connection with initial user.
2022-07-06 14:58:46.808 62c532a6.4918 dcep_acq_db 281452314695024 dn_6001 0 dn_6001_6002 28000 0 [BACKEND] FATAL: Forbid remote connection with initial user.
评论 有用 0
墨值悬赏