Re: High table creation rate results in “File exists” error

Поиск
Список
Период
Сортировка
От Ruud van Asseldonk
Тема Re: High table creation rate results in “File exists” error
Дата
Msg-id CAAqqbi=V60Wxjy3VP94HV3sfi__Yse+bzV0=7S+5Rw5W2xUmKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High table creation rate results in “File exists” error  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-bugs
Hi, thanks for looking into this!

On Wed, 22 Jan 2020 at 18:07, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
>
> So what was the actual rate of table creation? How long did it take to
> get to this state?

Currently we create tables at about 1.8 Hz. We drop them at the same
rate, almost all tables are short-lived (between 1d and 1h). We
started seeing this error roughly 1.5 years after we started using
this system, but in the beginning the rate was not as high as it is
now.

I don’t have all historical occurrences at hand, but in the past 14
days, the error has occurred twice.

> What kernel/filesystem was used? What did lsof say?

We use kernel 4.15.0-1036-gcp and the file system is ext4. Lsof does
not currently list the file in the most recent error message, but I
don't know what the state was at the time of the error.

Best,
Ruud



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16226: background worker "logical replication worker" (PID ) was terminated by signal 11: Segmentation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 12.1 Partitioned Table Creation Bug