pg.ddx.io pgsql-testers@postgresql.org mailing list archive
help / color / mirror / Atom feedrecord with incorrect prev-link
3+ messages / 2 participants
[nested] [flat]
* record with incorrect prev-link
@ 2010-09-14 09:42 Philippe Rimbault <primbault@edd.fr>
2010-09-14 15:55 ` Re: record with incorrect prev-link Bernd Helmle <mailings@oopsware.de>
0 siblings, 1 reply; 3+ messages in thread
From: Philippe Rimbault @ 2010-09-14 09:42 UTC (permalink / raw)
To: pgsql-testers
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: record with incorrect prev-link
2010-09-14 09:42 record with incorrect prev-link Philippe Rimbault <primbault@edd.fr>
@ 2010-09-14 15:55 ` Bernd Helmle <mailings@oopsware.de>
2010-09-15 07:04 ` Re: record with incorrect prev-link Philippe Rimbault <primbault@edd.fr>
0 siblings, 1 reply; 3+ messages in thread
From: Bernd Helmle @ 2010-09-14 15:55 UTC (permalink / raw)
To: Philippe Rimbault <primbault@edd.fr>; pgsql-testers
--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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: record with incorrect prev-link
2010-09-14 09:42 record with incorrect prev-link Philippe Rimbault <primbault@edd.fr>
2010-09-14 15:55 ` Re: record with incorrect prev-link Bernd Helmle <mailings@oopsware.de>
@ 2010-09-15 07:04 ` Philippe Rimbault <primbault@edd.fr>
0 siblings, 0 replies; 3+ messages in thread
From: Philippe Rimbault @ 2010-09-15 07:04 UTC (permalink / raw)
To: Bernd Helmle <mailings@oopsware.de>; +Cc: pgsql-testers
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 ...
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-09-15 07:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-14 09:42 record with incorrect prev-link Philippe Rimbault <primbault@edd.fr>
2010-09-14 15:55 ` Bernd Helmle <mailings@oopsware.de>
2010-09-15 07:04 ` Philippe Rimbault <primbault@edd.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox