Thread: BUG #16009: ERROR: found xmax 1245512970 from before relfrozenxid 1245512975
BUG #16009: ERROR: found xmax 1245512970 from before relfrozenxid 1245512975
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 16009 Logged by: david ni Email address: zn1314@126.com PostgreSQL version: 10.4 Operating system: CentOS Linux release 7.3.1611 (Core) Description: 1,autovaccum is not triggered relid | 26342 schemaname | hengtian_gb_bj relname | tu_login seq_scan | 1 seq_tup_read | 13823 idx_scan | 1347432 idx_tup_fetch | 1347420 n_tup_ins | 12 n_tup_upd | 673710 n_tup_del | 0 n_tup_hot_upd | 672658 n_live_tup | 13831 n_dead_tup | 1634 n_mod_since_analyze | 1322 last_vacuum | 2019-09-10 18:01:56.326208+08 last_autovacuum | last_analyze | 2019-09-10 18:01:57.632177+08 last_autoanalyze | 2019-09-17 15:26:43.607952+08 vacuum_count | 2 autovacuum_count | 0 analyze_count | 1 autoanalyze_count | 455 hengtian_tsp_prod=# show autovacuum; -[ RECORD 1 ]-- autovacuum | on hengtian_tsp_prod=# show autovacuum_vacuum_threshold; -[ RECORD 1 ]---------------+--- autovacuum_vacuum_threshold | 50 hengtian_tsp_prod=# show autovacuum_vacuum_scale_factor ; -[ RECORD 1 ]------------------+---- autovacuum_vacuum_scale_factor | 0.2 2,vacuum scheduled.qrtz_locks ; ERROR: found xmax 1245512970 from before relfrozenxid 1245512975 table can not be vacuumed 3,I want to subscribe the mailing list,go to https://lists.postgresql.org,click "Manage subscriptions",then returns "Server Error(500)"