getting error could not open file "pg_xlog"

From: Fazreil Amreen Abdul Jalil <fazreilamreen(dot)abduljalil(at)openet(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: getting error could not open file "pg_xlog"
Date: 2017-08-01 15:15:17
Message-ID: AM5PR0502MB3026CB6EEBB6DE02C1253F81FDB30@AM5PR0502MB3026.eurprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I am working on setting up postgresql with replication using ansible. I came to a point where I perform pg_basebackup and try to start the replication node. The startup failed with the following error:

LOG: entering standby mode
cp: cannot stat 'mnt/server/archivedir/000000010000000000000014': No such file or directory
LOG: consistent recovery state reached at 0/14000020
LOG: redo starts at 0/14000020
LOG: record with zero length at 0/140000B8
cp: cannot stat 'mnt/server/archivedir/000000010000000000000014': No such file or directory
LOG: streaming replication successfully connected to primary
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up
FATAL: the database system is starting up

The last line keep repeating until in the end it says:

LOG: received smart shutdown request
FATAL: terminating walreceiver process due to administrator command
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down in recovery at 2017-08-01 16:01:11 IST

Thank you,
Fazreil Amreen
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please note that any review, dissemination, disclosure, alteration, printing, circulation, retention or transmission of this e-mail and/or any file or attachment transmitted with it, is prohibited and may be unlawful. If you have received this e-mail or any file or attachment transmitted with it in error please notify postmaster(at)openet(dot)com(dot) Although Openet has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2017-08-01 17:14:38 Re: getting error could not open file "pg_xlog"
Previous Message Daniel Verite 2017-08-01 07:45:03 Re: Crash report for some ICU-52 (debian8) COLLATE and work_mem values