proc.c 51.4 KB
Newer Older
1 2
/*-------------------------------------------------------------------------
 *
3
 * proc.c
4
 *	  routines to manage per-process shared memory data structure
5
 *
B
Bruce Momjian 已提交
6
 * Portions Copyright (c) 1996-2011, PostgreSQL Global Development Group
B
Add:  
Bruce Momjian 已提交
7
 * Portions Copyright (c) 1994, Regents of the University of California
8 9 10
 *
 *
 * IDENTIFICATION
11
 *	  src/backend/storage/lmgr/proc.c
12 13 14 15 16
 *
 *-------------------------------------------------------------------------
 */
/*
 * Interface (a):
17
 *		ProcSleep(), ProcWakeup(),
18 19
 *		ProcQueueAlloc() -- create a shm queue for sleeping processes
 *		ProcQueueInit() -- create a queue without allocing memory
20
 *
21 22
 * Waiting for a lock causes the backend to be put to sleep.  Whoever releases
 * the lock wakes the process up again (and gives it an error code so it knows
23 24 25 26
 * whether it was awoken on an error condition).
 *
 * Interface (b):
 *
27 28
 * ProcReleaseLocks -- frees the locks associated with current transaction
 *
29
 * ProcKill -- destroys the shared memory state (and locks)
30
 * associated with the process.
31
 */
32 33
#include "postgres.h"

34
#include <signal.h>
35 36
#include <unistd.h>
#include <sys/time.h>
M
Marc G. Fournier 已提交
37

38
#include "access/transam.h"
39
#include "access/xact.h"
40
#include "miscadmin.h"
41
#include "postmaster/autovacuum.h"
42
#include "replication/syncrep.h"
43
#include "storage/ipc.h"
44
#include "storage/lmgr.h"
45
#include "storage/pmsignal.h"
46
#include "storage/proc.h"
47
#include "storage/procarray.h"
48
#include "storage/procsignal.h"
49
#include "storage/spin.h"
50

51

52
/* GUC variables */
B
Bruce Momjian 已提交
53
int			DeadlockTimeout = 1000;
54
int			StatementTimeout = 0;
55
bool		log_lock_waits = false;
M
 
Marc G. Fournier 已提交
56

57
/* Pointer to this process's PGPROC struct, if any */
J
Jan Wieck 已提交
58
PGPROC	   *MyProc = NULL;
59 60

/*
J
Jan Wieck 已提交
61
 * This spinlock protects the freelist of recycled PGPROC structures.
62
 * We cannot use an LWLock because the LWLock manager depends on already
J
Jan Wieck 已提交
63
 * having a PGPROC and a wait semaphore!  But these structures are touched
64 65
 * relatively infrequently (only at backend startup or shutdown) and not for
 * very long, so a spinlock is okay.
66
 */
67
NON_EXEC_STATIC slock_t *ProcStructLock = NULL;
68

69
/* Pointers to shared-memory structures */
70
NON_EXEC_STATIC PROC_HDR *ProcGlobal = NULL;
71
NON_EXEC_STATIC PGPROC *AuxiliaryProcs = NULL;
72

73 74
/* If we are waiting for a lock, this points to the associated LOCALLOCK */
static LOCALLOCK *lockAwaited = NULL;
75

76
/* Mark these volatile because they can be changed by signal handler */
77
static volatile bool standby_timeout_active = false;
78 79
static volatile bool statement_timeout_active = false;
static volatile bool deadlock_timeout_active = false;
80
static volatile DeadLockState deadlock_state = DS_NOT_YET_CHECKED;
81
volatile bool cancel_from_timeout = false;
B
Bruce Momjian 已提交
82

83 84 85
/* timeout_start_time is set when log_lock_waits is true */
static TimestampTz timeout_start_time;

86
/* statement_fin_time is valid only if statement_timeout_active is true */
87
static TimestampTz statement_fin_time;
88
static TimestampTz statement_fin_time2; /* valid only in recovery */
89 90


91
static void RemoveProcFromArray(int code, Datum arg);
92
static void ProcKill(int code, Datum arg);
93
static void AuxiliaryProcKill(int code, Datum arg);
94
static bool CheckStatementTimeout(void);
95
static bool CheckStandbyTimeout(void);
96

V
Vadim B. Mikheev 已提交
97

98 99 100
/*
 * Report shared-memory space needed by InitProcGlobal.
 */
101
Size
102
ProcGlobalShmemSize(void)
103
{
104 105 106 107
	Size		size = 0;

	/* ProcGlobal */
	size = add_size(size, sizeof(PROC_HDR));
108 109
	/* AuxiliaryProcs */
	size = add_size(size, mul_size(NUM_AUXILIARY_PROCS, sizeof(PGPROC)));
110
	/* MyProcs, including autovacuum workers and launcher */
111 112 113
	size = add_size(size, mul_size(MaxBackends, sizeof(PGPROC)));
	/* ProcStructLock */
	size = add_size(size, sizeof(slock_t));
114 115 116 117

	return size;
}

118 119 120 121
/*
 * Report number of semaphores needed by InitProcGlobal.
 */
int
122
ProcGlobalSemas(void)
123
{
124 125 126 127
	/*
	 * We need a sema per backend (including autovacuum), plus one for each
	 * auxiliary process.
	 */
128
	return MaxBackends + NUM_AUXILIARY_PROCS;
129 130
}

131 132
/*
 * InitProcGlobal -
133 134
 *	  Initialize the global process table during postmaster or standalone
 *	  backend startup.
135
 *
136
 *	  We also create all the per-process semaphores we will need to support
137 138 139 140 141 142 143
 *	  the requested number of backends.  We used to allocate semaphores
 *	  only when backends were actually started up, but that is bad because
 *	  it lets Postgres fail under load --- a lot of Unix systems are
 *	  (mis)configured with small limits on the number of semaphores, and
 *	  running out when trying to start another backend is a common failure.
 *	  So, now we grab enough semaphores to support the desired max number
 *	  of backends immediately at initialization --- if the sysadmin has set
144 145
 *	  MaxConnections or autovacuum_max_workers higher than his kernel will
 *	  support, he'll find out sooner rather than later.
146 147 148 149
 *
 *	  Another reason for creating semaphores here is that the semaphore
 *	  implementation typically requires us to create semaphores in the
 *	  postmaster, not in backends.
150 151
 *
 * Note: this is NOT called by individual backends under a postmaster,
152
 * not even in the EXEC_BACKEND case.  The ProcGlobal and AuxiliaryProcs
153
 * pointers must be propagated specially for EXEC_BACKEND operation.
154 155
 */
void
156
InitProcGlobal(void)
157
{
158 159 160
	PGPROC	   *procs;
	int			i;
	bool		found;
R
Robert Haas 已提交
161
	uint32		TotalProcs = MaxBackends + NUM_AUXILIARY_PROCS;
162

163
	/* Create the ProcGlobal shared structure */
164
	ProcGlobal = (PROC_HDR *)
165 166
		ShmemInitStruct("Proc Header", sizeof(PROC_HDR), &found);
	Assert(!found);
167

168 169 170
	/*
	 * Initialize the data structures.
	 */
R
Robert Haas 已提交
171
	ProcGlobal->spins_per_delay = DEFAULT_SPINS_PER_DELAY;
172 173
	ProcGlobal->freeProcs = NULL;
	ProcGlobal->autovacFreeProcs = NULL;
174

175
	/*
R
Robert Haas 已提交
176 177 178
	 * Create and initialize all the PGPROC structures we'll need (except for
	 * those used for 2PC, which are embedded within a GlobalTransactionData
	 * struct).
179
	 *
R
Robert Haas 已提交
180 181 182 183
	 * There are three separate consumers of PGPROC structures: (1) normal
	 * backends, (2) autovacuum workers and the autovacuum launcher, and (3)
	 * auxiliary processes.  Each PGPROC structure is dedicated to exactly
	 * one of these purposes, and they do not move between groups.
184
	 */
R
Robert Haas 已提交
185
	procs = (PGPROC *) ShmemAlloc(TotalProcs * sizeof(PGPROC));
186 187 188 189
	if (!procs)
		ereport(FATAL,
				(errcode(ERRCODE_OUT_OF_MEMORY),
				 errmsg("out of shared memory")));
R
Robert Haas 已提交
190 191
	MemSet(procs, 0, TotalProcs * sizeof(PGPROC));
	for (i = 0; i < TotalProcs; i++)
192
	{
R
Robert Haas 已提交
193
		/* Common initialization for all PGPROCs, regardless of type. */
194
		PGSemaphoreCreate(&(procs[i].sem));
195
		InitSharedLatch(&procs[i].waitLatch);
R
Robert Haas 已提交
196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215

		/*
		 * Newly created PGPROCs for normal backends or for autovacuum must
		 * be queued up on the appropriate free list.  Because there can only
		 * ever be a small, fixed number of auxiliary processes, no free
		 * list is used in that case; InitAuxiliaryProcess() instead uses a
		 * linear search.
		 */
		if (i < MaxConnections)
		{
			/* PGPROC for normal backend, add to freeProcs list */
			procs[i].links.next = (SHM_QUEUE *) ProcGlobal->freeProcs;
			ProcGlobal->freeProcs = &procs[i];
		}
		else if (i < MaxBackends)
		{
			/* PGPROC for AV launcher/worker, add to autovacFreeProcs list */
			procs[i].links.next = (SHM_QUEUE *) ProcGlobal->autovacFreeProcs;
			ProcGlobal->autovacFreeProcs = &procs[i];
		}
216 217
	}

218
	/*
R
Robert Haas 已提交
219 220
	 * Save a pointer to the block of PGPROC structures reserved for
	 * auxiliary proceses.
221
	 */
R
Robert Haas 已提交
222
	AuxiliaryProcs = &procs[MaxBackends];
223 224 225 226

	/* Create ProcStructLock spinlock, too */
	ProcStructLock = (slock_t *) ShmemAlloc(sizeof(slock_t));
	SpinLockInit(ProcStructLock);
227 228
}

