*
* walwriter.cpp
*
* The WAL writer background process is new as of Postgres 8.3. It attempts
* to keep regular backends from having to write out (and fsync) WAL pages.
* Also, it guarantees that transaction commit records that weren't synced
* to disk immediately upon commit (ie, were "asynchronously committed")
* will reach disk within a knowable time --- which, as it happens, is at
* most three times the wal_writer_delay cycle time.
*
* Note that as with the bgwriter for shared buffers, regular backends are
* still empowered to issue WAL writes and fsyncs when the walwriter doesn't
* keep up. This means that the WALWriter is not an essential process and
* can shutdown quickly when requested.
*
* Because the walwriter's cycle is directly linked to the maximum delay
* before async-commit transactions are guaranteed committed, it's probably
* unwise to load additional functionality onto it. For instance, if you've
* got a yen to create xlog segments further in advance, that'd be better done
* in bgwriter than in walwriter.
*
* The walwriter is started by the postmaster as soon as the startup subprocess
* finishes. It remains alive until the postmaster commands it to terminate.
* Normal termination is by SIGTERM, which instructs the walwriter to exit(0).
* Emergency termination is by SIGQUIT; like any backend, the walwriter will
* simply abort and exit on SIGQUIT.
*
* If the walwriter exits unexpectedly, the postmaster treats that the same
* as a backend crash: shared memory may be corrupted, so remaining backends
* should be killed by SIGQUIT and then a recovery cycle started.
*
* Portions Copyright (c) 2020 Huawei Technologies Co.,Ltd.
* Portions Copyright (c) 1996-2012, PostgreSQL Global Development Group
*
* IDENTIFICATION
* src/gausskernel/process/postmaster/walwriter.cpp
*
* -------------------------------------------------------------------------
*/
#include "postgres.h"
#include "knl/knl_variable.h"
#include <signal.h>
#include <sys/time.h>
#include <time.h>
#include <unistd.h>
#include "access/xlog.h"
#include "libpq/pqsignal.h"
#include "miscadmin.h"
#include "pgstat.h"
#include "postmaster/walwriter.h"
#include "storage/buf/bufmgr.h"
#include "storage/ipc.h"
#include "storage/lock/lwlock.h"
#include "storage/proc.h"
#include "storage/smgr/smgr.h"
#include "utils/guc.h"
#include "utils/hsearch.h"
#include "utils/memutils.h"
#include "utils/resowner.h"
#include "gssignal/gs_signal.h"
#define NANOSECONDS_PER_MILLISECOND 1000000L
#define NANOSECONDS_PER_SECOND 1000000000L
static void wal_quickdie(SIGNAL_ARGS);
static void WalSigHupHandler(SIGNAL_ARGS);
static void WalShutdownHandler(SIGNAL_ARGS);
static void walwriter_sigusr1_handler(SIGNAL_ARGS);
THR_LOCAL const int g_sleep_timeout_ms = 300;
* Main entry point for walwriter process
*
* This is invoked from AuxiliaryProcessMain, which has already created the
* basic execution environment, but not enabled signals yet.
*/
void WalWriterMain(void)
{
sigjmp_buf local_sigjmp_buf;
MemoryContext walwriter_context;
sigset_t old_sig_mask;
bool wrote_something = true;
long times_wrote_nothing = 0;
struct timespec time_to_wait;
int sleep_times_counter = 0;
int time_out_counter = 0;
load_server_mode();
if (t_thrd.xlog_cxt.server_mode == PRIMARY_MODE ||
t_thrd.xlog_cxt.server_mode == NORMAL_MODE) {
* Different from WalWriterPID, isWalWriterUp is used to signal that
* the WAL writer thread is not only created, it is also created to
* write WAL from the WAL buffer to disks.
*
* We need isWalWriterUp instead of WalWriterPID in places where threads
* to see whether there is a WAL writer running and flushing WAL buffer.
* In standbys where we don't write WAL from the WAL buffer during redo,
* the WAL writer can be potentially re-purposed, in which case
* WalWriterPID check is insufficient
*/
g_instance.wal_cxt.isWalWriterUp = true;
}
ereport(LOG, (errmsg("walwriter started")));
if (g_instance.attr.attr_storage.walwriter_cpu_bind >= 0) {
cpu_set_t walWriterSet;
CPU_ZERO(&walWriterSet);
CPU_SET(g_instance.attr.attr_storage.walwriter_cpu_bind, &walWriterSet);
int rc = sched_setaffinity(0, sizeof(cpu_set_t), &walWriterSet);
if (rc == -1) {
ereport(FATAL, (errcode(ERRCODE_OPERATE_INVALID_PARAM), errmsg("Invalid attribute for thread pool."),
errdetail("Current thread num %d is out of range.", g_instance.attr.attr_storage.walwriter_cpu_bind)));
}
}
* Properly accept or ignore signals the postmaster might send us.
* We have no particular use for SIGINT at the moment, but seems
* reasonable to treat like SIGTERM.
*
* Reset some signals that are accepted by postmaster but not here.
*/
(void)gspqsignal(SIGHUP, WalSigHupHandler);
(void)gspqsignal(SIGINT, WalShutdownHandler);
(void)gspqsignal(SIGTERM, WalShutdownHandler);
(void)gspqsignal(SIGQUIT, wal_quickdie);
(void)gspqsignal(SIGALRM, SIG_IGN);
(void)gspqsignal(SIGPIPE, SIG_IGN);
(void)gspqsignal(SIGUSR1, walwriter_sigusr1_handler);
(void)gspqsignal(SIGUSR2, SIG_IGN);
(void)gspqsignal(SIGURG, print_stack);
* Reset some signals that are accepted by postmaster but not here.
*/
(void)gspqsignal(SIGCHLD, SIG_DFL);
(void)gspqsignal(SIGTTIN, SIG_DFL);
(void)gspqsignal(SIGTTOU, SIG_DFL);
(void)gspqsignal(SIGCONT, SIG_DFL);
(void)gspqsignal(SIGWINCH, SIG_DFL);
sigdelset(&t_thrd.libpq_cxt.BlockSig, SIGQUIT);
* Create a resource owner to keep track of our resources (not clear that
* we need this, but may as well have one).
*/
t_thrd.utils_cxt.CurrentResourceOwner = ResourceOwnerCreate(NULL, "Wal Writer",
THREAD_GET_MEM_CXT_GROUP(MEMORY_CONTEXT_STORAGE));
* Create a memory context that we will do all our work in. We do this so
* that we can reset the context during error recovery and thereby avoid
* possible memory leaks. Formerly this code just ran in
* t_thrd.top_mem_cxt, but resetting that would be a really bad idea.
*/
walwriter_context = AllocSetContextCreate(t_thrd.top_mem_cxt,
"Wal Writer",
ALLOCSET_DEFAULT_MINSIZE,
ALLOCSET_DEFAULT_INITSIZE,
ALLOCSET_DEFAULT_MAXSIZE);
(void)MemoryContextSwitchTo(walwriter_context);
* If an exception is encountered, processing resumes here.
*
* This code is heavily based on bgwriter.c, q.v.
*/
int curTryCounter;
int* oldTryCounter = NULL;
if (sigsetjmp(local_sigjmp_buf, 1) != 0) {
* Close all open files after any error. This is helpful on Windows,
* where holding deleted files open causes various strange errors.
* It's not clear we need it elsewhere, but shouldn't hurt.
*/
gstrace_tryblock_exit(true, oldTryCounter);
pthread_sigmask(SIG_SETMASK, &old_sig_mask, NULL);
t_thrd.log_cxt.error_context_stack = NULL;
t_thrd.log_cxt.call_stack = NULL;
HOLD_INTERRUPTS();
EmitErrorReport();
AbortAsyncListIO();
AtEOXact_SysDBCache(false);
* These operations are really just a minimal subset of
* AbortTransaction(). We don't have very many resources to worry
* about in walwriter, but we do have LWLocks, and perhaps buffers?
*/
LWLockReleaseAll();
pgstat_report_waitevent(WAIT_EVENT_END);
AbortBufferIO();
UnlockBuffers();
ResourceOwnerRelease(t_thrd.utils_cxt.CurrentResourceOwner, RESOURCE_RELEASE_BEFORE_LOCKS, false, true);
AtEOXact_Buffers(false);
AtEOXact_SMgr();
AtEOXact_Files();
AtEOXact_HashTables(false);
* Now return to normal top-level context and clear ErrorContext for
* next time.
*/
(void)MemoryContextSwitchTo(walwriter_context);
FlushErrorState();
MemoryContextResetAndDeleteChildren(walwriter_context);
RESUME_INTERRUPTS();
* Sleep at least 1 second after any error. A write error is likely
* to be repeated, and we don't want to be filling the error logs as
* fast as we can.
*/
pg_usleep(1000000L);
}
oldTryCounter = gstrace_tryblock_entry(&curTryCounter);
t_thrd.log_cxt.PG_exception_stack = &local_sigjmp_buf;
* Unblock signals (they were blocked when the postmaster forked us)
*/
gs_signal_setmask(&t_thrd.libpq_cxt.UnBlockSig, NULL);
(void)gs_signal_unblock_sigusr2();
* Reset hibernation state after any error.
*/
SetWalWriterSleeping(false);
* Advertise our latch that backends can use to wake us up while we're
* sleeping.
*/
g_instance.proc_base->walwriterLatch = &t_thrd.proc->procLatch;
pgstat_report_appname("Wal Writer");
pgstat_report_activity(STATE_IDLE, NULL);
* Loop forever
*/
for (;;) {
pgstat_report_activity(STATE_RUNNING, NULL);
* Process any requests or signals received recently.
*/
if (t_thrd.walwriter_cxt.got_SIGHUP) {
t_thrd.walwriter_cxt.got_SIGHUP = false;
ProcessConfigFile(PGC_SIGHUP);
}
if (t_thrd.walwriter_cxt.shutdown_requested) {
proc_exit(0);
}
if (!t_thrd.walwriter_cxt.lockhold) {
LWLockAcquire(WALWriteLock, LW_EXCLUSIVE);
t_thrd.walwriter_cxt.lockhold = true;
}
wrote_something = XLogBackgroundFlush();
if (!wrote_something && ++times_wrote_nothing > g_instance.attr.attr_storage.walwriter_sleep_threshold) {
XLogBackgroundFlush(true);
LWLockRelease(WALWriteLock);
t_thrd.walwriter_cxt.lockhold = false;
* Wait for the first entry after last flushed entry to be updated
*/
int lastFlushedEntry = g_instance.wal_cxt.lastWalStatusEntryFlushed;
int nextStatusEntry =
GET_NEXT_STATUS_ENTRY(lastFlushedEntry);
volatile WalInsertStatusEntry *pCriticalEntry =
&g_instance.wal_cxt.walInsertStatusTable[nextStatusEntry];
if (g_instance.wal_cxt.isWalWriterUp && pCriticalEntry->endLSN == 0) {
sleep_times_counter++;
(void)pthread_mutex_lock(&g_instance.wal_cxt.criticalEntryMutex);
g_instance.wal_cxt.isWalWriterSleeping = true;
while (pCriticalEntry->endLSN == 0 && !t_thrd.walwriter_cxt.shutdown_requested) {
(void)clock_gettime(CLOCK_MONOTONIC, &time_to_wait);
time_to_wait.tv_nsec += g_sleep_timeout_ms * NANOSECONDS_PER_MILLISECOND;
if (time_to_wait.tv_nsec >= NANOSECONDS_PER_SECOND) {
time_to_wait.tv_nsec -= NANOSECONDS_PER_SECOND;
time_to_wait.tv_sec += 1;
}
int res = pthread_cond_timedwait(&g_instance.wal_cxt.criticalEntryCV,
&g_instance.wal_cxt.criticalEntryMutex, &time_to_wait);
if (res == 0) {
* We should not break out here because we may be notified by an
* entry after the critiacal entry. We must check again if critical
* entry status is WAL_NOT_COPIED.
*/
continue;
} else if (res == ETIMEDOUT) {
time_out_counter++;
} else {
ereport(WARNING, (errmsg("WAL writer pthread_cond_timedwait returned error code = %d.",
errno)));
}
WakeupWalSemaphore(&g_instance.wal_cxt.walFlushWaitLock->l.sem);
WakeupWalSemaphore(&g_instance.wal_cxt.walBufferInitWaitLock->l.sem);
CHECK_FOR_INTERRUPTS();
}
g_instance.wal_cxt.isWalWriterSleeping = false;
(void)pthread_mutex_unlock(&g_instance.wal_cxt.criticalEntryMutex);
time_out_counter = 0;
}
times_wrote_nothing = 0;
}
pgstat_report_activity(STATE_IDLE, NULL);
}
}
* signal handler routines
* --------------------------------
*/
* wal_quickdie() occurs when signalled SIGQUIT by the postmaster.
*
* Some backend has bought the farm,
* so we need to stop what we're doing and exit.
*/
static void wal_quickdie(SIGNAL_ARGS)
{
gs_signal_setmask(&t_thrd.libpq_cxt.BlockSig, NULL);
g_instance.wal_cxt.isWalWriterUp = false;
pg_memory_barrier();
WakeupWalSemaphore(&g_instance.wal_cxt.walInitSegLock->l.sem);
WakeupWalSemaphore(&g_instance.wal_cxt.walFlushWaitLock->l.sem);
* We DO NOT want to run proc_exit() callbacks -- we're here because
* shared memory may be corrupted, so we don't want to try to clean up our
* transaction. Just nail the windows shut and get out of town. Now that
* there's an atexit callback to prevent third-party code from breaking
* things by calling exit() directly, we have to reset the callbacks
* explicitly to make this work as intended.
*/
on_exit_reset();
* Note we do exit(2) not exit(0). This is to force the postmaster into a
* system reset cycle if some idiot DBA sends a manual SIGQUIT to a random
* backend. This is necessary precisely because we don't clean up our
* shared memory state. (The "dead man switch" mechanism in pmsignal.c
* should ensure the postmaster sees this as a crash, too, but no harm in
* being doubly sure.)
*/
exit(2);
}
static void WalSigHupHandler(SIGNAL_ARGS)
{
int save_errno = errno;
t_thrd.walwriter_cxt.got_SIGHUP = true;
if (t_thrd.proc)
SetLatch(&t_thrd.proc->procLatch);
errno = save_errno;
}
static void WalShutdownHandler(SIGNAL_ARGS)
{
int save_errno = errno;
t_thrd.walwriter_cxt.shutdown_requested = true;
if (t_thrd.proc)
SetLatch(&t_thrd.proc->procLatch);
errno = save_errno;
g_instance.wal_cxt.isWalWriterUp = false;
pg_memory_barrier();
WakeupWalSemaphore(&g_instance.wal_cxt.walInitSegLock->l.sem);
WakeupWalSemaphore(&g_instance.wal_cxt.walFlushWaitLock->l.sem);
}
static void walwriter_sigusr1_handler(SIGNAL_ARGS)
{
int save_errno = errno;
latch_sigusr1_handler();
errno = save_errno;
}