Re: ERROR could not access transaction/Could not open file pg_commit_ts

2018-03-09 Thread Jerry Sievers
Alvaro Herrera writes: > Jeremy Finzel wrote: > >> UPDATE: what is actually failing is a call to >> pg_xact_commit_timestamp(xmin) on a given table under the view. We still >> think we must have some corruption though with pg_commit_ts. > > This is not a valid query, because the xmin may belong

Re: ERROR could not access transaction/Could not open file pg_commit_ts

2018-03-09 Thread Alvaro Herrera
Jeremy Finzel wrote: > UPDATE: what is actually failing is a call to > pg_xact_commit_timestamp(xmin) on a given table under the view. We still > think we must have some corruption though with pg_commit_ts. This is not a valid query, because the xmin may belong to a frozen tuple. pg_commit_ts d

Re: ERROR could not access transaction/Could not open file pg_commit_ts

2018-03-09 Thread Jeremy Finzel
On Fri, Mar 9, 2018 at 10:43 AM, Jeremy Finzel wrote: > Hello - > > Here is our cluster setup: > > cluster_a 9.5.11 Ubuntu 16.04.4 LTS > --> cluster_b (streamer) 9.5.11 Ubuntu 16.04.4 LTS > --> cluster_c (streamer) 9.5.11 Ubuntu 16.04.4 LTS > > Very recently, we started seeing these errors when

ERROR could not access transaction/Could not open file pg_commit_ts

2018-03-09 Thread Jeremy Finzel
Hello - Here is our cluster setup: cluster_a 9.5.11 Ubuntu 16.04.4 LTS --> cluster_b (streamer) 9.5.11 Ubuntu 16.04.4 LTS --> cluster_c (streamer) 9.5.11 Ubuntu 16.04.4 LTS Very recently, we started seeing these errors when running a query on a specific table on the streamer: 2018-03-09 08:28