proc.c 49.4 KB
Newer Older
1 2
/*-------------------------------------------------------------------------
 *
3
 * proc.c
4
 *	  routines to manage per-process shared memory data structure
5
 *
6
 * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group
B
Add:  
Bruce Momjian 已提交
7
 * Portions Copyright (c) 1994, Regents of the University of California
8 9 10
 *
 *
 * IDENTIFICATION
B
Bruce Momjian 已提交
11
 *	  $PostgreSQL: pgsql/src/backend/storage/lmgr/proc.c,v 1.217 2010/02/26 02:01:01 momjian Exp $
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/walsender.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 89


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

V
Vadim B. Mikheev 已提交
96

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

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

	return size;
}

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

132 133
/*
 * InitProcGlobal -
134 135
 *	  Initialize the global process table during postmaster or standalone
 *	  backend startup.
136
 *
137
 *	  We also create all the per-process semaphores we will need to support
138 139 140 141 142 143 144
 *	  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
145 146
 *	  MaxConnections or autovacuum_max_workers higher than his kernel will
 *	  support, he'll find out sooner rather than later.
147 148 149 150
 *
 *	  Another reason for creating semaphores here is that the semaphore
 *	  implementation typically requires us to create semaphores in the
 *	  postmaster, not in backends.
151 152
 *
 * Note: this is NOT called by individual backends under a postmaster,
153
 * not even in the EXEC_BACKEND case.  The ProcGlobal and AuxiliaryProcs
154
 * pointers must be propagated specially for EXEC_BACKEND operation.
155 156
 */