229
/*
230
 * InitProcess -- initialize a per-process data structure for this backend
231 232
 */
void
233
InitProcess(void)
234
{
235 236
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;
237
	int			i;
238 239

	/*
240 241
	 * ProcGlobal should be set up already (if we are a backend, we inherit
	 * this by fork() or EXEC_BACKEND mechanism from the postmaster).
242
	 */
243
	if (procglobal == NULL)
244
		elog(PANIC, "proc header uninitialized");
245 246

	if (MyProc != NULL)
247
		elog(ERROR, "you already exist");
248

249
	/*
B
Bruce Momjian 已提交
250 251
	 * Try to get a proc struct from the free list.  If this fails, we must be
	 * out of PGPROC structures (not to mention semaphores).
252
	 *
B
Bruce Momjian 已提交
253 254
	 * While we are holding the ProcStructLock, also copy the current shared
	 * estimate of spins_per_delay to local storage.
255
	 */
256
	SpinLockAcquire(ProcStructLock);
257

258 259
	set_spins_per_delay(procglobal->spins_per_delay);

260
	if (IsAnyAutoVacuumProcess())
261
		MyProc = procglobal->autovacFreeProcs;
262
	else
263
		MyProc = procglobal->freeProcs;
264

265
	if (MyProc != NULL)
266
	{
267
		if (IsAnyAutoVacuumProcess())
268
			procglobal->autovacFreeProcs = (PGPROC *) MyProc->links.next;
269
		else
270
			procglobal->freeProcs = (PGPROC *) MyProc->links.next;
271
		SpinLockRelease(ProcStructLock);
272 273 274 275
	}
	else
	{
		/*
B
Bruce Momjian 已提交
276 277
		 * If we reach here, all the PGPROCs are in use.  This is one of the
		 * possible places to detect "too many backends", so give the standard
278 279
		 * error message.  XXX do we need to give a different failure message
		 * in the autovacuum case?
280
		 */
281
		SpinLockRelease(ProcStructLock);
282 283 284
		ereport(FATAL,
				(errcode(ERRCODE_TOO_MANY_CONNECTIONS),
				 errmsg("sorry, too many clients already")));
285
	}
286

287 288
	/*
	 * Now that we have a PGPROC, mark ourselves as an active postmaster
289
	 * child; this is so that the postmaster can detect it if we exit without
290 291
	 * cleaning up.  (XXX autovac launcher currently doesn't participate in
	 * this; it probably should.)
292
	 */
293
	if (IsUnderPostmaster && !IsAutoVacuumLauncherProcess())
294
		MarkPostmasterChildActive();
295

296
	/*
B
Bruce Momjian 已提交
297 298
	 * Initialize all fields of MyProc, except for the semaphore which was
	 * prepared for us by InitProcGlobal.
299
	 */
300
	SHMQueueElemInit(&(MyProc->links));
301
	MyProc->waitStatus = STATUS_OK;
302
	MyProc->lxid = InvalidLocalTransactionId;
303
	MyProc->xid = InvalidTransactionId;
304
	MyProc->xmin = InvalidTransactionId;
305
	MyProc->pid = MyProcPid;
306 307
	/* backendId, databaseId and roleId will be filled in later */
	MyProc->backendId = InvalidBackendId;
308
	MyProc->databaseId = InvalidOid;
309
	MyProc->roleId = InvalidOid;
310
	MyProc->inCommit = false;
311
	MyProc->vacuumFlags = 0;
312
	/* NB -- autovac launcher intentionally does not set IS_AUTOVACUUM */
313 314
	if (IsAutoVacuumWorkerProcess())
		MyProc->vacuumFlags |= PROC_IS_AUTOVACUUM;
315 316 317
	MyProc->lwWaiting = false;
	MyProc->lwExclusive = false;
	MyProc->lwWaitLink = NULL;
318
	MyProc->waitLock = NULL;
319
	MyProc->waitProcLock = NULL;
320 321
	for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
		SHMQueueInit(&(MyProc->myProcLocks[i]));
322
	MyProc->recoveryConflictPending = false;
323

324 325 326 327 328 329 330
	/* Initialise for sync rep */
	MyProc->waitLSN.xlogid = 0;
	MyProc->waitLSN.xrecoff = 0;
	MyProc->syncRepState = SYNC_REP_NOT_WAITING;
	SHMQueueElemInit(&(MyProc->syncRepLinks));
	OwnLatch((Latch *) &MyProc->waitLatch);

331
	/*
332
	 * We might be reusing a semaphore that belonged to a failed process. So
B
Bruce Momjian 已提交
333
	 * be careful and reinitialize its value here.	(This is not strictly
334
	 * necessary anymore, but seems like a good idea for cleanliness.)
335
	 */
336
	PGSemaphoreReset(&MyProc->sem);
337

338
	/*
339
	 * Arrange to clean up at backend exit.
340
	 */
341
	on_shmem_exit(ProcKill, 0);
342 343

	/*
B
Bruce Momjian 已提交
344 345
	 * Now that we have a PGPROC, we could try to acquire locks, so initialize
	 * the deadlock checker.
346 347
	 */
	InitDeadLockChecking();
348 349
}

350 351 352 353
/*
 * InitProcessPhase2 -- make MyProc visible in the shared ProcArray.
 *
 * This is separate from InitProcess because we can't acquire LWLocks until
354 355
 * we've created a PGPROC, but in the EXEC_BACKEND case ProcArrayAdd won't
 * work until after we've done CreateSharedMemoryAndSemaphores.
356 357 358 359 360 361 362 363 364 365 366 367 368 369
 */
void
InitProcessPhase2(void)
{
	Assert(MyProc != NULL);

	/*
	 * Add our PGPROC to the PGPROC array in shared memory.
	 */
	ProcArrayAdd(MyProc);

	/*
	 * Arrange to clean that up at backend exit.
	 */
370
	on_shmem_exit(SyncRepCleanupAtProcExit, 0);
371 372 373
	on_shmem_exit(RemoveProcFromArray, 0);
}

374
/*
375
 * InitAuxiliaryProcess -- create a per-auxiliary-process data structure
376
 *
377 378
 * This is called by bgwriter and similar processes so that they will have a
 * MyProc value that's real enough to let them wait for LWLocks.  The PGPROC
379
 * and sema that are assigned are one of the extra ones created during
380
 * InitProcGlobal.
381
 *
382
 * Auxiliary processes are presently not expected to wait for real (lockmgr)
383
 * locks, so we need not set up the deadlock checker.  They are never added
B
Bruce Momjian 已提交
384
 * to the ProcArray or the sinval messaging mechanism, either.	They also
385 386
 * don't get a VXID assigned, since this is only useful when we actually
 * hold lockmgr locks.
387 388 389 390 391
 *
 * Startup process however uses locks but never waits for them in the
 * normal backend sense. Startup process also takes part in sinval messaging
 * as a sendOnly process, so never reads messages from sinval queue. So
 * Startup process does have a VXID and does show up in pg_locks.
392 393
 */
