Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large
Date
Msg-id CAKFQuwYPEdo_AS5NWp5wi40hqQOchs=E0qaK4HGZb3=d19Utng@mail.gmail.com
Whole thread Raw
In response to BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large  (prikshat@cadence.com)
Responses Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large
List pgsql-bugs
On Fri, Aug 5, 2016 at 2:41 AM, <prikshat@cadence.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14280
> Logged by:          Prikshat Heera
> Email address:      prikshat@cadence.com
> PostgreSQL version: 9.2.16
> Operating system:   Linux
> Description:
>
> A table has 400 columns. While inserting data into this table, We are
> getting the error - "could not extend file "base/16385/16872": File too
> large".
> After that, we vacuumm'ed and reindex'ed the table and insert worked fine=
.
> Please evaluate and let us know if this has been fixed in 9.3 ?
>

=E2=80=8BMost likely whatever "it" is has not been fixed.  9.2 is still act=
ive =E2=80=8Bso
any fix would have been back-patched to it.  If "the problem" goes away in
9.3 is would be purely coincidental.

With the information provided diagnostics seems problematic - since it
would likely first require getting a machine into the failing mode which
your's no longer is and there is no obvious reproduction approach.

Which Linux?

Possibly a bit more guessing could be had from someone knowledgeable with
the code surrounding that error path but this is awfully light, transient,
and potentially machine specific, to track down.  Working toward
reproduction or posting back while the machine is failing (if it ever comes
up again) seem like necessary next steps.

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: jsonb_array_elements issue
Next
From: Tom Lane
Date:
Subject: Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large