作者小头像 Lv.1
52 成长值

个人介绍

这个人很懒,什么都没有留下

感兴趣或擅长的领域

暂无数据
个人勋章
TA还没获得勋章~
成长雷达
25
27
0
0
0

个人资料

个人介绍

这个人很懒,什么都没有留下

感兴趣或擅长的领域

暂无数据

达成规则

发布时间 2022-02-19 18:40:25 最后回复 五湖四海@银河护卫队 2022-02-23 18:40:25 版块 Database
1818 5 0
发布时间 2022-02-19 18:40:25 最后回复 五湖四海@银河护卫队 2022-02-23 18:40:25 版块 Database
1818 5 0
发布时间 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