void
394
InitAuxiliaryProcess(void)
395
{
396
	PGPROC	   *auxproc;
397
	int			proctype;
398
	int			i;
J
Jan Wieck 已提交
399

400
	/*
401 402
	 * ProcGlobal should be set up already (if we are a backend, we inherit
	 * this by fork() or EXEC_BACKEND mechanism from the postmaster).
403
	 */
404
	if (ProcGlobal == NULL || AuxiliaryProcs == NULL)
405
		elog(PANIC, "proc header uninitialized");
406 407

	if (MyProc != NULL)
408
		elog(ERROR, "you already exist");
409

410
	/*
411
	 * We use the ProcStructLock to protect assignment and releasing of
412
	 * AuxiliaryProcs entries.
413
	 *
B
Bruce Momjian 已提交
414 415
	 * While we are holding the ProcStructLock, also copy the current shared
	 * estimate of spins_per_delay to local storage.
416 417 418 419 420
	 */
	SpinLockAcquire(ProcStructLock);

	set_spins_per_delay(ProcGlobal->spins_per_delay);

421
	/*
422
	 * Find a free auxproc ... *big* trouble if there isn't one ...
423
	 */
424
	for (proctype = 0; proctype < NUM_AUXILIARY_PROCS; proctype++)
425
	{
426 427
		auxproc = &AuxiliaryProcs[proctype];
		if (auxproc->pid == 0)
428 429
			break;
	}
430
	if (proctype >= NUM_AUXILIARY_PROCS)
431 432
	{
		SpinLockRelease(ProcStructLock);
433
		elog(FATAL, "all AuxiliaryProcs are in use");
434
	}
435

436
	/* Mark auxiliary proc as in use by me */
437
	/* use volatile pointer to prevent code rearrangement */
438
	((volatile PGPROC *) auxproc)->pid = MyProcPid;
439

440
	MyProc = auxproc;
441 442 443

	SpinLockRelease(ProcStructLock);

444
	/*
445 446
	 * Initialize all fields of MyProc, except for the semaphore which was
	 * prepared for us by InitProcGlobal.
447 448
	 */
	SHMQueueElemInit(&(MyProc->links));
449
	MyProc->waitStatus = STATUS_OK;
450
	MyProc->lxid = InvalidLocalTransactionId;
451 452
	MyProc->xid = InvalidTransactionId;
	MyProc->xmin = InvalidTransactionId;
453
	MyProc->backendId = InvalidBackendId;
454
	MyProc->databaseId = InvalidOid;
455
	MyProc->roleId = InvalidOid;
456
	MyProc->inCommit = false;
457
	MyProc->vacuumFlags = 0;
458 459 460 461
	MyProc->lwWaiting = false;
	MyProc->lwExclusive = false;
	MyProc->lwWaitLink = NULL;
	MyProc->waitLock = NULL;
462
	MyProc->waitProcLock = NULL;
463 464
	for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
		SHMQueueInit(&(MyProc->myProcLocks[i]));
465 466

	/*
B
Bruce Momjian 已提交
467
	 * We might be reusing a semaphore that belonged to a failed process. So
B
Bruce Momjian 已提交
468
	 * be careful and reinitialize its value here.	(This is not strictly
469
	 * necessary anymore, but seems like a good idea for cleanliness.)
470
	 */
471
	PGSemaphoreReset(&MyProc->sem);
472 473 474 475

	/*
	 * Arrange to clean up at process exit.
	 */
476
	on_shmem_exit(AuxiliaryProcKill, Int32GetDatum(proctype));
477 478
}

479 480 481 482 483 484 485 486 487 488 489 490 491 492
/*
 * Record the PID and PGPROC structures for the Startup process, for use in
 * ProcSendSignal().  See comments there for further explanation.
 */
void
PublishStartupProcessInformation(void)
{
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;

	SpinLockAcquire(ProcStructLock);

	procglobal->startupProc = MyProc;
	procglobal->startupProcPid = MyProcPid;
493
	procglobal->startupBufferPinWaitBufId = 0;
494 495 496 497

	SpinLockRelease(ProcStructLock);
}

498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519
/*
 * Used from bufgr to share the value of the buffer that Startup waits on,
 * or to reset the value to "not waiting" (-1). This allows processing
 * of recovery conflicts for buffer pins. Set is made before backends look
 * at this value, so locking not required, especially since the set is
 * an atomic integer set operation.
 */
void
SetStartupBufferPinWaitBufId(int bufid)
{
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;

	procglobal->startupBufferPinWaitBufId = bufid;
}

/*
 * Used by backends when they receive a request to check for buffer pin waits.
 */
int
GetStartupBufferPinWaitBufId(void)
{
B
Bruce Momjian 已提交
520
	int			bufid;
521 522 523 524 525 526 527 528 529

	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;

	bufid = procglobal->startupBufferPinWaitBufId;

	return bufid;
}

530 531 532 533 534 535 536 537 538
/*
 * Check whether there are at least N free PGPROC objects.
 *
 * Note: this is designed on the assumption that N will generally be small.
 */
bool
HaveNFreeProcs(int n)
{
	PGPROC	   *proc;
B
Bruce Momjian 已提交
539

540 541 542 543 544
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;

	SpinLockAcquire(ProcStructLock);

545
	proc = procglobal->freeProcs;
546

547
	while (n > 0 && proc != NULL)
548
	{
549
		proc = (PGPROC *) proc->links.next;
550 551 552 553 554 555 556 557
		n--;
	}

	SpinLockRelease(ProcStructLock);

	return (n <= 0);
}

558 559 560 561 562 563 564 565 566
bool
IsWaitingForLock(void)
{
	if (lockAwaited == NULL)
		return false;

	return true;
}

567 568 569 570
/*
 * Cancel any pending wait for lock, when aborting a transaction.
 *
 * (Normally, this would only happen if we accept a cancel/die
571
 * interrupt while waiting; but an ereport(ERROR) while waiting is
572 573
 * within the realm of possibility, too.)
 */
574
void
575 576
LockWaitCancel(void)
{
577 578
	LWLockId	partitionLock;

579
	/* Nothing to do if we weren't waiting for a lock */
580
	if (lockAwaited == NULL)
581
		return;
582

583
	/* Turn off the deadlock timer, if it's still running (see ProcSleep) */
584
	disable_sig_alarm(false);
585 586

	/* Unlink myself from the wait queue, if on it (might not be anymore!) */
587
	partitionLock = LockHashPartitionLock(lockAwaited->hashcode);
588
	LWLockAcquire(partitionLock, LW_EXCLUSIVE);
589

590
	if (MyProc->links.next != NULL)
591 592
	{
		/* We could not have been granted the lock yet */
593
		RemoveFromWaitQueue(MyProc, lockAwaited->hashcode);
594 595 596 597 598
	}
	else
	{
		/*
		 * Somebody kicked us off the lock queue already.  Perhaps they
B
Bruce Momjian 已提交
599 600 601
		 * granted us the lock, or perhaps they detected a deadlock. If they
		 * did grant us the lock, we'd better remember it in our local lock
		 * table.
602
		 */
603 604
		if (MyProc->waitStatus == STATUS_OK)
			GrantAwaitedLock();
605 606
	}

607
	lockAwaited = NULL;
608

609
	LWLockRelease(partitionLock);
H
Hiroshi Inoue 已提交
610

611
	/*
612
	 * We used to do PGSemaphoreReset() here to ensure that our proc's wait
B
Bruce Momjian 已提交
613 614 615 616 617 618
	 * semaphore is reset to zero.	This prevented a leftover wakeup signal
	 * from remaining in the semaphore if someone else had granted us the lock
	 * we wanted before we were able to remove ourselves from the wait-list.
	 * However, now that ProcSleep loops until waitStatus changes, a leftover
	 * wakeup signal isn't harmful, and it seems not worth expending cycles to
	 * get rid of a signal that most likely isn't there.
619
	 */
H
Hiroshi Inoue 已提交
620
}
621

622

623
/*
624
 * ProcReleaseLocks() -- release locks associated with current transaction
625
 *			at main transaction commit or abort
626 627
 *
 * At main transaction commit, we release all locks except session locks.
628
 * At main transaction abort, we release all locks including session locks.
629 630
 *
 * At subtransaction commit, we don't release any locks (so this func is not
631
 * needed at all); we will defer the releasing to the parent transaction.
632
 * At subtransaction abort, we release all locks held by the subtransaction;
633 634
 * this is implemented by retail releasing of the locks under control of
 * the ResourceOwner mechanism.
635 636
 */
void
637
ProcReleaseLocks(bool isCommit)
638
{
639 640
	if (!MyProc)
		return;
641 642 643
	/* If waiting, get off wait queue (should only be needed after error) */
	LockWaitCancel();
	/* Release locks */
644
	LockReleaseAll(DEFAULT_LOCKMETHOD, !isCommit);
645 646 647

	/* Release transaction level advisory locks */
	LockReleaseAll(USER_LOCKMETHOD, false);
648 649 650
}


651 652 653 654 655 656 657
/*
 * RemoveProcFromArray() -- Remove this process from the shared ProcArray.
 */
static void
RemoveProcFromArray(int code, Datum arg)
{
	Assert(MyProc != NULL);
658
	ProcArrayRemove(MyProc, InvalidTransactionId);
659 660
}

661 662
/*
 * ProcKill() -- Destroy the per-proc data structure for
663
 *		this process. Release any of its held LW locks.
664 665
 */
