diff options
Diffstat (limited to 'src/bin/pg_rewind/parsexlog.c')
-rw-r--r-- | src/bin/pg_rewind/parsexlog.c | 462 |
1 files changed, 462 insertions, 0 deletions
diff --git a/src/bin/pg_rewind/parsexlog.c b/src/bin/pg_rewind/parsexlog.c new file mode 100644 index 0000000..c6792da --- /dev/null +++ b/src/bin/pg_rewind/parsexlog.c @@ -0,0 +1,462 @@ +/*------------------------------------------------------------------------- + * + * parsexlog.c + * Functions for reading Write-Ahead-Log + * + * Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group + * Portions Copyright (c) 1994, Regents of the University of California + * + *------------------------------------------------------------------------- + */ + +#include "postgres_fe.h" + +#include <unistd.h> + +#include "access/rmgr.h" +#include "access/xact.h" +#include "access/xlog_internal.h" +#include "access/xlogreader.h" +#include "catalog/pg_control.h" +#include "catalog/storage_xlog.h" +#include "commands/dbcommands_xlog.h" +#include "fe_utils/archive.h" +#include "filemap.h" +#include "pg_rewind.h" + +/* + * RmgrNames is an array of the built-in resource manager names, to make error + * messages a bit nicer. + */ +#define PG_RMGR(symname,name,redo,desc,identify,startup,cleanup,mask,decode) \ + name, + +static const char *RmgrNames[RM_MAX_ID + 1] = { +#include "access/rmgrlist.h" +}; + +#define RmgrName(rmid) (((rmid) <= RM_MAX_BUILTIN_ID) ? \ + RmgrNames[rmid] : "custom") + +static void extractPageInfo(XLogReaderState *record); + +static int xlogreadfd = -1; +static XLogSegNo xlogreadsegno = 0; +static char xlogfpath[MAXPGPATH]; + +typedef struct XLogPageReadPrivate +{ + const char *restoreCommand; + int tliIndex; +} XLogPageReadPrivate; + +static int SimpleXLogPageRead(XLogReaderState *xlogreader, + XLogRecPtr targetPagePtr, + int reqLen, XLogRecPtr targetRecPtr, char *readBuf); + +/* + * Read WAL from the datadir/pg_wal, starting from 'startpoint' on timeline + * index 'tliIndex' in target timeline history, until 'endpoint'. Make note of + * the data blocks touched by the WAL records, and return them in a page map. + * + * 'endpoint' is the end of the last record to read. The record starting at + * 'endpoint' is the first one that is not read. + */ +void +extractPageMap(const char *datadir, XLogRecPtr startpoint, int tliIndex, + XLogRecPtr endpoint, const char *restoreCommand) +{ + XLogRecord *record; + XLogReaderState *xlogreader; + char *errormsg; + XLogPageReadPrivate private; + + private.tliIndex = tliIndex; + private.restoreCommand = restoreCommand; + xlogreader = XLogReaderAllocate(WalSegSz, datadir, + XL_ROUTINE(.page_read = &SimpleXLogPageRead), + &private); + if (xlogreader == NULL) + pg_fatal("out of memory while allocating a WAL reading processor"); + + XLogBeginRead(xlogreader, startpoint); + do + { + record = XLogReadRecord(xlogreader, &errormsg); + + if (record == NULL) + { + XLogRecPtr errptr = xlogreader->EndRecPtr; + + if (errormsg) + pg_fatal("could not read WAL record at %X/%X: %s", + LSN_FORMAT_ARGS(errptr), + errormsg); + else + pg_fatal("could not read WAL record at %X/%X", + LSN_FORMAT_ARGS(errptr)); + } + + extractPageInfo(xlogreader); + } while (xlogreader->EndRecPtr < endpoint); + + /* + * If 'endpoint' didn't point exactly at a record boundary, the caller + * messed up. + */ + if (xlogreader->EndRecPtr != endpoint) + pg_fatal("end pointer %X/%X is not a valid end point; expected %X/%X", + LSN_FORMAT_ARGS(endpoint), LSN_FORMAT_ARGS(xlogreader->EndRecPtr)); + + XLogReaderFree(xlogreader); + if (xlogreadfd != -1) + { + close(xlogreadfd); + xlogreadfd = -1; + } +} + +/* + * Reads one WAL record. Returns the end position of the record, without + * doing anything with the record itself. + */ +XLogRecPtr +readOneRecord(const char *datadir, XLogRecPtr ptr, int tliIndex, + const char *restoreCommand) +{ + XLogRecord *record; + XLogReaderState *xlogreader; + char *errormsg; + XLogPageReadPrivate private; + XLogRecPtr endptr; + + private.tliIndex = tliIndex; + private.restoreCommand = restoreCommand; + xlogreader = XLogReaderAllocate(WalSegSz, datadir, + XL_ROUTINE(.page_read = &SimpleXLogPageRead), + &private); + if (xlogreader == NULL) + pg_fatal("out of memory while allocating a WAL reading processor"); + + XLogBeginRead(xlogreader, ptr); + record = XLogReadRecord(xlogreader, &errormsg); + if (record == NULL) + { + if (errormsg) + pg_fatal("could not read WAL record at %X/%X: %s", + LSN_FORMAT_ARGS(ptr), errormsg); + else + pg_fatal("could not read WAL record at %X/%X", + LSN_FORMAT_ARGS(ptr)); + } + endptr = xlogreader->EndRecPtr; + + XLogReaderFree(xlogreader); + if (xlogreadfd != -1) + { + close(xlogreadfd); + xlogreadfd = -1; + } + + return endptr; +} + +/* + * Find the previous checkpoint preceding given WAL location. + */ +void +findLastCheckpoint(const char *datadir, XLogRecPtr forkptr, int tliIndex, + XLogRecPtr *lastchkptrec, TimeLineID *lastchkpttli, + XLogRecPtr *lastchkptredo, const char *restoreCommand) +{ + /* Walk backwards, starting from the given record */ + XLogRecord *record; + XLogRecPtr searchptr; + XLogReaderState *xlogreader; + char *errormsg; + XLogPageReadPrivate private; + + /* + * The given fork pointer points to the end of the last common record, + * which is not necessarily the beginning of the next record, if the + * previous record happens to end at a page boundary. Skip over the page + * header in that case to find the next record. + */ + if (forkptr % XLOG_BLCKSZ == 0) + { + if (XLogSegmentOffset(forkptr, WalSegSz) == 0) + forkptr += SizeOfXLogLongPHD; + else + forkptr += SizeOfXLogShortPHD; + } + + private.tliIndex = tliIndex; + private.restoreCommand = restoreCommand; + xlogreader = XLogReaderAllocate(WalSegSz, datadir, + XL_ROUTINE(.page_read = &SimpleXLogPageRead), + &private); + if (xlogreader == NULL) + pg_fatal("out of memory while allocating a WAL reading processor"); + + searchptr = forkptr; + for (;;) + { + uint8 info; + + XLogBeginRead(xlogreader, searchptr); + record = XLogReadRecord(xlogreader, &errormsg); + + if (record == NULL) + { + if (errormsg) + pg_fatal("could not find previous WAL record at %X/%X: %s", + LSN_FORMAT_ARGS(searchptr), + errormsg); + else + pg_fatal("could not find previous WAL record at %X/%X", + LSN_FORMAT_ARGS(searchptr)); + } + + /* + * Check if it is a checkpoint record. This checkpoint record needs to + * be the latest checkpoint before WAL forked and not the checkpoint + * where the primary has been stopped to be rewound. + */ + info = XLogRecGetInfo(xlogreader) & ~XLR_INFO_MASK; + if (searchptr < forkptr && + XLogRecGetRmid(xlogreader) == RM_XLOG_ID && + (info == XLOG_CHECKPOINT_SHUTDOWN || + info == XLOG_CHECKPOINT_ONLINE)) + { + CheckPoint checkPoint; + + memcpy(&checkPoint, XLogRecGetData(xlogreader), sizeof(CheckPoint)); + *lastchkptrec = searchptr; + *lastchkpttli = checkPoint.ThisTimeLineID; + *lastchkptredo = checkPoint.redo; + break; + } + + /* Walk backwards to previous record. */ + searchptr = record->xl_prev; + } + + XLogReaderFree(xlogreader); + if (xlogreadfd != -1) + { + close(xlogreadfd); + xlogreadfd = -1; + } +} + +/* XLogReader callback function, to read a WAL page */ +static int +SimpleXLogPageRead(XLogReaderState *xlogreader, XLogRecPtr targetPagePtr, + int reqLen, XLogRecPtr targetRecPtr, char *readBuf) +{ + XLogPageReadPrivate *private = (XLogPageReadPrivate *) xlogreader->private_data; + uint32 targetPageOff; + XLogRecPtr targetSegEnd; + XLogSegNo targetSegNo; + int r; + + XLByteToSeg(targetPagePtr, targetSegNo, WalSegSz); + XLogSegNoOffsetToRecPtr(targetSegNo + 1, 0, WalSegSz, targetSegEnd); + targetPageOff = XLogSegmentOffset(targetPagePtr, WalSegSz); + + /* + * See if we need to switch to a new segment because the requested record + * is not in the currently open one. + */ + if (xlogreadfd >= 0 && + !XLByteInSeg(targetPagePtr, xlogreadsegno, WalSegSz)) + { + close(xlogreadfd); + xlogreadfd = -1; + } + + XLByteToSeg(targetPagePtr, xlogreadsegno, WalSegSz); + + if (xlogreadfd < 0) + { + char xlogfname[MAXFNAMELEN]; + + /* + * Since incomplete segments are copied into next timelines, switch to + * the timeline holding the required segment. Assuming this scan can + * be done both forward and backward, consider also switching timeline + * accordingly. + */ + while (private->tliIndex < targetNentries - 1 && + targetHistory[private->tliIndex].end < targetSegEnd) + private->tliIndex++; + while (private->tliIndex > 0 && + targetHistory[private->tliIndex].begin >= targetSegEnd) + private->tliIndex--; + + XLogFileName(xlogfname, targetHistory[private->tliIndex].tli, + xlogreadsegno, WalSegSz); + + snprintf(xlogfpath, MAXPGPATH, "%s/" XLOGDIR "/%s", + xlogreader->segcxt.ws_dir, xlogfname); + + xlogreadfd = open(xlogfpath, O_RDONLY | PG_BINARY, 0); + + if (xlogreadfd < 0) + { + /* + * If we have no restore_command to execute, then exit. + */ + if (private->restoreCommand == NULL) + { + pg_log_error("could not open file \"%s\": %m", xlogfpath); + return -1; + } + + /* + * Since we have restore_command, then try to retrieve missing WAL + * file from the archive. + */ + xlogreadfd = RestoreArchivedFile(xlogreader->segcxt.ws_dir, + xlogfname, + WalSegSz, + private->restoreCommand); + + if (xlogreadfd < 0) + return -1; + else + pg_log_debug("using file \"%s\" restored from archive", + xlogfpath); + } + } + + /* + * At this point, we have the right segment open. + */ + Assert(xlogreadfd != -1); + + /* Read the requested page */ + if (lseek(xlogreadfd, (off_t) targetPageOff, SEEK_SET) < 0) + { + pg_log_error("could not seek in file \"%s\": %m", xlogfpath); + return -1; + } + + + r = read(xlogreadfd, readBuf, XLOG_BLCKSZ); + if (r != XLOG_BLCKSZ) + { + if (r < 0) + pg_log_error("could not read file \"%s\": %m", xlogfpath); + else + pg_log_error("could not read file \"%s\": read %d of %zu", + xlogfpath, r, (Size) XLOG_BLCKSZ); + + return -1; + } + + Assert(targetSegNo == xlogreadsegno); + + xlogreader->seg.ws_tli = targetHistory[private->tliIndex].tli; + return XLOG_BLCKSZ; +} + +/* + * Extract information on which blocks the current record modifies. + */ +static void +extractPageInfo(XLogReaderState *record) +{ + int block_id; + RmgrId rmid = XLogRecGetRmid(record); + uint8 info = XLogRecGetInfo(record); + uint8 rminfo = info & ~XLR_INFO_MASK; + + /* Is this a special record type that I recognize? */ + + if (rmid == RM_DBASE_ID && rminfo == XLOG_DBASE_CREATE_FILE_COPY) + { + /* + * New databases can be safely ignored. It won't be present in the + * source system, so it will be deleted. There's one corner-case, + * though: if a new, different, database is also created in the source + * system, we'll see that the files already exist and not copy them. + * That's OK, though; WAL replay of creating the new database, from + * the source systems's WAL, will re-copy the new database, + * overwriting the database created in the target system. + */ + } + else if (rmid == RM_DBASE_ID && rminfo == XLOG_DBASE_CREATE_WAL_LOG) + { + /* + * New databases can be safely ignored. It won't be present in the + * source system, so it will be deleted. + */ + } + else if (rmid == RM_DBASE_ID && rminfo == XLOG_DBASE_DROP) + { + /* + * An existing database was dropped. We'll see that the files don't + * exist in the target data dir, and copy them in toto from the source + * system. No need to do anything special here. + */ + } + else if (rmid == RM_SMGR_ID && rminfo == XLOG_SMGR_CREATE) + { + /* + * We can safely ignore these. The file will be removed from the + * target, if it doesn't exist in source system. If a file with same + * name is created in source system, too, there will be WAL records + * for all the blocks in it. + */ + } + else if (rmid == RM_SMGR_ID && rminfo == XLOG_SMGR_TRUNCATE) + { + /* + * We can safely ignore these. When we compare the sizes later on, + * we'll notice that they differ, and copy the missing tail from + * source system. + */ + } + else if (rmid == RM_XACT_ID && + ((rminfo & XLOG_XACT_OPMASK) == XLOG_XACT_COMMIT || + (rminfo & XLOG_XACT_OPMASK) == XLOG_XACT_COMMIT_PREPARED || + (rminfo & XLOG_XACT_OPMASK) == XLOG_XACT_ABORT || + (rminfo & XLOG_XACT_OPMASK) == XLOG_XACT_ABORT_PREPARED)) + { + /* + * These records can include "dropped rels". We can safely ignore + * them, we will see that they are missing and copy them from the + * source. + */ + } + else if (info & XLR_SPECIAL_REL_UPDATE) + { + /* + * This record type modifies a relation file in some special way, but + * we don't recognize the type. That's bad - we don't know how to + * track that change. + */ + pg_fatal("WAL record modifies a relation, but record type is not recognized: " + "lsn: %X/%X, rmid: %d, rmgr: %s, info: %02X", + LSN_FORMAT_ARGS(record->ReadRecPtr), + rmid, RmgrName(rmid), info); + } + + for (block_id = 0; block_id <= XLogRecMaxBlockId(record); block_id++) + { + RelFileNode rnode; + ForkNumber forknum; + BlockNumber blkno; + + if (!XLogRecGetBlockTagExtended(record, block_id, + &rnode, &forknum, &blkno, NULL)) + continue; + + /* We only care about the main fork; others are copied in toto */ + if (forknum != MAIN_FORKNUM) + continue; + + process_target_wal_block_change(forknum, rnode, blkno); + } +} |