BUG #16009: ERROR:  found xmax 1245512970 from before relfrozenxid 1245512975

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)"

Browse pgsql-bugs by date

  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