void
157
InitProcGlobal(void)
158
{
159 160 161
	PGPROC	   *procs;
	int			i;
	bool		found;
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
	 * Create the PGPROC structures for auxiliary (bgwriter) processes, too.
	 * These do not get linked into the freeProcs list.
171
	 */
172 173
	AuxiliaryProcs = (PGPROC *)
		ShmemInitStruct("AuxiliaryProcs", NUM_AUXILIARY_PROCS * sizeof(PGPROC),
174 175
						&found);
	Assert(!found);
176

177 178 179
	/*
	 * Initialize the data structures.
	 */
180 181
	ProcGlobal->freeProcs = NULL;
	ProcGlobal->autovacFreeProcs = NULL;
182

183
	ProcGlobal->spins_per_delay = DEFAULT_SPINS_PER_DELAY;
184

185 186 187
	/*
	 * Pre-create the PGPROC structures and create a semaphore for each.
	 */
188
	procs = (PGPROC *) ShmemAlloc((MaxConnections) * sizeof(PGPROC));
189 190 191 192
	if (!procs)
		ereport(FATAL,
				(errcode(ERRCODE_OUT_OF_MEMORY),
				 errmsg("out of shared memory")));
193 194
	MemSet(procs, 0, MaxConnections * sizeof(PGPROC));
	for (i = 0; i < MaxConnections; i++)
195 196
	{
		PGSemaphoreCreate(&(procs[i].sem));
197 198
		procs[i].links.next = (SHM_QUEUE *) ProcGlobal->freeProcs;
		ProcGlobal->freeProcs = &procs[i];
199
	}
200

201 202 203 204 205 206
	/*
	 * Likewise for the PGPROCs reserved for autovacuum.
	 *
	 * Note: the "+1" here accounts for the autovac launcher
	 */
	procs = (PGPROC *) ShmemAlloc((autovacuum_max_workers + 1) * sizeof(PGPROC));
207 208 209 210
	if (!procs)
		ereport(FATAL,
				(errcode(ERRCODE_OUT_OF_MEMORY),
				 errmsg("out of shared memory")));
211 212
	MemSet(procs, 0, (autovacuum_max_workers + 1) * sizeof(PGPROC));
	for (i = 0; i < autovacuum_max_workers + 1; i++)
213 214
	{
		PGSemaphoreCreate(&(procs[i].sem));
215 216
		procs[i].links.next = (SHM_QUEUE *) ProcGlobal->autovacFreeProcs;
		ProcGlobal->autovacFreeProcs = &procs[i];
217 218
	}

219 220 221
	/*
	 * And auxiliary procs.
	 */
222 223
	MemSet(AuxiliaryProcs, 0, NUM_AUXILIARY_PROCS * sizeof(PGPROC));
	for (i = 0; i < NUM_AUXILIARY_PROCS; i++)
224
	{
B
Bruce Momjian 已提交
225
		AuxiliaryProcs[i].pid = 0;		/* marks auxiliary proc as not in use */
226
		PGSemaphoreCreate(&(AuxiliaryProcs[i].sem));
227
	}
228 229 230 231

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

234
/*
235
 * InitProcess -- initialize a per-process data structure for this backend
236 237
 */
void
238
InitProcess(void)
239
{
240 241
	/* use volatile pointer to prevent code rearrangement */
	volatile PROC_HDR *procglobal = ProcGlobal;
242
	int			i;
243 244

	/*
245 246
	 * ProcGlobal should be set up already (if we are a backend, we inherit
	 * this by fork() or EXEC_BACKEND mechanism from the postmaster).
247
	 */
248
	if (procglobal == NULL)
249
		elog(PANIC, "proc header uninitialized");
250 251

	if (MyProc != NULL)
252
		elog(ERROR, "you already exist");
253

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

263 264
	set_spins_per_delay(procglobal->spins_per_delay);

265
	if (IsAnyAutoVacuumProcess())
266
		MyProc = procglobal->autovacFreeProcs;
267
	else
268
		MyProc = procglobal->freeProcs;
269

270
	if (MyProc != NULL)
271
	{
272
		if (IsAnyAutoVacuumProcess())
273
			procglobal->autovacFreeProcs = (PGPROC *) MyProc->links.next;
274
		else
275
			procglobal->freeProcs = (PGPROC *) MyProc->links.next;
276
		SpinLockRelease(ProcStructLock);
277 278 279 280
	}
	else
	{
		/*
B
Bruce Momjian 已提交
281 282
		 * 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
283 284
		 * error message.  XXX do we need to give a different failure message
		 * in the autovacuum case?
285
		 */
286
		SpinLockRelease(ProcStructLock);
287 288 289
		ereport(FATAL,
				(errcode(ERRCODE_TOO_MANY_CONNECTIONS),
				 errmsg("sorry, too many clients already")));
290
	}
291

292 293
	/*
	 * Now that we have a PGPROC, mark ourselves as an active postmaster
294
	 * child; this is so that the postmaster can detect it if we exit without
295 296
	 * cleaning up.  (XXX autovac launcher currently doesn't participate in
	 * this; it probably should.)
297
	 */
298
	if (IsUnderPostmaster && !IsAutoVacuumLauncherProcess())
299 300 301 302 303 304
	{
		if (am_walsender)
			MarkPostmasterChildWalSender();
		else
			MarkPostmasterChildActive();
	}
305

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

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

341
	/*
342
	 * Arrange to clean up at backend exit.
343
	 */
344
	on_shmem_exit(ProcKill, 0);
345 346

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

353 354 355 356
/*
 * InitProcessPhase2 -- make MyProc visible in the shared ProcArray.
 *
 * This is separate from InitProcess because we can't acquire LWLocks until
357 358
 * we've created a PGPROC, but in the EXEC_BACKEND case ProcArrayAdd won't
 * work until after we've done CreateSharedMemoryAndSemaphores.
359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375
 */
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.
	 */
	on_shmem_exit(RemoveProcFromArray, 0);
}

376
/*
377
 * InitAuxiliaryProcess -- create a per-auxiliary-process data structure
378
 *
379 380
 * 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
381
 * and sema that are assigned are one of the extra ones created during
382
 * InitProcGlobal.
383
 *
384
 * Auxiliary processes are presently not expected to wait for real (lockmgr)
385
 * locks, so we need not set up the deadlock checker.  They are never added
B
Bruce Momjian 已提交
386
 * to the ProcArray or the sinval messaging mechanism, either.	They also
387 388
 * don't get a VXID assigned, since this is only useful when we actually
 * hold lockmgr locks.
389 390 391 392 393
 *
 * 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.
394 395
 */
void
396
InitAuxiliaryProcess(void)
397
{
398
	PGPROC	   *auxproc;
399
	int			proctype;
400
	int			i;
J
Jan Wieck 已提交
401

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

	if (MyProc != NULL)
410
		elog(ERROR, "you already exist");
411

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

	set_spins_per_delay(ProcGlobal->spins_per_delay);

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

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

442
	MyProc = auxproc;
443 444 445

	SpinLockRelease(ProcStructLock);

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

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

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

481 482 483 484 485 486 487 488 489 490 491 492 493 494
/*
 * 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;
495
	procglobal->startupBufferPinWaitBufId = 0;
496 497 498 499

	SpinLockRelease(ProcStructLock);
}

500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521
/*
 * 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 已提交
522
	int			bufid;
523 524 525 526 527 528 529 530 531

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

	bufid = procglobal->startupBufferPinWaitBufId;

	return bufid;
}

532 533 534 535 536 537 538 539 540
/*
 * 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 已提交
541

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

	SpinLockAcquire(ProcStructLock);

547
	proc = procglobal->freeProcs;
548

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

	SpinLockRelease(ProcStructLock);

	return (n <= 0);
}

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

	return true;
}

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

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

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

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

592
	if (MyProc->links.next != NULL)
593 594
	{
		/* We could not have been granted the lock yet */
595
		RemoveFromWaitQueue(MyProc, lockAwaited->hashcode);
596 597 598 599 600
	}
	else
	{
		/*
		 * Somebody kicked us off the lock queue already.  Perhaps they
B
Bruce Momjian 已提交
601 602 603
		 * 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.
604
		 */
605 606
		if (MyProc->waitStatus == STATUS_OK)
			GrantAwaitedLock();
607 608
	}

609
	lockAwaited = NULL;
610

611
	LWLockRelease(partitionLock);
H
Hiroshi Inoue 已提交
612

613
	/*
614
	 * We used to do PGSemaphoreReset() here to ensure that our proc's wait
B
Bruce Momjian 已提交
615 616 617 618 619 620
	 * 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.
621
	 */
H
Hiroshi Inoue 已提交
622
}
623

