Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 371811337FF3 for ; Wed, 15 Sep 2010 04:05:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 10141-02 for ; Wed, 15 Sep 2010 07:04:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vs-mailrelay.intranet (mail.edd.fr [62.23.156.6]) by mail.postgresql.org (Postfix) with ESMTP id 487B51337FF7 for ; Wed, 15 Sep 2010 04:04:19 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by vs-mailrelay.intranet (Postfix) with ESMTP id 67006D0210; Wed, 15 Sep 2010 09:04:18 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at vs-mailrelay.intranet Received: from vs-mailrelay.intranet ([127.0.0.1]) by localhost (vs-mailrelay.intranet [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id h0HfLXAV6hto; Wed, 15 Sep 2010 09:04:18 +0200 (CEST) Received: from vs-dovecot.intranet (unknown [192.168.39.143]) by vs-mailrelay.intranet (Postfix) with ESMTP id 33155D020D; Wed, 15 Sep 2010 09:04:18 +0200 (CEST) Received: from [192.168.13.113] (unknown [192.168.13.113]) by vs-dovecot.intranet (Postfix) with ESMTP id 043AB2008F; Wed, 15 Sep 2010 09:04:18 +0200 (CEST) Message-ID: <4C906FF1.7060301@edd.fr> Date: Wed, 15 Sep 2010 09:04:17 +0200 From: Philippe Rimbault User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.11) Gecko/20100805 Icedove/3.0.6 MIME-Version: 1.0 To: Bernd Helmle CC: pgsql-testers@postgresql.org Subject: Re: record with incorrect prev-link References: <4C8F4395.9090405@edd.fr> <9758CFA9378D0C798E10C32D@amenophis> In-Reply-To: <9758CFA9378D0C798E10C32D@amenophis> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/24 X-Sequence-Number: 200 On 14/09/2010 17:55, Bernd Helmle wrote: > > > --On 14. September 2010 11:42:45 +0200 Philippe Rimbault > 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 ...