Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6716D1337B6E for ; Tue, 14 Sep 2010 13:12:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 59810-03 for ; Tue, 14 Sep 2010 16:12:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from dd1514.kasserver.com (dd1514.kasserver.com [85.13.128.107]) by mail.postgresql.org (Postfix) with ESMTP id 60612133655C for ; Tue, 14 Sep 2010 13:12:38 -0300 (ADT) Received: from [192.168.1.3] (dslb-092-073-030-127.pools.arcor-ip.net [92.73.30.127]) by dd1514.kasserver.com (Postfix) with ESMTP id 1C2471874143; Tue, 14 Sep 2010 17:55:40 +0200 (CEST) Date: Tue, 14 Sep 2010 17:55:39 +0200 From: Bernd Helmle To: Philippe Rimbault , pgsql-testers@postgresql.org Subject: Re: record with incorrect prev-link Message-ID: <9758CFA9378D0C798E10C32D@amenophis> In-Reply-To: <4C8F4395.9090405@edd.fr> References: <4C8F4395.9090405@edd.fr> X-Mailer: Mulberry/4.0.8 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=BAYES_40=-0.001, MIME_QP_LONG_LINE=0.001 X-Spam-Level: X-Archive-Number: 201009/23 X-Sequence-Number: 199 --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'=C3=A9valuer =C2=AB /opt/wal/00000001000000010000007B = =C2=BB: 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'=C3=A9valuer =C2=AB /opt/wal/00000001000000010000007B = =C2=BB: 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" =3D "no = such > file or directory") Maybe i'm wrong, but if I understand the code correctly this could mean=20 that the walreceiver got a corrupted wal record, was shut down and the=20 retry code retried recovering from the archive. Just guessing, but maybe=20 there are issues with your network connectivity involved? Are you keeping=20 getting such errors? --=20 Thanks Bernd