pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
record 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