static void
666
ProcKill(int code, Datum arg)
667
{
668 669 670
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;

671
	Assert(MyProc != NULL);
672

673
	/*
B
Bruce Momjian 已提交
674 675
	 * Release any LW locks I am holding.  There really shouldn't be any, but
	 * it's cheap to check again before we cut the knees off the LWLock
676
	 * facility by releasing our PGPROC ...
677
	 */
678
	LWLockReleaseAll();
679

680
	SpinLockAcquire(ProcStructLock);
681

682 683
	/* Return PGPROC structure (and semaphore) to appropriate freelist */
	if (IsAnyAutoVacuumProcess())
684
	{
685 686
		MyProc->links.next = (SHM_QUEUE *) procglobal->autovacFreeProcs;
		procglobal->autovacFreeProcs = MyProc;
687 688 689
	}
	else
	{
690 691
		MyProc->links.next = (SHM_QUEUE *) procglobal->freeProcs;
		procglobal->freeProcs = MyProc;
692
	}
693

J
Jan Wieck 已提交
694
	/* PGPROC struct isn't mine anymore */
695
	MyProc = NULL;
696

697 698 699
	/* Update shared estimate of spins_per_delay */
	procglobal->spins_per_delay = update_spins_per_delay(procglobal->spins_per_delay);

700
	SpinLockRelease(ProcStructLock);
701

702 703
	/*
	 * This process is no longer present in shared memory in any meaningful
B
Bruce Momjian 已提交
704 705
	 * way, so tell the postmaster we've cleaned up acceptably well. (XXX
	 * autovac launcher should be included here someday)
706
	 */
707
	if (IsUnderPostmaster && !IsAutoVacuumLauncherProcess())
708 709
		MarkPostmasterChildInactive();

710 711
	/* wake autovac launcher if needed -- see comments in FreeWorkerInfo */
	if (AutovacuumLauncherPid != 0)
712
		kill(AutovacuumLauncherPid, SIGUSR2);
713 714 715
}

/*
716 717 718
 * AuxiliaryProcKill() -- Cut-down version of ProcKill for auxiliary
 *		processes (bgwriter, etc).	The PGPROC and sema are not released, only
 *		marked as not-in-use.
719 720
 */
static void
721
AuxiliaryProcKill(int code, Datum arg)
722
{
B
Bruce Momjian 已提交
723
	int			proctype = DatumGetInt32(arg);
724
	PGPROC	   *auxproc;
J
Jan Wieck 已提交
725

726
	Assert(proctype >= 0 && proctype < NUM_AUXILIARY_PROCS);
J
Jan Wieck 已提交
727

728
	auxproc = &AuxiliaryProcs[proctype];
J
Jan Wieck 已提交
729

730
	Assert(MyProc == auxproc);
731

732
	/* Release any LW locks I am holding (see notes above) */
733 734
	LWLockReleaseAll();

735 736
	SpinLockAcquire(ProcStructLock);

737
	/* Mark auxiliary proc no longer in use */
738 739
	MyProc->pid = 0;

J
Jan Wieck 已提交
740
	/* PGPROC struct isn't mine anymore */
741
	MyProc = NULL;
742 743 744 745 746

	/* Update shared estimate of spins_per_delay */
	ProcGlobal->spins_per_delay = update_spins_per_delay(ProcGlobal->spins_per_delay);

	SpinLockRelease(ProcStructLock);
747 748
}

749

750 751
/*
 * ProcQueue package: routines for putting processes to sleep
752
 *		and  waking them up
753 754 755 756 757
 */

/*
 * ProcQueueAlloc -- alloc/attach to a shared memory process queue
 *
758 759
 * Returns: a pointer to the queue
 * Side Effects: Initializes the queue if it wasn't there before
760
 */
761
#ifdef NOT_USED
762
PROC_QUEUE *
763
ProcQueueAlloc(const char *name)
764
{
765
	PROC_QUEUE *queue;
766
	bool		found;
767

768 769 770
	queue = (PROC_QUEUE *)
		ShmemInitStruct(name, sizeof(PROC_QUEUE), &found);

771 772
	if (!found)
		ProcQueueInit(queue);
773

774
	return queue;
775
}
776
#endif
777 778 779 780 781

/*
 * ProcQueueInit -- initialize a shared memory process queue
 */
void
782
ProcQueueInit(PROC_QUEUE *queue)
783
{
784 785
	SHMQueueInit(&(queue->links));
	queue->size = 0;
786 787 788 789
}


/*
790
 * ProcSleep -- put a process to sleep on the specified lock
791
 *
792 793
 * Caller must have set MyProc->heldLocks to reflect locks already held
 * on the lockable object by this process (under all XIDs).
794
 *
795
 * The lock table's partition lock must be held at entry, and will be held
796
 * at exit.
797
 *
798
 * Result: STATUS_OK if we acquired the lock, STATUS_ERROR if not (deadlock).
799
 *
800
 * ASSUME: that no one will fiddle with the queue until after
801
 *		we release the partition lock.
802 803
 *
 * NOTES: The process queue is now a priority queue for locking.
804 805 806
 *
 * P() on the semaphore should put us to sleep.  The process
 * semaphore is normally zero, so when we try to acquire it, we sleep.
807 808
 */