624

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


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

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

672
	Assert(MyProc != NULL);
673

674
	/*
B
Bruce Momjian 已提交
675 676
	 * 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
677
	 * facility by releasing our PGPROC ...
678
	 */
679
	LWLockReleaseAll();
680

681
	SpinLockAcquire(ProcStructLock);
682

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

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

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

701
	SpinLockRelease(ProcStructLock);
702

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

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

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

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

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

731
	Assert(MyProc == auxproc);
732

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

736 737
	SpinLockAcquire(ProcStructLock);

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

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

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

	SpinLockRelease(ProcStructLock);
748 749
}

750

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

/*
 * ProcQueueAlloc -- alloc/attach to a shared memory process queue
 *
 * Returns: a pointer to the queue or NULL
 * Side Effects: Initializes the queue if we allocated one
 */
762
#ifdef NOT_USED
763
PROC_QUEUE *
764 765
ProcQueueAlloc(char *name)
{
766 767
	bool		found;
	PROC_QUEUE *queue = (PROC_QUEUE *)
B
Bruce Momjian 已提交
768
	ShmemInitStruct(name, sizeof(PROC_QUEUE), &found);
769 770

	if (!queue)
771
		return NULL;
772 773
	if (!found)
		ProcQueueInit(queue);
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 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020

				elog(DEBUG2, "sending cancel to blocking autovacuum pid = %d",
					 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 1327
		 *
		 * If blocked by autovacuum, this wakeup will enable ProcSleep to send
		 * the cancelling 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 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682

/*
 * 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.
 */
bool
enable_standby_sig_alarm(long delay_s, int delay_us, TimestampTz fin_time)
{
	struct itimerval timeval;

	Assert(delay_s >= 0 && delay_us >= 0);

	statement_fin_time = fin_time;

	standby_timeout_active = true;

	MemSet(&timeval, 0, sizeof(struct itimerval));
	timeval.it_value.tv_sec = delay_s;
	timeval.it_value.tv_usec = delay_us;
	if (setitimer(ITIMER_REAL, &timeval, NULL))
		return false;
	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;

	standby_timeout_active = false;

	now = GetCurrentTimestamp();

	if (now >= statement_fin_time)
1683
		SendRecoveryConflictWithBufferPin(PROCSIG_RECOVERY_CONFLICT_BUFFERPIN);
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
	else
	{
		/* Not time yet, so (re)schedule the interrupt */
		long		secs;
		int			usecs;
		struct itimerval timeval;

		TimestampDifference(now, statement_fin_time,
							&secs, &usecs);

		/*
		 * 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;

		standby_timeout_active = true;

		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;
	}

	return true;
}

void
handle_standby_sig_alarm(SIGNAL_ARGS)
{
B
Bruce Momjian 已提交
1716
	int			save_errno = errno;
1717 1718 1719 1720 1721 1722

	if (standby_timeout_active)
		(void) CheckStandbyTimeout();

	errno = save_errno;
}