From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | zn1314(at)126(dot)com |
Subject: | BUG #16009: ERROR: found xmax 1245512970 from before relfrozenxid 1245512975 |
Date: | 2019-09-17 09:27:57 |
Message-ID: | 16009-bd375c00ca00d682@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16009
Logged by: david ni
Email address: zn1314(at)126(dot)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)"
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-09-17 15:47:19 | BUG #16010: Unexpected reordering of WHERE clause operations and SELECT list function calls |
Previous Message | Tom Lane | 2019-09-16 13:54:55 | Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return |