int
809
ProcSleep(LOCALLOCK *locallock, LockMethod lockMethodTable)
810
{
811 812 813
	LOCKMODE	lockmode = locallock->tag.mode;
	LOCK	   *lock = locallock->lock;
	PROCLOCK   *proclock = locallock->proclock;
814 815
	uint32		hashcode = locallock->hashcode;
	LWLockId	partitionLock = LockHashPartitionLock(hashcode);
816
	PROC_QUEUE *waitQueue = &(lock->waitProcs);
817
	LOCKMASK	myHeldLocks = MyProc->heldLocks;
818
	bool		early_deadlock = false;
B
Bruce Momjian 已提交
819
	bool		allow_autovacuum_cancel = true;
820
	int			myWaitStatus;
J
Jan Wieck 已提交
821
	PGPROC	   *proc;
822
	int			i;
823

824
	/*
825 826
	 * Determine where to add myself in the wait queue.
	 *
827 828 829 830
	 * Normally I should go at the end of the queue.  However, if I already
	 * hold locks that conflict with the request of any previous waiter, put
	 * myself in the queue just in front of the first such waiter. This is not
	 * a necessary step, since deadlock detection would move me to before that
B
Bruce Momjian 已提交
831 832
	 * waiter anyway; but it's relatively cheap to detect such a conflict
	 * immediately, and avoid delaying till deadlock timeout.
833
	 *
834 835
	 * Special case: if I find I should go in front of some waiter, check to
	 * see if I conflict with already-held locks or the requests before that
B
Bruce Momjian 已提交
836 837 838 839
	 * waiter.	If not, then just grant myself the requested lock immediately.
	 * This is the same as the test for immediate grant in LockAcquire, except
	 * we are only considering the part of the wait queue before my insertion
	 * point.
840 841
	 */
	if (myHeldLocks != 0)
V
Vadim B. Mikheev 已提交
842
	{
843
		LOCKMASK	aheadRequests = 0;
844

845
		proc = (PGPROC *) waitQueue->links.next;
846
		for (i = 0; i < waitQueue->size; i++)
V
Vadim B. Mikheev 已提交
847
		{
848
			/* Must he wait for me? */
B
Bruce Momjian 已提交
849
			if (lockMethodTable->conflictTab[proc->waitLockMode] & myHeldLocks)
V
Vadim B. Mikheev 已提交
850
			{
851
				/* Must I wait for him ? */
B
Bruce Momjian 已提交
852
				if (lockMethodTable->conflictTab[lockmode] & proc->heldLocks)
853
				{
854
					/*
B
Bruce Momjian 已提交
855 856 857 858 859
					 * Yes, so we have a deadlock.	Easiest way to clean up
					 * correctly is to call RemoveFromWaitQueue(), but we
					 * can't do that until we are *on* the wait queue. So, set
					 * a flag to check below, and break out of loop.  Also,
					 * record deadlock info for later message.
860
					 */
861
					RememberSimpleDeadLock(MyProc, lockmode, lock, proc);
862 863
					early_deadlock = true;
					break;
864
				}
865
				/* I must go before this waiter.  Check special case. */
B
Bruce Momjian 已提交
866
				if ((lockMethodTable->conflictTab[lockmode] & aheadRequests) == 0 &&
867 868 869
					LockCheckConflicts(lockMethodTable,
									   lockmode,
									   lock,
870
									   proclock,
871
									   MyProc) == STATUS_OK)
872
				{
873
					/* Skip the wait and just grant myself the lock. */
874
					GrantLock(lock, proclock, lockmode);
875
					GrantAwaitedLock();
876
					return STATUS_OK;
877 878
				}
				/* Break out of loop to put myself before him */
V
Vadim B. Mikheev 已提交
879
				break;
880
			}
881
			/* Nope, so advance to next waiter */
882
			aheadRequests |= LOCKBIT_ON(proc->waitLockMode);
883
			proc = (PGPROC *) proc->links.next;
V
Vadim B. Mikheev 已提交
884
		}
B
Bruce Momjian 已提交
885

886
		/*
B
Bruce Momjian 已提交
887 888
		 * If we fall out of loop normally, proc points to waitQueue head, so
		 * we will insert at tail of queue as desired.
889
		 */
890 891 892 893
	}
	else
	{
		/* I hold no locks, so I can't push in front of anyone. */
J
Jan Wieck 已提交
894
		proc = (PGPROC *) &(waitQueue->links);
V
Vadim B. Mikheev 已提交
895
	}
896

897
	/*
B
Bruce Momjian 已提交
898
	 * Insert self into queue, ahead of the given proc (or at tail of queue).
899
	 */
900
	SHMQueueInsertBefore(&(proc->links), &(MyProc->links));
B
Bruce Momjian 已提交
901
	waitQueue->size++;
902

903
	lock->waitMask |= LOCKBIT_ON(lockmode);
904

J
Jan Wieck 已提交
905
	/* Set up wait information in PGPROC object, too */
906
	MyProc->waitLock = lock;
907
	MyProc->waitProcLock = proclock;
908 909
	MyProc->waitLockMode = lockmode;

910
	MyProc->waitStatus = STATUS_WAITING;
911 912

	/*
B
Bruce Momjian 已提交
913 914 915
	 * If we detected deadlock, give up without waiting.  This must agree with
	 * CheckDeadLock's recovery code, except that we shouldn't release the
	 * semaphore since we haven't tried to lock it yet.
916 917 918
	 */
	if (early_deadlock)
	{
919
		RemoveFromWaitQueue(MyProc, hashcode);
920 921
		return STATUS_ERROR;
	}
922

923
	/* mark that we are waiting for a lock */
924
	lockAwaited = locallock;
925

926
	/*
927
	 * Release the lock table's partition lock.
928
	 *
929
	 * NOTE: this may also cause us to exit critical-section state, possibly
B
Bruce Momjian 已提交
930 931
	 * allowing a cancel/die interrupt to be accepted. This is OK because we
	 * have recorded the fact that we are waiting for a lock, and so
932
	 * LockWaitCancel will clean up if cancel/die happens.
933
	 */
934
	LWLockRelease(partitionLock);
935

936 937 938
	/* Reset deadlock_state before enabling the signal handler */
	deadlock_state = DS_NOT_YET_CHECKED;

939
	/*
B
Bruce Momjian 已提交
940 941 942 943
	 * Set timer so we can wake up after awhile and check for a deadlock. If a
	 * deadlock is detected, the handler releases the process's semaphore and
	 * sets MyProc->waitStatus = STATUS_ERROR, allowing us to know that we
	 * must report failure rather than success.
944
	 *
945 946
	 * By delaying the check until we've waited for a bit, we can avoid
	 * running the rather expensive deadlock-check code in most cases.
947
	 */
948
	if (!enable_sig_alarm(DeadlockTimeout, false))
949
		elog(FATAL, "could not set timer for process wakeup");
950

951
	/*
952
	 * If someone wakes us between LWLockRelease and PGSemaphoreLock,
B
Bruce Momjian 已提交
953
	 * PGSemaphoreLock will not block.	The wakeup is "saved" by the semaphore
B
Bruce Momjian 已提交
954 955 956 957 958
	 * implementation.	While this is normally good, there are cases where a
	 * saved wakeup might be leftover from a previous operation (for example,
	 * we aborted ProcWaitForSignal just before someone did ProcSendSignal).
	 * So, loop to wait again if the waitStatus shows we haven't been granted
	 * nor denied the lock yet.
959
	 *
960 961 962 963 964 965 966
	 * We pass interruptOK = true, which eliminates a window in which
	 * cancel/die interrupts would be held off undesirably.  This is a promise
	 * that we don't mind losing control to a cancel/die interrupt here.  We
	 * don't, because we have no shared-state-change work to do after being
	 * granted the lock (the grantor did it all).  We do have to worry about
	 * updating the locallock table, but if we lose control to an error,
	 * LockWaitCancel will fix that up.
967
	 */
B
Bruce Momjian 已提交
968 969
	do
	{
970
		PGSemaphoreLock(&MyProc->sem, true);
971

972 973
		/*
		 * waitStatus could change from STATUS_WAITING to something else
B
Bruce Momjian 已提交
974
		 * asynchronously.	Read it just once per loop to prevent surprising
975 976 977 978
		 * behavior (such as missing log messages).
		 */
		myWaitStatus = MyProc->waitStatus;

979 980
		/*
		 * If we are not deadlocked, but are waiting on an autovacuum-induced
B
Bruce Momjian 已提交
981
		 * task, send a signal to interrupt it.
982 983 984
		 */
		if (deadlock_state == DS_BLOCKED_BY_AUTOVACUUM && allow_autovacuum_cancel)
		{
B
Bruce Momjian 已提交
985
			PGPROC	   *autovac = GetBlockingAutoVacuumPgproc();
986 987 988 989 990 991 992 993 994 995 996

			LWLockAcquire(ProcArrayLock, LW_EXCLUSIVE);

			/*
			 * Only do it if the worker is not working to protect against Xid
			 * wraparound.
			 */
			if ((autovac != NULL) &&
				(autovac->vacuumFlags & PROC_IS_AUTOVACUUM) &&
				!(autovac->vacuumFlags & PROC_VACUUM_FOR_WRAPAROUND))
			{
B
Bruce Momjian 已提交
997
				int			pid = autovac->pid;
998

P
Peter Eisentraut 已提交
999
				elog(DEBUG2, "sending cancel to blocking autovacuum PID %d",
1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
					 pid);

				/* don't hold the lock across the kill() syscall */
				LWLockRelease(ProcArrayLock);

				/* send the autovacuum worker Back to Old Kent Road */
				if (kill(pid, SIGINT) < 0)
				{
					/* Just a warning to allow multiple callers */
					ereport(WARNING,
							(errmsg("could not send signal to process %d: %m",
									pid)));
				}
			}
			else
				LWLockRelease(ProcArrayLock);

			/* prevent signal from being resent more than once */
			allow_autovacuum_cancel = false;
		}

1021 1022 1023 1024
		/*
		 * If awoken after the deadlock check interrupt has run, and
		 * log_lock_waits is on, then report about the wait.
		 */
1025
		if (log_lock_waits && deadlock_state != DS_NOT_YET_CHECKED)
1026
		{
1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044
			StringInfoData buf;
			const char *modename;
			long		secs;
			int			usecs;
			long		msecs;

			initStringInfo(&buf);
			DescribeLockTag(&buf, &locallock->tag.lock);
			modename = GetLockmodeName(locallock->tag.lock.locktag_lockmethodid,
									   lockmode);
			TimestampDifference(timeout_start_time, GetCurrentTimestamp(),
								&secs, &usecs);
			msecs = secs * 1000 + usecs / 1000;
			usecs = usecs % 1000;

			if (deadlock_state == DS_SOFT_DEADLOCK)
				ereport(LOG,
						(errmsg("process %d avoided deadlock for %s on %s by rearranging queue order after %ld.%03d ms",
B
Bruce Momjian 已提交
1045
							  MyProcPid, modename, buf.data, msecs, usecs)));
1046
			else if (deadlock_state == DS_HARD_DEADLOCK)
1047
			{
1048
				/*
B
Bruce Momjian 已提交
1049 1050 1051 1052
				 * This message is a bit redundant with the error that will be
				 * reported subsequently, but in some cases the error report
				 * might not make it to the log (eg, if it's caught by an
				 * exception handler), and we want to ensure all long-wait
1053 1054 1055 1056
				 * events get logged.
				 */
				ereport(LOG,
						(errmsg("process %d detected deadlock while waiting for %s on %s after %ld.%03d ms",
B
Bruce Momjian 已提交
1057
							  MyProcPid, modename, buf.data, msecs, usecs)));
1058
			}
1059 1060 1061 1062

			if (myWaitStatus == STATUS_WAITING)
				ereport(LOG,
						(errmsg("process %d still waiting for %s on %s after %ld.%03d ms",
B
Bruce Momjian 已提交
1063
							  MyProcPid, modename, buf.data, msecs, usecs)));
1064 1065
			else if (myWaitStatus == STATUS_OK)
				ereport(LOG,
B
Bruce Momjian 已提交
1066 1067
					(errmsg("process %d acquired %s on %s after %ld.%03d ms",
							MyProcPid, modename, buf.data, msecs, usecs)));
1068 1069 1070
			else
			{
				Assert(myWaitStatus == STATUS_ERROR);
B
Bruce Momjian 已提交
1071

1072 1073
				/*
				 * Currently, the deadlock checker always kicks its own
B
Bruce Momjian 已提交
1074 1075 1076 1077 1078
				 * process, which means that we'll only see STATUS_ERROR when
				 * deadlock_state == DS_HARD_DEADLOCK, and there's no need to
				 * print redundant messages.  But for completeness and
				 * future-proofing, print a message if it looks like someone
				 * else kicked us off the lock.
1079 1080 1081 1082
				 */
				if (deadlock_state != DS_HARD_DEADLOCK)
					ereport(LOG,
							(errmsg("process %d failed to acquire %s on %s after %ld.%03d ms",
B
Bruce Momjian 已提交
1083
							  MyProcPid, modename, buf.data, msecs, usecs)));
1084 1085 1086
			}

			/*
B
Bruce Momjian 已提交
1087 1088
			 * At this point we might still need to wait for the lock. Reset
			 * state so we don't print the above messages again.
1089 1090 1091 1092
			 */
			deadlock_state = DS_NO_DEADLOCK;

			pfree(buf.data);
1093
		}
1094
	} while (myWaitStatus == STATUS_WAITING);
1095

1096
	/*
1097
	 * Disable the timer, if it's still running
B
Bruce Momjian 已提交
1098
	 */
1099
	if (!disable_sig_alarm(false))
1100
		elog(FATAL, "could not disable timer for process wakeup");
B
Bruce Momjian 已提交
1101

1102
	/*
B
Bruce Momjian 已提交
1103 1104 1105
	 * Re-acquire the lock table's partition lock.  We have to do this to hold
	 * off cancel/die interrupts before we can mess with lockAwaited (else we
	 * might have a missed or duplicated locallock update).
1106
	 */
1107
	LWLockAcquire(partitionLock, LW_EXCLUSIVE);
1108 1109 1110

	/*
	 * We no longer want LockWaitCancel to do anything.
1111
	 */
1112
	lockAwaited = NULL;
1113

1114
	/*
1115
	 * If we got the lock, be sure to remember it in the locallock table.
1116
	 */
1117
	if (MyProc->waitStatus == STATUS_OK)
1118
		GrantAwaitedLock();
1119

1120 1121 1122 1123
	/*
	 * We don't have to do anything else, because the awaker did all the
	 * necessary update of the lock table and MyProc.
	 */
1124
	return MyProc->waitStatus;
1125 1126 1127 1128 1129 1130
}


