Обсуждение: Space Related Errors in Postgres 10.4 Logical Replication

Поиск
Список
Период
Сортировка

Space Related Errors in Postgres 10.4 Logical Replication

От
pavan95
Дата:
Hi all,

I have configured Postgres Native Logical Replication for 2 servers(a
publisher and subscriber). I have came across a new error in the postgres
log file as shown as below:

*PUBLISHER LOG:*
*2018-08-20 10:34:55.801 IST [24955] user@db ERROR:  could not create
directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space left on
device *
*2018-08-20 10:34:56.036 IST [34222] user@db ERROR:  could not create file
"pg_replslot/mysub/state.tmp": No space left on device*
*2018-08-20 10:34:56.053 IST [23444] user@db WARNING:  could not create
relation-cache initialization file "global/pg_internal.init.11331": No space
left on device*
*2018-08-20 10:34:56.053 IST [23444] user@db DETAIL:  Continuing anyway, but
there's something wrong.*

My questions are: 
1) why has the error occurred?
2) What is the immediate to do task to reduce this error?
3) How to prevent it's forthcoming occurrence (or) How to make changes to
reduce this error?

This is my first Logical Replication setup. Kindly help me with these
issues..

Thanks in Advance.


Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


Re: Space Related Errors in Postgres 10.4 Logical Replication

От
pavan95
Дата:
Hi all,

Looking forward to hear from you regarding the above errors.

Thanks in advance.

Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html


Re: Space Related Errors in Postgres 10.4 Logical Replication

От
Christoph Berg
Дата:
Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com>
> *PUBLISHER LOG:*
> *2018-08-20 10:34:55.801 IST [24955] user@db ERROR:  could not create
> directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space left on
> device *

This is simply what it says: your disk was full. You need to make sure
PG has enough free disk space available.

Christoph


Re: Space Related Errors in Postgres 10.4 Logical Replication

От
Pavan Teja
Дата:
But enough space was available. Don't know why it occurred.

Regards,
Pavan

On Tue, Aug 28, 2018, 12:08 AM Christoph Berg <myon@debian.org> wrote:
Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com>
> *PUBLISHER LOG:*
> *2018-08-20 10:34:55.801 IST [24955] user@db ERROR:  could not create
> directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space left on
> device *

This is simply what it says: your disk was full. You need to make sure
PG has enough free disk space available.

Christoph

Re: Space Related Errors in Postgres 10.4 Logical Replication

От
Mark Kirkwood
Дата:
Maybe check if you have any quotas set up that might be limiting the 
space available. Alternatively it might just be that the space required 
is bigger than you think (i.e usage grows so fast that casual monitoring 
does not pick it up).

regards

Mark


On 28/08/18 06:58, Pavan Teja wrote:
> But enough space was available. Don't know why it occurred.
>
> Regards,
> Pavan
>
> On Tue, Aug 28, 2018, 12:08 AM Christoph Berg <myon@debian.org 
> <mailto:myon@debian.org>> wrote:
>
>     Re: pavan95 2018-08-20 <1534743876524-0.post@n3.nabble.com
>     <mailto:1534743876524-0.post@n3.nabble.com>>
>     > *PUBLISHER LOG:*
>     > *2018-08-20 10:34:55.801 IST [24955] user@db ERROR: could not create
>     > directory "pg_replslot/mysub_14211111_sync_111111.tmp": No space
>     left on
>     > device *
>
>     This is simply what it says: your disk was full. You need to make sure
>     PG has enough free disk space available.
>
>     Christoph
>