High table creation rate results in “File exists” error

Hi,

We occasionally run into an internal error when creating tables. The error
message is «could not create file "base/17006/2851173576": File exists»
with SQLSTATE 58P02. The attachment is included with this email contains
the PostgreSQL logs. Note that some identifiers are renamed in the logs
because they contain sensitive information, but identifier names are
unlikely the source of the error.

An old mailing list thread [1] suggests a problem related to OID
wraparound. Our use case involves creating and dropping thousands of tables
every day. The CREATE TABLE statements for these tables are similar to the
one in the attached logs, but with different table names and columns.
Nonetheless, the error is difficult to reproduce as it happens only
sporadically. Retrying the CREATE TABLE statement fixes the problem
temporarily.

Some more information about our PostgreSQL instance and usage:

- PostgreSQL version: PostgreSQL 10.6 (Ubuntu 10.6-1.pgdg16.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0
20160609, 64-bit.
- The DBMS did not crash or abruptly shut down recently.
- The file base/17006/2851173576 was actually in use by an index, as
indicated by pg_class.relfilenode.
- Autovacuum is disabled for these tables. Logging is disabled for these
tables upon creation, but enabled after filling them with data.
- The query “SELECT max(oid) FROM pg_class” reports 4,294,603,797, which
is close to 2³² - 1.

Kind regards,

Radek Slupik
Channable

[1]:
https://www.postgresql.org/message-id/CAP_rwwmVcFqZJ72WkyxcFrGPY6XpDSUj_UrxfCMnRYT4hCGfBg%40mail.gmail.com