/*
 * ProcWakeup -- wake up a process by releasing its private semaphore.
 *
1131
 *	 Also remove the process from the wait queue and set its links invalid.
1132
 *	 RETURN: the next process in the wait queue.
1133
 *
1134 1135
 * The appropriate lock partition lock must be held by caller.
 *
1136 1137 1138
 * XXX: presently, this code is only used for the "success" case, and only
 * works correctly for that case.  To clean up in failure case, would need
 * to twiddle the lock's request counts too --- see RemoveFromWaitQueue.
1139
 * Hence, in practice the waitStatus parameter must be STATUS_OK.
1140
 */
J
Jan Wieck 已提交
1141
PGPROC *
1142
ProcWakeup(PGPROC *proc, int waitStatus)
1143
{
J
Jan Wieck 已提交
1144
	PGPROC	   *retProc;
1145

1146
	/* Proc should be sleeping ... */
1147 1148
	if (proc->links.prev == NULL ||
		proc->links.next == NULL)
1149
		return NULL;
1150
	Assert(proc->waitStatus == STATUS_WAITING);
1151

1152
	/* Save next process before we zap the list link */
1153
	retProc = (PGPROC *) proc->links.next;
1154

1155
	/* Remove process from wait queue */
1156
	SHMQueueDelete(&(proc->links));
1157
	(proc->waitLock->waitProcs.size)--;
1158

1159 1160
	/* Clean up process' state and pass it the ok/fail signal */
	proc->waitLock = NULL;
1161
	proc->waitProcLock = NULL;
1162
	proc->waitStatus = waitStatus;
1163

1164
	/* And awaken it */
1165
	PGSemaphoreUnlock(&proc->sem);
1166 1167

	return retProc;
1168 1169 1170 1171
}

/*
 * ProcLockWakeup -- routine for waking up processes when a lock is
1172 1173
 *		released (or a prior waiter is aborted).  Scan all waiters
 *		for lock, waken any that are no longer blocked.
1174 1175
 *
 * The appropriate lock partition lock must be held by caller.
1176
 */
1177
void
1178
ProcLockWakeup(LockMethod lockMethodTable, LOCK *lock)
1179
{
1180 1181
	PROC_QUEUE *waitQueue = &(lock->waitProcs);
	int			queue_size = waitQueue->size;
J
Jan Wieck 已提交
1182
	PGPROC	   *proc;
1183
	LOCKMASK	aheadRequests = 0;
M
 
Marc G. Fournier 已提交
1184

1185
	Assert(queue_size >= 0);
1186

1187 1188
	if (queue_size == 0)
		return;
1189

1190
	proc = (PGPROC *) waitQueue->links.next;
1191

1192 1193
	while (queue_size-- > 0)
	{
B
Bruce Momjian 已提交
1194
		LOCKMODE	lockmode = proc->waitLockMode;
M
 
Marc G. Fournier 已提交
1195 1196

		/*
B
Bruce Momjian 已提交
1197 1198
		 * Waken if (a) doesn't conflict with requests of earlier waiters, and
		 * (b) doesn't conflict with already-held locks.
M
 
Marc G. Fournier 已提交
1199
		 */
B
Bruce Momjian 已提交
1200
		if ((lockMethodTable->conflictTab[lockmode] & aheadRequests) == 0 &&
1201 1202 1203
			LockCheckConflicts(lockMethodTable,
							   lockmode,
							   lock,
1204
							   proc->waitProcLock,
1205
							   proc) == STATUS_OK)
M
 
Marc G. Fournier 已提交
1206
		{
1207
			/* OK to waken */
1208
			GrantLock(lock, proc->waitProcLock, lockmode);
1209
			proc = ProcWakeup(proc, STATUS_OK);
B
Bruce Momjian 已提交
1210

1211
			/*
B
Bruce Momjian 已提交
1212 1213 1214
			 * ProcWakeup removes proc from the lock's waiting process queue
			 * and returns the next proc in chain; don't use proc's next-link,
			 * because it's been cleared.
1215
			 */
M
 
Marc G. Fournier 已提交
1216
		}
1217
		else
1218
		{
B
Bruce Momjian 已提交
1219
			/*
B
Bruce Momjian 已提交
1220
			 * Cannot wake this guy. Remember his request for later checks.
B
Bruce Momjian 已提交
1221
			 */
1222
			aheadRequests |= LOCKBIT_ON(lockmode);
1223
			proc = (PGPROC *) proc->links.next;
1224
		}
M
 
Marc G. Fournier 已提交
1225
	}
1226 1227

	Assert(waitQueue->size >= 0);
1228 1229
}

1230 1231 1232
/*
 * CheckDeadLock
 *
1233
 * We only get to this routine if we got SIGALRM after DeadlockTimeout
1234 1235
 * while waiting for a lock to be released by some other process.  Look
 * to see if there's a deadlock; if not, just return and continue waiting.
1236
 * (But signal ProcSleep to log a message, if log_lock_waits is true.)
1237 1238
 * If we have a real deadlock, remove ourselves from the lock's wait queue
 * and signal an error to ProcSleep.
1239 1240 1241
 *
 * NB: this is run inside a signal handler, so be very wary about what is done
 * here or in called routines.
1242
 */
1243
static void
1244
CheckDeadLock(void)
1245
{
1246 1247
	int			i;

1248
	/*
B
Bruce Momjian 已提交
1249 1250
	 * Acquire exclusive lock on the entire shared lock data structures. Must
	 * grab LWLocks in partition-number order to avoid LWLock deadlock.
1251 1252 1253 1254 1255 1256
	 *
	 * Note that the deadlock check interrupt had better not be enabled
	 * anywhere that this process itself holds lock partition locks, else this
	 * will wait forever.  Also note that LWLockAcquire creates a critical
	 * section, so that this routine cannot be interrupted by cancel/die
	 * interrupts.
1257
	 */
1258 1259
	for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
		LWLockAcquire(FirstLockMgrLock + i, LW_EXCLUSIVE);
1260

1261
	/*
1262 1263
	 * Check to see if we've been awoken by anyone in the interim.
	 *
1264
	 * If we have, we can return and resume our transaction -- happy day.
1265 1266
	 * Before we are awoken the process releasing the lock grants it to us so
	 * we know that we don't have to wait anymore.
1267
	 *
1268
	 * We check by looking to see if we've been unlinked from the wait queue.
B
Bruce Momjian 已提交
1269
	 * This is quicker than checking our semaphore's state, since no kernel
1270
	 * call is needed, and it is safe because we hold the lock partition lock.
1271
	 */
1272 1273
	if (MyProc->links.prev == NULL ||
		MyProc->links.next == NULL)
1274 1275 1276 1277 1278 1279 1280 1281 1282 1283
		goto check_done;

#ifdef LOCK_DEBUG
	if (Debug_deadlocks)
		DumpAllLocks();
#endif

	/* Run the deadlock check, and set deadlock_state for use by ProcSleep */
	deadlock_state = DeadLockCheck(MyProc);

1284
	if (deadlock_state == DS_HARD_DEADLOCK)
B
Bruce Momjian 已提交
1285
	{
1286 1287 1288
		/*
		 * Oops.  We have a deadlock.
		 *
1289 1290 1291 1292
		 * Get this process out of wait state. (Note: we could do this more
		 * efficiently by relying on lockAwaited, but use this coding to
		 * preserve the flexibility to kill some other transaction than the
		 * one detecting the deadlock.)
1293 1294
		 *
		 * RemoveFromWaitQueue sets MyProc->waitStatus to STATUS_ERROR, so
1295 1296
		 * ProcSleep will report an error after we return from the signal
		 * handler.
1297 1298 1299
		 */
		Assert(MyProc->waitLock != NULL);
		RemoveFromWaitQueue(MyProc, LockTagHashCode(&(MyProc->waitLock->tag)));
1300

1301 1302 1303 1304 1305
		/*
		 * Unlock my semaphore so that the interrupted ProcSleep() call can
		 * finish.
		 */
		PGSemaphoreUnlock(&MyProc->sem);
1306

1307
		/*
1308 1309 1310 1311 1312 1313 1314 1315
		 * We're done here.  Transaction abort caused by the error that
		 * ProcSleep will raise will cause any other locks we hold to be
		 * released, thus allowing other processes to wake up; we don't need
		 * to do that here.  NOTE: an exception is that releasing locks we
		 * hold doesn't consider the possibility of waiters that were blocked
		 * behind us on the lock we just failed to get, and might now be
		 * wakable because we're not in front of them anymore.  However,
		 * RemoveFromWaitQueue took care of waking up any such processes.
1316 1317
		 */
	}
1318
	else if (log_lock_waits || deadlock_state == DS_BLOCKED_BY_AUTOVACUUM)
1319 1320 1321 1322
	{
		/*
		 * Unlock my semaphore so that the interrupted ProcSleep() call can
		 * print the log message (we daren't do it here because we are inside
B
Bruce Momjian 已提交
1323 1324
		 * a signal handler).  It will then sleep again until someone releases
		 * the lock.
1325 1326
		 *
		 * If blocked by autovacuum, this wakeup will enable ProcSleep to send
1327
		 * the canceling signal to the autovacuum worker.
1328 1329 1330
		 */
		PGSemaphoreUnlock(&MyProc->sem);
	}
1331 1332

	/*
B
Bruce Momjian 已提交
1333 1334 1335 1336 1337
	 * And release locks.  We do this in reverse order for two reasons: (1)
	 * Anyone else who needs more than one of the locks will be trying to lock
	 * them in increasing order; we don't want to release the other process
	 * until it can get all the locks it needs. (2) This avoids O(N^2)
	 * behavior inside LWLockRelease.
1338
	 */
1339
check_done:
B
Bruce Momjian 已提交
1340
	for (i = NUM_LOCK_PARTITIONS; --i >= 0;)
1341
		LWLockRelease(FirstLockMgrLock + i);
1342 1343 1344
}


