Postgres Pro
Downloads
Home   >   mailing lists

Thread: record with incorrect prev-link

record with incorrect prev-link

From
Philippe Rimbault
Date:
Hi,

I'm testing Hot standby with streaming on 9.0RC1 (Debian testing).

I've found this message in my server log (on the standby server) :
...
2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
1/798BDFC4 at 1/7B8BE010
2010-09-14 11:10:51 CEST ( )FATAL:  terminating walreceiver process due
to administrator command
cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
fichier ou dossier de ce type
2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
1/798BDFC4 at 1/7B8BE010
cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
fichier ou dossier de ce type
2010-09-14 11:10:51 CEST ( )LOG:  streaming replication successfully
connected to primary
...
(i'm french, the message "Aucun fichier ou dossier de ce type" = "no
such file or directory")

There is no error on the primary server.

I've google and search archive, but i can't find any reason for this
message.
All work fine, but i'm curious to understand :)

Thx.

Philippe

Re: record with incorrect prev-link

From
Bernd Helmle
Date:

--On 14. September 2010 11:42:45 +0200 Philippe Rimbault <primbault@edd.fr>
wrote:

> I've found this message in my server log (on the standby server) :
> ...
> 2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
> 1/798BDFC4 at 1/7B8BE010
> 2010-09-14 11:10:51 CEST ( )FATAL:  terminating walreceiver process due
> to administrator command
> cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
> fichier ou dossier de ce type
> 2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
> 1/798BDFC4 at 1/7B8BE010
> cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
> fichier ou dossier de ce type
> 2010-09-14 11:10:51 CEST ( )LOG:  streaming replication successfully
> connected to primary
> ...
> (i'm french, the message "Aucun fichier ou dossier de ce type" = "no such
> file or directory")

Maybe i'm wrong, but if I understand the code correctly this could mean
that the walreceiver got a corrupted wal record, was shut down and the
retry code retried recovering from the archive. Just guessing, but maybe
there are issues with your network connectivity involved? Are you keeping
getting such errors?

--
Thanks

    Bernd

Re: record with incorrect prev-link

From
Philippe Rimbault
Date:
On 14/09/2010 17:55, Bernd Helmle wrote:
>
>
> --On 14. September 2010 11:42:45 +0200 Philippe Rimbault
> <primbault@edd.fr> wrote:
>
>> I've found this message in my server log (on the standby server) :
>> ...
>> 2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
>> 1/798BDFC4 at 1/7B8BE010
>> 2010-09-14 11:10:51 CEST ( )FATAL:  terminating walreceiver process due
>> to administrator command
>> cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
>> fichier ou dossier de ce type
>> 2010-09-14 11:10:51 CEST ( )LOG:  record with incorrect prev-link
>> 1/798BDFC4 at 1/7B8BE010
>> cp: impossible d'évaluer « /opt/wal/00000001000000010000007B »: Aucun
>> fichier ou dossier de ce type
>> 2010-09-14 11:10:51 CEST ( )LOG:  streaming replication successfully
>> connected to primary
>> ...
>> (i'm french, the message "Aucun fichier ou dossier de ce type" = "no
>> such
>> file or directory")
>
> Maybe i'm wrong, but if I understand the code correctly this could
> mean that the walreceiver got a corrupted wal record, was shut down
> and the retry code retried recovering from the archive. Just guessing,
> but maybe there are issues with your network connectivity involved?
> Are you keeping getting such errors?
>
No more error at this time ...