Re: Fwd: Cluster "stuck" in "not accepting commands to avoid wraparound data loss"

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Fwd: Cluster "stuck" in "not accepting commands to avoid wraparound data loss"
Дата
Msg-id 20151217182023.GD2224@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Fwd: Cluster "stuck" in "not accepting commands to avoid wraparound data loss"  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Fwd: Cluster "stuck" in "not accepting commands to avoid wraparound data loss"  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 2015-12-17 13:08:15 -0500, Robert Haas wrote:
> On Thu, Dec 17, 2015 at 12:14 PM, Andres Freund <andres@anarazel.de> wrote:
> > On 2015-12-17 09:04:25 -0800, Jeff Janes wrote:
> >> > But I'm somewhat confused what this has to do with Andres's report.
> >>
> >> Doesn't it explain the exact situation he is in, where the oldest
> >> database is 200 million, but the cluster as a whole is 2 billion?
> >
> > There were no crashes, so no, I don't think so.
> 
> Backing up a step, do we think that the fact that this was running in
> a shell rather than a screen is relevant somehow?  Or did something
> happen to this particular cluster totally unrelated to that?

I reran the whole thing on a separate, but very similar, VM. Just
checked. Same thing happened. This time I have log files and
everything. No time to investigate right now, but it's reproducible if
you accept running tests for a week or so.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Freeze avoidance of very large table.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: PATCH: postpone building buckets to the end of Hash (in HashJoin)