1345 1346 1347 1348 1349 1350
/*
 * ProcWaitForSignal - wait for a signal from another backend.
 *
 * This can share the semaphore normally used for waiting for locks,
 * since a backend could never be waiting for a lock and a signal at
 * the same time.  As with locks, it's OK if the signal arrives just
B
Bruce Momjian 已提交
1351
 * before we actually reach the waiting state.	Also as with locks,
1352 1353
 * it's necessary that the caller be robust against bogus wakeups:
 * always check that the desired state has occurred, and wait again
B
Bruce Momjian 已提交
1354
 * if not.	This copes with possible "leftover" wakeups.
1355 1356 1357 1358
 */
void
ProcWaitForSignal(void)
{
1359
	PGSemaphoreLock(&MyProc->sem, true);
1360 1361 1362
}

/*
1363
 * ProcSendSignal - send a signal to a backend identified by PID
1364 1365
 */
void
1366
ProcSendSignal(int pid)
1367
{
1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378
	PGPROC	   *proc = NULL;

	if (RecoveryInProgress())
	{
		/* use volatile pointer to prevent code rearrangement */
		volatile PROC_HDR *procglobal = ProcGlobal;

		SpinLockAcquire(ProcStructLock);

		/*
		 * Check to see whether it is the Startup process we wish to signal.
B
Bruce Momjian 已提交
1379 1380
		 * This call is made by the buffer manager when it wishes to wake up a
		 * process that has been waiting for a pin in so it can obtain a
1381
		 * cleanup lock using LockBufferForCleanup(). Startup is not a normal
B
Bruce Momjian 已提交
1382 1383
		 * backend, so BackendPidGetProc() will not return any pid at all. So
		 * we remember the information for this special case.
1384 1385 1386 1387 1388 1389 1390 1391 1392
		 */
		if (pid == procglobal->startupProcPid)
			proc = procglobal->startupProc;

		SpinLockRelease(ProcStructLock);
	}

	if (proc == NULL)
		proc = BackendPidGetProc(pid);
1393 1394

	if (proc != NULL)
1395
		PGSemaphoreUnlock(&proc->sem);
1396 1397 1398
}


1399 1400 1401 1402 1403 1404 1405 1406 1407
/*****************************************************************************
 * SIGALRM interrupt support
 *
 * Maybe these should be in pqsignal.c?
 *****************************************************************************/

/*
 * Enable the SIGALRM interrupt to fire after the specified delay
 *
1408
 * Delay is given in milliseconds.	Caller should be sure a SIGALRM
1409 1410
 * signal handler is installed before this is called.
 *
1411 1412
 * This code properly handles nesting of deadlock timeout alarms within
 * statement timeout alarms.
1413
 *
1414 1415 1416
 * Returns TRUE if okay, FALSE on failure.
 */
bool
1417
enable_sig_alarm(int delayms, bool is_statement_timeout)
1418
{
1419
	TimestampTz fin_time;
1420
	struct itimerval timeval;
1421

1422 1423
	if (is_statement_timeout)
	{
1424 1425 1426 1427 1428 1429 1430 1431 1432 1433
		/*
		 * Begin statement-level timeout
		 *
		 * Note that we compute statement_fin_time with reference to the
		 * statement_timestamp, but apply the specified delay without any
		 * correction; that is, we ignore whatever time has elapsed since
		 * statement_timestamp was set.  In the normal case only a small
		 * interval will have elapsed and so this doesn't matter, but there
		 * are corner cases (involving multi-statement query strings with
		 * embedded COMMIT or ROLLBACK) where we might re-initialize the
B
Bruce Momjian 已提交
1434 1435 1436 1437
		 * statement timeout long after initial receipt of the message. In
		 * such cases the enforcement of the statement timeout will be a bit
		 * inconsistent.  This annoyance is judged not worth the cost of
		 * performing an additional gettimeofday() here.
1438
		 */
1439
		Assert(!deadlock_timeout_active);
1440 1441
		fin_time = GetCurrentStatementStartTimestamp();
		fin_time = TimestampTzPlusMilliseconds(fin_time, delayms);
1442
		statement_fin_time = fin_time;
1443
		cancel_from_timeout = false;
1444
		statement_timeout_active = true;
1445 1446 1447 1448 1449 1450
	}
	else if (statement_timeout_active)
	{
		/*
		 * Begin deadlock timeout with statement-level timeout active
		 *
1451 1452 1453 1454
		 * Here, we want to interrupt at the closer of the two timeout times.
		 * If fin_time >= statement_fin_time then we need not touch the
		 * existing timer setting; else set up to interrupt at the deadlock
		 * timeout time.
1455 1456 1457
		 *
		 * NOTE: in this case it is possible that this routine will be
		 * interrupted by the previously-set timer alarm.  This is okay
B
Bruce Momjian 已提交
1458 1459 1460
		 * because the signal handler will do only what it should do according
		 * to the state variables.	The deadlock checker may get run earlier
		 * than normal, but that does no harm.
1461
		 */
1462 1463
		timeout_start_time = GetCurrentTimestamp();
		fin_time = TimestampTzPlusMilliseconds(timeout_start_time, delayms);
1464
		deadlock_timeout_active = true;
1465
		if (fin_time >= statement_fin_time)
1466 1467 1468 1469 1470 1471
			return true;
	}
	else
	{
		/* Begin deadlock timeout with no statement-level timeout */
		deadlock_timeout_active = true;
1472 1473 1474
		/* GetCurrentTimestamp can be expensive, so only do it if we must */
		if (log_lock_waits)
			timeout_start_time = GetCurrentTimestamp();
1475
	}
1476

1477
	/* If we reach here, okay to set the timer interrupt */
1478
	MemSet(&timeval, 0, sizeof(struct itimerval));
1479 1480
	timeval.it_value.tv_sec = delayms / 1000;
	timeval.it_value.tv_usec = (delayms % 1000) * 1000;
1481
	if (setitimer(ITIMER_REAL, &timeval, NULL))
1482
		return false;
1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503
	return true;
}

/*
 * Cancel the SIGALRM timer, either for a deadlock timeout or a statement
 * timeout.  If a deadlock timeout is canceled, any active statement timeout
 * remains in force.
 *
 * Returns TRUE if okay, FALSE on failure.
 */
bool
disable_sig_alarm(bool is_statement_timeout)
{
	/*
	 * Always disable the interrupt if it is active; this avoids being
	 * interrupted by the signal handler and thereby possibly getting
	 * confused.
	 *
	 * We will re-enable the interrupt if necessary in CheckStatementTimeout.
	 */
	if (statement_timeout_active || deadlock_timeout_active)
1504
	{
1505
		struct itimerval timeval;
1506

1507
		MemSet(&timeval, 0, sizeof(struct itimerval));
1508
		if (setitimer(ITIMER_REAL, &timeval, NULL))
1509
		{
1510 1511 1512
			statement_timeout_active = false;
			cancel_from_timeout = false;
			deadlock_timeout_active = false;
1513 1514
			return false;
		}
1515 1516
	}

1517 1518 1519 1520
	/* Always cancel deadlock timeout, in case this is error cleanup */
	deadlock_timeout_active = false;

	/* Cancel or reschedule statement timeout */
1521
	if (is_statement_timeout)
1522
	{
1523
		statement_timeout_active = false;
1524 1525
		cancel_from_timeout = false;
	}
1526 1527 1528 1529 1530
	else if (statement_timeout_active)
	{
		if (!CheckStatementTimeout())
			return false;
	}
1531 1532 1533
	return true;
}

