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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large
Дата
Msg-id CAKFQuwYPEdo_AS5NWp5wi40hqQOchs=E0qaK4HGZb3=d19Utng@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large  (prikshat@cadence.com)
Ответы Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: jsonb_array_elements issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14280: Error in PostgreSQL - could not extend file "base...": File too large