Lv.1
个人资料
个人介绍
这个人很懒，什么都没有留下
感兴趣或擅长的领域
暂无数据
![]()
以上满足项可达成此勋章
发布时间
2022-01-25 20:10:10
最后回复
多米诺的古牌
2022-02-19 20:10:10
版块
Database
2121
6
1
发布时间
2022-02-18 16:28:56
最后回复
miguel2
2022-02-18 16:28:56
版块
Database
1515
4
0
发布时间
2022-02-18 16:28:56
最后回复
miguel2
2022-02-18 16:28:56
版块
Database
1515
4
0
发布时间
2022-02-16 18:00:37
最后回复
miguel2
2022-02-18 18:00:37
版块
Database
2222
11
0
发布时间
2022-02-16 18:00:37
最后回复
miguel2
2022-02-18 18:00:37
版块
Database
2222
11
0
发布时间
2022-02-16 18:00:37
最后回复
miguel2
2022-02-18 18:00:37
版块
Database
2222
11
0
他的回复:
确实有点异常 ，似乎是 wdr report 用户连接有问题
2022-02-18 10:46:09.441 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 0 dn_6001 00000 562949953421340 LOG: WDR snapshot start2022-02-18 10:46:09.444 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 00000 562949953421340 LOG: old system table pg_cast does not have castowner column, use old default permission2022-02-18 10:46:09.444 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 00000 562949953421340 CONTEXT: SQL statement "INSERT INTO snapshot.snap_global_record_reset_time(snapshot_id, "snap_node_name" , "snap_reset_time" ) select 994, "node_name" , "reset_time" from dbe_perf.global_record_reset_time"2022-02-18 10:46:09.490 620f0871.5042 tpcc1w 46996744308480 dn_6001 0 dn_6001 28000 0 FATAL: Forbid remote connection with initial user.2022-02-18 10:46:09.494 620f0871.5042 tpcc1w 46996244137728 dn_6001 0 dn_6001 28000 0 FATAL: Forbid remote connection with initial user.2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 ERROR: could not establish connection2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 DETAIL: FATAL: Forbid remote connection with initial user. FATAL: Forbid remote connection with initial user.
2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 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=tpcc1w'::text, 'select 994, ''tpcc1w'', 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-02-18 10:46:09.495 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 01000 562949953421340 WARNING: WDR snapshot failed2022-02-18 10:46:19.093 620f087b.5042 postgres 46996244137728 Clean Statement thread 0 dn_6001 00000 0 LOG: clean statement thread start
发布时间
2022-02-16 18:00:37
最后回复
miguel2
2022-02-18 18:00:37
版块
Database
2222
11
0
他的回复:
看 pg_log 有一句日志跟这个有关
2022-02-18 10:45:54.589 620e1e4c.6129 46995706218240 dn_6001 0 dn_6001 00000 0 LOG: will update control file (create checkpoint), shutdown:02022-02-18 10:45:54.591 620e1e4c.6129 46995706218240 dn_6001 0 dn_6001 00000 0 LOG: attempting to remove WAL segments older than log file 0000000100000123000000F02022-02-18 10:46:09.441 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 0 dn_6001 00000 562949953421340 LOG: WDR snapshot start2022-02-18 10:46:09.444 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 00000 562949953421340 LOG: old system table pg_cast does not have castowner column, use old default permission2022-02-18 10:46:09.444 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 00000 562949953421340 CONTEXT: SQL statement "INSERT INTO snapshot.snap_global_record_reset_time(snapshot_id, "snap_node_name" , "snap_reset_time" ) select 994, "node_name" , "reset_time" from dbe_perf.global_record_reset_time"2022-02-18 10:46:09.490 620f0871.5042 tpcc1w 46996744308480 dn_6001 0 dn_6001 28000 0 FATAL: Forbid remote connection with initial user.2022-02-18 10:46:09.494 620f0871.5042 tpcc1w 46996244137728 dn_6001 0 dn_6001 28000 0 FATAL: Forbid remote connection with initial user.2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 ERROR: could not establish connection2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 DETAIL: FATAL: Forbid remote connection with initial user. FATAL: Forbid remote connection with initial user.
2022-02-18 10:46:09.494 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 08001 562949953421340 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=tpcc1w'::text, 'select 994, ''tpcc1w'', 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-02-18 10:46:09.495 620e1e4c.5067 postgres 46996039145216 WDRSnapshot 37513 dn_6001 01000 562949953421340 WARNING: WDR snapshot failed2022-02-18 10:46:19.093 620f087b.5042 postgres 46996244137728 Clean Statement thread 0 dn_6001 00000 0 LOG: clean statement thread start~
发布时间
2022-02-16 18:00:37
最后回复
miguel2
2022-02-18 18:00:37
版块
Database
2222
11
0