1534

1535
/*
1536 1537 1538
 * Check for statement timeout.  If the timeout time has come,
 * trigger a query-cancel interrupt; if not, reschedule the SIGALRM
 * interrupt to occur at the right time.
1539
 *
1540
 * Returns true if okay, false if failed to set the interrupt.
1541
 */
1542 1543
static bool
CheckStatementTimeout(void)
1544
{
1545
	TimestampTz now;
B
Bruce Momjian 已提交
1546

1547 1548 1549
	if (!statement_timeout_active)
		return true;			/* do nothing if not active */

1550
	now = GetCurrentTimestamp();
1551

1552
	if (now >= statement_fin_time)
1553
	{
1554 1555
		/* Time to die */
		statement_timeout_active = false;
1556
		cancel_from_timeout = true;
1557 1558 1559 1560
#ifdef HAVE_SETSID
		/* try to signal whole process group */
		kill(-MyProcPid, SIGINT);
#endif
1561
		kill(MyProcPid, SIGINT);
1562 1563 1564 1565
	}
	else
	{
		/* Not time yet, so (re)schedule the interrupt */
1566 1567
		long		secs;
		int			usecs;
1568 1569
		struct itimerval timeval;

1570 1571
		TimestampDifference(now, statement_fin_time,
							&secs, &usecs);
B
Bruce Momjian 已提交
1572

1573 1574 1575 1576 1577 1578
		/*
		 * It's possible that the difference is less than a microsecond;
		 * ensure we don't cancel, rather than set, the interrupt.
		 */
		if (secs == 0 && usecs == 0)
			usecs = 1;
1579
		MemSet(&timeval, 0, sizeof(struct itimerval));
1580 1581
		timeval.it_value.tv_sec = secs;
		timeval.it_value.tv_usec = usecs;
1582
		if (setitimer(ITIMER_REAL, &timeval, NULL))
1583 1584 1585
			return false;
	}

1586 1587
	return true;
}
1588 1589 1590


/*
1591
 * Signal handler for SIGALRM for normal user backends
1592 1593 1594 1595 1596
 *
 * Process deadlock check and/or statement timeout check, as needed.
 * To avoid various edge cases, we must be careful to do nothing
 * when there is nothing to be done.  We also need to be able to
 * reschedule the timer interrupt if called before end of statement.
1597 1598 1599 1600
 */
void
handle_sig_alarm(SIGNAL_ARGS)
{
1601 1602 1603
	int			save_errno = errno;

	if (deadlock_timeout_active)
1604
	{
1605
		deadlock_timeout_active = false;
1606 1607
		CheckDeadLock();
	}
1608 1609 1610 1611 1612

	if (statement_timeout_active)
		(void) CheckStatementTimeout();

	errno = save_errno;
1613
}
1614 1615 1616 1617 1618 1619 1620

/*
 * Signal handler for SIGALRM in Startup process
 *
 * To avoid various edge cases, we must be careful to do nothing
 * when there is nothing to be done.  We also need to be able to
 * reschedule the timer interrupt if called before end of statement.
1621 1622 1623
 *
 * We set either deadlock_timeout_active or statement_timeout_active
 * or both. Interrupts are enabled if standby_timeout_active.
1624 1625
 */
bool
1626
enable_standby_sig_alarm(TimestampTz now, TimestampTz fin_time, bool deadlock_only)
1627
{
1628 1629
	TimestampTz deadlock_time = TimestampTzPlusMilliseconds(now,
															DeadlockTimeout);
1630

1631 1632 1633
	if (deadlock_only)
	{
		/*
1634
		 * Wake up at deadlock_time only, then wait forever
1635 1636 1637 1638 1639 1640 1641 1642
		 */
		statement_fin_time = deadlock_time;
		deadlock_timeout_active = true;
		statement_timeout_active = false;
	}
	else if (fin_time > deadlock_time)
	{
		/*
1643
		 * Wake up at deadlock_time, then again at fin_time
1644 1645 1646 1647 1648 1649 1650 1651 1652
		 */
		statement_fin_time = deadlock_time;
		statement_fin_time2 = fin_time;
		deadlock_timeout_active = true;
		statement_timeout_active = true;
	}
	else
	{
		/*
1653
		 * Wake only at fin_time because its fairly soon
1654 1655 1656 1657 1658
		 */
		statement_fin_time = fin_time;
		deadlock_timeout_active = false;
		statement_timeout_active = true;
	}
1659

1660 1661 1662 1663 1664
	if (deadlock_timeout_active || statement_timeout_active)
	{
		long		secs;
		int			usecs;
		struct itimerval timeval;
B
Bruce Momjian 已提交
1665

1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676
		TimestampDifference(now, statement_fin_time,
							&secs, &usecs);
		if (secs == 0 && usecs == 0)
			usecs = 1;
		MemSet(&timeval, 0, sizeof(struct itimerval));
		timeval.it_value.tv_sec = secs;
		timeval.it_value.tv_usec = usecs;
		if (setitimer(ITIMER_REAL, &timeval, NULL))
			return false;
		standby_timeout_active = true;
	}
1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716

	return true;
}

bool
disable_standby_sig_alarm(void)
{
	/*
	 * Always disable the interrupt if it is active; this avoids being
	 * interrupted by the signal handler and thereby possibly getting
	 * confused.
	 *
	 * We will re-enable the interrupt if necessary in CheckStandbyTimeout.
	 */
	if (standby_timeout_active)
	{
		struct itimerval timeval;

		MemSet(&timeval, 0, sizeof(struct itimerval));
		if (setitimer(ITIMER_REAL, &timeval, NULL))
		{
			standby_timeout_active = false;
			return false;
		}
	}

	standby_timeout_active = false;

	return true;
}

/*
 * CheckStandbyTimeout() runs unconditionally in the Startup process
 * SIGALRM handler. Timers will only be set when InHotStandby.
 * We simply ignore any signals unless the timer has been set.
 */
static bool
CheckStandbyTimeout(void)
{
	TimestampTz now;
B
Bruce Momjian 已提交
1717
	bool		reschedule = false;
1718 1719 1720 1721 1722

	standby_timeout_active = false;

	now = GetCurrentTimestamp();

1723
	/*
B
Bruce Momjian 已提交
1724 1725
	 * Reschedule the timer if its not time to wake yet, or if we have both
	 * timers set and the first one has just been reached.
1726
	 */
1727
	if (now >= statement_fin_time)
1728 1729 1730 1731
	{
		if (deadlock_timeout_active)
		{
			/*
1732
			 * We're still waiting when we reach deadlock timeout, so send out
B
Bruce Momjian 已提交
1733 1734
			 * a request to have other backends check themselves for deadlock.
			 * Then continue waiting until statement_fin_time, if that's set.
1735 1736 1737 1738 1739
			 */
			SendRecoveryConflictWithBufferPin(PROCSIG_RECOVERY_CONFLICT_STARTUP_DEADLOCK);
			deadlock_timeout_active = false;

			/*
1740
			 * Begin second waiting period if required.
1741 1742 1743 1744 1745 1746 1747 1748 1749 1750
			 */
			if (statement_timeout_active)
			{
				reschedule = true;
				statement_fin_time = statement_fin_time2;
			}
		}
		else
		{
			/*
1751 1752
			 * We've now reached statement_fin_time, so ask all conflicts to
			 * leave, so we can press ahead with applying changes in recovery.
1753 1754 1755 1756
			 */
			SendRecoveryConflictWithBufferPin(PROCSIG_RECOVERY_CONFLICT_BUFFERPIN);
		}
	}
1757
	else
1758 1759 1760
		reschedule = true;

	if (reschedule)
1761 1762 1763 1764
	{
		long		secs;
		int			usecs;
		struct itimerval timeval;
B
Bruce Momjian 已提交
1765

1766 1767 1768 1769 1770 1771 1772 1773 1774
		TimestampDifference(now, statement_fin_time,
							&secs, &usecs);
		if (secs == 0 && usecs == 0)
			usecs = 1;
		MemSet(&timeval, 0, sizeof(struct itimerval));
		timeval.it_value.tv_sec = secs;
		timeval.it_value.tv_usec = usecs;
		if (setitimer(ITIMER_REAL, &timeval, NULL))
			return false;
1775
		standby_timeout_active = true;
1776 1777 1778 1779 1780 1781 1782 1783
	}

	return true;
}

void
handle_standby_sig_alarm(SIGNAL_ARGS)
{
B
Bruce Momjian 已提交
1784
	int			save_errno = errno;
1785 1786 1787 1788 1789 1790

	if (standby_timeout_active)
		(void) CheckStandbyTimeout();

	errno = save_errno;
}