Age Owner Branch data TLA Line data Source code
1 : : /*-------------------------------------------------------------------------
2 : : *
3 : : * lock.c
4 : : * POSTGRES primary lock mechanism
5 : : *
6 : : * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
7 : : * Portions Copyright (c) 1994, Regents of the University of California
8 : : *
9 : : *
10 : : * IDENTIFICATION
11 : : * src/backend/storage/lmgr/lock.c
12 : : *
13 : : * NOTES
14 : : * A lock table is a shared memory hash table. When
15 : : * a process tries to acquire a lock of a type that conflicts
16 : : * with existing locks, it is put to sleep using the routines
17 : : * in storage/lmgr/proc.c.
18 : : *
19 : : * For the most part, this code should be invoked via lmgr.c
20 : : * or another lock-management module, not directly.
21 : : *
22 : : * Interface:
23 : : *
24 : : * LockManagerShmemInit(), GetLocksMethodTable(), GetLockTagsMethodTable(),
25 : : * LockAcquire(), LockRelease(), LockReleaseAll(),
26 : : * LockCheckConflicts(), GrantLock()
27 : : *
28 : : *-------------------------------------------------------------------------
29 : : */
30 : : #include "postgres.h"
31 : :
32 : : #include <signal.h>
33 : : #include <unistd.h>
34 : :
35 : : #include "access/transam.h"
36 : : #include "access/twophase.h"
37 : : #include "access/twophase_rmgr.h"
38 : : #include "access/xlog.h"
39 : : #include "access/xlogutils.h"
40 : : #include "miscadmin.h"
41 : : #include "pg_trace.h"
42 : : #include "pgstat.h"
43 : : #include "storage/lmgr.h"
44 : : #include "storage/proc.h"
45 : : #include "storage/procarray.h"
46 : : #include "storage/shmem.h"
47 : : #include "storage/spin.h"
48 : : #include "storage/standby.h"
49 : : #include "storage/subsystems.h"
50 : : #include "utils/memutils.h"
51 : : #include "utils/ps_status.h"
52 : : #include "utils/resowner.h"
53 : :
54 : :
55 : : /* GUC variables */
56 : : int max_locks_per_xact; /* used to set the lock table size */
57 : : bool log_lock_failures = false;
58 : :
59 : : #define NLOCKENTS() \
60 : : mul_size(max_locks_per_xact, add_size(MaxBackends, max_prepared_xacts))
61 : :
62 : :
63 : : /*
64 : : * Data structures defining the semantics of the standard lock methods.
65 : : *
66 : : * The conflict table defines the semantics of the various lock modes.
67 : : */
68 : : static const LOCKMASK LockConflicts[] = {
69 : : 0,
70 : :
71 : : /* AccessShareLock */
72 : : LOCKBIT_ON(AccessExclusiveLock),
73 : :
74 : : /* RowShareLock */
75 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
76 : :
77 : : /* RowExclusiveLock */
78 : : LOCKBIT_ON(ShareLock) | LOCKBIT_ON(ShareRowExclusiveLock) |
79 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
80 : :
81 : : /* ShareUpdateExclusiveLock */
82 : : LOCKBIT_ON(ShareUpdateExclusiveLock) |
83 : : LOCKBIT_ON(ShareLock) | LOCKBIT_ON(ShareRowExclusiveLock) |
84 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
85 : :
86 : : /* ShareLock */
87 : : LOCKBIT_ON(RowExclusiveLock) | LOCKBIT_ON(ShareUpdateExclusiveLock) |
88 : : LOCKBIT_ON(ShareRowExclusiveLock) |
89 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
90 : :
91 : : /* ShareRowExclusiveLock */
92 : : LOCKBIT_ON(RowExclusiveLock) | LOCKBIT_ON(ShareUpdateExclusiveLock) |
93 : : LOCKBIT_ON(ShareLock) | LOCKBIT_ON(ShareRowExclusiveLock) |
94 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
95 : :
96 : : /* ExclusiveLock */
97 : : LOCKBIT_ON(RowShareLock) |
98 : : LOCKBIT_ON(RowExclusiveLock) | LOCKBIT_ON(ShareUpdateExclusiveLock) |
99 : : LOCKBIT_ON(ShareLock) | LOCKBIT_ON(ShareRowExclusiveLock) |
100 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock),
101 : :
102 : : /* AccessExclusiveLock */
103 : : LOCKBIT_ON(AccessShareLock) | LOCKBIT_ON(RowShareLock) |
104 : : LOCKBIT_ON(RowExclusiveLock) | LOCKBIT_ON(ShareUpdateExclusiveLock) |
105 : : LOCKBIT_ON(ShareLock) | LOCKBIT_ON(ShareRowExclusiveLock) |
106 : : LOCKBIT_ON(ExclusiveLock) | LOCKBIT_ON(AccessExclusiveLock)
107 : :
108 : : };
109 : :
110 : : /* Names of lock modes, for debug printouts */
111 : : static const char *const lock_mode_names[] =
112 : : {
113 : : "INVALID",
114 : : "AccessShareLock",
115 : : "RowShareLock",
116 : : "RowExclusiveLock",
117 : : "ShareUpdateExclusiveLock",
118 : : "ShareLock",
119 : : "ShareRowExclusiveLock",
120 : : "ExclusiveLock",
121 : : "AccessExclusiveLock"
122 : : };
123 : :
124 : : #ifndef LOCK_DEBUG
125 : : static bool Dummy_trace = false;
126 : : #endif
127 : :
128 : : static const LockMethodData default_lockmethod = {
129 : : MaxLockMode,
130 : : LockConflicts,
131 : : lock_mode_names,
132 : : #ifdef LOCK_DEBUG
133 : : &Trace_locks
134 : : #else
135 : : &Dummy_trace
136 : : #endif
137 : : };
138 : :
139 : : static const LockMethodData user_lockmethod = {
140 : : MaxLockMode,
141 : : LockConflicts,
142 : : lock_mode_names,
143 : : #ifdef LOCK_DEBUG
144 : : &Trace_userlocks
145 : : #else
146 : : &Dummy_trace
147 : : #endif
148 : : };
149 : :
150 : : /*
151 : : * map from lock method id to the lock table data structures
152 : : */
153 : : static const LockMethod LockMethods[] = {
154 : : NULL,
155 : : &default_lockmethod,
156 : : &user_lockmethod
157 : : };
158 : :
159 : :
160 : : /* Record that's written to 2PC state file when a lock is persisted */
161 : : typedef struct TwoPhaseLockRecord
162 : : {
163 : : LOCKTAG locktag;
164 : : LOCKMODE lockmode;
165 : : } TwoPhaseLockRecord;
166 : :
167 : :
168 : : /*
169 : : * Count of the number of fast path lock slots we believe to be used. This
170 : : * might be higher than the real number if another backend has transferred
171 : : * our locks to the primary lock table, but it can never be lower than the
172 : : * real value, since only we can acquire locks on our own behalf.
173 : : *
174 : : * XXX Allocate a static array of the maximum size. We could use a pointer
175 : : * and then allocate just the right size to save a couple kB, but then we
176 : : * would have to initialize that, while for the static array that happens
177 : : * automatically. Doesn't seem worth the extra complexity.
178 : : */
179 : : static int FastPathLocalUseCounts[FP_LOCK_GROUPS_PER_BACKEND_MAX];
180 : :
181 : : /*
182 : : * Flag to indicate if the relation extension lock is held by this backend.
183 : : * This flag is used to ensure that while holding the relation extension lock
184 : : * we don't try to acquire a heavyweight lock on any other object. This
185 : : * restriction implies that the relation extension lock won't ever participate
186 : : * in the deadlock cycle because we can never wait for any other heavyweight
187 : : * lock after acquiring this lock.
188 : : *
189 : : * Such a restriction is okay for relation extension locks as unlike other
190 : : * heavyweight locks these are not held till the transaction end. These are
191 : : * taken for a short duration to extend a particular relation and then
192 : : * released.
193 : : */
194 : : static bool IsRelationExtensionLockHeld PG_USED_FOR_ASSERTS_ONLY = false;
195 : :
196 : : /*
197 : : * Number of fast-path locks per backend - size of the arrays in PGPROC.
198 : : * This is set only once during start, before initializing shared memory,
199 : : * and remains constant after that.
200 : : *
201 : : * We set the limit based on max_locks_per_transaction GUC, because that's
202 : : * the best information about expected number of locks per backend we have.
203 : : * See InitializeFastPathLocks() for details.
204 : : */
205 : : int FastPathLockGroupsPerBackend = 0;
206 : :
207 : : /*
208 : : * Macros to calculate the fast-path group and index for a relation.
209 : : *
210 : : * The formula is a simple hash function, designed to spread the OIDs a bit,
211 : : * so that even contiguous values end up in different groups. In most cases
212 : : * there will be gaps anyway, but the multiplication should help a bit.
213 : : *
214 : : * The selected constant (49157) is a prime not too close to 2^k, and it's
215 : : * small enough to not cause overflows (in 64-bit).
216 : : *
217 : : * We can assume that FastPathLockGroupsPerBackend is a power-of-two per
218 : : * InitializeFastPathLocks().
219 : : */
220 : : #define FAST_PATH_REL_GROUP(rel) \
221 : : (((uint64) (rel) * 49157) & (FastPathLockGroupsPerBackend - 1))
222 : :
223 : : /*
224 : : * Given the group/slot indexes, calculate the slot index in the whole array
225 : : * of fast-path lock slots.
226 : : */
227 : : #define FAST_PATH_SLOT(group, index) \
228 : : (AssertMacro((uint32) (group) < FastPathLockGroupsPerBackend), \
229 : : AssertMacro((uint32) (index) < FP_LOCK_SLOTS_PER_GROUP), \
230 : : ((group) * FP_LOCK_SLOTS_PER_GROUP + (index)))
231 : :
232 : : /*
233 : : * Given a slot index (into the whole per-backend array), calculated using
234 : : * the FAST_PATH_SLOT macro, split it into group and index (in the group).
235 : : */
236 : : #define FAST_PATH_GROUP(index) \
237 : : (AssertMacro((uint32) (index) < FastPathLockSlotsPerBackend()), \
238 : : ((index) / FP_LOCK_SLOTS_PER_GROUP))
239 : : #define FAST_PATH_INDEX(index) \
240 : : (AssertMacro((uint32) (index) < FastPathLockSlotsPerBackend()), \
241 : : ((index) % FP_LOCK_SLOTS_PER_GROUP))
242 : :
243 : : /* Macros for manipulating proc->fpLockBits */
244 : : #define FAST_PATH_BITS_PER_SLOT 3
245 : : #define FAST_PATH_LOCKNUMBER_OFFSET 1
246 : : #define FAST_PATH_MASK ((1 << FAST_PATH_BITS_PER_SLOT) - 1)
247 : : #define FAST_PATH_BITS(proc, n) (proc)->fpLockBits[FAST_PATH_GROUP(n)]
248 : : #define FAST_PATH_GET_BITS(proc, n) \
249 : : ((FAST_PATH_BITS(proc, n) >> (FAST_PATH_BITS_PER_SLOT * FAST_PATH_INDEX(n))) & FAST_PATH_MASK)
250 : : #define FAST_PATH_BIT_POSITION(n, l) \
251 : : (AssertMacro((l) >= FAST_PATH_LOCKNUMBER_OFFSET), \
252 : : AssertMacro((l) < FAST_PATH_BITS_PER_SLOT+FAST_PATH_LOCKNUMBER_OFFSET), \
253 : : AssertMacro((n) < FastPathLockSlotsPerBackend()), \
254 : : ((l) - FAST_PATH_LOCKNUMBER_OFFSET + FAST_PATH_BITS_PER_SLOT * (FAST_PATH_INDEX(n))))
255 : : #define FAST_PATH_SET_LOCKMODE(proc, n, l) \
256 : : FAST_PATH_BITS(proc, n) |= UINT64CONST(1) << FAST_PATH_BIT_POSITION(n, l)
257 : : #define FAST_PATH_CLEAR_LOCKMODE(proc, n, l) \
258 : : FAST_PATH_BITS(proc, n) &= ~(UINT64CONST(1) << FAST_PATH_BIT_POSITION(n, l))
259 : : #define FAST_PATH_CHECK_LOCKMODE(proc, n, l) \
260 : : (FAST_PATH_BITS(proc, n) & (UINT64CONST(1) << FAST_PATH_BIT_POSITION(n, l)))
261 : :
262 : : /*
263 : : * The fast-path lock mechanism is concerned only with relation locks on
264 : : * unshared relations by backends bound to a database. The fast-path
265 : : * mechanism exists mostly to accelerate acquisition and release of locks
266 : : * that rarely conflict. Because ShareUpdateExclusiveLock is
267 : : * self-conflicting, it can't use the fast-path mechanism; but it also does
268 : : * not conflict with any of the locks that do, so we can ignore it completely.
269 : : */
270 : : #define EligibleForRelationFastPath(locktag, mode) \
271 : : ((locktag)->locktag_lockmethodid == DEFAULT_LOCKMETHOD && \
272 : : (locktag)->locktag_type == LOCKTAG_RELATION && \
273 : : (locktag)->locktag_field1 == MyDatabaseId && \
274 : : MyDatabaseId != InvalidOid && \
275 : : (mode) < ShareUpdateExclusiveLock)
276 : : #define ConflictsWithRelationFastPath(locktag, mode) \
277 : : ((locktag)->locktag_lockmethodid == DEFAULT_LOCKMETHOD && \
278 : : (locktag)->locktag_type == LOCKTAG_RELATION && \
279 : : (locktag)->locktag_field1 != InvalidOid && \
280 : : (mode) > ShareUpdateExclusiveLock)
281 : :
282 : : static bool FastPathGrantRelationLock(Oid relid, LOCKMODE lockmode);
283 : : static bool FastPathUnGrantRelationLock(Oid relid, LOCKMODE lockmode);
284 : : static bool FastPathTransferRelationLocks(LockMethod lockMethodTable,
285 : : const LOCKTAG *locktag, uint32 hashcode);
286 : : static PROCLOCK *FastPathGetRelationLockEntry(LOCALLOCK *locallock);
287 : :
288 : : /*
289 : : * To make the fast-path lock mechanism work, we must have some way of
290 : : * preventing the use of the fast-path when a conflicting lock might be present.
291 : : * We partition* the locktag space into FAST_PATH_STRONG_LOCK_HASH_PARTITIONS,
292 : : * and maintain an integer count of the number of "strong" lockers
293 : : * in each partition. When any "strong" lockers are present (which is
294 : : * hopefully not very often), the fast-path mechanism can't be used, and we
295 : : * must fall back to the slower method of pushing matching locks directly
296 : : * into the main lock tables.
297 : : *
298 : : * The deadlock detector does not know anything about the fast path mechanism,
299 : : * so any locks that might be involved in a deadlock must be transferred from
300 : : * the fast-path queues to the main lock table.
301 : : */
302 : :
303 : : #define FAST_PATH_STRONG_LOCK_HASH_BITS 10
304 : : #define FAST_PATH_STRONG_LOCK_HASH_PARTITIONS \
305 : : (1 << FAST_PATH_STRONG_LOCK_HASH_BITS)
306 : : #define FastPathStrongLockHashPartition(hashcode) \
307 : : ((hashcode) % FAST_PATH_STRONG_LOCK_HASH_PARTITIONS)
308 : :
309 : : typedef struct
310 : : {
311 : : slock_t mutex;
312 : : uint32 count[FAST_PATH_STRONG_LOCK_HASH_PARTITIONS];
313 : : } FastPathStrongRelationLockData;
314 : :
315 : : static FastPathStrongRelationLockData *FastPathStrongRelationLocks;
316 : :
317 : : static void LockManagerShmemRequest(void *arg);
318 : : static void LockManagerShmemInit(void *arg);
319 : :
320 : : const ShmemCallbacks LockManagerShmemCallbacks = {
321 : : .request_fn = LockManagerShmemRequest,
322 : : .init_fn = LockManagerShmemInit,
323 : : };
324 : :
325 : :
326 : : /*
327 : : * Pointers to hash tables containing lock state
328 : : *
329 : : * The LockMethodLockHash and LockMethodProcLockHash hash tables are in
330 : : * shared memory; LockMethodLocalHash is local to each backend.
331 : : */
332 : : static HTAB *LockMethodLockHash;
333 : : static HTAB *LockMethodProcLockHash;
334 : : static HTAB *LockMethodLocalHash;
335 : :
336 : :
337 : : /* private state for error cleanup */
338 : : static LOCALLOCK *StrongLockInProgress;
339 : : static LOCALLOCK *awaitedLock;
340 : : static ResourceOwner awaitedOwner;
341 : :
342 : :
343 : : #ifdef LOCK_DEBUG
344 : :
345 : : /*------
346 : : * The following configuration options are available for lock debugging:
347 : : *
348 : : * TRACE_LOCKS -- give a bunch of output what's going on in this file
349 : : * TRACE_USERLOCKS -- same but for user locks
350 : : * TRACE_LOCK_OIDMIN-- do not trace locks for tables below this oid
351 : : * (use to avoid output on system tables)
352 : : * TRACE_LOCK_TABLE -- trace locks on this table (oid) unconditionally
353 : : * DEBUG_DEADLOCKS -- currently dumps locks at untimely occasions ;)
354 : : *
355 : : * Furthermore, but in storage/lmgr/lwlock.c:
356 : : * TRACE_LWLOCKS -- trace lightweight locks (pretty useless)
357 : : *
358 : : * Define LOCK_DEBUG at compile time to get all these enabled.
359 : : * --------
360 : : */
361 : :
362 : : int Trace_lock_oidmin = FirstNormalObjectId;
363 : : bool Trace_locks = false;
364 : : bool Trace_userlocks = false;
365 : : int Trace_lock_table = 0;
366 : : bool Debug_deadlocks = false;
367 : :
368 : :
369 : : inline static bool
370 : : LOCK_DEBUG_ENABLED(const LOCKTAG *tag)
371 : : {
372 : : return
373 : : (*(LockMethods[tag->locktag_lockmethodid]->trace_flag) &&
374 : : ((Oid) tag->locktag_field2 >= (Oid) Trace_lock_oidmin))
375 : : || (Trace_lock_table &&
376 : : (tag->locktag_field2 == Trace_lock_table));
377 : : }
378 : :
379 : :
380 : : inline static void
381 : : LOCK_PRINT(const char *where, const LOCK *lock, LOCKMODE type)
382 : : {
383 : : if (LOCK_DEBUG_ENABLED(&lock->tag))
384 : : elog(LOG,
385 : : "%s: lock(%p) id(%u,%u,%u,%u,%u,%u) grantMask(%x) "
386 : : "req(%d,%d,%d,%d,%d,%d,%d)=%d "
387 : : "grant(%d,%d,%d,%d,%d,%d,%d)=%d wait(%d) type(%s)",
388 : : where, lock,
389 : : lock->tag.locktag_field1, lock->tag.locktag_field2,
390 : : lock->tag.locktag_field3, lock->tag.locktag_field4,
391 : : lock->tag.locktag_type, lock->tag.locktag_lockmethodid,
392 : : lock->grantMask,
393 : : lock->requested[1], lock->requested[2], lock->requested[3],
394 : : lock->requested[4], lock->requested[5], lock->requested[6],
395 : : lock->requested[7], lock->nRequested,
396 : : lock->granted[1], lock->granted[2], lock->granted[3],
397 : : lock->granted[4], lock->granted[5], lock->granted[6],
398 : : lock->granted[7], lock->nGranted,
399 : : dclist_count(&lock->waitProcs),
400 : : LockMethods[LOCK_LOCKMETHOD(*lock)]->lockModeNames[type]);
401 : : }
402 : :
403 : :
404 : : inline static void
405 : : PROCLOCK_PRINT(const char *where, const PROCLOCK *proclockP)
406 : : {
407 : : if (LOCK_DEBUG_ENABLED(&proclockP->tag.myLock->tag))
408 : : elog(LOG,
409 : : "%s: proclock(%p) lock(%p) method(%u) proc(%p) hold(%x)",
410 : : where, proclockP, proclockP->tag.myLock,
411 : : PROCLOCK_LOCKMETHOD(*(proclockP)),
412 : : proclockP->tag.myProc, (int) proclockP->holdMask);
413 : : }
414 : : #else /* not LOCK_DEBUG */
415 : :
416 : : #define LOCK_PRINT(where, lock, type) ((void) 0)
417 : : #define PROCLOCK_PRINT(where, proclockP) ((void) 0)
418 : : #endif /* not LOCK_DEBUG */
419 : :
420 : :
421 : : static uint32 proclock_hash(const void *key, Size keysize);
422 : : static void RemoveLocalLock(LOCALLOCK *locallock);
423 : : static PROCLOCK *SetupLockInTable(LockMethod lockMethodTable, PGPROC *proc,
424 : : const LOCKTAG *locktag, uint32 hashcode, LOCKMODE lockmode);
425 : : static void GrantLockLocal(LOCALLOCK *locallock, ResourceOwner owner);
426 : : static void BeginStrongLockAcquire(LOCALLOCK *locallock, uint32 fasthashcode);
427 : : static void FinishStrongLockAcquire(void);
428 : : static ProcWaitStatus WaitOnLock(LOCALLOCK *locallock, ResourceOwner owner);
429 : : static void waitonlock_error_callback(void *arg);
430 : : static void ReleaseLockIfHeld(LOCALLOCK *locallock, bool sessionLock);
431 : : static void LockReassignOwner(LOCALLOCK *locallock, ResourceOwner parent);
432 : : static bool UnGrantLock(LOCK *lock, LOCKMODE lockmode,
433 : : PROCLOCK *proclock, LockMethod lockMethodTable);
434 : : static void CleanUpLock(LOCK *lock, PROCLOCK *proclock,
435 : : LockMethod lockMethodTable, uint32 hashcode,
436 : : bool wakeupNeeded);
437 : : static void LockRefindAndRelease(LockMethod lockMethodTable, PGPROC *proc,
438 : : LOCKTAG *locktag, LOCKMODE lockmode,
439 : : bool decrement_strong_lock_count);
440 : : static void GetSingleProcBlockerStatusData(PGPROC *blocked_proc,
441 : : BlockedProcsData *data);
442 : :
443 : :
444 : : /*
445 : : * Register the lock manager's shmem data structures.
446 : : *
447 : : * In addition to this, each backend must also call InitLockManagerAccess() to
448 : : * create the locallock hash table.
449 : : */
450 : : static void
110 heikki.linnakangas@i 451 :CBC 1225 : LockManagerShmemRequest(void *arg)
452 : : {
453 : : int64 max_table_size;
454 : :
455 : : /*
456 : : * Compute sizes for lock hashtables.
457 : : */
7708 tgl@sss.pgh.pa.us 458 : 1225 : max_table_size = NLOCKENTS();
459 : :
460 : : /*
461 : : * Hash table for LOCK structs. This stores per-locked-object
462 : : * information.
463 : : */
110 heikki.linnakangas@i 464 : 1225 : ShmemRequestHash(.name = "LOCK hash",
465 : : .nelems = max_table_size,
466 : : .ptr = &LockMethodLockHash,
467 : : .hash_info.keysize = sizeof(LOCKTAG),
468 : : .hash_info.entrysize = sizeof(LOCK),
469 : : .hash_info.num_partitions = NUM_LOCK_PARTITIONS,
470 : : .hash_flags = HASH_ELEM | HASH_BLOBS | HASH_PARTITION,
471 : : );
472 : :
473 : : /* Assume an average of 2 holders per lock */
7531 tgl@sss.pgh.pa.us 474 : 1225 : max_table_size *= 2;
475 : :
110 heikki.linnakangas@i 476 : 1225 : ShmemRequestHash(.name = "PROCLOCK hash",
477 : : .nelems = max_table_size,
478 : : .ptr = &LockMethodProcLockHash,
479 : : .hash_info.keysize = sizeof(PROCLOCKTAG),
480 : : .hash_info.entrysize = sizeof(PROCLOCK),
481 : : .hash_info.hash = proclock_hash,
482 : : .hash_info.num_partitions = NUM_LOCK_PARTITIONS,
483 : : .hash_flags = HASH_ELEM | HASH_FUNCTION | HASH_PARTITION,
484 : : );
485 : :
486 : 1225 : ShmemRequestStruct(.name = "Fast Path Strong Relation Lock Data",
487 : : .size = sizeof(FastPathStrongRelationLockData),
488 : : .ptr = (void **) (void *) &FastPathStrongRelationLocks,
489 : : );
490 : 1225 : }
491 : :
492 : : static void
493 : 1222 : LockManagerShmemInit(void *arg)
494 : : {
495 : 1222 : SpinLockInit(&FastPathStrongRelationLocks->mutex);
695 496 : 1222 : }
497 : :
498 : : /*
499 : : * Initialize the lock manager's backend-private data structures.
500 : : */
501 : : void
502 : 22795 : InitLockManagerAccess(void)
503 : : {
504 : : /*
505 : : * Allocate non-shared hash table for LOCALLOCK structs. This stores lock
506 : : * counts and resource owner information.
507 : : */
508 : : HASHCTL info;
509 : :
8002 tgl@sss.pgh.pa.us 510 : 22795 : info.keysize = sizeof(LOCALLOCKTAG);
511 : 22795 : info.entrysize = sizeof(LOCALLOCK);
512 : :
7533 513 : 22795 : LockMethodLocalHash = hash_create("LOCALLOCK hash",
514 : : 16,
515 : : &info,
516 : : HASH_ELEM | HASH_BLOBS);
10973 scrappy@hub.org 517 : 22795 : }
518 : :
519 : :
520 : : /*
521 : : * Fetch the lock method table associated with a given lock
522 : : */
523 : : LockMethod
7533 tgl@sss.pgh.pa.us 524 : 134 : GetLocksMethodTable(const LOCK *lock)
525 : : {
526 : 134 : LOCKMETHODID lockmethodid = LOCK_LOCKMETHOD(*lock);
527 : :
528 [ + - - + ]: 134 : Assert(0 < lockmethodid && lockmethodid < lengthof(LockMethods));
529 : 134 : return LockMethods[lockmethodid];
530 : : }
531 : :
532 : : /*
533 : : * Fetch the lock method table associated with a given locktag
534 : : */
535 : : LockMethod
3806 536 : 1285 : GetLockTagsMethodTable(const LOCKTAG *locktag)
537 : : {
538 : 1285 : LOCKMETHODID lockmethodid = (LOCKMETHODID) locktag->locktag_lockmethodid;
539 : :
540 [ + - - + ]: 1285 : Assert(0 < lockmethodid && lockmethodid < lengthof(LockMethods));
541 : 1285 : return LockMethods[lockmethodid];
542 : : }
543 : :
544 : :
545 : : /*
546 : : * Compute the hash code associated with a LOCKTAG.
547 : : *
548 : : * To avoid unnecessary recomputations of the hash code, we try to do this
549 : : * just once per function, and then pass it around as needed. Aside from
550 : : * passing the hashcode to hash_search_with_hash_value(), we can extract
551 : : * the lock partition number from the hashcode.
552 : : */
553 : : uint32
7307 554 : 23174524 : LockTagHashCode(const LOCKTAG *locktag)
555 : : {
596 peter@eisentraut.org 556 : 23174524 : return get_hash_value(LockMethodLockHash, locktag);
557 : : }
558 : :
559 : : /*
560 : : * Compute the hash code associated with a PROCLOCKTAG.
561 : : *
562 : : * Because we want to use just one set of partition locks for both the
563 : : * LOCK and PROCLOCK hash tables, we have to make sure that PROCLOCKs
564 : : * fall into the same partition number as their associated LOCKs.
565 : : * dynahash.c expects the partition number to be the low-order bits of
566 : : * the hash code, and therefore a PROCLOCKTAG's hash code must have the
567 : : * same low-order bits as the associated LOCKTAG's hash code. We achieve
568 : : * this with this specialized hash function.
569 : : */
570 : : static uint32
7307 tgl@sss.pgh.pa.us 571 : 751 : proclock_hash(const void *key, Size keysize)
572 : : {
573 : 751 : const PROCLOCKTAG *proclocktag = (const PROCLOCKTAG *) key;
574 : : uint32 lockhash;
575 : : Datum procptr;
576 : :
577 [ - + ]: 751 : Assert(keysize == sizeof(PROCLOCKTAG));
578 : :
579 : : /* Look into the associated LOCK object, and compute its hash code */
580 : 751 : lockhash = LockTagHashCode(&proclocktag->myLock->tag);
581 : :
582 : : /*
583 : : * To make the hash code also depend on the PGPROC, we xor the proc
584 : : * struct's address into the hash code, left-shifted so that the
585 : : * partition-number bits don't change. Since this is only a hash, we
586 : : * don't care if we lose high-order bits of the address; use an
587 : : * intermediate variable to suppress cast-pointer-to-int warnings.
588 : : */
589 : 751 : procptr = PointerGetDatum(proclocktag->myProc);
351 peter@eisentraut.org 590 : 751 : lockhash ^= DatumGetUInt32(procptr) << LOG2_NUM_LOCK_PARTITIONS;
591 : :
7307 tgl@sss.pgh.pa.us 592 : 751 : return lockhash;
593 : : }
594 : :
595 : : /*
596 : : * Compute the hash code associated with a PROCLOCKTAG, given the hashcode
597 : : * for its underlying LOCK.
598 : : *
599 : : * We use this just to avoid redundant calls of LockTagHashCode().
600 : : */
601 : : static inline uint32
602 : 5262648 : ProcLockHashCode(const PROCLOCKTAG *proclocktag, uint32 hashcode)
603 : : {
7234 bruce@momjian.us 604 : 5262648 : uint32 lockhash = hashcode;
605 : : Datum procptr;
606 : :
607 : : /*
608 : : * This must match proclock_hash()!
609 : : */
7307 tgl@sss.pgh.pa.us 610 : 5262648 : procptr = PointerGetDatum(proclocktag->myProc);
351 peter@eisentraut.org 611 : 5262648 : lockhash ^= DatumGetUInt32(procptr) << LOG2_NUM_LOCK_PARTITIONS;
612 : :
7307 tgl@sss.pgh.pa.us 613 : 5262648 : return lockhash;
614 : : }
615 : :
616 : : /*
617 : : * Given two lock modes, return whether they would conflict.
618 : : */
619 : : bool
4931 alvherre@alvh.no-ip. 620 : 232961 : DoLockModesConflict(LOCKMODE mode1, LOCKMODE mode2)
621 : : {
622 : 232961 : LockMethod lockMethodTable = LockMethods[DEFAULT_LOCKMETHOD];
623 : :
624 [ + + ]: 232961 : if (lockMethodTable->conflictTab[mode1] & LOCKBIT_ON(mode2))
625 : 194082 : return true;
626 : :
627 : 38879 : return false;
628 : : }
629 : :
630 : : /*
631 : : * LockHeldByMe -- test whether lock 'locktag' is held by the current
632 : : * transaction
633 : : *
634 : : * Returns true if current transaction holds a lock on 'tag' of mode
635 : : * 'lockmode'. If 'orstronger' is true, a stronger lockmode is also OK.
636 : : * ("Stronger" is defined as "numerically higher", which is a bit
637 : : * semantically dubious but is OK for the purposes we use this for.)
638 : : */
639 : : bool
758 noah@leadboat.com 640 : 8372656 : LockHeldByMe(const LOCKTAG *locktag,
641 : : LOCKMODE lockmode, bool orstronger)
642 : : {
643 : : LOCALLOCKTAG localtag;
644 : : LOCALLOCK *locallock;
645 : :
646 : : /*
647 : : * See if there is a LOCALLOCK entry for this lock and lockmode
648 : : */
2854 tgl@sss.pgh.pa.us 649 [ + - - + : 8372656 : MemSet(&localtag, 0, sizeof(localtag)); /* must clear padding */
- - - - -
- ]
650 : 8372656 : localtag.lock = *locktag;
651 : 8372656 : localtag.mode = lockmode;
652 : :
653 : 8372656 : locallock = (LOCALLOCK *) hash_search(LockMethodLocalHash,
654 : : &localtag,
655 : : HASH_FIND, NULL);
656 : :
758 noah@leadboat.com 657 [ + + + - ]: 8372656 : if (locallock && locallock->nLocks > 0)
658 : 3574318 : return true;
659 : :
660 [ + + ]: 4798338 : if (orstronger)
661 : : {
662 : : LOCKMODE slockmode;
663 : :
664 : 1260974 : for (slockmode = lockmode + 1;
665 [ + + ]: 4692161 : slockmode <= MaxLockMode;
666 : 3431187 : slockmode++)
667 : : {
668 [ + + ]: 4591957 : if (LockHeldByMe(locktag, slockmode, false))
669 : 1160770 : return true;
670 : : }
671 : : }
672 : :
673 : 3637568 : return false;
674 : : }
675 : :
676 : : #ifdef USE_ASSERT_CHECKING
677 : : /*
678 : : * GetLockMethodLocalHash -- return the hash of local locks, for modules that
679 : : * evaluate assertions based on all locks held.
680 : : */
681 : : HTAB *
2303 682 : 1916 : GetLockMethodLocalHash(void)
683 : : {
684 : 1916 : return LockMethodLocalHash;
685 : : }
686 : : #endif
687 : :
688 : : /*
689 : : * LockHasWaiters -- look up 'locktag' and check if releasing this
690 : : * lock would wake up other processes waiting for it.
691 : : */
692 : : bool
4974 kgrittn@postgresql.o 693 :UBC 0 : LockHasWaiters(const LOCKTAG *locktag, LOCKMODE lockmode, bool sessionLock)
694 : : {
695 : 0 : LOCKMETHODID lockmethodid = locktag->locktag_lockmethodid;
696 : : LockMethod lockMethodTable;
697 : : LOCALLOCKTAG localtag;
698 : : LOCALLOCK *locallock;
699 : : LOCK *lock;
700 : : PROCLOCK *proclock;
701 : : LWLock *partitionLock;
702 : 0 : bool hasWaiters = false;
703 : :
704 [ # # # # ]: 0 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
705 [ # # ]: 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
706 : 0 : lockMethodTable = LockMethods[lockmethodid];
707 [ # # # # ]: 0 : if (lockmode <= 0 || lockmode > lockMethodTable->numLockModes)
708 [ # # ]: 0 : elog(ERROR, "unrecognized lock mode: %d", lockmode);
709 : :
710 : : #ifdef LOCK_DEBUG
711 : : if (LOCK_DEBUG_ENABLED(locktag))
712 : : elog(LOG, "LockHasWaiters: lock [%u,%u] %s",
713 : : locktag->locktag_field1, locktag->locktag_field2,
714 : : lockMethodTable->lockModeNames[lockmode]);
715 : : #endif
716 : :
717 : : /*
718 : : * Find the LOCALLOCK entry for this lock and lockmode
719 : : */
3321 tgl@sss.pgh.pa.us 720 [ # # # # : 0 : MemSet(&localtag, 0, sizeof(localtag)); /* must clear padding */
# # # # #
# ]
4974 kgrittn@postgresql.o 721 : 0 : localtag.lock = *locktag;
722 : 0 : localtag.mode = lockmode;
723 : :
724 : 0 : locallock = (LOCALLOCK *) hash_search(LockMethodLocalHash,
725 : : &localtag,
726 : : HASH_FIND, NULL);
727 : :
728 : : /*
729 : : * let the caller print its own error message, too. Do not ereport(ERROR).
730 : : */
731 [ # # # # ]: 0 : if (!locallock || locallock->nLocks <= 0)
732 : : {
733 [ # # ]: 0 : elog(WARNING, "you don't own a lock of type %s",
734 : : lockMethodTable->lockModeNames[lockmode]);
735 : 0 : return false;
736 : : }
737 : :
738 : : /*
739 : : * Check the shared lock table.
740 : : */
741 : 0 : partitionLock = LockHashPartitionLock(locallock->hashcode);
742 : :
743 : 0 : LWLockAcquire(partitionLock, LW_SHARED);
744 : :
745 : : /*
746 : : * We don't need to re-find the lock or proclock, since we kept their
747 : : * addresses in the locallock table, and they couldn't have been removed
748 : : * while we were holding a lock on them.
749 : : */
750 : 0 : lock = locallock->lock;
751 : : LOCK_PRINT("LockHasWaiters: found", lock, lockmode);
752 : 0 : proclock = locallock->proclock;
753 : : PROCLOCK_PRINT("LockHasWaiters: found", proclock);
754 : :
755 : : /*
756 : : * Double-check that we are actually holding a lock of the type we want to
757 : : * release.
758 : : */
759 [ # # ]: 0 : if (!(proclock->holdMask & LOCKBIT_ON(lockmode)))
760 : : {
761 : : PROCLOCK_PRINT("LockHasWaiters: WRONGTYPE", proclock);
762 : 0 : LWLockRelease(partitionLock);
763 [ # # ]: 0 : elog(WARNING, "you don't own a lock of type %s",
764 : : lockMethodTable->lockModeNames[lockmode]);
765 : 0 : RemoveLocalLock(locallock);
766 : 0 : return false;
767 : : }
768 : :
769 : : /*
770 : : * Do the checking.
771 : : */
772 [ # # ]: 0 : if ((lockMethodTable->conflictTab[lockmode] & lock->waitMask) != 0)
773 : 0 : hasWaiters = true;
774 : :
775 : 0 : LWLockRelease(partitionLock);
776 : :
777 : 0 : return hasWaiters;
778 : : }
779 : :
780 : : /*
781 : : * LockAcquire -- Check for lock conflicts, sleep if conflict found,
782 : : * set lock if/when no conflicts.
783 : : *
784 : : * Inputs:
785 : : * locktag: unique identifier for the lockable object
786 : : * lockmode: lock mode to acquire
787 : : * sessionLock: if true, acquire lock for session not current transaction
788 : : * dontWait: if true, don't wait to acquire lock
789 : : *
790 : : * Returns one of:
791 : : * LOCKACQUIRE_NOT_AVAIL lock not available, and dontWait=true
792 : : * LOCKACQUIRE_OK lock successfully acquired
793 : : * LOCKACQUIRE_ALREADY_HELD incremented count for lock already held
794 : : * LOCKACQUIRE_ALREADY_CLEAR incremented count for lock already clear
795 : : *
796 : : * In the normal case where dontWait=false and the caller doesn't need to
797 : : * distinguish a freshly acquired lock from one already taken earlier in
798 : : * this same transaction, there is no need to examine the return value.
799 : : *
800 : : * Side Effects: The lock is acquired and recorded in lock tables.
801 : : *
802 : : * NOTE: if we wait for the lock, there is no way to abort the wait
803 : : * short of aborting the transaction.
804 : : */
805 : : LockAcquireResult
7533 tgl@sss.pgh.pa.us 806 :CBC 973052 : LockAcquire(const LOCKTAG *locktag,
807 : : LOCKMODE lockmode,
808 : : bool sessionLock,
809 : : bool dontWait)
810 : : {
2878 811 : 973052 : return LockAcquireExtended(locktag, lockmode, sessionLock, dontWait,
812 : : true, NULL, false);
813 : : }
814 : :
815 : : /*
816 : : * LockAcquireExtended - allows us to specify additional options
817 : : *
818 : : * reportMemoryError specifies whether a lock request that fills the lock
819 : : * table should generate an ERROR or not. Passing "false" allows the caller
820 : : * to attempt to recover from lock-table-full situations, perhaps by forcibly
821 : : * canceling other lock holders and then retrying. Note, however, that the
822 : : * return code for that is LOCKACQUIRE_NOT_AVAIL, so that it's unsafe to use
823 : : * in combination with dontWait = true, as the cause of failure couldn't be
824 : : * distinguished.
825 : : *
826 : : * If locallockp isn't NULL, *locallockp receives a pointer to the LOCALLOCK
827 : : * table entry if a lock is successfully acquired, or NULL if not.
828 : : *
829 : : * logLockFailure indicates whether to log details when a lock acquisition
830 : : * fails with dontWait = true.
831 : : */
832 : : LockAcquireResult
6062 simon@2ndQuadrant.co 833 : 25425081 : LockAcquireExtended(const LOCKTAG *locktag,
834 : : LOCKMODE lockmode,
835 : : bool sessionLock,
836 : : bool dontWait,
837 : : bool reportMemoryError,
838 : : LOCALLOCK **locallockp,
839 : : bool logLockFailure)
840 : : {
7533 tgl@sss.pgh.pa.us 841 : 25425081 : LOCKMETHODID lockmethodid = locktag->locktag_lockmethodid;
842 : : LockMethod lockMethodTable;
843 : : LOCALLOCKTAG localtag;
844 : : LOCALLOCK *locallock;
845 : : LOCK *lock;
846 : : PROCLOCK *proclock;
847 : : bool found;
848 : : ResourceOwner owner;
849 : : uint32 hashcode;
850 : : LWLock *partitionLock;
851 : : bool found_conflict;
852 : : ProcWaitStatus waitResult;
5717 simon@2ndQuadrant.co 853 : 25425081 : bool log_lock = false;
854 : :
7533 tgl@sss.pgh.pa.us 855 [ + - - + ]: 25425081 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7533 tgl@sss.pgh.pa.us 856 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7533 tgl@sss.pgh.pa.us 857 :CBC 25425081 : lockMethodTable = LockMethods[lockmethodid];
858 [ + - - + ]: 25425081 : if (lockmode <= 0 || lockmode > lockMethodTable->numLockModes)
7533 tgl@sss.pgh.pa.us 859 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock mode: %d", lockmode);
860 : :
6062 simon@2ndQuadrant.co 861 [ + + + + ]:CBC 25425081 : if (RecoveryInProgress() && !InRecovery &&
862 [ + + ]: 381460 : (locktag->locktag_type == LOCKTAG_OBJECT ||
5993 bruce@momjian.us 863 [ + - - + ]: 381460 : locktag->locktag_type == LOCKTAG_RELATION) &&
864 : : lockmode > RowExclusiveLock)
6062 simon@2ndQuadrant.co 865 [ # # ]:UBC 0 : ereport(ERROR,
866 : : (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
867 : : errmsg("cannot acquire lock mode %s on database objects while recovery is in progress",
868 : : lockMethodTable->lockModeNames[lockmode]),
869 : : errhint("Only RowExclusiveLock or less can be acquired on database objects during recovery.")));
870 : :
871 : : #ifdef LOCK_DEBUG
872 : : if (LOCK_DEBUG_ENABLED(locktag))
873 : : elog(LOG, "LockAcquire: lock [%u,%u] %s",
874 : : locktag->locktag_field1, locktag->locktag_field2,
875 : : lockMethodTable->lockModeNames[lockmode]);
876 : : #endif
877 : :
878 : : /* Identify owner for lock */
5195 tgl@sss.pgh.pa.us 879 [ + + ]:CBC 25425081 : if (sessionLock)
8002 880 : 47369 : owner = NULL;
881 : : else
5195 882 : 25377712 : owner = CurrentResourceOwner;
883 : :
884 : : /*
885 : : * Find or create a LOCALLOCK entry for this lock and lockmode
886 : : */
3321 887 [ + - - + : 25425081 : MemSet(&localtag, 0, sizeof(localtag)); /* must clear padding */
- - - - -
- ]
8002 888 : 25425081 : localtag.lock = *locktag;
889 : 25425081 : localtag.mode = lockmode;
890 : :
7533 891 : 25425081 : locallock = (LOCALLOCK *) hash_search(LockMethodLocalHash,
892 : : &localtag,
893 : : HASH_ENTER, &found);
894 : :
895 : : /*
896 : : * if it's a new locallock object, initialize it
897 : : */
8002 898 [ + + ]: 25425081 : if (!found)
899 : : {
900 : 22363054 : locallock->lock = NULL;
901 : 22363054 : locallock->proclock = NULL;
7307 902 : 22363054 : locallock->hashcode = LockTagHashCode(&(localtag.lock));
8002 903 : 22363054 : locallock->nLocks = 0;
2878 904 : 22363054 : locallock->holdsStrongLockCount = false;
905 : 22363054 : locallock->lockCleared = false;
8002 906 : 22363054 : locallock->numLockOwners = 0;
907 : 22363054 : locallock->maxLockOwners = 8;
3961 908 : 22363054 : locallock->lockOwners = NULL; /* in case next line fails */
8002 909 : 22363054 : locallock->lockOwners = (LOCALLOCKOWNER *)
910 : 22363054 : MemoryContextAlloc(TopMemoryContext,
3321 911 : 22363054 : locallock->maxLockOwners * sizeof(LOCALLOCKOWNER));
912 : : }
913 : : else
914 : : {
915 : : /* Make sure there will be room to remember the lock */
8002 916 [ + + ]: 3062027 : if (locallock->numLockOwners >= locallock->maxLockOwners)
917 : : {
8000 bruce@momjian.us 918 : 21 : int newsize = locallock->maxLockOwners * 2;
919 : :
8002 tgl@sss.pgh.pa.us 920 : 21 : locallock->lockOwners = (LOCALLOCKOWNER *)
921 : 21 : repalloc(locallock->lockOwners,
922 : : newsize * sizeof(LOCALLOCKOWNER));
923 : 21 : locallock->maxLockOwners = newsize;
924 : : }
925 : : }
5537 rhaas@postgresql.org 926 : 25425081 : hashcode = locallock->hashcode;
927 : :
2878 tgl@sss.pgh.pa.us 928 [ + + ]: 25425081 : if (locallockp)
929 : 24451935 : *locallockp = locallock;
930 : :
931 : : /*
932 : : * If we already hold the lock, we can just increase the count locally.
933 : : *
934 : : * If lockCleared is already set, caller need not worry about absorbing
935 : : * sinval messages related to the lock's object.
936 : : */
8002 937 [ + + ]: 25425081 : if (locallock->nLocks > 0)
938 : : {
939 : 3062027 : GrantLockLocal(locallock, owner);
2878 940 [ + + ]: 3062027 : if (locallock->lockCleared)
941 : 2962305 : return LOCKACQUIRE_ALREADY_CLEAR;
942 : : else
943 : 99722 : return LOCKACQUIRE_ALREADY_HELD;
944 : : }
945 : :
946 : : /*
947 : : * We don't acquire any other heavyweight lock while holding the relation
948 : : * extension lock. We do allow to acquire the same relation extension
949 : : * lock more than once but that case won't reach here.
950 : : */
2320 akapila@postgresql.o 951 [ - + ]: 22363054 : Assert(!IsRelationExtensionLockHeld);
952 : :
953 : : /*
954 : : * Prepare to emit a WAL record if acquisition of this lock needs to be
955 : : * replayed in a standby server.
956 : : *
957 : : * Here we prepare to log; after lock is acquired we'll issue log record.
958 : : * This arrangement simplifies error recovery in case the preparation step
959 : : * fails.
960 : : *
961 : : * Only AccessExclusiveLocks can conflict with lock types that read-only
962 : : * transactions can acquire in a standby server. Make sure this definition
963 : : * matches the one in GetRunningTransactionLocks().
964 : : */
5717 simon@2ndQuadrant.co 965 [ + + ]: 22363054 : if (lockmode >= AccessExclusiveLock &&
966 [ + + ]: 319577 : locktag->locktag_type == LOCKTAG_RELATION &&
967 [ + + ]: 209979 : !RecoveryInProgress() &&
968 [ + + ]: 181836 : XLogStandbyInfoActive())
969 : : {
970 : 174368 : LogAccessExclusiveLockPrepare();
971 : 174368 : log_lock = true;
972 : : }
973 : :
974 : : /*
975 : : * Attempt to take lock via fast path, if eligible. But if we remember
976 : : * having filled up the fast path array, we don't attempt to make any
977 : : * further use of it until we release some locks. It's possible that some
978 : : * other backend has transferred some of those locks to the shared hash
979 : : * table, leaving space free, but it's not worth acquiring the LWLock just
980 : : * to check. It's also possible that we're acquiring a second or third
981 : : * lock type on a relation we have already locked using the fast-path, but
982 : : * for now we don't worry about that case either.
983 : : */
123 michael@paquier.xyz 984 [ + + + + : 22363054 : if (EligibleForRelationFastPath(locktag, lockmode))
+ + + + +
+ ]
985 : : {
986 [ + + ]: 20125305 : if (FastPathLocalUseCounts[FAST_PATH_REL_GROUP(locktag->locktag_field2)] <
987 : : FP_LOCK_SLOTS_PER_GROUP)
988 : : {
989 : 20031889 : uint32 fasthashcode = FastPathStrongLockHashPartition(hashcode);
990 : : bool acquired;
991 : :
992 : : /*
993 : : * LWLockAcquire acts as a memory sequencing point, so it's safe
994 : : * to assume that any strong locker whose increment to
995 : : * FastPathStrongRelationLocks->counts becomes visible after we
996 : : * test it has yet to begin to transfer fast-path locks.
997 : : */
998 : 20031889 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
999 [ + + ]: 20031889 : if (FastPathStrongRelationLocks->count[fasthashcode] != 0)
1000 : 451079 : acquired = false;
1001 : : else
1002 : 19580810 : acquired = FastPathGrantRelationLock(locktag->locktag_field2,
1003 : : lockmode);
1004 : 20031889 : LWLockRelease(&MyProc->fpInfoLock);
1005 [ + + ]: 20031889 : if (acquired)
1006 : : {
1007 : : /*
1008 : : * The locallock might contain stale pointers to some old
1009 : : * shared objects; we MUST reset these to null before
1010 : : * considering the lock to be acquired via fast-path.
1011 : : */
1012 : 19580810 : locallock->lock = NULL;
1013 : 19580810 : locallock->proclock = NULL;
1014 : 19580810 : GrantLockLocal(locallock, owner);
1015 : 19580810 : return LOCKACQUIRE_OK;
1016 : : }
1017 : : }
1018 : : else
1019 : : {
1020 : : /*
1021 : : * Increment the lock statistics counter if lock could not be
1022 : : * acquired via the fast-path.
1023 : : */
1024 : 93416 : pgstat_count_lock_fastpath_exceeded(locallock->tag.lock.locktag_type);
1025 : : }
1026 : : }
1027 : :
1028 : : /*
1029 : : * If this lock could potentially have been taken via the fast-path by
1030 : : * some other backend, we must (temporarily) disable further use of the
1031 : : * fast-path for this lock tag, and migrate any locks already taken via
1032 : : * this method to the main lock table.
1033 : : */
5169 rhaas@postgresql.org 1034 [ + + + + : 2782244 : if (ConflictsWithRelationFastPath(locktag, lockmode))
+ + + + ]
1035 : : {
5158 bruce@momjian.us 1036 : 249890 : uint32 fasthashcode = FastPathStrongLockHashPartition(hashcode);
1037 : :
5169 rhaas@postgresql.org 1038 : 249890 : BeginStrongLockAcquire(locallock, fasthashcode);
1039 [ - + ]: 249890 : if (!FastPathTransferRelationLocks(lockMethodTable, locktag,
1040 : : hashcode))
1041 : : {
5169 rhaas@postgresql.org 1042 :UBC 0 : AbortStrongLockAcquire();
2878 tgl@sss.pgh.pa.us 1043 [ # # ]: 0 : if (locallock->nLocks == 0)
1044 : 0 : RemoveLocalLock(locallock);
1045 [ # # ]: 0 : if (locallockp)
1046 : 0 : *locallockp = NULL;
5169 rhaas@postgresql.org 1047 [ # # ]: 0 : if (reportMemoryError)
1048 [ # # ]: 0 : ereport(ERROR,
1049 : : (errcode(ERRCODE_OUT_OF_MEMORY),
1050 : : errmsg("out of shared memory"),
1051 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
1052 : : else
1053 : 0 : return LOCKACQUIRE_NOT_AVAIL;
1054 : : }
1055 : : }
1056 : :
1057 : : /*
1058 : : * We didn't find the lock in our LOCALLOCK table, and we didn't manage to
1059 : : * take it via the fast-path, either, so we've got to mess with the shared
1060 : : * lock table.
1061 : : */
7307 tgl@sss.pgh.pa.us 1062 :CBC 2782244 : partitionLock = LockHashPartitionLock(hashcode);
1063 : :
7531 1064 : 2782244 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
1065 : :
1066 : : /*
1067 : : * Find or create lock and proclock entries with this tag
1068 : : *
1069 : : * Note: if the locallock object already existed, it might have a pointer
1070 : : * to the lock already ... but we should not assume that that pointer is
1071 : : * valid, since a lock object with zero hold and request counts can go
1072 : : * away anytime. So we have to use SetupLockInTable() to recompute the
1073 : : * lock and proclock pointers, even if they're already set.
1074 : : */
5537 rhaas@postgresql.org 1075 : 2782244 : proclock = SetupLockInTable(lockMethodTable, MyProc, locktag,
1076 : : hashcode, lockmode);
1077 [ - + ]: 2782244 : if (!proclock)
1078 : : {
5211 rhaas@postgresql.org 1079 :UBC 0 : AbortStrongLockAcquire();
5537 1080 : 0 : LWLockRelease(partitionLock);
2878 tgl@sss.pgh.pa.us 1081 [ # # ]: 0 : if (locallock->nLocks == 0)
1082 : 0 : RemoveLocalLock(locallock);
1083 [ # # ]: 0 : if (locallockp)
1084 : 0 : *locallockp = NULL;
5537 rhaas@postgresql.org 1085 [ # # ]: 0 : if (reportMemoryError)
1086 [ # # ]: 0 : ereport(ERROR,
1087 : : (errcode(ERRCODE_OUT_OF_MEMORY),
1088 : : errmsg("out of shared memory"),
1089 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
1090 : : else
1091 : 0 : return LOCKACQUIRE_NOT_AVAIL;
1092 : : }
5537 rhaas@postgresql.org 1093 :CBC 2782244 : locallock->proclock = proclock;
1094 : 2782244 : lock = proclock->tag.myLock;
1095 : 2782244 : locallock->lock = lock;
1096 : :
1097 : : /*
1098 : : * If lock requested conflicts with locks requested by waiters, must join
1099 : : * wait queue. Otherwise, check for conflict with already-held locks.
1100 : : * (That's last because most complex check.)
1101 : : */
1102 [ + + ]: 2782244 : if (lockMethodTable->conflictTab[lockmode] & lock->waitMask)
2400 peter@eisentraut.org 1103 : 290 : found_conflict = true;
1104 : : else
1105 : 2781954 : found_conflict = LockCheckConflicts(lockMethodTable, lockmode,
1106 : : lock, proclock);
1107 : :
1108 [ + + ]: 2782244 : if (!found_conflict)
1109 : : {
1110 : : /* No conflict with held or previously requested locks */
5537 rhaas@postgresql.org 1111 : 2779932 : GrantLock(lock, proclock, lockmode);
628 heikki.linnakangas@i 1112 : 2779932 : waitResult = PROC_WAIT_STATUS_OK;
1113 : : }
1114 : : else
1115 : : {
1116 : : /*
1117 : : * Join the lock's wait queue. We call this even in the dontWait
1118 : : * case, because JoinWaitQueue() may discover that we can acquire the
1119 : : * lock immediately after all.
1120 : : */
1121 : 2312 : waitResult = JoinWaitQueue(locallock, lockMethodTable, dontWait);
1122 : : }
1123 : :
1124 [ + + ]: 2782244 : if (waitResult == PROC_WAIT_STATUS_ERROR)
1125 : : {
1126 : : /*
1127 : : * We're not getting the lock because a deadlock was detected already
1128 : : * while trying to join the wait queue, or because we would have to
1129 : : * wait but the caller requested no blocking.
1130 : : *
1131 : : * Undo the changes to shared entries before releasing the partition
1132 : : * lock.
1133 : : */
1134 : 763 : AbortStrongLockAcquire();
1135 : :
1136 [ + + ]: 763 : if (proclock->holdMask == 0)
1137 : : {
1138 : : uint32 proclock_hashcode;
1139 : :
1140 : 559 : proclock_hashcode = ProcLockHashCode(&proclock->tag,
1141 : : hashcode);
1142 : 559 : dlist_delete(&proclock->lockLink);
1143 : 559 : dlist_delete(&proclock->procLink);
1144 [ - + ]: 559 : if (!hash_search_with_hash_value(LockMethodProcLockHash,
1145 : 559 : &(proclock->tag),
1146 : : proclock_hashcode,
1147 : : HASH_REMOVE,
1148 : : NULL))
628 heikki.linnakangas@i 1149 [ # # ]:UBC 0 : elog(PANIC, "proclock table corrupted");
1150 : : }
1151 : : else
1152 : : PROCLOCK_PRINT("LockAcquire: did not join wait queue", proclock);
628 heikki.linnakangas@i 1153 :CBC 763 : lock->nRequested--;
1154 : 763 : lock->requested[lockmode]--;
1155 : : LOCK_PRINT("LockAcquire: did not join wait queue",
1156 : : lock, lockmode);
1157 [ + - - + ]: 763 : Assert((lock->nRequested > 0) &&
1158 : : (lock->requested[lockmode] >= 0));
1159 [ - + ]: 763 : Assert(lock->nGranted <= lock->nRequested);
1160 : 763 : LWLockRelease(partitionLock);
1161 [ + - ]: 763 : if (locallock->nLocks == 0)
1162 : 763 : RemoveLocalLock(locallock);
1163 : :
1164 [ + + ]: 763 : if (dontWait)
1165 : : {
1166 : : /*
1167 : : * Log lock holders and waiters as a detail log message if
1168 : : * logLockFailure = true and lock acquisition fails with dontWait
1169 : : * = true
1170 : : */
498 fujii@postgresql.org 1171 [ - + ]: 762 : if (logLockFailure)
1172 : : {
1173 : : StringInfoData buf,
1174 : : lock_waiters_sbuf,
1175 : : lock_holders_sbuf;
1176 : : const char *modename;
498 fujii@postgresql.org 1177 :UBC 0 : int lockHoldersNum = 0;
1178 : :
1179 : 0 : initStringInfo(&buf);
1180 : 0 : initStringInfo(&lock_waiters_sbuf);
1181 : 0 : initStringInfo(&lock_holders_sbuf);
1182 : :
1183 : 0 : DescribeLockTag(&buf, &locallock->tag.lock);
1184 : 0 : modename = GetLockmodeName(locallock->tag.lock.locktag_lockmethodid,
1185 : : lockmode);
1186 : :
1187 : : /* Gather a list of all lock holders and waiters */
1188 : 0 : LWLockAcquire(partitionLock, LW_SHARED);
1189 : 0 : GetLockHoldersAndWaiters(locallock, &lock_holders_sbuf,
1190 : : &lock_waiters_sbuf, &lockHoldersNum);
1191 : 0 : LWLockRelease(partitionLock);
1192 : :
1193 [ # # ]: 0 : ereport(LOG,
1194 : : (errmsg("process %d could not obtain %s on %s",
1195 : : MyProcPid, modename, buf.data),
1196 : : errdetail_log_plural(
1197 : : "Process holding the lock: %s, Wait queue: %s.",
1198 : : "Processes holding the lock: %s, Wait queue: %s.",
1199 : : lockHoldersNum,
1200 : : lock_holders_sbuf.data,
1201 : : lock_waiters_sbuf.data)));
1202 : :
1203 : 0 : pfree(buf.data);
1204 : 0 : pfree(lock_holders_sbuf.data);
1205 : 0 : pfree(lock_waiters_sbuf.data);
1206 : : }
628 heikki.linnakangas@i 1207 [ + + ]:CBC 762 : if (locallockp)
1208 : 223 : *locallockp = NULL;
1209 : 762 : return LOCKACQUIRE_NOT_AVAIL;
1210 : : }
1211 : : else
1212 : : {
1213 : 1 : DeadLockReport();
1214 : : /* DeadLockReport() will not return */
1215 : : }
1216 : : }
1217 : :
1218 : : /*
1219 : : * We are now in the lock queue, or the lock was already granted. If
1220 : : * queued, go to sleep.
1221 : : */
1222 [ + + ]: 2781481 : if (waitResult == PROC_WAIT_STATUS_WAITING)
1223 : : {
1224 [ - + ]: 1530 : Assert(!dontWait);
1225 : : PROCLOCK_PRINT("LockAcquire: sleeping on lock", proclock);
1226 : : LOCK_PRINT("LockAcquire: sleeping on lock", lock, lockmode);
1227 : 1530 : LWLockRelease(partitionLock);
1228 : :
1229 : 1530 : waitResult = WaitOnLock(locallock, owner);
1230 : :
1231 : : /*
1232 : : * NOTE: do not do any material change of state between here and
1233 : : * return. All required changes in locktable state must have been
1234 : : * done when the lock was granted to us --- see notes in WaitOnLock.
1235 : : */
1236 : :
1237 [ + + ]: 1488 : if (waitResult == PROC_WAIT_STATUS_ERROR)
1238 : : {
1239 : : /*
1240 : : * We failed as a result of a deadlock, see CheckDeadLock(). Quit
1241 : : * now.
1242 : : */
1243 [ - + ]: 5 : Assert(!dontWait);
1244 : 5 : DeadLockReport();
1245 : : /* DeadLockReport() will not return */
1246 : : }
1247 : : }
1248 : : else
1249 : 2779951 : LWLockRelease(partitionLock);
1250 [ - + ]: 2781434 : Assert(waitResult == PROC_WAIT_STATUS_OK);
1251 : :
1252 : : /* The lock was granted to us. Update the local lock entry accordingly */
1253 [ - + ]: 2781434 : Assert((proclock->holdMask & LOCKBIT_ON(lockmode)) != 0);
1254 : 2781434 : GrantLockLocal(locallock, owner);
1255 : :
1256 : : /*
1257 : : * Lock state is fully up-to-date now; if we error out after this, no
1258 : : * special error cleanup is required.
1259 : : */
5211 rhaas@postgresql.org 1260 : 2781434 : FinishStrongLockAcquire();
1261 : :
1262 : : /*
1263 : : * Emit a WAL record if acquisition of this lock needs to be replayed in a
1264 : : * standby server.
1265 : : */
5537 1266 [ + + ]: 2781434 : if (log_lock)
1267 : : {
1268 : : /*
1269 : : * Decode the locktag back to the original values, to avoid sending
1270 : : * lots of empty bytes with every message. See lock.h to check how a
1271 : : * locktag is defined for LOCKTAG_RELATION
1272 : : */
1273 : 174154 : LogAccessExclusiveLock(locktag->locktag_field1,
1274 : 174154 : locktag->locktag_field2);
1275 : : }
1276 : :
1277 : 2781434 : return LOCKACQUIRE_OK;
1278 : : }
1279 : :
1280 : : /*
1281 : : * Find or create LOCK and PROCLOCK objects as needed for a new lock
1282 : : * request.
1283 : : *
1284 : : * Returns the PROCLOCK object, or NULL if we failed to create the objects
1285 : : * for lack of shared memory.
1286 : : *
1287 : : * The appropriate partition lock must be held at entry, and will be
1288 : : * held at exit.
1289 : : */
1290 : : static PROCLOCK *
1291 : 2784427 : SetupLockInTable(LockMethod lockMethodTable, PGPROC *proc,
1292 : : const LOCKTAG *locktag, uint32 hashcode, LOCKMODE lockmode)
1293 : : {
1294 : : LOCK *lock;
1295 : : PROCLOCK *proclock;
1296 : : PROCLOCKTAG proclocktag;
1297 : : uint32 proclock_hashcode;
1298 : : bool found;
1299 : :
1300 : : /*
1301 : : * Find or create a lock with this tag.
1302 : : */
7307 tgl@sss.pgh.pa.us 1303 : 2784427 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
1304 : : locktag,
1305 : : hashcode,
1306 : : HASH_ENTER_NULL,
1307 : : &found);
10548 bruce@momjian.us 1308 [ - + ]: 2784427 : if (!lock)
5537 rhaas@postgresql.org 1309 :UBC 0 : return NULL;
1310 : :
1311 : : /*
1312 : : * if it's a new lock object, initialize it
1313 : : */
10548 bruce@momjian.us 1314 [ + + ]:CBC 2784427 : if (!found)
1315 : : {
9321 tgl@sss.pgh.pa.us 1316 : 2402092 : lock->grantMask = 0;
1317 : 2402092 : lock->waitMask = 0;
1284 andres@anarazel.de 1318 : 2402092 : dlist_init(&lock->procLocks);
1319 : 2402092 : dclist_init(&lock->waitProcs);
9321 tgl@sss.pgh.pa.us 1320 : 2402092 : lock->nRequested = 0;
1321 : 2402092 : lock->nGranted = 0;
7745 neilc@samurai.com 1322 [ + - + - : 14412552 : MemSet(lock->requested, 0, sizeof(int) * MAX_LOCKMODES);
+ - + - +
+ ]
1323 [ - + - - : 2402092 : MemSet(lock->granted, 0, sizeof(int) * MAX_LOCKMODES);
- - - - -
- ]
1324 : : LOCK_PRINT("LockAcquire: new", lock, lockmode);
1325 : : }
1326 : : else
1327 : : {
1328 : : LOCK_PRINT("LockAcquire: found", lock, lockmode);
9321 tgl@sss.pgh.pa.us 1329 [ + - - + ]: 382335 : Assert((lock->nRequested >= 0) && (lock->requested[lockmode] >= 0));
1330 [ + - - + ]: 382335 : Assert((lock->nGranted >= 0) && (lock->granted[lockmode] >= 0));
1331 [ - + ]: 382335 : Assert(lock->nGranted <= lock->nRequested);
1332 : : }
1333 : :
1334 : : /*
1335 : : * Create the hash key for the proclock table.
1336 : : */
7307 1337 : 2784427 : proclocktag.myLock = lock;
5537 rhaas@postgresql.org 1338 : 2784427 : proclocktag.myProc = proc;
1339 : :
7307 tgl@sss.pgh.pa.us 1340 : 2784427 : proclock_hashcode = ProcLockHashCode(&proclocktag, hashcode);
1341 : :
1342 : : /*
1343 : : * Find or create a proclock entry with this tag
1344 : : */
1345 : 2784427 : proclock = (PROCLOCK *) hash_search_with_hash_value(LockMethodProcLockHash,
1346 : : &proclocktag,
1347 : : proclock_hashcode,
1348 : : HASH_ENTER_NULL,
1349 : : &found);
8558 bruce@momjian.us 1350 [ - + ]: 2784427 : if (!proclock)
1351 : : {
1352 : : /* Oops, not enough shmem for the proclock */
7986 tgl@sss.pgh.pa.us 1353 [ # # ]:UBC 0 : if (lock->nRequested == 0)
1354 : : {
1355 : : /*
1356 : : * There are no other requestors of this lock, so garbage-collect
1357 : : * the lock object. We *must* do this to avoid a permanent leak
1358 : : * of shared memory, because there won't be anything to cause
1359 : : * anyone to release the lock object later.
1360 : : */
1284 andres@anarazel.de 1361 [ # # ]: 0 : Assert(dlist_is_empty(&(lock->procLocks)));
7307 tgl@sss.pgh.pa.us 1362 [ # # ]: 0 : if (!hash_search_with_hash_value(LockMethodLockHash,
1265 peter@eisentraut.org 1363 : 0 : &(lock->tag),
1364 : : hashcode,
1365 : : HASH_REMOVE,
1366 : : NULL))
7737 tgl@sss.pgh.pa.us 1367 [ # # ]: 0 : elog(PANIC, "lock table corrupted");
1368 : : }
5537 rhaas@postgresql.org 1369 : 0 : return NULL;
1370 : : }
1371 : :
1372 : : /*
1373 : : * If new, initialize the new entry
1374 : : */
10548 bruce@momjian.us 1375 [ + + ]:CBC 2784427 : if (!found)
1376 : : {
5537 rhaas@postgresql.org 1377 : 2475380 : uint32 partition = LockHashPartition(hashcode);
1378 : :
1379 : : /*
1380 : : * It might seem unsafe to access proclock->groupLeader without a
1381 : : * lock, but it's not really. Either we are initializing a proclock
1382 : : * on our own behalf, in which case our group leader isn't changing
1383 : : * because the group leader for a process can only ever be changed by
1384 : : * the process itself; or else we are transferring a fast-path lock to
1385 : : * the main lock table, in which case that process can't change its
1386 : : * lock group leader without first releasing all of its locks (and in
1387 : : * particular the one we are currently transferring).
1388 : : */
3821 1389 : 4950760 : proclock->groupLeader = proc->lockGroupLeader != NULL ?
1390 [ + + ]: 2475380 : proc->lockGroupLeader : proc;
8002 tgl@sss.pgh.pa.us 1391 : 2475380 : proclock->holdMask = 0;
7711 1392 : 2475380 : proclock->releaseMask = 0;
1393 : : /* Add proclock to appropriate lists */
1284 andres@anarazel.de 1394 : 2475380 : dlist_push_tail(&lock->procLocks, &proclock->lockLink);
1395 : 2475380 : dlist_push_tail(&proc->myProcLocks[partition], &proclock->procLink);
1396 : : PROCLOCK_PRINT("LockAcquire: new", proclock);
1397 : : }
1398 : : else
1399 : : {
1400 : : PROCLOCK_PRINT("LockAcquire: found", proclock);
8002 tgl@sss.pgh.pa.us 1401 [ - + ]: 309047 : Assert((proclock->holdMask & ~lock->grantMask) == 0);
1402 : :
1403 : : #ifdef CHECK_DEADLOCK_RISK
1404 : :
1405 : : /*
1406 : : * Issue warning if we already hold a lower-level lock on this object
1407 : : * and do not hold a lock of the requested level or higher. This
1408 : : * indicates a deadlock-prone coding practice (eg, we'd have a
1409 : : * deadlock if another backend were following the same code path at
1410 : : * about the same time).
1411 : : *
1412 : : * This is not enabled by default, because it may generate log entries
1413 : : * about user-level coding practices that are in fact safe in context.
1414 : : * It can be enabled to help find system-level problems.
1415 : : *
1416 : : * XXX Doing numeric comparison on the lockmodes is a hack; it'd be
1417 : : * better to use a table. For now, though, this works.
1418 : : */
1419 : : {
1420 : : int i;
1421 : :
1422 : : for (i = lockMethodTable->numLockModes; i > 0; i--)
1423 : : {
1424 : : if (proclock->holdMask & LOCKBIT_ON(i))
1425 : : {
1426 : : if (i >= (int) lockmode)
1427 : : break; /* safe: we have a lock >= req level */
1428 : : elog(LOG, "deadlock risk: raising lock level"
1429 : : " from %s to %s on object %u/%u/%u",
1430 : : lockMethodTable->lockModeNames[i],
1431 : : lockMethodTable->lockModeNames[lockmode],
1432 : : lock->tag.locktag_field1, lock->tag.locktag_field2,
1433 : : lock->tag.locktag_field3);
1434 : : break;
1435 : : }
1436 : : }
1437 : : }
1438 : : #endif /* CHECK_DEADLOCK_RISK */
1439 : : }
1440 : :
1441 : : /*
1442 : : * lock->nRequested and lock->requested[] count the total number of
1443 : : * requests, whether granted or waiting, so increment those immediately.
1444 : : * The other counts don't increment till we get the lock.
1445 : : */
9321 1446 : 2784427 : lock->nRequested++;
1447 : 2784427 : lock->requested[lockmode]++;
1448 [ + - - + ]: 2784427 : Assert((lock->nRequested > 0) && (lock->requested[lockmode] > 0));
1449 : :
1450 : : /*
1451 : : * We shouldn't already hold the desired lock; else locallock table is
1452 : : * broken.
1453 : : */
7711 1454 [ - + ]: 2784427 : if (proclock->holdMask & LOCKBIT_ON(lockmode))
7711 tgl@sss.pgh.pa.us 1455 [ # # ]:UBC 0 : elog(ERROR, "lock %s on object %u/%u/%u is already held",
1456 : : lockMethodTable->lockModeNames[lockmode],
1457 : : lock->tag.locktag_field1, lock->tag.locktag_field2,
1458 : : lock->tag.locktag_field3);
1459 : :
5537 rhaas@postgresql.org 1460 :CBC 2784427 : return proclock;
1461 : : }
1462 : :
1463 : : /*
1464 : : * Check and set/reset the flag that we hold the relation extension lock.
1465 : : *
1466 : : * It is callers responsibility that this function is called after
1467 : : * acquiring/releasing the relation extension lock.
1468 : : *
1469 : : * Pass acquired as true if lock is acquired, false otherwise.
1470 : : */
1471 : : static inline void
2320 akapila@postgresql.o 1472 : 45787503 : CheckAndSetLockHeld(LOCALLOCK *locallock, bool acquired)
1473 : : {
1474 : : #ifdef USE_ASSERT_CHECKING
1475 [ + + ]: 45787503 : if (LOCALLOCK_LOCKTAG(*locallock) == LOCKTAG_RELATION_EXTEND)
1476 : 415194 : IsRelationExtensionLockHeld = acquired;
1477 : : #endif
1478 : 45787503 : }
1479 : :
1480 : : /*
1481 : : * Subroutine to free a locallock entry
1482 : : */
1483 : : static void
8002 tgl@sss.pgh.pa.us 1484 : 22363054 : RemoveLocalLock(LOCALLOCK *locallock)
1485 : : {
1486 : : int i;
1487 : :
5147 heikki.linnakangas@i 1488 [ + + ]: 22470948 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
1489 : : {
1490 [ + + ]: 107894 : if (locallock->lockOwners[i].owner != NULL)
1491 : 107835 : ResourceOwnerForgetLock(locallock->lockOwners[i].owner, locallock);
1492 : : }
3961 tgl@sss.pgh.pa.us 1493 : 22363054 : locallock->numLockOwners = 0;
1494 [ + - ]: 22363054 : if (locallock->lockOwners != NULL)
1495 : 22363054 : pfree(locallock->lockOwners);
8002 1496 : 22363054 : locallock->lockOwners = NULL;
1497 : :
5537 rhaas@postgresql.org 1498 [ + + ]: 22363054 : if (locallock->holdsStrongLockCount)
1499 : : {
1500 : : uint32 fasthashcode;
1501 : :
1502 : 249571 : fasthashcode = FastPathStrongLockHashPartition(locallock->hashcode);
1503 : :
5485 1504 : 249571 : SpinLockAcquire(&FastPathStrongRelationLocks->mutex);
1505 [ - + ]: 249571 : Assert(FastPathStrongRelationLocks->count[fasthashcode] > 0);
1506 : 249571 : FastPathStrongRelationLocks->count[fasthashcode]--;
3265 peter_e@gmx.net 1507 : 249571 : locallock->holdsStrongLockCount = false;
5485 rhaas@postgresql.org 1508 : 249571 : SpinLockRelease(&FastPathStrongRelationLocks->mutex);
1509 : : }
1510 : :
7533 tgl@sss.pgh.pa.us 1511 [ - + ]: 22363054 : if (!hash_search(LockMethodLocalHash,
1265 peter@eisentraut.org 1512 : 22363054 : &(locallock->tag),
1513 : : HASH_REMOVE, NULL))
8002 tgl@sss.pgh.pa.us 1514 [ # # ]:UBC 0 : elog(WARNING, "locallock table corrupted");
1515 : :
1516 : : /*
1517 : : * Indicate that the lock is released for certain types of locks
1518 : : */
2320 akapila@postgresql.o 1519 :CBC 22363054 : CheckAndSetLockHeld(locallock, false);
8002 tgl@sss.pgh.pa.us 1520 : 22363054 : }
1521 : :
1522 : : /*
1523 : : * LockCheckConflicts -- test whether requested lock conflicts
1524 : : * with those already granted
1525 : : *
1526 : : * Returns true if conflict, false if no conflict.
1527 : : *
1528 : : * NOTES:
1529 : : * Here's what makes this complicated: one process's locks don't
1530 : : * conflict with one another, no matter what purpose they are held for
1531 : : * (eg, session and transaction locks do not conflict). Nor do the locks
1532 : : * of one process in a lock group conflict with those of another process in
1533 : : * the same group. So, we must subtract off these locks when determining
1534 : : * whether the requested new lock conflicts with those already held.
1535 : : */
1536 : : bool
8272 bruce@momjian.us 1537 : 2783786 : LockCheckConflicts(LockMethod lockMethodTable,
1538 : : LOCKMODE lockmode,
1539 : : LOCK *lock,
1540 : : PROCLOCK *proclock)
1541 : : {
8773 1542 : 2783786 : int numLockModes = lockMethodTable->numLockModes;
1543 : : LOCKMASK myLocks;
3821 rhaas@postgresql.org 1544 : 2783786 : int conflictMask = lockMethodTable->conflictTab[lockmode];
1545 : : int conflictsRemaining[MAX_LOCKMODES];
1546 : 2783786 : int totalConflictsRemaining = 0;
1547 : : dlist_iter proclock_iter;
1548 : : int i;
1549 : :
1550 : : /*
1551 : : * first check for global conflicts: If no locks conflict with my request,
1552 : : * then I get the lock.
1553 : : *
1554 : : * Checking for conflict: lock->grantMask represents the types of
1555 : : * currently held locks. conflictTable[lockmode] has a bit set for each
1556 : : * type of lock that conflicts with request. Bitwise compare tells if
1557 : : * there is a conflict.
1558 : : */
1559 [ + + ]: 2783786 : if (!(conflictMask & lock->grantMask))
1560 : : {
1561 : : PROCLOCK_PRINT("LockCheckConflicts: no conflict", proclock);
2400 peter@eisentraut.org 1562 : 2627034 : return false;
1563 : : }
1564 : :
1565 : : /*
1566 : : * Rats. Something conflicts. But it could still be my own lock, or a
1567 : : * lock held by another member of my locking group. First, figure out how
1568 : : * many conflicts remain after subtracting out any locks I hold myself.
1569 : : */
7711 tgl@sss.pgh.pa.us 1570 : 156752 : myLocks = proclock->holdMask;
8272 bruce@momjian.us 1571 [ + + ]: 1410768 : for (i = 1; i <= numLockModes; i++)
1572 : : {
3821 rhaas@postgresql.org 1573 [ + + ]: 1254016 : if ((conflictMask & LOCKBIT_ON(i)) == 0)
1574 : : {
1575 : 755415 : conflictsRemaining[i] = 0;
1576 : 755415 : continue;
1577 : : }
1578 : 498601 : conflictsRemaining[i] = lock->granted[i];
1579 [ + + ]: 498601 : if (myLocks & LOCKBIT_ON(i))
1580 : 166483 : --conflictsRemaining[i];
1581 : 498601 : totalConflictsRemaining += conflictsRemaining[i];
1582 : : }
1583 : :
1584 : : /* If no conflicts remain, we get the lock. */
1585 [ + + ]: 156752 : if (totalConflictsRemaining == 0)
1586 : : {
1587 : : PROCLOCK_PRINT("LockCheckConflicts: resolved (simple)", proclock);
2400 peter@eisentraut.org 1588 : 153618 : return false;
1589 : : }
1590 : :
1591 : : /* If no group locking, it's definitely a conflict. */
3821 rhaas@postgresql.org 1592 [ + + + + ]: 3134 : if (proclock->groupLeader == MyProc && MyProc->lockGroupLeader == NULL)
1593 : : {
1594 [ - + ]: 2014 : Assert(proclock->tag.myProc == MyProc);
1595 : : PROCLOCK_PRINT("LockCheckConflicts: conflicting (simple)",
1596 : : proclock);
2400 peter@eisentraut.org 1597 : 2014 : return true;
1598 : : }
1599 : :
1600 : : /*
1601 : : * The relation extension lock conflict even between the group members.
1602 : : */
1115 akapila@postgresql.o 1603 [ + + ]: 1120 : if (LOCK_LOCKTAG(*lock) == LOCKTAG_RELATION_EXTEND)
1604 : : {
1605 : : PROCLOCK_PRINT("LockCheckConflicts: conflicting (group)",
1606 : : proclock);
2318 1607 : 7 : return true;
1608 : : }
1609 : :
1610 : : /*
1611 : : * Locks held in conflicting modes by members of our own lock group are
1612 : : * not real conflicts; we can subtract those out and see if we still have
1613 : : * a conflict. This is O(N) in the number of processes holding or
1614 : : * awaiting locks on this object. We could improve that by making the
1615 : : * shared memory state more complex (and larger) but it doesn't seem worth
1616 : : * it.
1617 : : */
1284 andres@anarazel.de 1618 [ + - + + ]: 2709 : dlist_foreach(proclock_iter, &lock->procLocks)
1619 : : {
1620 : 2381 : PROCLOCK *otherproclock =
1621 : 2381 : dlist_container(PROCLOCK, lockLink, proclock_iter.cur);
1622 : :
3821 rhaas@postgresql.org 1623 [ + + ]: 2381 : if (proclock != otherproclock &&
1624 [ + + ]: 2053 : proclock->groupLeader == otherproclock->groupLeader &&
1625 [ + + ]: 804 : (otherproclock->holdMask & conflictMask) != 0)
1626 : : {
3698 1627 : 802 : int intersectMask = otherproclock->holdMask & conflictMask;
1628 : :
3821 1629 [ + + ]: 7218 : for (i = 1; i <= numLockModes; i++)
1630 : : {
1631 [ + + ]: 6416 : if ((intersectMask & LOCKBIT_ON(i)) != 0)
1632 : : {
1633 [ - + ]: 815 : if (conflictsRemaining[i] <= 0)
3821 rhaas@postgresql.org 1634 [ # # ]:UBC 0 : elog(PANIC, "proclocks held do not match lock");
3821 rhaas@postgresql.org 1635 :CBC 815 : conflictsRemaining[i]--;
1636 : 815 : totalConflictsRemaining--;
1637 : : }
1638 : : }
1639 : :
1640 [ + + ]: 802 : if (totalConflictsRemaining == 0)
1641 : : {
1642 : : PROCLOCK_PRINT("LockCheckConflicts: resolved (group)",
1643 : : proclock);
2400 peter@eisentraut.org 1644 : 785 : return false;
1645 : : }
1646 : : }
1647 : : }
1648 : :
1649 : : /* Nope, it's a real conflict. */
1650 : : PROCLOCK_PRINT("LockCheckConflicts: conflicting (group)", proclock);
1651 : 328 : return true;
1652 : : }
1653 : :
1654 : : /*
1655 : : * GrantLock -- update the lock and proclock data structures to show
1656 : : * the lock request has been granted.
1657 : : *
1658 : : * NOTE: if proc was blocked, it also needs to be removed from the wait list
1659 : : * and have its waitLock/waitProcLock fields cleared. That's not done here.
1660 : : *
1661 : : * NOTE: the lock grant also has to be recorded in the associated LOCALLOCK
1662 : : * table entry; but since we may be awaking some other process, we can't do
1663 : : * that here; it's done by GrantLockLocal, instead.
1664 : : */
1665 : : void
8558 bruce@momjian.us 1666 : 2783716 : GrantLock(LOCK *lock, PROCLOCK *proclock, LOCKMODE lockmode)
1667 : : {
9321 tgl@sss.pgh.pa.us 1668 : 2783716 : lock->nGranted++;
1669 : 2783716 : lock->granted[lockmode]++;
8272 bruce@momjian.us 1670 : 2783716 : lock->grantMask |= LOCKBIT_ON(lockmode);
9321 tgl@sss.pgh.pa.us 1671 [ + + ]: 2783716 : if (lock->granted[lockmode] == lock->requested[lockmode])
8272 bruce@momjian.us 1672 : 2783242 : lock->waitMask &= LOCKBIT_OFF(lockmode);
8002 tgl@sss.pgh.pa.us 1673 : 2783716 : proclock->holdMask |= LOCKBIT_ON(lockmode);
1674 : : LOCK_PRINT("GrantLock", lock, lockmode);
9321 1675 [ + - - + ]: 2783716 : Assert((lock->nGranted > 0) && (lock->granted[lockmode] > 0));
1676 [ - + ]: 2783716 : Assert(lock->nGranted <= lock->nRequested);
8002 1677 : 2783716 : }
1678 : :
1679 : : /*
1680 : : * UnGrantLock -- opposite of GrantLock.
1681 : : *
1682 : : * Updates the lock and proclock data structures to show that the lock
1683 : : * is no longer held nor requested by the current holder.
1684 : : *
1685 : : * Returns true if there were any waiters waiting on the lock that
1686 : : * should now be woken up with ProcLockWakeup.
1687 : : */
1688 : : static bool
7841 neilc@samurai.com 1689 : 2783645 : UnGrantLock(LOCK *lock, LOCKMODE lockmode,
1690 : : PROCLOCK *proclock, LockMethod lockMethodTable)
1691 : : {
7588 bruce@momjian.us 1692 : 2783645 : bool wakeupNeeded = false;
1693 : :
7841 neilc@samurai.com 1694 [ + - - + ]: 2783645 : Assert((lock->nRequested > 0) && (lock->requested[lockmode] > 0));
1695 [ + - - + ]: 2783645 : Assert((lock->nGranted > 0) && (lock->granted[lockmode] > 0));
1696 [ - + ]: 2783645 : Assert(lock->nGranted <= lock->nRequested);
1697 : :
1698 : : /*
1699 : : * fix the general lock stats
1700 : : */
1701 : 2783645 : lock->nRequested--;
1702 : 2783645 : lock->requested[lockmode]--;
1703 : 2783645 : lock->nGranted--;
1704 : 2783645 : lock->granted[lockmode]--;
1705 : :
1706 [ + + ]: 2783645 : if (lock->granted[lockmode] == 0)
1707 : : {
1708 : : /* change the conflict mask. No more of this lock type. */
1709 : 2729968 : lock->grantMask &= LOCKBIT_OFF(lockmode);
1710 : : }
1711 : :
1712 : : LOCK_PRINT("UnGrantLock: updated", lock, lockmode);
1713 : :
1714 : : /*
1715 : : * We need only run ProcLockWakeup if the released lock conflicts with at
1716 : : * least one of the lock types requested by waiter(s). Otherwise whatever
1717 : : * conflict made them wait must still exist. NOTE: before MVCC, we could
1718 : : * skip wakeup if lock->granted[lockmode] was still positive. But that's
1719 : : * not true anymore, because the remaining granted locks might belong to
1720 : : * some waiter, who could now be awakened because he doesn't conflict with
1721 : : * his own locks.
1722 : : */
1723 [ + + ]: 2783645 : if (lockMethodTable->conflictTab[lockmode] & lock->waitMask)
1724 : 1448 : wakeupNeeded = true;
1725 : :
1726 : : /*
1727 : : * Now fix the per-proclock state.
1728 : : */
1729 : 2783645 : proclock->holdMask &= LOCKBIT_OFF(lockmode);
1730 : : PROCLOCK_PRINT("UnGrantLock: updated", proclock);
1731 : :
1732 : 2783645 : return wakeupNeeded;
1733 : : }
1734 : :
1735 : : /*
1736 : : * CleanUpLock -- clean up after releasing a lock. We garbage-collect the
1737 : : * proclock and lock objects if possible, and call ProcLockWakeup if there
1738 : : * are remaining requests and the caller says it's OK. (Normally, this
1739 : : * should be called after UnGrantLock, and wakeupNeeded is the result from
1740 : : * UnGrantLock.)
1741 : : *
1742 : : * The appropriate partition lock must be held at entry, and will be
1743 : : * held at exit.
1744 : : */
1745 : : static void
7531 tgl@sss.pgh.pa.us 1746 : 2735791 : CleanUpLock(LOCK *lock, PROCLOCK *proclock,
1747 : : LockMethod lockMethodTable, uint32 hashcode,
1748 : : bool wakeupNeeded)
1749 : : {
1750 : : /*
1751 : : * If this was my last hold on this lock, delete my entry in the proclock
1752 : : * table.
1753 : : */
7737 1754 [ + + ]: 2735791 : if (proclock->holdMask == 0)
1755 : : {
1756 : : uint32 proclock_hashcode;
1757 : :
1758 : : PROCLOCK_PRINT("CleanUpLock: deleting", proclock);
1284 andres@anarazel.de 1759 : 2474842 : dlist_delete(&proclock->lockLink);
1760 : 2474842 : dlist_delete(&proclock->procLink);
7307 tgl@sss.pgh.pa.us 1761 : 2474842 : proclock_hashcode = ProcLockHashCode(&proclock->tag, hashcode);
1762 [ - + ]: 2474842 : if (!hash_search_with_hash_value(LockMethodProcLockHash,
1265 peter@eisentraut.org 1763 : 2474842 : &(proclock->tag),
1764 : : proclock_hashcode,
1765 : : HASH_REMOVE,
1766 : : NULL))
7737 tgl@sss.pgh.pa.us 1767 [ # # ]:UBC 0 : elog(PANIC, "proclock table corrupted");
1768 : : }
1769 : :
7737 tgl@sss.pgh.pa.us 1770 [ + + ]:CBC 2735791 : if (lock->nRequested == 0)
1771 : : {
1772 : : /*
1773 : : * The caller just released the last lock, so garbage-collect the lock
1774 : : * object.
1775 : : */
1776 : : LOCK_PRINT("CleanUpLock: deleting", lock, 0);
1284 andres@anarazel.de 1777 [ - + ]: 2402108 : Assert(dlist_is_empty(&lock->procLocks));
7307 tgl@sss.pgh.pa.us 1778 [ - + ]: 2402108 : if (!hash_search_with_hash_value(LockMethodLockHash,
1265 peter@eisentraut.org 1779 : 2402108 : &(lock->tag),
1780 : : hashcode,
1781 : : HASH_REMOVE,
1782 : : NULL))
7737 tgl@sss.pgh.pa.us 1783 [ # # ]:UBC 0 : elog(PANIC, "lock table corrupted");
1784 : : }
7737 tgl@sss.pgh.pa.us 1785 [ + + ]:CBC 333683 : else if (wakeupNeeded)
1786 : : {
1787 : : /* There are waiters on this lock, so wake them up. */
7531 1788 : 1491 : ProcLockWakeup(lockMethodTable, lock);
1789 : : }
7737 1790 : 2735791 : }
1791 : :
1792 : : /*
1793 : : * GrantLockLocal -- update the locallock data structures to show
1794 : : * the lock request has been granted.
1795 : : *
1796 : : * We expect that LockAcquire made sure there is room to add a new
1797 : : * ResourceOwner entry.
1798 : : */
1799 : : static void
8002 1800 : 25424272 : GrantLockLocal(LOCALLOCK *locallock, ResourceOwner owner)
1801 : : {
1802 : 25424272 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
1803 : : int i;
1804 : :
1805 [ - + ]: 25424272 : Assert(locallock->numLockOwners < locallock->maxLockOwners);
1806 : : /* Count the total */
1807 : 25424272 : locallock->nLocks++;
1808 : : /* Count the per-owner lock */
1809 [ + + ]: 27190376 : for (i = 0; i < locallock->numLockOwners; i++)
1810 : : {
1811 [ + + ]: 3765927 : if (lockOwners[i].owner == owner)
1812 : : {
1813 : 1999823 : lockOwners[i].nLocks++;
1814 : 1999823 : return;
1815 : : }
1816 : : }
1817 : 23424449 : lockOwners[i].owner = owner;
1818 : 23424449 : lockOwners[i].nLocks = 1;
1819 : 23424449 : locallock->numLockOwners++;
5147 heikki.linnakangas@i 1820 [ + + ]: 23424449 : if (owner != NULL)
1821 : 23377641 : ResourceOwnerRememberLock(owner, locallock);
1822 : :
1823 : : /* Indicate that the lock is acquired for certain types of locks. */
2320 akapila@postgresql.o 1824 : 23424449 : CheckAndSetLockHeld(locallock, true);
1825 : : }
1826 : :
1827 : : /*
1828 : : * BeginStrongLockAcquire - inhibit use of fastpath for a given LOCALLOCK,
1829 : : * and arrange for error cleanup if it fails
1830 : : */
1831 : : static void
5211 rhaas@postgresql.org 1832 : 249890 : BeginStrongLockAcquire(LOCALLOCK *locallock, uint32 fasthashcode)
1833 : : {
1834 [ - + ]: 249890 : Assert(StrongLockInProgress == NULL);
3265 peter_e@gmx.net 1835 [ - + ]: 249890 : Assert(locallock->holdsStrongLockCount == false);
1836 : :
1837 : : /*
1838 : : * Adding to a memory location is not atomic, so we take a spinlock to
1839 : : * ensure we don't collide with someone else trying to bump the count at
1840 : : * the same time.
1841 : : *
1842 : : * XXX: It might be worth considering using an atomic fetch-and-add
1843 : : * instruction here, on architectures where that is supported.
1844 : : */
1845 : :
5211 rhaas@postgresql.org 1846 : 249890 : SpinLockAcquire(&FastPathStrongRelationLocks->mutex);
1847 : 249890 : FastPathStrongRelationLocks->count[fasthashcode]++;
3265 peter_e@gmx.net 1848 : 249890 : locallock->holdsStrongLockCount = true;
5211 rhaas@postgresql.org 1849 : 249890 : StrongLockInProgress = locallock;
1850 : 249890 : SpinLockRelease(&FastPathStrongRelationLocks->mutex);
1851 : 249890 : }
1852 : :
1853 : : /*
1854 : : * FinishStrongLockAcquire - cancel pending cleanup for a strong lock
1855 : : * acquisition once it's no longer needed
1856 : : */
1857 : : static void
1858 : 2781434 : FinishStrongLockAcquire(void)
1859 : : {
1860 : 2781434 : StrongLockInProgress = NULL;
1861 : 2781434 : }
1862 : :
1863 : : /*
1864 : : * AbortStrongLockAcquire - undo strong lock state changes performed by
1865 : : * BeginStrongLockAcquire.
1866 : : */
1867 : : void
1868 : 470456 : AbortStrongLockAcquire(void)
1869 : : {
1870 : : uint32 fasthashcode;
1871 : 470456 : LOCALLOCK *locallock = StrongLockInProgress;
1872 : :
1873 [ + + ]: 470456 : if (locallock == NULL)
1874 : 470242 : return;
1875 : :
1876 : 214 : fasthashcode = FastPathStrongLockHashPartition(locallock->hashcode);
3265 peter_e@gmx.net 1877 [ - + ]: 214 : Assert(locallock->holdsStrongLockCount == true);
5211 rhaas@postgresql.org 1878 : 214 : SpinLockAcquire(&FastPathStrongRelationLocks->mutex);
4492 1879 [ - + ]: 214 : Assert(FastPathStrongRelationLocks->count[fasthashcode] > 0);
5211 1880 : 214 : FastPathStrongRelationLocks->count[fasthashcode]--;
3265 peter_e@gmx.net 1881 : 214 : locallock->holdsStrongLockCount = false;
5211 rhaas@postgresql.org 1882 : 214 : StrongLockInProgress = NULL;
1883 : 214 : SpinLockRelease(&FastPathStrongRelationLocks->mutex);
1884 : : }
1885 : :
1886 : : /*
1887 : : * GrantAwaitedLock -- call GrantLockLocal for the lock we are doing
1888 : : * WaitOnLock on.
1889 : : *
1890 : : * proc.c needs this for the case where we are booted off the lock by
1891 : : * timeout, but discover that someone granted us the lock anyway.
1892 : : *
1893 : : * We could just export GrantLockLocal, but that would require including
1894 : : * resowner.h in lock.h, which creates circularity.
1895 : : */
1896 : : void
8002 tgl@sss.pgh.pa.us 1897 : 1 : GrantAwaitedLock(void)
1898 : : {
1899 : 1 : GrantLockLocal(awaitedLock, awaitedOwner);
10196 scrappy@hub.org 1900 : 1 : }
1901 : :
1902 : : /*
1903 : : * GetAwaitedLock -- Return the lock we're currently doing WaitOnLock on.
1904 : : */
1905 : : LOCALLOCK *
628 heikki.linnakangas@i 1906 : 471231 : GetAwaitedLock(void)
1907 : : {
1908 : 471231 : return awaitedLock;
1909 : : }
1910 : :
1911 : : /*
1912 : : * ResetAwaitedLock -- Forget that we are waiting on a lock.
1913 : : */
1914 : : void
484 1915 : 40 : ResetAwaitedLock(void)
1916 : : {
1917 : 40 : awaitedLock = NULL;
1918 : 40 : }
1919 : :
1920 : : /*
1921 : : * MarkLockClear -- mark an acquired lock as "clear"
1922 : : *
1923 : : * This means that we know we have absorbed all sinval messages that other
1924 : : * sessions generated before we acquired this lock, and so we can confidently
1925 : : * assume we know about any catalog changes protected by this lock.
1926 : : */
1927 : : void
2878 tgl@sss.pgh.pa.us 1928 : 21507407 : MarkLockClear(LOCALLOCK *locallock)
1929 : : {
1930 [ - + ]: 21507407 : Assert(locallock->nLocks > 0);
1931 : 21507407 : locallock->lockCleared = true;
1932 : 21507407 : }
1933 : :
1934 : : /*
1935 : : * WaitOnLock -- wait to acquire a lock
1936 : : *
1937 : : * This is a wrapper around ProcSleep, with extra tracing and bookkeeping.
1938 : : */
1939 : : static ProcWaitStatus
628 heikki.linnakangas@i 1940 : 1530 : WaitOnLock(LOCALLOCK *locallock, ResourceOwner owner)
1941 : : {
1942 : : ProcWaitStatus result;
1943 : : ErrorContextCallback waiterrcontext;
1944 : :
1945 : : TRACE_POSTGRESQL_LOCK_WAIT_START(locallock->tag.lock.locktag_field1,
1946 : : locallock->tag.lock.locktag_field2,
1947 : : locallock->tag.lock.locktag_field3,
1948 : : locallock->tag.lock.locktag_field4,
1949 : : locallock->tag.lock.locktag_type,
1950 : : locallock->tag.mode);
1951 : :
1952 : : /* Setup error traceback support for ereport() */
330 tgl@sss.pgh.pa.us 1953 : 1530 : waiterrcontext.callback = waitonlock_error_callback;
246 peter@eisentraut.org 1954 : 1530 : waiterrcontext.arg = locallock;
330 tgl@sss.pgh.pa.us 1955 : 1530 : waiterrcontext.previous = error_context_stack;
1956 : 1530 : error_context_stack = &waiterrcontext;
1957 : :
1958 : : /* adjust the process title to indicate that it's waiting */
1251 drowley@postgresql.o 1959 : 1530 : set_ps_display_suffix("waiting");
1960 : :
1961 : : /*
1962 : : * Record the fact that we are waiting for a lock, so that
1963 : : * LockErrorCleanup will clean up if cancel/die happens.
1964 : : */
8002 tgl@sss.pgh.pa.us 1965 : 1530 : awaitedLock = locallock;
1966 : 1530 : awaitedOwner = owner;
1967 : :
1968 : : /*
1969 : : * NOTE: Think not to put any shared-state cleanup after the call to
1970 : : * ProcSleep, in either the normal or failure path. The lock state must
1971 : : * be fully set by the lock grantor, or by CheckDeadLock if we give up
1972 : : * waiting for the lock. This is necessary because of the possibility
1973 : : * that a cancel/die interrupt will interrupt ProcSleep after someone else
1974 : : * grants us the lock, but before we've noticed it. Hence, after granting,
1975 : : * the locktable state must fully reflect the fact that we own the lock;
1976 : : * we can't do additional work on return.
1977 : : *
1978 : : * We can and do use a PG_TRY block to try to clean up after failure, but
1979 : : * this still has a major limitation: elog(FATAL) can occur while waiting
1980 : : * (eg, a "die" interrupt), and then control won't come back here. So all
1981 : : * cleanup of essential state should happen in LockErrorCleanup, not here.
1982 : : * We can use PG_TRY to clear the "waiting" status flags, since doing that
1983 : : * is unimportant if the process exits.
1984 : : */
6748 1985 [ + + ]: 1530 : PG_TRY();
1986 : : {
628 heikki.linnakangas@i 1987 : 1530 : result = ProcSleep(locallock);
1988 : : }
6748 tgl@sss.pgh.pa.us 1989 : 39 : PG_CATCH();
1990 : : {
1991 : : /* In this path, awaitedLock remains set until LockErrorCleanup */
1992 : :
1993 : : /* reset ps display to remove the suffix */
1251 drowley@postgresql.o 1994 : 39 : set_ps_display_remove_suffix();
1995 : :
1996 : : /* and propagate the error */
6748 tgl@sss.pgh.pa.us 1997 : 39 : PG_RE_THROW();
1998 : : }
1999 [ - + ]: 1488 : PG_END_TRY();
2000 : :
2001 : : /*
2002 : : * We no longer want LockErrorCleanup to do anything.
2003 : : */
8002 2004 : 1488 : awaitedLock = NULL;
2005 : :
2006 : : /* reset ps display to remove the suffix */
1251 drowley@postgresql.o 2007 : 1488 : set_ps_display_remove_suffix();
2008 : :
330 tgl@sss.pgh.pa.us 2009 : 1488 : error_context_stack = waiterrcontext.previous;
2010 : :
2011 : : TRACE_POSTGRESQL_LOCK_WAIT_DONE(locallock->tag.lock.locktag_field1,
2012 : : locallock->tag.lock.locktag_field2,
2013 : : locallock->tag.lock.locktag_field3,
2014 : : locallock->tag.lock.locktag_field4,
2015 : : locallock->tag.lock.locktag_type,
2016 : : locallock->tag.mode);
2017 : :
628 heikki.linnakangas@i 2018 : 1488 : return result;
2019 : : }
2020 : :
2021 : : /*
2022 : : * error context callback for failures in WaitOnLock
2023 : : *
2024 : : * We report which lock was being waited on, in the same style used in
2025 : : * deadlock reports. This helps with lock timeout errors in particular.
2026 : : */
2027 : : static void
330 tgl@sss.pgh.pa.us 2028 : 276 : waitonlock_error_callback(void *arg)
2029 : : {
2030 : 276 : LOCALLOCK *locallock = (LOCALLOCK *) arg;
2031 : 276 : const LOCKTAG *tag = &locallock->tag.lock;
2032 : 276 : LOCKMODE mode = locallock->tag.mode;
2033 : : StringInfoData locktagbuf;
2034 : :
2035 : 276 : initStringInfo(&locktagbuf);
2036 : 276 : DescribeLockTag(&locktagbuf, tag);
2037 : :
2038 : 552 : errcontext("waiting for %s on %s",
2039 : 276 : GetLockmodeName(tag->locktag_lockmethodid, mode),
2040 : : locktagbuf.data);
2041 : 276 : }
2042 : :
2043 : : /*
2044 : : * Remove a proc from the wait-queue it is on (caller must know it is on one).
2045 : : * This is only used when the proc has failed to get the lock, so we set its
2046 : : * waitStatus to PROC_WAIT_STATUS_ERROR.
2047 : : *
2048 : : * Appropriate partition lock must be held by caller. Also, caller is
2049 : : * responsible for signaling the proc if needed.
2050 : : *
2051 : : * NB: this does not clean up any locallock object that may exist for the lock.
2052 : : */
2053 : : void
7307 2054 : 44 : RemoveFromWaitQueue(PGPROC *proc, uint32 hashcode)
2055 : : {
9256 bruce@momjian.us 2056 : 44 : LOCK *waitLock = proc->waitLock;
7816 tgl@sss.pgh.pa.us 2057 : 44 : PROCLOCK *proclock = proc->waitProcLock;
9256 bruce@momjian.us 2058 : 44 : LOCKMODE lockmode = proc->waitLockMode;
7816 tgl@sss.pgh.pa.us 2059 : 44 : LOCKMETHODID lockmethodid = LOCK_LOCKMETHOD(*waitLock);
2060 : :
2061 : : /* Make sure proc is waiting */
2229 peter@eisentraut.org 2062 [ - + ]: 44 : Assert(proc->waitStatus == PROC_WAIT_STATUS_WAITING);
155 heikki.linnakangas@i 2063 [ - + ]: 44 : Assert(!dlist_node_is_detached(&proc->waitLink));
9312 tgl@sss.pgh.pa.us 2064 [ - + ]: 44 : Assert(waitLock);
1284 andres@anarazel.de 2065 [ - + ]: 44 : Assert(!dclist_is_empty(&waitLock->waitProcs));
7533 tgl@sss.pgh.pa.us 2066 [ + - - + ]: 44 : Assert(0 < lockmethodid && lockmethodid < lengthof(LockMethods));
2067 : :
2068 : : /* Remove proc from lock's wait queue */
155 heikki.linnakangas@i 2069 : 44 : dclist_delete_from_thoroughly(&waitLock->waitProcs, &proc->waitLink);
2070 : :
2071 : : /* Undo increments of request counts by waiting process */
9312 tgl@sss.pgh.pa.us 2072 [ - + ]: 44 : Assert(waitLock->nRequested > 0);
2073 [ - + ]: 44 : Assert(waitLock->nRequested > proc->waitLock->nGranted);
2074 : 44 : waitLock->nRequested--;
2075 [ - + ]: 44 : Assert(waitLock->requested[lockmode] > 0);
2076 : 44 : waitLock->requested[lockmode]--;
2077 : : /* don't forget to clear waitMask bit if appropriate */
2078 [ + - ]: 44 : if (waitLock->granted[lockmode] == waitLock->requested[lockmode])
8272 bruce@momjian.us 2079 : 44 : waitLock->waitMask &= LOCKBIT_OFF(lockmode);
2080 : :
2081 : : /* Clean up the proc's own state, and pass it the ok/fail signal */
9312 tgl@sss.pgh.pa.us 2082 : 44 : proc->waitLock = NULL;
8002 2083 : 44 : proc->waitProcLock = NULL;
2229 peter@eisentraut.org 2084 : 44 : proc->waitStatus = PROC_WAIT_STATUS_ERROR;
2085 : :
2086 : : /*
2087 : : * Delete the proclock immediately if it represents no already-held locks.
2088 : : * (This must happen now because if the owner of the lock decides to
2089 : : * release it, and the requested/granted counts then go to zero,
2090 : : * LockRelease expects there to be no remaining proclocks.) Then see if
2091 : : * any other waiters for the lock can be woken up now.
2092 : : */
7531 tgl@sss.pgh.pa.us 2093 : 44 : CleanUpLock(waitLock, proclock,
7307 2094 : 44 : LockMethods[lockmethodid], hashcode,
2095 : : true);
9312 2096 : 44 : }
2097 : :
2098 : : /*
2099 : : * LockRelease -- look up 'locktag' and release one 'lockmode' lock on it.
2100 : : * Release a session lock if 'sessionLock' is true, else release a
2101 : : * regular transaction lock.
2102 : : *
2103 : : * Side Effects: find any waiting processes that are now wakable,
2104 : : * grant them their requested locks and awaken them.
2105 : : * (We have to grant the lock here to avoid a race between
2106 : : * the waking process and any new process to
2107 : : * come along and request the lock.)
2108 : : */
2109 : : bool
7533 2110 : 22575498 : LockRelease(const LOCKTAG *locktag, LOCKMODE lockmode, bool sessionLock)
2111 : : {
2112 : 22575498 : LOCKMETHODID lockmethodid = locktag->locktag_lockmethodid;
2113 : : LockMethod lockMethodTable;
2114 : : LOCALLOCKTAG localtag;
2115 : : LOCALLOCK *locallock;
2116 : : LOCK *lock;
2117 : : PROCLOCK *proclock;
2118 : : LWLock *partitionLock;
2119 : : bool wakeupNeeded;
2120 : :
2121 [ + - - + ]: 22575498 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7533 tgl@sss.pgh.pa.us 2122 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7533 tgl@sss.pgh.pa.us 2123 :CBC 22575498 : lockMethodTable = LockMethods[lockmethodid];
2124 [ + - - + ]: 22575498 : if (lockmode <= 0 || lockmode > lockMethodTable->numLockModes)
7533 tgl@sss.pgh.pa.us 2125 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock mode: %d", lockmode);
2126 : :
2127 : : #ifdef LOCK_DEBUG
2128 : : if (LOCK_DEBUG_ENABLED(locktag))
2129 : : elog(LOG, "LockRelease: lock [%u,%u] %s",
2130 : : locktag->locktag_field1, locktag->locktag_field2,
2131 : : lockMethodTable->lockModeNames[lockmode]);
2132 : : #endif
2133 : :
2134 : : /*
2135 : : * Find the LOCALLOCK entry for this lock and lockmode
2136 : : */
3321 tgl@sss.pgh.pa.us 2137 [ + - - + :CBC 22575498 : MemSet(&localtag, 0, sizeof(localtag)); /* must clear padding */
- - - - -
- ]
8002 2138 : 22575498 : localtag.lock = *locktag;
2139 : 22575498 : localtag.mode = lockmode;
2140 : :
7533 2141 : 22575498 : locallock = (LOCALLOCK *) hash_search(LockMethodLocalHash,
2142 : : &localtag,
2143 : : HASH_FIND, NULL);
2144 : :
2145 : : /*
2146 : : * let the caller print its own error message, too. Do not ereport(ERROR).
2147 : : */
8002 2148 [ + + - + ]: 22575498 : if (!locallock || locallock->nLocks <= 0)
2149 : : {
2150 [ + - ]: 17 : elog(WARNING, "you don't own a lock of type %s",
2151 : : lockMethodTable->lockModeNames[lockmode]);
3265 peter_e@gmx.net 2152 : 17 : return false;
2153 : : }
2154 : :
2155 : : /*
2156 : : * Decrease the count for the resource owner.
2157 : : */
2158 : : {
8002 tgl@sss.pgh.pa.us 2159 : 22575481 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
2160 : : ResourceOwner owner;
2161 : : int i;
2162 : :
2163 : : /* Identify owner for lock */
5195 2164 [ + + ]: 22575481 : if (sessionLock)
8002 2165 : 46790 : owner = NULL;
2166 : : else
5195 2167 : 22528691 : owner = CurrentResourceOwner;
2168 : :
8002 2169 [ + + ]: 22576679 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
2170 : : {
2171 [ + + ]: 22576663 : if (lockOwners[i].owner == owner)
2172 : : {
2173 [ - + ]: 22575465 : Assert(lockOwners[i].nLocks > 0);
2174 [ + + ]: 22575465 : if (--lockOwners[i].nLocks == 0)
2175 : : {
5147 heikki.linnakangas@i 2176 [ + + ]: 21808456 : if (owner != NULL)
2177 : 21761707 : ResourceOwnerForgetLock(owner, locallock);
2178 : : /* compact out unused slot */
8002 tgl@sss.pgh.pa.us 2179 : 21808456 : locallock->numLockOwners--;
2180 [ + + ]: 21808456 : if (i < locallock->numLockOwners)
2181 : 72 : lockOwners[i] = lockOwners[locallock->numLockOwners];
2182 : : }
2183 : 22575465 : break;
2184 : : }
2185 : : }
2186 [ + + ]: 22575481 : if (i < 0)
2187 : : {
2188 : : /* don't release a lock belonging to another owner */
2189 [ + - ]: 16 : elog(WARNING, "you don't own a lock of type %s",
2190 : : lockMethodTable->lockModeNames[lockmode]);
3265 peter_e@gmx.net 2191 : 16 : return false;
2192 : : }
2193 : : }
2194 : :
2195 : : /*
2196 : : * Decrease the total local count. If we're still holding the lock, we're
2197 : : * done.
2198 : : */
8002 tgl@sss.pgh.pa.us 2199 : 22575465 : locallock->nLocks--;
2200 : :
2201 [ + + ]: 22575465 : if (locallock->nLocks > 0)
3265 peter_e@gmx.net 2202 : 1653914 : return true;
2203 : :
2204 : : /*
2205 : : * At this point we can no longer suppose we are clear of invalidation
2206 : : * messages related to this lock. Although we'll delete the LOCALLOCK
2207 : : * object before any intentional return from this routine, it seems worth
2208 : : * the trouble to explicitly reset lockCleared right now, just in case
2209 : : * some error prevents us from deleting the LOCALLOCK.
2210 : : */
2878 tgl@sss.pgh.pa.us 2211 : 20921551 : locallock->lockCleared = false;
2212 : :
2213 : : /* Attempt fast release of any lock eligible for the fast path. */
4623 2214 [ + + + + : 20921551 : if (EligibleForRelationFastPath(locktag, lockmode) &&
+ + + + +
+ ]
672 tomas.vondra@postgre 2215 [ + + ]: 19419720 : FastPathLocalUseCounts[FAST_PATH_REL_GROUP(locktag->locktag_field2)] > 0)
2216 : : {
2217 : : bool released;
2218 : :
2219 : : /*
2220 : : * We might not find the lock here, even if we originally entered it
2221 : : * here. Another backend may have moved it to the main table.
2222 : : */
2262 tgl@sss.pgh.pa.us 2223 : 19039655 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
5485 rhaas@postgresql.org 2224 : 19039655 : released = FastPathUnGrantRelationLock(locktag->locktag_field2,
2225 : : lockmode);
2262 tgl@sss.pgh.pa.us 2226 : 19039655 : LWLockRelease(&MyProc->fpInfoLock);
5537 rhaas@postgresql.org 2227 [ + + ]: 19039655 : if (released)
2228 : : {
2229 : 18902953 : RemoveLocalLock(locallock);
3265 peter_e@gmx.net 2230 : 18902953 : return true;
2231 : : }
2232 : : }
2233 : :
2234 : : /*
2235 : : * Otherwise we've got to mess with the shared lock table.
2236 : : */
7307 tgl@sss.pgh.pa.us 2237 : 2018598 : partitionLock = LockHashPartitionLock(locallock->hashcode);
2238 : :
7531 2239 : 2018598 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
2240 : :
2241 : : /*
2242 : : * Normally, we don't need to re-find the lock or proclock, since we kept
2243 : : * their addresses in the locallock table, and they couldn't have been
2244 : : * removed while we were holding a lock on them. But it's possible that
2245 : : * the lock was taken fast-path and has since been moved to the main hash
2246 : : * table by another backend, in which case we will need to look up the
2247 : : * objects here. We assume the lock field is NULL if so.
2248 : : */
8002 2249 : 2018598 : lock = locallock->lock;
5537 rhaas@postgresql.org 2250 [ + + ]: 2018598 : if (!lock)
2251 : : {
2252 : : PROCLOCKTAG proclocktag;
2253 : :
5169 2254 [ + - + - : 6 : Assert(EligibleForRelationFastPath(locktag, lockmode));
+ - + - -
+ ]
5537 2255 : 6 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
2256 : : locktag,
2257 : : locallock->hashcode,
2258 : : HASH_FIND,
2259 : : NULL);
4623 tgl@sss.pgh.pa.us 2260 [ - + ]: 6 : if (!lock)
4623 tgl@sss.pgh.pa.us 2261 [ # # ]:UBC 0 : elog(ERROR, "failed to re-find shared lock object");
5537 rhaas@postgresql.org 2262 :CBC 6 : locallock->lock = lock;
2263 : :
2264 : 6 : proclocktag.myLock = lock;
2265 : 6 : proclocktag.myProc = MyProc;
2266 : 6 : locallock->proclock = (PROCLOCK *) hash_search(LockMethodProcLockHash,
2267 : : &proclocktag,
2268 : : HASH_FIND,
2269 : : NULL);
4623 tgl@sss.pgh.pa.us 2270 [ - + ]: 6 : if (!locallock->proclock)
4623 tgl@sss.pgh.pa.us 2271 [ # # ]:UBC 0 : elog(ERROR, "failed to re-find shared proclock object");
2272 : : }
2273 : : LOCK_PRINT("LockRelease: found", lock, lockmode);
8002 tgl@sss.pgh.pa.us 2274 :CBC 2018598 : proclock = locallock->proclock;
2275 : : PROCLOCK_PRINT("LockRelease: found", proclock);
2276 : :
2277 : : /*
2278 : : * Double-check that we are actually holding a lock of the type we want to
2279 : : * release.
2280 : : */
2281 [ - + ]: 2018598 : if (!(proclock->holdMask & LOCKBIT_ON(lockmode)))
2282 : : {
2283 : : PROCLOCK_PRINT("LockRelease: WRONGTYPE", proclock);
7531 tgl@sss.pgh.pa.us 2284 :UBC 0 : LWLockRelease(partitionLock);
8402 2285 [ # # ]: 0 : elog(WARNING, "you don't own a lock of type %s",
2286 : : lockMethodTable->lockModeNames[lockmode]);
8002 2287 : 0 : RemoveLocalLock(locallock);
3265 peter_e@gmx.net 2288 : 0 : return false;
2289 : : }
2290 : :
2291 : : /*
2292 : : * Do the releasing. CleanUpLock will waken any now-wakable waiters.
2293 : : */
7737 tgl@sss.pgh.pa.us 2294 :CBC 2018598 : wakeupNeeded = UnGrantLock(lock, lockmode, proclock, lockMethodTable);
2295 : :
7531 2296 : 2018598 : CleanUpLock(lock, proclock,
2297 : : lockMethodTable, locallock->hashcode,
2298 : : wakeupNeeded);
2299 : :
2300 : 2018598 : LWLockRelease(partitionLock);
2301 : :
8002 2302 : 2018598 : RemoveLocalLock(locallock);
3265 peter_e@gmx.net 2303 : 2018598 : return true;
2304 : : }
2305 : :
2306 : : /*
2307 : : * LockReleaseAll -- Release all locks of the specified lock method that
2308 : : * are held by the current process.
2309 : : *
2310 : : * Well, not necessarily *all* locks. The available behaviors are:
2311 : : * allLocks == true: release all locks including session locks.
2312 : : * allLocks == false: release all non-session locks.
2313 : : */
2314 : : void
7711 tgl@sss.pgh.pa.us 2315 : 874445 : LockReleaseAll(LOCKMETHODID lockmethodid, bool allLocks)
2316 : : {
2317 : : HASH_SEQ_STATUS status;
2318 : : LockMethod lockMethodTable;
2319 : : int i,
2320 : : numLockModes;
2321 : : LOCALLOCK *locallock;
2322 : : LOCK *lock;
2323 : : int partition;
5537 rhaas@postgresql.org 2324 : 874445 : bool have_fast_path_lwlock = false;
2325 : :
7533 tgl@sss.pgh.pa.us 2326 [ + - - + ]: 874445 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7533 tgl@sss.pgh.pa.us 2327 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7533 tgl@sss.pgh.pa.us 2328 :CBC 874445 : lockMethodTable = LockMethods[lockmethodid];
2329 : :
2330 : : #ifdef LOCK_DEBUG
2331 : : if (*(lockMethodTable->trace_flag))
2332 : : elog(LOG, "LockReleaseAll: lockmethod=%d", lockmethodid);
2333 : : #endif
2334 : :
2335 : : /*
2336 : : * Get rid of our fast-path VXID lock, if appropriate. Note that this is
2337 : : * the only way that the lock we hold on our own VXID can ever get
2338 : : * released: it is always and only released when a toplevel transaction
2339 : : * ends.
2340 : : */
5469 rhaas@postgresql.org 2341 [ + + ]: 874445 : if (lockmethodid == DEFAULT_LOCKMETHOD)
2342 : 428232 : VirtualXactLockTableCleanup();
2343 : :
8773 bruce@momjian.us 2344 : 874445 : numLockModes = lockMethodTable->numLockModes;
2345 : :
2346 : : /*
2347 : : * First we run through the locallock table and get rid of unwanted
2348 : : * entries, then we scan the process's proclocks and get rid of those. We
2349 : : * do this separately because we may have multiple locallock entries
2350 : : * pointing to the same proclock, and we daren't end up with any dangling
2351 : : * pointers. Fast-path locks are cleaned up during the locallock table
2352 : : * scan, though.
2353 : : */
7533 tgl@sss.pgh.pa.us 2354 : 874445 : hash_seq_init(&status, LockMethodLocalHash);
2355 : :
8002 2356 [ + + ]: 2382837 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
2357 : : {
2358 : : /*
2359 : : * If the LOCALLOCK entry is unused, something must've gone wrong
2360 : : * while trying to acquire this lock. Just forget the local entry.
2361 : : */
5169 rhaas@postgresql.org 2362 [ + + ]: 1508392 : if (locallock->nLocks == 0)
2363 : : {
2364 : 46 : RemoveLocalLock(locallock);
2365 : 46 : continue;
2366 : : }
2367 : :
2368 : : /* Ignore items that are not of the lockmethod to be removed */
2369 [ + + ]: 1508346 : if (LOCALLOCK_LOCKMETHOD(*locallock) != lockmethodid)
2370 : 34400 : continue;
2371 : :
2372 : : /*
2373 : : * If we are asked to release all locks, we can just zap the entry.
2374 : : * Otherwise, must scan to see if there are session locks. We assume
2375 : : * there is at most one lockOwners entry for session locks.
2376 : : */
2377 [ + + ]: 1473946 : if (!allLocks)
2378 : : {
2379 : 1367948 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
2380 : :
2381 : : /* If session lock is above array position 0, move it down to 0 */
4805 bruce@momjian.us 2382 [ + + ]: 2757550 : for (i = 0; i < locallock->numLockOwners; i++)
2383 : : {
5169 rhaas@postgresql.org 2384 [ + + ]: 1389602 : if (lockOwners[i].owner == NULL)
2385 : 34079 : lockOwners[0] = lockOwners[i];
2386 : : else
5147 heikki.linnakangas@i 2387 : 1355523 : ResourceOwnerForgetLock(lockOwners[i].owner, locallock);
2388 : : }
2389 : :
5169 rhaas@postgresql.org 2390 [ + - ]: 1367948 : if (locallock->numLockOwners > 0 &&
2391 [ + + ]: 1367948 : lockOwners[0].owner == NULL &&
2392 [ + - ]: 34079 : lockOwners[0].nLocks > 0)
2393 : : {
2394 : : /* Fix the locallock to show just the session locks */
2395 : 34079 : locallock->nLocks = lockOwners[0].nLocks;
2396 : 34079 : locallock->numLockOwners = 1;
2397 : : /* We aren't deleting this locallock, so done */
5537 2398 : 34079 : continue;
2399 : : }
2400 : : else
5147 heikki.linnakangas@i 2401 : 1333869 : locallock->numLockOwners = 0;
2402 : : }
2403 : :
2404 : : #ifdef USE_ASSERT_CHECKING
2405 : :
2406 : : /*
2407 : : * Tuple locks are currently held only for short durations within a
2408 : : * transaction. Check that we didn't forget to release one.
2409 : : */
669 noah@leadboat.com 2410 [ + + - + ]: 1439867 : if (LOCALLOCK_LOCKTAG(*locallock) == LOCKTAG_TUPLE && !allLocks)
669 noah@leadboat.com 2411 [ # # ]:UBC 0 : elog(WARNING, "tuple lock held at commit");
2412 : : #endif
2413 : :
2414 : : /*
2415 : : * If the lock or proclock pointers are NULL, this lock was taken via
2416 : : * the relation fast-path (and is not known to have been transferred).
2417 : : */
5169 rhaas@postgresql.org 2418 [ + + - + ]:CBC 1439867 : if (locallock->proclock == NULL || locallock->lock == NULL)
2419 : 1556 : {
2420 : 677530 : LOCKMODE lockmode = locallock->tag.mode;
2421 : : Oid relid;
2422 : :
2423 : : /* Verify that a fast-path lock is what we've got. */
2424 [ + - + - : 677530 : if (!EligibleForRelationFastPath(&locallock->tag.lock, lockmode))
+ - + - -
+ ]
5537 rhaas@postgresql.org 2425 [ # # ]:UBC 0 : elog(PANIC, "locallock table corrupted");
2426 : :
2427 : : /*
2428 : : * If we don't currently hold the LWLock that protects our
2429 : : * fast-path data structures, we must acquire it before attempting
2430 : : * to release the lock via the fast-path. We will continue to
2431 : : * hold the LWLock until we're done scanning the locallock table,
2432 : : * unless we hit a transferred fast-path lock. (XXX is this
2433 : : * really such a good idea? There could be a lot of entries ...)
2434 : : */
5537 rhaas@postgresql.org 2435 [ + + ]:CBC 677530 : if (!have_fast_path_lwlock)
2436 : : {
2262 tgl@sss.pgh.pa.us 2437 : 195142 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
5537 rhaas@postgresql.org 2438 : 195142 : have_fast_path_lwlock = true;
2439 : : }
2440 : :
2441 : : /* Attempt fast-path release. */
2442 : 677530 : relid = locallock->tag.lock.locktag_field2;
5485 2443 [ + + ]: 677530 : if (FastPathUnGrantRelationLock(relid, lockmode))
2444 : : {
5537 2445 : 675974 : RemoveLocalLock(locallock);
2446 : 675974 : continue;
2447 : : }
2448 : :
2449 : : /*
2450 : : * Our lock, originally taken via the fast path, has been
2451 : : * transferred to the main lock table. That's going to require
2452 : : * some extra work, so release our fast-path lock before starting.
2453 : : */
2262 tgl@sss.pgh.pa.us 2454 : 1556 : LWLockRelease(&MyProc->fpInfoLock);
5537 rhaas@postgresql.org 2455 : 1556 : have_fast_path_lwlock = false;
2456 : :
2457 : : /*
2458 : : * Now dump the lock. We haven't got a pointer to the LOCK or
2459 : : * PROCLOCK in this case, so we have to handle this a bit
2460 : : * differently than a normal lock release. Unfortunately, this
2461 : : * requires an extra LWLock acquire-and-release cycle on the
2462 : : * partitionLock, but hopefully it shouldn't happen often.
2463 : : */
2464 : 1556 : LockRefindAndRelease(lockMethodTable, MyProc,
2465 : : &locallock->tag.lock, lockmode, false);
8002 tgl@sss.pgh.pa.us 2466 : 1556 : RemoveLocalLock(locallock);
2467 : 1556 : continue;
2468 : : }
2469 : :
2470 : : /* Mark the proclock to show we need to release this lockmode */
7711 2471 [ + - ]: 762337 : if (locallock->nLocks > 0)
2472 : 762337 : locallock->proclock->releaseMask |= LOCKBIT_ON(locallock->tag.mode);
2473 : :
2474 : : /* And remove the locallock hashtable entry */
8002 2475 : 762337 : RemoveLocalLock(locallock);
2476 : : }
2477 : :
2478 : : /* Done with the fast-path data structures */
5537 rhaas@postgresql.org 2479 [ + + ]: 874445 : if (have_fast_path_lwlock)
2262 tgl@sss.pgh.pa.us 2480 : 193586 : LWLockRelease(&MyProc->fpInfoLock);
2481 : :
2482 : : /*
2483 : : * Now, scan each lock partition separately.
2484 : : */
7531 2485 [ + + ]: 14865565 : for (partition = 0; partition < NUM_LOCK_PARTITIONS; partition++)
2486 : : {
2487 : : LWLock *partitionLock;
1284 andres@anarazel.de 2488 : 13991120 : dlist_head *procLocks = &MyProc->myProcLocks[partition];
2489 : : dlist_mutable_iter proclock_iter;
2490 : :
4562 rhaas@postgresql.org 2491 : 13991120 : partitionLock = LockHashPartitionLockByIndex(partition);
2492 : :
2493 : : /*
2494 : : * If the proclock list for this partition is empty, we can skip
2495 : : * acquiring the partition lock. This optimization is trickier than
2496 : : * it looks, because another backend could be in process of adding
2497 : : * something to our proclock list due to promoting one of our
2498 : : * fast-path locks. However, any such lock must be one that we
2499 : : * decided not to delete above, so it's okay to skip it again now;
2500 : : * we'd just decide not to delete it again. We must, however, be
2501 : : * careful to re-fetch the list header once we've acquired the
2502 : : * partition lock, to be sure we have a valid, up-to-date pointer.
2503 : : * (There is probably no significant risk if pointer fetch/store is
2504 : : * atomic, but we don't wish to assume that.)
2505 : : *
2506 : : * XXX This argument assumes that the locallock table correctly
2507 : : * represents all of our fast-path locks. While allLocks mode
2508 : : * guarantees to clean up all of our normal locks regardless of the
2509 : : * locallock situation, we lose that guarantee for fast-path locks.
2510 : : * This is not ideal.
2511 : : */
1284 andres@anarazel.de 2512 [ + + ]: 13991120 : if (dlist_is_empty(procLocks))
7531 tgl@sss.pgh.pa.us 2513 : 13372503 : continue; /* needn't examine this partition */
2514 : :
2515 : 618617 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
2516 : :
1284 andres@anarazel.de 2517 [ + - + + ]: 1400667 : dlist_foreach_modify(proclock_iter, procLocks)
2518 : : {
2519 : 782050 : PROCLOCK *proclock = dlist_container(PROCLOCK, procLink, proclock_iter.cur);
7531 tgl@sss.pgh.pa.us 2520 : 782050 : bool wakeupNeeded = false;
2521 : :
7307 2522 [ - + ]: 782050 : Assert(proclock->tag.myProc == MyProc);
2523 : :
2524 : 782050 : lock = proclock->tag.myLock;
2525 : :
2526 : : /* Ignore items that are not of the lockmethod to be removed */
7531 2527 [ + + ]: 782050 : if (LOCK_LOCKMETHOD(*lock) != lockmethodid)
4622 2528 : 34400 : continue;
2529 : :
2530 : : /*
2531 : : * In allLocks mode, force release of all locks even if locallock
2532 : : * table had problems
2533 : : */
7531 2534 [ + + ]: 747650 : if (allLocks)
2535 : 46112 : proclock->releaseMask = proclock->holdMask;
2536 : : else
2537 [ - + ]: 701538 : Assert((proclock->releaseMask & ~proclock->holdMask) == 0);
2538 : :
2539 : : /*
2540 : : * Ignore items that have nothing to be released, unless they have
2541 : : * holdMask == 0 and are therefore recyclable
2542 : : */
2543 [ + + + - ]: 747650 : if (proclock->releaseMask == 0 && proclock->holdMask != 0)
4622 2544 : 33209 : continue;
2545 : :
2546 : : PROCLOCK_PRINT("LockReleaseAll", proclock);
2547 : : LOCK_PRINT("LockReleaseAll", lock, 0);
7531 2548 [ - + ]: 714441 : Assert(lock->nRequested >= 0);
2549 [ - + ]: 714441 : Assert(lock->nGranted >= 0);
2550 [ - + ]: 714441 : Assert(lock->nGranted <= lock->nRequested);
2551 [ - + ]: 714441 : Assert((proclock->holdMask & ~lock->grantMask) == 0);
2552 : :
2553 : : /*
2554 : : * Release the previously-marked lock modes
2555 : : */
2556 [ + + ]: 6429969 : for (i = 1; i <= numLockModes; i++)
2557 : : {
2558 [ + + ]: 5715528 : if (proclock->releaseMask & LOCKBIT_ON(i))
2559 : 762339 : wakeupNeeded |= UnGrantLock(lock, i, proclock,
2560 : : lockMethodTable);
2561 : : }
2562 [ + - - + ]: 714441 : Assert((lock->nRequested >= 0) && (lock->nGranted >= 0));
2563 [ - + ]: 714441 : Assert(lock->nGranted <= lock->nRequested);
2564 : : LOCK_PRINT("LockReleaseAll: updated", lock, 0);
2565 : :
2566 : 714441 : proclock->releaseMask = 0;
2567 : :
2568 : : /* CleanUpLock will wake up waiters if needed. */
2569 : 714441 : CleanUpLock(lock, proclock,
2570 : : lockMethodTable,
7307 2571 : 714441 : LockTagHashCode(&lock->tag),
2572 : : wakeupNeeded);
2573 : : } /* loop over PROCLOCKs within this partition */
2574 : :
7531 2575 : 618617 : LWLockRelease(partitionLock);
2576 : : } /* loop over partitions */
2577 : :
2578 : : #ifdef LOCK_DEBUG
2579 : : if (*(lockMethodTable->trace_flag))
2580 : : elog(LOG, "LockReleaseAll done");
2581 : : #endif
10973 scrappy@hub.org 2582 : 874445 : }
2583 : :
2584 : : /*
2585 : : * LockReleaseSession -- Release all session locks of the specified lock method
2586 : : * that are held by the current process.
2587 : : */
2588 : : void
5195 tgl@sss.pgh.pa.us 2589 : 122 : LockReleaseSession(LOCKMETHODID lockmethodid)
2590 : : {
2591 : : HASH_SEQ_STATUS status;
2592 : : LOCALLOCK *locallock;
2593 : :
2594 [ + - - + ]: 122 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
5195 tgl@sss.pgh.pa.us 2595 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
2596 : :
5195 tgl@sss.pgh.pa.us 2597 :CBC 122 : hash_seq_init(&status, LockMethodLocalHash);
2598 : :
2599 [ + + ]: 242 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
2600 : : {
2601 : : /* Ignore items that are not of the specified lock method */
2602 [ + + ]: 120 : if (LOCALLOCK_LOCKMETHOD(*locallock) != lockmethodid)
2603 : 11 : continue;
2604 : :
2605 : 109 : ReleaseLockIfHeld(locallock, true);
2606 : : }
2607 : 122 : }
2608 : :
2609 : : /*
2610 : : * LockReleaseCurrentOwner
2611 : : * Release all locks belonging to CurrentResourceOwner
2612 : : *
2613 : : * If the caller knows what those locks are, it can pass them as an array.
2614 : : * That speeds up the call significantly, when a lot of locks are held.
2615 : : * Otherwise, pass NULL for locallocks, and we'll traverse through our hash
2616 : : * table to find them.
2617 : : */
2618 : : void
5147 heikki.linnakangas@i 2619 : 6322 : LockReleaseCurrentOwner(LOCALLOCK **locallocks, int nlocks)
2620 : : {
2621 [ + + ]: 6322 : if (locallocks == NULL)
2622 : : {
2623 : : HASH_SEQ_STATUS status;
2624 : : LOCALLOCK *locallock;
2625 : :
2626 : 9 : hash_seq_init(&status, LockMethodLocalHash);
2627 : :
2628 [ + + ]: 647 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
2629 : 638 : ReleaseLockIfHeld(locallock, false);
2630 : : }
2631 : : else
2632 : : {
2633 : : int i;
2634 : :
2635 [ + + ]: 9793 : for (i = nlocks - 1; i >= 0; i--)
2636 : 3480 : ReleaseLockIfHeld(locallocks[i], false);
2637 : : }
5636 itagaki.takahiro@gma 2638 : 6322 : }
2639 : :
2640 : : /*
2641 : : * ReleaseLockIfHeld
2642 : : * Release any session-level locks on this lockable object if sessionLock
2643 : : * is true; else, release any locks held by CurrentResourceOwner.
2644 : : *
2645 : : * It is tempting to pass this a ResourceOwner pointer (or NULL for session
2646 : : * locks), but without refactoring LockRelease() we cannot support releasing
2647 : : * locks belonging to resource owners other than CurrentResourceOwner.
2648 : : * If we were to refactor, it'd be a good idea to fix it so we don't have to
2649 : : * do a hashtable lookup of the locallock, too. However, currently this
2650 : : * function isn't used heavily enough to justify refactoring for its
2651 : : * convenience.
2652 : : */
2653 : : static void
5195 tgl@sss.pgh.pa.us 2654 : 4227 : ReleaseLockIfHeld(LOCALLOCK *locallock, bool sessionLock)
2655 : : {
2656 : : ResourceOwner owner;
2657 : : LOCALLOCKOWNER *lockOwners;
2658 : : int i;
2659 : :
2660 : : /* Identify owner for lock (must match LockRelease!) */
2661 [ + + ]: 4227 : if (sessionLock)
2662 : 109 : owner = NULL;
2663 : : else
2664 : 4118 : owner = CurrentResourceOwner;
2665 : :
2666 : : /* Scan to see if there are any locks belonging to the target owner */
5636 itagaki.takahiro@gma 2667 : 4227 : lockOwners = locallock->lockOwners;
2668 [ + + ]: 4696 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
2669 : : {
2670 [ + + ]: 4227 : if (lockOwners[i].owner == owner)
2671 : : {
2672 [ - + ]: 3758 : Assert(lockOwners[i].nLocks > 0);
2673 [ + + ]: 3758 : if (lockOwners[i].nLocks < locallock->nLocks)
2674 : : {
2675 : : /*
2676 : : * We will still hold this lock after forgetting this
2677 : : * ResourceOwner.
2678 : : */
2679 : 973 : locallock->nLocks -= lockOwners[i].nLocks;
2680 : : /* compact out unused slot */
2681 : 973 : locallock->numLockOwners--;
5147 heikki.linnakangas@i 2682 [ + - ]: 973 : if (owner != NULL)
2683 : 973 : ResourceOwnerForgetLock(owner, locallock);
5636 itagaki.takahiro@gma 2684 [ - + ]: 973 : if (i < locallock->numLockOwners)
5636 itagaki.takahiro@gma 2685 :UBC 0 : lockOwners[i] = lockOwners[locallock->numLockOwners];
2686 : : }
2687 : : else
2688 : : {
5636 itagaki.takahiro@gma 2689 [ - + ]:CBC 2785 : Assert(lockOwners[i].nLocks == locallock->nLocks);
2690 : : /* We want to call LockRelease just once */
2691 : 2785 : lockOwners[i].nLocks = 1;
2692 : 2785 : locallock->nLocks = 1;
2693 [ - + ]: 2785 : if (!LockRelease(&locallock->tag.lock,
2694 : : locallock->tag.mode,
2695 : : sessionLock))
5195 tgl@sss.pgh.pa.us 2696 [ # # ]:UBC 0 : elog(WARNING, "ReleaseLockIfHeld: failed??");
2697 : : }
5636 itagaki.takahiro@gma 2698 :CBC 3758 : break;
2699 : : }
2700 : : }
8002 tgl@sss.pgh.pa.us 2701 : 4227 : }
2702 : :
2703 : : /*
2704 : : * LockReassignCurrentOwner
2705 : : * Reassign all locks belonging to CurrentResourceOwner to belong
2706 : : * to its parent resource owner.
2707 : : *
2708 : : * If the caller knows what those locks are, it can pass them as an array.
2709 : : * That speeds up the call significantly, when a lot of locks are held
2710 : : * (e.g pg_dump with a large schema). Otherwise, pass NULL for locallocks,
2711 : : * and we'll traverse through our hash table to find them.
2712 : : */
2713 : : void
5147 heikki.linnakangas@i 2714 : 439898 : LockReassignCurrentOwner(LOCALLOCK **locallocks, int nlocks)
2715 : : {
8002 tgl@sss.pgh.pa.us 2716 : 439898 : ResourceOwner parent = ResourceOwnerGetParent(CurrentResourceOwner);
2717 : :
2718 [ - + ]: 439898 : Assert(parent != NULL);
2719 : :
5147 heikki.linnakangas@i 2720 [ + + ]: 439898 : if (locallocks == NULL)
2721 : : {
2722 : : HASH_SEQ_STATUS status;
2723 : : LOCALLOCK *locallock;
2724 : :
2725 : 7971 : hash_seq_init(&status, LockMethodLocalHash);
2726 : :
2727 [ + + ]: 240298 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
2728 : 232327 : LockReassignOwner(locallock, parent);
2729 : : }
2730 : : else
2731 : : {
2732 : : int i;
2733 : :
2734 [ + + ]: 1003585 : for (i = nlocks - 1; i >= 0; i--)
2735 : 571658 : LockReassignOwner(locallocks[i], parent);
2736 : : }
2737 : 439898 : }
2738 : :
2739 : : /*
2740 : : * Subroutine of LockReassignCurrentOwner. Reassigns a given lock belonging to
2741 : : * CurrentResourceOwner to its parent.
2742 : : */
2743 : : static void
2744 : 803985 : LockReassignOwner(LOCALLOCK *locallock, ResourceOwner parent)
2745 : : {
2746 : : LOCALLOCKOWNER *lockOwners;
2747 : : int i;
2748 : 803985 : int ic = -1;
2749 : 803985 : int ip = -1;
2750 : :
2751 : : /*
2752 : : * Scan to see if there are any locks belonging to current owner or its
2753 : : * parent
2754 : : */
2755 : 803985 : lockOwners = locallock->lockOwners;
2756 [ + + ]: 1803452 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
2757 : : {
2758 [ + + ]: 999467 : if (lockOwners[i].owner == CurrentResourceOwner)
2759 : 743380 : ic = i;
2760 [ + + ]: 256087 : else if (lockOwners[i].owner == parent)
2761 : 212165 : ip = i;
2762 : : }
2763 : :
2764 [ + + ]: 803985 : if (ic < 0)
4805 bruce@momjian.us 2765 : 60605 : return; /* no current locks */
2766 : :
5147 heikki.linnakangas@i 2767 [ + + ]: 743380 : if (ip < 0)
2768 : : {
2769 : : /* Parent has no slot, so just give it the child's slot */
2770 : 591777 : lockOwners[ic].owner = parent;
2771 : 591777 : ResourceOwnerRememberLock(parent, locallock);
2772 : : }
2773 : : else
2774 : : {
2775 : : /* Merge child's count with parent's */
2776 : 151603 : lockOwners[ip].nLocks += lockOwners[ic].nLocks;
2777 : : /* compact out unused slot */
2778 : 151603 : locallock->numLockOwners--;
2779 [ + + ]: 151603 : if (ic < locallock->numLockOwners)
2780 : 905 : lockOwners[ic] = lockOwners[locallock->numLockOwners];
2781 : : }
2782 : 743380 : ResourceOwnerForgetLock(CurrentResourceOwner, locallock);
2783 : : }
2784 : :
2785 : : /*
2786 : : * FastPathGrantRelationLock
2787 : : * Grant lock using per-backend fast-path array, if there is space.
2788 : : */
2789 : : static bool
5485 rhaas@postgresql.org 2790 : 19580810 : FastPathGrantRelationLock(Oid relid, LOCKMODE lockmode)
2791 : : {
2792 : : uint32 i;
508 tomas.vondra@postgre 2793 : 19580810 : uint32 unused_slot = FastPathLockSlotsPerBackend();
2794 : :
2795 : : /* fast-path group the lock belongs to */
672 2796 : 19580810 : uint32 group = FAST_PATH_REL_GROUP(relid);
2797 : :
2798 : : /* Scan for existing entry for this relid, remembering empty slot. */
2799 [ + + ]: 331976212 : for (i = 0; i < FP_LOCK_SLOTS_PER_GROUP; i++)
2800 : : {
2801 : : /* index into the whole per-backend array */
2802 [ - + - + ]: 313094881 : uint32 f = FAST_PATH_SLOT(group, i);
2803 : :
5537 rhaas@postgresql.org 2804 [ - + - + : 313094881 : if (FAST_PATH_GET_BITS(MyProc, f) == 0)
+ + ]
2805 : 306003436 : unused_slot = f;
2806 [ + + ]: 7091445 : else if (MyProc->fpRelId[f] == relid)
2807 : : {
2808 [ - + - + : 699479 : Assert(!FAST_PATH_CHECK_LOCKMODE(MyProc, f, lockmode));
- + - + -
+ - + ]
2809 [ - + - + : 699479 : FAST_PATH_SET_LOCKMODE(MyProc, f, lockmode);
- + - + -
+ ]
2810 : 699479 : return true;
2811 : : }
2812 : : }
2813 : :
2814 : : /* If no existing entry, use any empty slot. */
508 tomas.vondra@postgre 2815 [ + - ]: 18881331 : if (unused_slot < FastPathLockSlotsPerBackend())
2816 : : {
5537 rhaas@postgresql.org 2817 : 18881331 : MyProc->fpRelId[unused_slot] = relid;
2818 [ - + - + : 18881331 : FAST_PATH_SET_LOCKMODE(MyProc, unused_slot, lockmode);
- + - + -
+ ]
672 tomas.vondra@postgre 2819 : 18881331 : ++FastPathLocalUseCounts[group];
5537 rhaas@postgresql.org 2820 : 18881331 : return true;
2821 : : }
2822 : :
2823 : : /* No existing entry, and no empty slot. */
5537 rhaas@postgresql.org 2824 :UBC 0 : return false;
2825 : : }
2826 : :
2827 : : /*
2828 : : * FastPathUnGrantRelationLock
2829 : : * Release fast-path lock, if present. Update backend-private local
2830 : : * use count, while we're at it.
2831 : : */
2832 : : static bool
5485 rhaas@postgresql.org 2833 :CBC 19717185 : FastPathUnGrantRelationLock(Oid relid, LOCKMODE lockmode)
2834 : : {
2835 : : uint32 i;
5537 2836 : 19717185 : bool result = false;
2837 : :
2838 : : /* fast-path group the lock belongs to */
672 tomas.vondra@postgre 2839 : 19717185 : uint32 group = FAST_PATH_REL_GROUP(relid);
2840 : :
2841 : 19717185 : FastPathLocalUseCounts[group] = 0;
2842 [ + + ]: 335192145 : for (i = 0; i < FP_LOCK_SLOTS_PER_GROUP; i++)
2843 : : {
2844 : : /* index into the whole per-backend array */
2845 [ - + - + ]: 315474960 : uint32 f = FAST_PATH_SLOT(group, i);
2846 : :
5537 rhaas@postgresql.org 2847 [ + + ]: 315474960 : if (MyProc->fpRelId[f] == relid
2848 [ - + - + : 28099380 : && FAST_PATH_CHECK_LOCKMODE(MyProc, f, lockmode))
- + - + -
+ + + ]
2849 : : {
2850 [ - + ]: 19578927 : Assert(!result);
2851 [ - + - + : 19578927 : FAST_PATH_CLEAR_LOCKMODE(MyProc, f, lockmode);
- + - + -
+ ]
2852 : 19578927 : result = true;
2853 : : /* we continue iterating so as to update FastPathLocalUseCount */
2854 : : }
2855 [ - + - + : 315474960 : if (FAST_PATH_GET_BITS(MyProc, f) != 0)
+ + ]
672 tomas.vondra@postgre 2856 : 8722527 : ++FastPathLocalUseCounts[group];
2857 : : }
5537 rhaas@postgresql.org 2858 : 19717185 : return result;
2859 : : }
2860 : :
2861 : : /*
2862 : : * FastPathTransferRelationLocks
2863 : : * Transfer locks matching the given lock tag from per-backend fast-path
2864 : : * arrays to the shared hash table.
2865 : : *
2866 : : * Returns true if successful, false if ran out of shared memory.
2867 : : */
2868 : : static bool
5485 2869 : 249890 : FastPathTransferRelationLocks(LockMethod lockMethodTable, const LOCKTAG *locktag,
2870 : : uint32 hashcode)
2871 : : {
4562 2872 : 249890 : LWLock *partitionLock = LockHashPartitionLock(hashcode);
5158 bruce@momjian.us 2873 : 249890 : Oid relid = locktag->locktag_field2;
2874 : : uint32 i;
2875 : :
2876 : : /* fast-path group the lock belongs to */
498 fujii@postgresql.org 2877 : 249890 : uint32 group = FAST_PATH_REL_GROUP(relid);
2878 : :
2879 : : /*
2880 : : * Every PGPROC that can potentially hold a fast-path lock is present in
2881 : : * ProcGlobal->allProcs. Prepared transactions are not, but any
2882 : : * outstanding fast-path locks held by prepared transactions are
2883 : : * transferred to the main lock table.
2884 : : */
5537 rhaas@postgresql.org 2885 [ + + ]: 37154715 : for (i = 0; i < ProcGlobal->allProcCount; i++)
2886 : : {
201 drowley@postgresql.o 2887 : 36904825 : PGPROC *proc = GetPGProcByNumber(i);
2888 : : uint32 j;
2889 : :
2262 tgl@sss.pgh.pa.us 2890 : 36904825 : LWLockAcquire(&proc->fpInfoLock, LW_EXCLUSIVE);
2891 : :
2892 : : /*
2893 : : * If the target backend isn't referencing the same database as the
2894 : : * lock, then we needn't examine the individual relation IDs at all;
2895 : : * none of them can be relevant.
2896 : : *
2897 : : * proc->databaseId is set at backend startup time and never changes
2898 : : * thereafter, so it might be safe to perform this test before
2899 : : * acquiring &proc->fpInfoLock. In particular, it's certainly safe to
2900 : : * assume that if the target backend holds any fast-path locks, it
2901 : : * must have performed a memory-fencing operation (in particular, an
2902 : : * LWLock acquisition) since setting proc->databaseId. However, it's
2903 : : * less clear that our backend is certain to have performed a memory
2904 : : * fencing operation since the other backend set proc->databaseId. So
2905 : : * for now, we test it after acquiring the LWLock just to be safe.
2906 : : *
2907 : : * Also skip groups without any registered fast-path locks.
2908 : : */
498 fujii@postgresql.org 2909 [ + + ]: 36904825 : if (proc->databaseId != locktag->locktag_field1 ||
2910 [ + + ]: 14841296 : proc->fpLockBits[group] == 0)
2911 : : {
2262 tgl@sss.pgh.pa.us 2912 : 36711724 : LWLockRelease(&proc->fpInfoLock);
5537 rhaas@postgresql.org 2913 : 36711724 : continue;
2914 : : }
2915 : :
672 tomas.vondra@postgre 2916 [ + + ]: 3281099 : for (j = 0; j < FP_LOCK_SLOTS_PER_GROUP; j++)
2917 : : {
2918 : : uint32 lockmode;
2919 : :
2920 : : /* index into the whole per-backend array */
2921 [ - + - + ]: 3089516 : uint32 f = FAST_PATH_SLOT(group, j);
2922 : :
2923 : : /* Look for an allocated slot matching the given relid. */
5537 rhaas@postgresql.org 2924 [ + + - + : 3089516 : if (relid != proc->fpRelId[f] || FAST_PATH_GET_BITS(proc, f) == 0)
- + + + ]
2925 : 3087998 : continue;
2926 : :
2927 : : /* Find or create lock object. */
2928 : 1518 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
2929 : 1518 : for (lockmode = FAST_PATH_LOCKNUMBER_OFFSET;
3321 tgl@sss.pgh.pa.us 2930 [ + + ]: 6072 : lockmode < FAST_PATH_LOCKNUMBER_OFFSET + FAST_PATH_BITS_PER_SLOT;
5537 rhaas@postgresql.org 2931 : 4554 : ++lockmode)
2932 : : {
2933 : : PROCLOCK *proclock;
2934 : :
2935 [ - + - + : 4554 : if (!FAST_PATH_CHECK_LOCKMODE(proc, f, lockmode))
- + - + -
+ + + ]
2936 : 2976 : continue;
2937 : 1578 : proclock = SetupLockInTable(lockMethodTable, proc, locktag,
2938 : : hashcode, lockmode);
2939 [ - + ]: 1578 : if (!proclock)
2940 : : {
5537 rhaas@postgresql.org 2941 :UBC 0 : LWLockRelease(partitionLock);
2262 tgl@sss.pgh.pa.us 2942 : 0 : LWLockRelease(&proc->fpInfoLock);
5537 rhaas@postgresql.org 2943 : 0 : return false;
2944 : : }
5537 rhaas@postgresql.org 2945 :CBC 1578 : GrantLock(proclock->tag.myLock, proclock, lockmode);
2946 [ - + - + : 1578 : FAST_PATH_CLEAR_LOCKMODE(proc, f, lockmode);
- + - + -
+ ]
2947 : : }
2948 : 1518 : LWLockRelease(partitionLock);
2949 : :
2950 : : /* No need to examine remaining slots. */
4623 tgl@sss.pgh.pa.us 2951 : 1518 : break;
2952 : : }
2262 2953 : 193101 : LWLockRelease(&proc->fpInfoLock);
2954 : : }
5537 rhaas@postgresql.org 2955 : 249890 : return true;
2956 : : }
2957 : :
2958 : : /*
2959 : : * FastPathGetRelationLockEntry
2960 : : * Return the PROCLOCK for a lock originally taken via the fast-path,
2961 : : * transferring it to the primary lock table if necessary.
2962 : : *
2963 : : * Note: caller takes care of updating the locallock object.
2964 : : */
2965 : : static PROCLOCK *
5485 2966 : 321 : FastPathGetRelationLockEntry(LOCALLOCK *locallock)
2967 : : {
5158 bruce@momjian.us 2968 : 321 : LockMethod lockMethodTable = LockMethods[DEFAULT_LOCKMETHOD];
2969 : 321 : LOCKTAG *locktag = &locallock->tag.lock;
2970 : 321 : PROCLOCK *proclock = NULL;
4562 rhaas@postgresql.org 2971 : 321 : LWLock *partitionLock = LockHashPartitionLock(locallock->hashcode);
5158 bruce@momjian.us 2972 : 321 : Oid relid = locktag->locktag_field2;
2973 : : uint32 i,
2974 : : group;
2975 : :
2976 : : /* fast-path group the lock belongs to */
672 tomas.vondra@postgre 2977 : 321 : group = FAST_PATH_REL_GROUP(relid);
2978 : :
2262 tgl@sss.pgh.pa.us 2979 : 321 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
2980 : :
672 tomas.vondra@postgre 2981 [ + + ]: 5146 : for (i = 0; i < FP_LOCK_SLOTS_PER_GROUP; i++)
2982 : : {
2983 : : uint32 lockmode;
2984 : :
2985 : : /* index into the whole per-backend array */
2986 [ - + - + ]: 5130 : uint32 f = FAST_PATH_SLOT(group, i);
2987 : :
2988 : : /* Look for an allocated slot matching the given relid. */
5537 rhaas@postgresql.org 2989 [ + + - + : 5130 : if (relid != MyProc->fpRelId[f] || FAST_PATH_GET_BITS(MyProc, f) == 0)
- + + + ]
2990 : 4825 : continue;
2991 : :
2992 : : /* If we don't have a lock of the given mode, forget it! */
2993 : 305 : lockmode = locallock->tag.mode;
2994 [ - + - + : 305 : if (!FAST_PATH_CHECK_LOCKMODE(MyProc, f, lockmode))
- + - + -
+ - + ]
5537 rhaas@postgresql.org 2995 :UBC 0 : break;
2996 : :
2997 : : /* Find or create lock object. */
5537 rhaas@postgresql.org 2998 :CBC 305 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
2999 : :
3000 : 305 : proclock = SetupLockInTable(lockMethodTable, MyProc, locktag,
3001 : : locallock->hashcode, lockmode);
3002 [ - + ]: 305 : if (!proclock)
3003 : : {
4946 tgl@sss.pgh.pa.us 3004 :UBC 0 : LWLockRelease(partitionLock);
2262 3005 : 0 : LWLockRelease(&MyProc->fpInfoLock);
5537 rhaas@postgresql.org 3006 [ # # ]: 0 : ereport(ERROR,
3007 : : (errcode(ERRCODE_OUT_OF_MEMORY),
3008 : : errmsg("out of shared memory"),
3009 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
3010 : : }
5537 rhaas@postgresql.org 3011 :CBC 305 : GrantLock(proclock->tag.myLock, proclock, lockmode);
3012 [ - + - + : 305 : FAST_PATH_CLEAR_LOCKMODE(MyProc, f, lockmode);
- + - + -
+ ]
3013 : :
3014 : 305 : LWLockRelease(partitionLock);
3015 : :
3016 : : /* No need to examine remaining slots. */
4623 tgl@sss.pgh.pa.us 3017 : 305 : break;
3018 : : }
3019 : :
2262 3020 : 321 : LWLockRelease(&MyProc->fpInfoLock);
3021 : :
3022 : : /* Lock may have already been transferred by some other backend. */
5537 rhaas@postgresql.org 3023 [ + + ]: 321 : if (proclock == NULL)
3024 : : {
3025 : : LOCK *lock;
3026 : : PROCLOCKTAG proclocktag;
3027 : : uint32 proclock_hashcode;
3028 : :
3029 : 16 : LWLockAcquire(partitionLock, LW_SHARED);
3030 : :
3031 : 16 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
3032 : : locktag,
3033 : : locallock->hashcode,
3034 : : HASH_FIND,
3035 : : NULL);
3036 [ - + ]: 16 : if (!lock)
5537 rhaas@postgresql.org 3037 [ # # ]:UBC 0 : elog(ERROR, "failed to re-find shared lock object");
3038 : :
5537 rhaas@postgresql.org 3039 :CBC 16 : proclocktag.myLock = lock;
3040 : 16 : proclocktag.myProc = MyProc;
3041 : :
3042 : 16 : proclock_hashcode = ProcLockHashCode(&proclocktag, locallock->hashcode);
3043 : : proclock = (PROCLOCK *)
3044 : 16 : hash_search_with_hash_value(LockMethodProcLockHash,
3045 : : &proclocktag,
3046 : : proclock_hashcode,
3047 : : HASH_FIND,
3048 : : NULL);
3049 [ - + ]: 16 : if (!proclock)
5537 rhaas@postgresql.org 3050 [ # # ]:UBC 0 : elog(ERROR, "failed to re-find shared proclock object");
5537 rhaas@postgresql.org 3051 :CBC 16 : LWLockRelease(partitionLock);
3052 : : }
3053 : :
3054 : 321 : return proclock;
3055 : : }
3056 : :
3057 : : /*
3058 : : * GetLockConflicts
3059 : : * Get an array of VirtualTransactionIds of xacts currently holding locks
3060 : : * that would conflict with the specified lock/lockmode.
3061 : : * xacts merely awaiting such a lock are NOT reported.
3062 : : *
3063 : : * The result array is palloc'd and is terminated with an invalid VXID.
3064 : : * *countp, if not null, is updated to the number of items set.
3065 : : *
3066 : : * Of course, the result could be out of date by the time it's returned, so
3067 : : * use of this function has to be thought about carefully. Similarly, a
3068 : : * PGPROC with no "lxid" will be considered non-conflicting regardless of any
3069 : : * lock it holds. Existing callers don't care about a locker after that
3070 : : * locker's pg_xact updates complete. CommitTransaction() clears "lxid" after
3071 : : * pg_xact updates and before releasing locks.
3072 : : *
3073 : : * Note we never include the current xact's vxid in the result array,
3074 : : * since an xact never blocks itself.
3075 : : */
3076 : : VirtualTransactionId *
2671 alvherre@alvh.no-ip. 3077 : 1674 : GetLockConflicts(const LOCKTAG *locktag, LOCKMODE lockmode, int *countp)
3078 : : {
3079 : : static VirtualTransactionId *vxids;
7272 tgl@sss.pgh.pa.us 3080 : 1674 : LOCKMETHODID lockmethodid = locktag->locktag_lockmethodid;
3081 : : LockMethod lockMethodTable;
3082 : : LOCK *lock;
3083 : : LOCKMASK conflictMask;
3084 : : dlist_iter proclock_iter;
3085 : : PROCLOCK *proclock;
3086 : : uint32 hashcode;
3087 : : LWLock *partitionLock;
6898 3088 : 1674 : int count = 0;
5537 rhaas@postgresql.org 3089 : 1674 : int fast_count = 0;
3090 : :
7272 tgl@sss.pgh.pa.us 3091 [ + - - + ]: 1674 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7272 tgl@sss.pgh.pa.us 3092 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7272 tgl@sss.pgh.pa.us 3093 :CBC 1674 : lockMethodTable = LockMethods[lockmethodid];
3094 [ + - - + ]: 1674 : if (lockmode <= 0 || lockmode > lockMethodTable->numLockModes)
7272 tgl@sss.pgh.pa.us 3095 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock mode: %d", lockmode);
3096 : :
3097 : : /*
3098 : : * Allocate memory to store results, and fill with InvalidVXID. We only
3099 : : * need enough space for MaxBackends + max_prepared_xacts + a terminator.
3100 : : * InHotStandby allocate once in TopMemoryContext.
3101 : : */
6021 simon@2ndQuadrant.co 3102 [ + + ]:CBC 1674 : if (InHotStandby)
3103 : : {
6022 3104 [ + + ]: 4 : if (vxids == NULL)
3105 : 1 : vxids = (VirtualTransactionId *)
6021 3106 : 1 : MemoryContextAlloc(TopMemoryContext,
3107 : : sizeof(VirtualTransactionId) *
1565 rhaas@postgresql.org 3108 : 1 : (MaxBackends + max_prepared_xacts + 1));
3109 : : }
3110 : : else
227 michael@paquier.xyz 3111 : 1670 : vxids = palloc0_array(VirtualTransactionId, (MaxBackends + max_prepared_xacts + 1));
3112 : :
3113 : : /* Compute hash code and partition lock, and look up conflicting modes. */
7272 tgl@sss.pgh.pa.us 3114 : 1674 : hashcode = LockTagHashCode(locktag);
3115 : 1674 : partitionLock = LockHashPartitionLock(hashcode);
5537 rhaas@postgresql.org 3116 : 1674 : conflictMask = lockMethodTable->conflictTab[lockmode];
3117 : :
3118 : : /*
3119 : : * Fast path locks might not have been entered in the primary lock table.
3120 : : * If the lock we're dealing with could conflict with such a lock, we must
3121 : : * examine each backend's fast-path array for conflicts.
3122 : : */
5169 3123 [ + - + - : 1674 : if (ConflictsWithRelationFastPath(locktag, lockmode))
+ - + - ]
3124 : : {
5537 3125 : 1674 : Oid relid = locktag->locktag_field2;
3126 : : VirtualTransactionId vxid;
3127 : :
3128 : : /* fast-path group the lock belongs to */
498 fujii@postgresql.org 3129 : 1674 : uint32 group = FAST_PATH_REL_GROUP(relid);
3130 : :
3131 : : /*
3132 : : * Iterate over relevant PGPROCs. Anything held by a prepared
3133 : : * transaction will have been transferred to the primary lock table,
3134 : : * so we need not worry about those. This is all a bit fuzzy, because
3135 : : * new locks could be taken after we've visited a particular
3136 : : * partition, but the callers had better be prepared to deal with that
3137 : : * anyway, since the locks could equally well be taken between the
3138 : : * time we return the value and the time the caller does something
3139 : : * with it.
3140 : : */
14 peter@eisentraut.org 3141 [ + + ]:GNC 263962 : for (uint32 i = 0; i < ProcGlobal->allProcCount; i++)
3142 : : {
201 drowley@postgresql.o 3143 :CBC 262288 : PGPROC *proc = GetPGProcByNumber(i);
3144 : : uint32 j;
3145 : :
3146 : : /* A backend never blocks itself */
5537 rhaas@postgresql.org 3147 [ + + ]: 262288 : if (proc == MyProc)
3148 : 1674 : continue;
3149 : :
2262 tgl@sss.pgh.pa.us 3150 : 260614 : LWLockAcquire(&proc->fpInfoLock, LW_SHARED);
3151 : :
3152 : : /*
3153 : : * If the target backend isn't referencing the same database as
3154 : : * the lock, then we needn't examine the individual relation IDs
3155 : : * at all; none of them can be relevant.
3156 : : *
3157 : : * See FastPathTransferRelationLocks() for discussion of why we do
3158 : : * this test after acquiring the lock.
3159 : : *
3160 : : * Also skip groups without any registered fast-path locks.
3161 : : */
498 fujii@postgresql.org 3162 [ + + ]: 260614 : if (proc->databaseId != locktag->locktag_field1 ||
3163 [ + + ]: 116482 : proc->fpLockBits[group] == 0)
3164 : : {
2262 tgl@sss.pgh.pa.us 3165 : 260179 : LWLockRelease(&proc->fpInfoLock);
5537 rhaas@postgresql.org 3166 : 260179 : continue;
3167 : : }
3168 : :
672 tomas.vondra@postgre 3169 [ + + ]: 7193 : for (j = 0; j < FP_LOCK_SLOTS_PER_GROUP; j++)
3170 : : {
3171 : : uint32 lockmask;
3172 : :
3173 : : /* index into the whole per-backend array */
3174 [ - + - + ]: 6960 : uint32 f = FAST_PATH_SLOT(group, j);
3175 : :
3176 : : /* Look for an allocated slot matching the given relid. */
5537 rhaas@postgresql.org 3177 [ + + ]: 6960 : if (relid != proc->fpRelId[f])
3178 : 6758 : continue;
3179 [ - + - + ]: 202 : lockmask = FAST_PATH_GET_BITS(proc, f);
3180 [ - + ]: 202 : if (!lockmask)
5537 rhaas@postgresql.org 3181 :UBC 0 : continue;
5537 rhaas@postgresql.org 3182 :CBC 202 : lockmask <<= FAST_PATH_LOCKNUMBER_OFFSET;
3183 : :
3184 : : /*
3185 : : * There can only be one entry per relation, so if we found it
3186 : : * and it doesn't conflict, we can skip the rest of the slots.
3187 : : */
3188 [ + + ]: 202 : if ((lockmask & conflictMask) == 0)
3189 : 5 : break;
3190 : :
3191 : : /* Conflict! */
3192 : 197 : GET_VXID_FROM_PGPROC(vxid, *proc);
3193 : :
3194 [ + + ]: 197 : if (VirtualTransactionIdIsValid(vxid))
3195 : 196 : vxids[count++] = vxid;
3196 : : /* else, xact already committed or aborted */
3197 : :
3198 : : /* No need to examine remaining slots. */
3199 : 197 : break;
3200 : : }
3201 : :
2262 tgl@sss.pgh.pa.us 3202 : 435 : LWLockRelease(&proc->fpInfoLock);
3203 : : }
3204 : : }
3205 : :
3206 : : /* Remember how many fast-path conflicts we found. */
5537 rhaas@postgresql.org 3207 : 1674 : fast_count = count;
3208 : :
3209 : : /*
3210 : : * Look up the lock object matching the tag.
3211 : : */
7272 tgl@sss.pgh.pa.us 3212 : 1674 : LWLockAcquire(partitionLock, LW_SHARED);
3213 : :
3214 : 1674 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
3215 : : locktag,
3216 : : hashcode,
3217 : : HASH_FIND,
3218 : : NULL);
3219 [ + + ]: 1674 : if (!lock)
3220 : : {
3221 : : /*
3222 : : * If the lock object doesn't exist, there is nothing holding a lock
3223 : : * on this lockable object.
3224 : : */
3225 : 72 : LWLockRelease(partitionLock);
874 heikki.linnakangas@i 3226 : 72 : vxids[count].procNumber = INVALID_PROC_NUMBER;
4195 andres@anarazel.de 3227 : 72 : vxids[count].localTransactionId = InvalidLocalTransactionId;
2671 alvherre@alvh.no-ip. 3228 [ - + ]: 72 : if (countp)
2671 alvherre@alvh.no-ip. 3229 :UBC 0 : *countp = count;
6898 tgl@sss.pgh.pa.us 3230 :CBC 72 : return vxids;
3231 : : }
3232 : :
3233 : : /*
3234 : : * Examine each existing holder (or awaiter) of the lock.
3235 : : */
1284 andres@anarazel.de 3236 [ + - + + ]: 3225 : dlist_foreach(proclock_iter, &lock->procLocks)
3237 : : {
3238 : 1623 : proclock = dlist_container(PROCLOCK, lockLink, proclock_iter.cur);
3239 : :
7272 tgl@sss.pgh.pa.us 3240 [ + + ]: 1623 : if (conflictMask & proclock->holdMask)
3241 : : {
7234 bruce@momjian.us 3242 : 1619 : PGPROC *proc = proclock->tag.myProc;
3243 : :
3244 : : /* A backend never blocks itself */
7272 tgl@sss.pgh.pa.us 3245 [ + + ]: 1619 : if (proc != MyProc)
3246 : : {
3247 : : VirtualTransactionId vxid;
3248 : :
6898 3249 : 21 : GET_VXID_FROM_PGPROC(vxid, *proc);
3250 : :
3251 [ + - ]: 21 : if (VirtualTransactionIdIsValid(vxid))
3252 : : {
3253 : : int i;
3254 : :
3255 : : /* Avoid duplicate entries. */
5537 rhaas@postgresql.org 3256 [ + + ]: 29 : for (i = 0; i < fast_count; ++i)
3257 [ + + + + ]: 9 : if (VirtualTransactionIdEquals(vxids[i], vxid))
3258 : 1 : break;
3259 [ + + ]: 21 : if (i >= fast_count)
3260 : 20 : vxids[count++] = vxid;
3261 : : }
3262 : : /* else, xact already committed or aborted */
3263 : : }
3264 : : }
3265 : : }
3266 : :
7272 tgl@sss.pgh.pa.us 3267 : 1602 : LWLockRelease(partitionLock);
3268 : :
1565 rhaas@postgresql.org 3269 [ - + ]: 1602 : if (count > MaxBackends + max_prepared_xacts) /* should never happen */
6898 tgl@sss.pgh.pa.us 3270 [ # # ]:UBC 0 : elog(PANIC, "too many conflicting locks found");
3271 : :
874 heikki.linnakangas@i 3272 :CBC 1602 : vxids[count].procNumber = INVALID_PROC_NUMBER;
4195 andres@anarazel.de 3273 : 1602 : vxids[count].localTransactionId = InvalidLocalTransactionId;
2671 alvherre@alvh.no-ip. 3274 [ + + ]: 1602 : if (countp)
3275 : 1599 : *countp = count;
6898 tgl@sss.pgh.pa.us 3276 : 1602 : return vxids;
3277 : : }
3278 : :
3279 : : /*
3280 : : * Find a lock in the shared lock table and release it. It is the caller's
3281 : : * responsibility to verify that this is a sane thing to do. (For example, it
3282 : : * would be bad to release a lock here if there might still be a LOCALLOCK
3283 : : * object with pointers to it.)
3284 : : *
3285 : : * We currently use this in two situations: first, to release locks held by
3286 : : * prepared transactions on commit (see lock_twophase_postcommit); and second,
3287 : : * to release locks taken via the fast-path, transferred to the main hash
3288 : : * table, and then released (see LockReleaseAll).
3289 : : */
3290 : : static void
5537 rhaas@postgresql.org 3291 : 2708 : LockRefindAndRelease(LockMethod lockMethodTable, PGPROC *proc,
3292 : : LOCKTAG *locktag, LOCKMODE lockmode,
3293 : : bool decrement_strong_lock_count)
3294 : : {
3295 : : LOCK *lock;
3296 : : PROCLOCK *proclock;
3297 : : PROCLOCKTAG proclocktag;
3298 : : uint32 hashcode;
3299 : : uint32 proclock_hashcode;
3300 : : LWLock *partitionLock;
3301 : : bool wakeupNeeded;
3302 : :
3303 : 2708 : hashcode = LockTagHashCode(locktag);
3304 : 2708 : partitionLock = LockHashPartitionLock(hashcode);
3305 : :
3306 : 2708 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
3307 : :
3308 : : /*
3309 : : * Re-find the lock object (it had better be there).
3310 : : */
3311 : 2708 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
3312 : : locktag,
3313 : : hashcode,
3314 : : HASH_FIND,
3315 : : NULL);
3316 [ - + ]: 2708 : if (!lock)
5537 rhaas@postgresql.org 3317 [ # # ]:UBC 0 : elog(PANIC, "failed to re-find shared lock object");
3318 : :
3319 : : /*
3320 : : * Re-find the proclock object (ditto).
3321 : : */
5537 rhaas@postgresql.org 3322 :CBC 2708 : proclocktag.myLock = lock;
3323 : 2708 : proclocktag.myProc = proc;
3324 : :
3325 : 2708 : proclock_hashcode = ProcLockHashCode(&proclocktag, hashcode);
3326 : :
3327 : 2708 : proclock = (PROCLOCK *) hash_search_with_hash_value(LockMethodProcLockHash,
3328 : : &proclocktag,
3329 : : proclock_hashcode,
3330 : : HASH_FIND,
3331 : : NULL);
3332 [ - + ]: 2708 : if (!proclock)
5537 rhaas@postgresql.org 3333 [ # # ]:UBC 0 : elog(PANIC, "failed to re-find shared proclock object");
3334 : :
3335 : : /*
3336 : : * Double-check that we are actually holding a lock of the type we want to
3337 : : * release.
3338 : : */
5537 rhaas@postgresql.org 3339 [ - + ]:CBC 2708 : if (!(proclock->holdMask & LOCKBIT_ON(lockmode)))
3340 : : {
3341 : : PROCLOCK_PRINT("lock_twophase_postcommit: WRONGTYPE", proclock);
5537 rhaas@postgresql.org 3342 :UBC 0 : LWLockRelease(partitionLock);
3343 [ # # ]: 0 : elog(WARNING, "you don't own a lock of type %s",
3344 : : lockMethodTable->lockModeNames[lockmode]);
3345 : 0 : return;
3346 : : }
3347 : :
3348 : : /*
3349 : : * Do the releasing. CleanUpLock will waken any now-wakable waiters.
3350 : : */
5537 rhaas@postgresql.org 3351 :CBC 2708 : wakeupNeeded = UnGrantLock(lock, lockmode, proclock, lockMethodTable);
3352 : :
3353 : 2708 : CleanUpLock(lock, proclock,
3354 : : lockMethodTable, hashcode,
3355 : : wakeupNeeded);
3356 : :
3357 : 2708 : LWLockRelease(partitionLock);
3358 : :
3359 : : /*
3360 : : * Decrement strong lock count. This logic is needed only for 2PC.
3361 : : */
3362 [ + + ]: 2708 : if (decrement_strong_lock_count
4384 3363 [ + - + + : 852 : && ConflictsWithRelationFastPath(locktag, lockmode))
+ - + + ]
3364 : : {
5158 bruce@momjian.us 3365 : 111 : uint32 fasthashcode = FastPathStrongLockHashPartition(hashcode);
3366 : :
5485 rhaas@postgresql.org 3367 : 111 : SpinLockAcquire(&FastPathStrongRelationLocks->mutex);
4492 3368 [ - + ]: 111 : Assert(FastPathStrongRelationLocks->count[fasthashcode] > 0);
5485 3369 : 111 : FastPathStrongRelationLocks->count[fasthashcode]--;
3370 : 111 : SpinLockRelease(&FastPathStrongRelationLocks->mutex);
3371 : : }
3372 : : }
3373 : :
3374 : : /*
3375 : : * CheckForSessionAndXactLocks
3376 : : * Check to see if transaction holds both session-level and xact-level
3377 : : * locks on the same object; if so, throw an error.
3378 : : *
3379 : : * If we have both session- and transaction-level locks on the same object,
3380 : : * PREPARE TRANSACTION must fail. This should never happen with regular
3381 : : * locks, since we only take those at session level in some special operations
3382 : : * like VACUUM. It's possible to hit this with advisory locks, though.
3383 : : *
3384 : : * It would be nice if we could keep the session hold and give away the
3385 : : * transactional hold to the prepared xact. However, that would require two
3386 : : * PROCLOCK objects, and we cannot be sure that another PROCLOCK will be
3387 : : * available when it comes time for PostPrepare_Locks to do the deed.
3388 : : * So for now, we error out while we can still do so safely.
3389 : : *
3390 : : * Since the LOCALLOCK table stores a separate entry for each lockmode,
3391 : : * we can't implement this check by examining LOCALLOCK entries in isolation.
3392 : : * We must build a transient hashtable that is indexed by locktag only.
3393 : : */
3394 : : static void
1827 tgl@sss.pgh.pa.us 3395 : 299 : CheckForSessionAndXactLocks(void)
3396 : : {
3397 : : typedef struct
3398 : : {
3399 : : LOCKTAG lock; /* identifies the lockable object */
3400 : : bool sessLock; /* is any lockmode held at session level? */
3401 : : bool xactLock; /* is any lockmode held at xact level? */
3402 : : } PerLockTagEntry;
3403 : :
3404 : : HASHCTL hash_ctl;
3405 : : HTAB *lockhtab;
3406 : : HASH_SEQ_STATUS status;
3407 : : LOCALLOCK *locallock;
3408 : :
3409 : : /* Create a local hash table keyed by LOCKTAG only */
3410 : 299 : hash_ctl.keysize = sizeof(LOCKTAG);
3411 : 299 : hash_ctl.entrysize = sizeof(PerLockTagEntry);
3412 : 299 : hash_ctl.hcxt = CurrentMemoryContext;
3413 : :
3414 : 299 : lockhtab = hash_create("CheckForSessionAndXactLocks table",
3415 : : 256, /* arbitrary initial size */
3416 : : &hash_ctl,
3417 : : HASH_ELEM | HASH_BLOBS | HASH_CONTEXT);
3418 : :
3419 : : /* Scan local lock table to find entries for each LOCKTAG */
3420 : 299 : hash_seq_init(&status, LockMethodLocalHash);
3421 : :
3422 [ + + ]: 1138 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
3423 : : {
3424 : 841 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
3425 : : PerLockTagEntry *hentry;
3426 : : bool found;
3427 : : int i;
3428 : :
3429 : : /*
3430 : : * Ignore VXID locks. We don't want those to be held by prepared
3431 : : * transactions, since they aren't meaningful after a restart.
3432 : : */
3433 [ - + ]: 841 : if (locallock->tag.lock.locktag_type == LOCKTAG_VIRTUALTRANSACTION)
1827 tgl@sss.pgh.pa.us 3434 :UBC 0 : continue;
3435 : :
3436 : : /* Ignore it if we don't actually hold the lock */
1827 tgl@sss.pgh.pa.us 3437 [ - + ]:CBC 841 : if (locallock->nLocks <= 0)
1827 tgl@sss.pgh.pa.us 3438 :UBC 0 : continue;
3439 : :
3440 : : /* Otherwise, find or make an entry in lockhtab */
1827 tgl@sss.pgh.pa.us 3441 :CBC 841 : hentry = (PerLockTagEntry *) hash_search(lockhtab,
1265 peter@eisentraut.org 3442 : 841 : &locallock->tag.lock,
3443 : : HASH_ENTER, &found);
1827 tgl@sss.pgh.pa.us 3444 [ + + ]: 841 : if (!found) /* initialize, if newly created */
3445 : 757 : hentry->sessLock = hentry->xactLock = false;
3446 : :
3447 : : /* Scan to see if we hold lock at session or xact level or both */
3448 [ + + ]: 1682 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
3449 : : {
3450 [ + + ]: 841 : if (lockOwners[i].owner == NULL)
3451 : 10 : hentry->sessLock = true;
3452 : : else
3453 : 831 : hentry->xactLock = true;
3454 : : }
3455 : :
3456 : : /*
3457 : : * We can throw error immediately when we see both types of locks; no
3458 : : * need to wait around to see if there are more violations.
3459 : : */
3460 [ + + + + ]: 841 : if (hentry->sessLock && hentry->xactLock)
3461 [ + - ]: 2 : ereport(ERROR,
3462 : : (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3463 : : errmsg("cannot PREPARE while holding both session-level and transaction-level locks on the same object")));
3464 : : }
3465 : :
3466 : : /* Success, so clean up */
3467 : 297 : hash_destroy(lockhtab);
3468 : 297 : }
3469 : :
3470 : : /*
3471 : : * AtPrepare_Locks
3472 : : * Do the preparatory work for a PREPARE: make 2PC state file records
3473 : : * for all locks currently held.
3474 : : *
3475 : : * Session-level locks are ignored, as are VXID locks.
3476 : : *
3477 : : * For the most part, we don't need to touch shared memory for this ---
3478 : : * all the necessary state information is in the locallock table.
3479 : : * Fast-path locks are an exception, however: we move any such locks to
3480 : : * the main table before allowing PREPARE TRANSACTION to succeed.
3481 : : */
3482 : : void
7708 3483 : 299 : AtPrepare_Locks(void)
3484 : : {
3485 : : HASH_SEQ_STATUS status;
3486 : : LOCALLOCK *locallock;
3487 : :
3488 : : /* First, verify there aren't locks of both xact and session level */
1827 3489 : 299 : CheckForSessionAndXactLocks();
3490 : :
3491 : : /* Now do the per-locallock cleanup work */
7533 3492 : 297 : hash_seq_init(&status, LockMethodLocalHash);
3493 : :
7708 3494 [ + + ]: 1132 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
3495 : : {
3496 : : TwoPhaseLockRecord record;
3497 : 835 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
3498 : : bool haveSessionLock;
3499 : : bool haveXactLock;
3500 : : int i;
3501 : :
3502 : : /*
3503 : : * Ignore VXID locks. We don't want those to be held by prepared
3504 : : * transactions, since they aren't meaningful after a restart.
3505 : : */
6898 3506 [ - + ]: 835 : if (locallock->tag.lock.locktag_type == LOCKTAG_VIRTUALTRANSACTION)
3507 : 8 : continue;
3508 : :
3509 : : /* Ignore it if we don't actually hold the lock */
7708 3510 [ - + ]: 835 : if (locallock->nLocks <= 0)
7708 tgl@sss.pgh.pa.us 3511 :UBC 0 : continue;
3512 : :
3513 : : /* Scan to see whether we hold it at session or transaction level */
5195 tgl@sss.pgh.pa.us 3514 :CBC 835 : haveSessionLock = haveXactLock = false;
7708 3515 [ + + ]: 1670 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
3516 : : {
3517 [ + + ]: 835 : if (lockOwners[i].owner == NULL)
5195 3518 : 8 : haveSessionLock = true;
3519 : : else
3520 : 827 : haveXactLock = true;
3521 : : }
3522 : :
3523 : : /* Ignore it if we have only session lock */
3524 [ + + ]: 835 : if (!haveXactLock)
3525 : 8 : continue;
3526 : :
3527 : : /* This can't happen, because we already checked it */
3528 [ - + ]: 827 : if (haveSessionLock)
5195 tgl@sss.pgh.pa.us 3529 [ # # ]:UBC 0 : ereport(ERROR,
3530 : : (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3531 : : errmsg("cannot PREPARE while holding both session-level and transaction-level locks on the same object")));
3532 : :
3533 : : /*
3534 : : * If the local lock was taken via the fast-path, we need to move it
3535 : : * to the primary lock table, or just get a pointer to the existing
3536 : : * primary lock table entry if by chance it's already been
3537 : : * transferred.
3538 : : */
5537 rhaas@postgresql.org 3539 [ + + ]:CBC 827 : if (locallock->proclock == NULL)
3540 : : {
5485 3541 : 321 : locallock->proclock = FastPathGetRelationLockEntry(locallock);
5537 3542 : 321 : locallock->lock = locallock->proclock->tag.myLock;
3543 : : }
3544 : :
3545 : : /*
3546 : : * Arrange to not release any strong lock count held by this lock
3547 : : * entry. We must retain the count until the prepared transaction is
3548 : : * committed or rolled back.
3549 : : */
3265 peter_e@gmx.net 3550 : 827 : locallock->holdsStrongLockCount = false;
3551 : :
3552 : : /*
3553 : : * Create a 2PC record.
3554 : : */
7708 tgl@sss.pgh.pa.us 3555 : 827 : memcpy(&(record.locktag), &(locallock->tag.lock), sizeof(LOCKTAG));
3556 : 827 : record.lockmode = locallock->tag.mode;
3557 : :
3558 : 827 : RegisterTwoPhaseRecord(TWOPHASE_RM_LOCK_ID, 0,
3559 : : &record, sizeof(TwoPhaseLockRecord));
3560 : : }
3561 : 297 : }
3562 : :
3563 : : /*
3564 : : * PostPrepare_Locks
3565 : : * Clean up after successful PREPARE
3566 : : *
3567 : : * Here, we want to transfer ownership of our locks to a dummy PGPROC
3568 : : * that's now associated with the prepared transaction, and we want to
3569 : : * clean out the corresponding entries in the LOCALLOCK table.
3570 : : *
3571 : : * Note: by removing the LOCALLOCK entries, we are leaving dangling
3572 : : * pointers in the transaction's resource owner. This is OK at the
3573 : : * moment since resowner.c doesn't try to free locks retail at a toplevel
3574 : : * transaction commit or abort. We could alternatively zero out nLocks
3575 : : * and leave the LOCALLOCK entries to be garbage-collected by LockReleaseAll,
3576 : : * but that probably costs more cycles.
3577 : : */
3578 : : void
383 michael@paquier.xyz 3579 : 297 : PostPrepare_Locks(FullTransactionId fxid)
3580 : : {
3581 : 297 : PGPROC *newproc = TwoPhaseGetDummyProc(fxid, false);
3582 : : HASH_SEQ_STATUS status;
3583 : : LOCALLOCK *locallock;
3584 : : LOCK *lock;
3585 : : PROCLOCK *proclock;
3586 : : PROCLOCKTAG proclocktag;
3587 : : int partition;
3588 : :
3589 : : /* Can't prepare a lock group follower. */
3821 rhaas@postgresql.org 3590 [ - + - - ]: 297 : Assert(MyProc->lockGroupLeader == NULL ||
3591 : : MyProc->lockGroupLeader == MyProc);
3592 : :
3593 : : /* This is a critical section: any error means big trouble */
7708 tgl@sss.pgh.pa.us 3594 : 297 : START_CRIT_SECTION();
3595 : :
3596 : : /*
3597 : : * First we run through the locallock table and get rid of unwanted
3598 : : * entries, then we scan the process's proclocks and transfer them to the
3599 : : * target proc.
3600 : : *
3601 : : * We do this separately because we may have multiple locallock entries
3602 : : * pointing to the same proclock, and we daren't end up with any dangling
3603 : : * pointers.
3604 : : */
7533 3605 : 297 : hash_seq_init(&status, LockMethodLocalHash);
3606 : :
7708 3607 [ + + ]: 1132 : while ((locallock = (LOCALLOCK *) hash_seq_search(&status)) != NULL)
3608 : : {
5195 3609 : 835 : LOCALLOCKOWNER *lockOwners = locallock->lockOwners;
3610 : : bool haveSessionLock;
3611 : : bool haveXactLock;
3612 : : int i;
3613 : :
7708 3614 [ + - - + ]: 835 : if (locallock->proclock == NULL || locallock->lock == NULL)
3615 : : {
3616 : : /*
3617 : : * We must've run out of shared memory while trying to set up this
3618 : : * lock. Just forget the local entry.
3619 : : */
7708 tgl@sss.pgh.pa.us 3620 [ # # ]:UBC 0 : Assert(locallock->nLocks == 0);
3621 : 0 : RemoveLocalLock(locallock);
3622 : 0 : continue;
3623 : : }
3624 : :
3625 : : /* Ignore VXID locks */
6898 tgl@sss.pgh.pa.us 3626 [ - + ]:CBC 835 : if (locallock->tag.lock.locktag_type == LOCKTAG_VIRTUALTRANSACTION)
6898 tgl@sss.pgh.pa.us 3627 :UBC 0 : continue;
3628 : :
3629 : : /* Scan to see whether we hold it at session or transaction level */
5195 tgl@sss.pgh.pa.us 3630 :CBC 835 : haveSessionLock = haveXactLock = false;
3631 [ + + ]: 1670 : for (i = locallock->numLockOwners - 1; i >= 0; i--)
3632 : : {
3633 [ + + ]: 835 : if (lockOwners[i].owner == NULL)
3634 : 8 : haveSessionLock = true;
3635 : : else
3636 : 827 : haveXactLock = true;
3637 : : }
3638 : :
3639 : : /* Ignore it if we have only session lock */
3640 [ + + ]: 835 : if (!haveXactLock)
3641 : 8 : continue;
3642 : :
3643 : : /* This can't happen, because we already checked it */
3644 [ - + ]: 827 : if (haveSessionLock)
5195 tgl@sss.pgh.pa.us 3645 [ # # ]:UBC 0 : ereport(PANIC,
3646 : : (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3647 : : errmsg("cannot PREPARE while holding both session-level and transaction-level locks on the same object")));
3648 : :
3649 : : /* Mark the proclock to show we need to release this lockmode */
7708 tgl@sss.pgh.pa.us 3650 [ + - ]:CBC 827 : if (locallock->nLocks > 0)
3651 : 827 : locallock->proclock->releaseMask |= LOCKBIT_ON(locallock->tag.mode);
3652 : :
3653 : : /* And remove the locallock hashtable entry */
3654 : 827 : RemoveLocalLock(locallock);
3655 : : }
3656 : :
3657 : : /*
3658 : : * Now, scan each lock partition separately.
3659 : : */
7531 3660 [ + + ]: 5049 : for (partition = 0; partition < NUM_LOCK_PARTITIONS; partition++)
3661 : : {
3662 : : LWLock *partitionLock;
1284 andres@anarazel.de 3663 : 4752 : dlist_head *procLocks = &(MyProc->myProcLocks[partition]);
3664 : : dlist_mutable_iter proclock_iter;
3665 : :
4562 rhaas@postgresql.org 3666 : 4752 : partitionLock = LockHashPartitionLockByIndex(partition);
3667 : :
3668 : : /*
3669 : : * If the proclock list for this partition is empty, we can skip
3670 : : * acquiring the partition lock. This optimization is safer than the
3671 : : * situation in LockReleaseAll, because we got rid of any fast-path
3672 : : * locks during AtPrepare_Locks, so there cannot be any case where
3673 : : * another backend is adding something to our lists now. For safety,
3674 : : * though, we code this the same way as in LockReleaseAll.
3675 : : */
1284 andres@anarazel.de 3676 [ + + ]: 4752 : if (dlist_is_empty(procLocks))
7531 tgl@sss.pgh.pa.us 3677 : 4025 : continue; /* needn't examine this partition */
3678 : :
3679 : 727 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
3680 : :
1284 andres@anarazel.de 3681 [ + - + + ]: 1503 : dlist_foreach_modify(proclock_iter, procLocks)
3682 : : {
3683 : 776 : proclock = dlist_container(PROCLOCK, procLink, proclock_iter.cur);
3684 : :
7307 tgl@sss.pgh.pa.us 3685 [ - + ]: 776 : Assert(proclock->tag.myProc == MyProc);
3686 : :
3687 : 776 : lock = proclock->tag.myLock;
3688 : :
3689 : : /* Ignore VXID locks */
6898 3690 [ + + ]: 776 : if (lock->tag.locktag_type == LOCKTAG_VIRTUALTRANSACTION)
4622 3691 : 23 : continue;
3692 : :
3693 : : PROCLOCK_PRINT("PostPrepare_Locks", proclock);
3694 : : LOCK_PRINT("PostPrepare_Locks", lock, 0);
7531 3695 [ - + ]: 753 : Assert(lock->nRequested >= 0);
3696 [ - + ]: 753 : Assert(lock->nGranted >= 0);
3697 [ - + ]: 753 : Assert(lock->nGranted <= lock->nRequested);
3698 [ - + ]: 753 : Assert((proclock->holdMask & ~lock->grantMask) == 0);
3699 : :
3700 : : /* Ignore it if nothing to release (must be a session lock) */
5195 3701 [ + + ]: 753 : if (proclock->releaseMask == 0)
4622 3702 : 8 : continue;
3703 : :
3704 : : /* Else we should be releasing all locks */
7531 3705 [ - + ]: 745 : if (proclock->releaseMask != proclock->holdMask)
7531 tgl@sss.pgh.pa.us 3706 [ # # ]:UBC 0 : elog(PANIC, "we seem to have dropped a bit somewhere");
3707 : :
3708 : : /*
3709 : : * We cannot simply modify proclock->tag.myProc to reassign
3710 : : * ownership of the lock, because that's part of the hash key and
3711 : : * the proclock would then be in the wrong hash chain. Instead
3712 : : * use hash_update_hash_key. (We used to create a new hash entry,
3713 : : * but that risks out-of-memory failure if other processes are
3714 : : * busy making proclocks too.) We must unlink the proclock from
3715 : : * our procLink chain and put it into the new proc's chain, too.
3716 : : *
3717 : : * Note: the updated proclock hash key will still belong to the
3718 : : * same hash partition, cf proclock_hash(). So the partition lock
3719 : : * we already hold is sufficient for this.
3720 : : */
1284 andres@anarazel.de 3721 :CBC 745 : dlist_delete(&proclock->procLink);
3722 : :
3723 : : /*
3724 : : * Create the new hash key for the proclock.
3725 : : */
7307 tgl@sss.pgh.pa.us 3726 : 745 : proclocktag.myLock = lock;
3727 : 745 : proclocktag.myProc = newproc;
3728 : :
3729 : : /*
3730 : : * Update groupLeader pointer to point to the new proc. (We'd
3731 : : * better not be a member of somebody else's lock group!)
3732 : : */
3821 rhaas@postgresql.org 3733 [ - + ]: 745 : Assert(proclock->groupLeader == proclock->tag.myProc);
3734 : 745 : proclock->groupLeader = newproc;
3735 : :
3736 : : /*
3737 : : * Update the proclock. We should not find any existing entry for
3738 : : * the same hash key, since there can be only one entry for any
3739 : : * given lock with my own proc.
3740 : : */
4941 tgl@sss.pgh.pa.us 3741 [ - + ]: 745 : if (!hash_update_hash_key(LockMethodProcLockHash,
3742 : : proclock,
3743 : : &proclocktag))
4941 tgl@sss.pgh.pa.us 3744 [ # # ]:UBC 0 : elog(PANIC, "duplicate entry found while reassigning a prepared transaction's locks");
3745 : :
3746 : : /* Re-link into the new proc's proclock list */
1284 andres@anarazel.de 3747 :CBC 745 : dlist_push_tail(&newproc->myProcLocks[partition], &proclock->procLink);
3748 : :
3749 : : PROCLOCK_PRINT("PostPrepare_Locks: updated", proclock);
3750 : : } /* loop over PROCLOCKs within this partition */
3751 : :
7531 tgl@sss.pgh.pa.us 3752 : 727 : LWLockRelease(partitionLock);
3753 : : } /* loop over partitions */
3754 : :
7708 3755 [ - + ]: 297 : END_CRIT_SECTION();
3756 : 297 : }
3757 : :
3758 : :
3759 : : /*
3760 : : * GetLockStatusData - Return a summary of the lock manager's internal
3761 : : * status, for use in a user-level reporting function.
3762 : : *
3763 : : * The return data consists of an array of LockInstanceData objects,
3764 : : * which are a lightly abstracted version of the PROCLOCK data structures,
3765 : : * i.e. there is one entry for each unique lock and interested PGPROC.
3766 : : * It is the caller's responsibility to match up related items (such as
3767 : : * references to the same lockable object or PGPROC) if wanted.
3768 : : *
3769 : : * The design goal is to hold the LWLocks for as short a time as possible;
3770 : : * thus, this function simply makes a copy of the necessary data and releases
3771 : : * the locks, allowing the caller to contemplate and format the data for as
3772 : : * long as it pleases.
3773 : : */
3774 : : LockData *
8729 3775 : 297 : GetLockStatusData(void)
3776 : : {
3777 : : LockData *data;
3778 : : PROCLOCK *proclock;
3779 : : HASH_SEQ_STATUS seqstat;
3780 : : int els;
3781 : : int el;
3782 : :
227 michael@paquier.xyz 3783 : 297 : data = palloc_object(LockData);
3784 : :
3785 : : /* Guess how much space we'll need. */
1565 rhaas@postgresql.org 3786 : 297 : els = MaxBackends;
5537 3787 : 297 : el = 0;
227 michael@paquier.xyz 3788 : 297 : data->locks = palloc_array(LockInstanceData, els);
3789 : :
3790 : : /*
3791 : : * First, we iterate through the per-backend fast-path arrays, locking
3792 : : * them one at a time. This might produce an inconsistent picture of the
3793 : : * system state, but taking all of those LWLocks at the same time seems
3794 : : * impractical (in particular, note MAX_SIMUL_LWLOCKS). It shouldn't
3795 : : * matter too much, because none of these locks can be involved in lock
3796 : : * conflicts anyway - anything that might must be present in the main lock
3797 : : * table. (For the same reason, we don't sweat about making leaderPid
3798 : : * completely valid. We cannot safely dereference another backend's
3799 : : * lockGroupLeader field without holding all lock partition locks, and
3800 : : * it's not worth that.)
3801 : : */
14 peter@eisentraut.org 3802 [ + + ]:GNC 44159 : for (uint32 i = 0; i < ProcGlobal->allProcCount; ++i)
3803 : : {
201 drowley@postgresql.o 3804 :CBC 43862 : PGPROC *proc = GetPGProcByNumber(i);
3805 : :
3806 : : /* Skip backends with pid=0, as they don't hold fast-path locks */
638 fujii@postgresql.org 3807 [ + + ]: 43862 : if (proc->pid == 0)
3808 : 39186 : continue;
3809 : :
2262 tgl@sss.pgh.pa.us 3810 : 4676 : LWLockAcquire(&proc->fpInfoLock, LW_SHARED);
3811 : :
638 fujii@postgresql.org 3812 [ + + ]: 42084 : for (uint32 g = 0; g < FastPathLockGroupsPerBackend; g++)
3813 : : {
3814 : : /* Skip groups without registered fast-path locks */
3815 [ + + ]: 37408 : if (proc->fpLockBits[g] == 0)
5537 rhaas@postgresql.org 3816 : 32351 : continue;
3817 : :
638 fujii@postgresql.org 3818 [ + + ]: 85969 : for (int j = 0; j < FP_LOCK_SLOTS_PER_GROUP; j++)
3819 : : {
3820 : : LockInstanceData *instance;
3821 [ - + - + ]: 80912 : uint32 f = FAST_PATH_SLOT(g, j);
3822 [ - + - + ]: 80912 : uint32 lockbits = FAST_PATH_GET_BITS(proc, f);
3823 : :
3824 : : /* Skip unallocated slots */
3825 [ + + ]: 80912 : if (!lockbits)
3826 : 74067 : continue;
3827 : :
3828 [ + + ]: 6845 : if (el >= els)
3829 : : {
3830 : 14 : els += MaxBackends;
3831 : 14 : data->locks = (LockInstanceData *)
3832 : 14 : repalloc(data->locks, sizeof(LockInstanceData) * els);
3833 : : }
3834 : :
3835 : 6845 : instance = &data->locks[el];
3836 : 6845 : SET_LOCKTAG_RELATION(instance->locktag, proc->databaseId,
3837 : : proc->fpRelId[f]);
3838 : 6845 : instance->holdMask = lockbits << FAST_PATH_LOCKNUMBER_OFFSET;
3839 : 6845 : instance->waitLockMode = NoLock;
3840 : 6845 : instance->vxid.procNumber = proc->vxid.procNumber;
3841 : 6845 : instance->vxid.localTransactionId = proc->vxid.lxid;
3842 : 6845 : instance->pid = proc->pid;
3843 : 6845 : instance->leaderPid = proc->pid;
3844 : 6845 : instance->fastpath = true;
3845 : :
3846 : : /*
3847 : : * Successfully taking fast path lock means there were no
3848 : : * conflicting locks.
3849 : : */
3850 : 6845 : instance->waitStart = 0;
3851 : :
3852 : 6845 : el++;
3853 : : }
3854 : : }
3855 : :
5469 rhaas@postgresql.org 3856 [ + + ]: 4676 : if (proc->fpVXIDLock)
3857 : : {
3858 : : VirtualTransactionId vxid;
3859 : : LockInstanceData *instance;
3860 : :
3861 [ + + ]: 1931 : if (el >= els)
3862 : : {
1565 3863 : 10 : els += MaxBackends;
5469 3864 : 10 : data->locks = (LockInstanceData *)
3865 : 10 : repalloc(data->locks, sizeof(LockInstanceData) * els);
3866 : : }
3867 : :
874 heikki.linnakangas@i 3868 : 1931 : vxid.procNumber = proc->vxid.procNumber;
5469 rhaas@postgresql.org 3869 : 1931 : vxid.localTransactionId = proc->fpLocalTransactionId;
3870 : :
3871 : 1931 : instance = &data->locks[el];
3872 : 1931 : SET_LOCKTAG_VIRTUALTRANSACTION(instance->locktag, vxid);
3873 : 1931 : instance->holdMask = LOCKBIT_ON(ExclusiveLock);
3874 : 1931 : instance->waitLockMode = NoLock;
874 heikki.linnakangas@i 3875 : 1931 : instance->vxid.procNumber = proc->vxid.procNumber;
3876 : 1931 : instance->vxid.localTransactionId = proc->vxid.lxid;
5469 rhaas@postgresql.org 3877 : 1931 : instance->pid = proc->pid;
3806 tgl@sss.pgh.pa.us 3878 : 1931 : instance->leaderPid = proc->pid;
5469 rhaas@postgresql.org 3879 : 1931 : instance->fastpath = true;
1986 fujii@postgresql.org 3880 : 1931 : instance->waitStart = 0;
3881 : :
5469 rhaas@postgresql.org 3882 : 1931 : el++;
3883 : : }
3884 : :
2262 tgl@sss.pgh.pa.us 3885 : 4676 : LWLockRelease(&proc->fpInfoLock);
3886 : : }
3887 : :
3888 : : /*
3889 : : * Next, acquire lock on the entire shared lock data structure. We do
3890 : : * this so that, at least for locks in the primary lock table, the state
3891 : : * will be self-consistent.
3892 : : *
3893 : : * Since this is a read-only operation, we take shared instead of
3894 : : * exclusive lock. There's not a whole lot of point to this, because all
3895 : : * the normal operations require exclusive lock, but it doesn't hurt
3896 : : * anything either. It will at least allow two backends to do
3897 : : * GetLockStatusData in parallel.
3898 : : *
3899 : : * Must grab LWLocks in partition-number order to avoid LWLock deadlock.
3900 : : */
14 peter@eisentraut.org 3901 [ + + ]:GNC 5049 : for (int i = 0; i < NUM_LOCK_PARTITIONS; i++)
4562 rhaas@postgresql.org 3902 :CBC 4752 : LWLockAcquire(LockHashPartitionLockByIndex(i), LW_SHARED);
3903 : :
3904 : : /* Now we can safely count the number of proclocks */
5537 3905 : 297 : data->nelements = el + hash_get_num_entries(LockMethodProcLockHash);
3906 [ + + ]: 297 : if (data->nelements > els)
3907 : : {
3908 : 30 : els = data->nelements;
3909 : 30 : data->locks = (LockInstanceData *)
3910 : 30 : repalloc(data->locks, sizeof(LockInstanceData) * els);
3911 : : }
3912 : :
3913 : : /* Now scan the tables to copy the data */
7307 tgl@sss.pgh.pa.us 3914 : 297 : hash_seq_init(&seqstat, LockMethodProcLockHash);
3915 : :
3916 [ + + ]: 4708 : while ((proclock = (PROCLOCK *) hash_seq_search(&seqstat)))
3917 : : {
3918 : 4411 : PGPROC *proc = proclock->tag.myProc;
3919 : 4411 : LOCK *lock = proclock->tag.myLock;
5158 bruce@momjian.us 3920 : 4411 : LockInstanceData *instance = &data->locks[el];
3921 : :
5537 rhaas@postgresql.org 3922 : 4411 : memcpy(&instance->locktag, &lock->tag, sizeof(LOCKTAG));
3923 : 4411 : instance->holdMask = proclock->holdMask;
3924 [ + + ]: 4411 : if (proc->waitLock == proclock->tag.myLock)
3925 : 11 : instance->waitLockMode = proc->waitLockMode;
3926 : : else
3927 : 4400 : instance->waitLockMode = NoLock;
874 heikki.linnakangas@i 3928 : 4411 : instance->vxid.procNumber = proc->vxid.procNumber;
3929 : 4411 : instance->vxid.localTransactionId = proc->vxid.lxid;
5537 rhaas@postgresql.org 3930 : 4411 : instance->pid = proc->pid;
3806 tgl@sss.pgh.pa.us 3931 : 4411 : instance->leaderPid = proclock->groupLeader->pid;
5537 rhaas@postgresql.org 3932 : 4411 : instance->fastpath = false;
1986 fujii@postgresql.org 3933 : 4411 : instance->waitStart = (TimestampTz) pg_atomic_read_u64(&proc->waitStart);
3934 : :
7307 tgl@sss.pgh.pa.us 3935 : 4411 : el++;
3936 : : }
3937 : :
3938 : : /*
3939 : : * And release locks. We do this in reverse order for two reasons: (1)
3940 : : * Anyone else who needs more than one of the locks will be trying to lock
3941 : : * them in increasing order; we don't want to release the other process
3942 : : * until it can get all the locks it needs. (2) This avoids O(N^2)
3943 : : * behavior inside LWLockRelease.
3944 : : */
14 peter@eisentraut.org 3945 [ + + ]:GNC 5049 : for (int i = NUM_LOCK_PARTITIONS; --i >= 0;)
4562 rhaas@postgresql.org 3946 :CBC 4752 : LWLockRelease(LockHashPartitionLockByIndex(i));
3947 : :
7531 tgl@sss.pgh.pa.us 3948 [ - + ]: 297 : Assert(el == data->nelements);
3949 : :
8729 3950 : 297 : return data;
3951 : : }
3952 : :
3953 : : /*
3954 : : * GetBlockerStatusData - Return a summary of the lock manager's state
3955 : : * concerning locks that are blocking the specified PID or any member of
3956 : : * the PID's lock group, for use in a user-level reporting function.
3957 : : *
3958 : : * For each PID within the lock group that is awaiting some heavyweight lock,
3959 : : * the return data includes an array of LockInstanceData objects, which are
3960 : : * the same data structure used by GetLockStatusData; but unlike that function,
3961 : : * this one reports only the PROCLOCKs associated with the lock that that PID
3962 : : * is blocked on. (Hence, all the locktags should be the same for any one
3963 : : * blocked PID.) In addition, we return an array of the PIDs of those backends
3964 : : * that are ahead of the blocked PID in the lock's wait queue. These can be
3965 : : * compared with the PIDs in the LockInstanceData objects to determine which
3966 : : * waiters are ahead of or behind the blocked PID in the queue.
3967 : : *
3968 : : * If blocked_pid isn't a valid backend PID or nothing in its lock group is
3969 : : * waiting on any heavyweight lock, return empty arrays.
3970 : : *
3971 : : * The design goal is to hold the LWLocks for as short a time as possible;
3972 : : * thus, this function simply makes a copy of the necessary data and releases
3973 : : * the locks, allowing the caller to contemplate and format the data for as
3974 : : * long as it pleases.
3975 : : */
3976 : : BlockedProcsData *
3806 3977 : 4124 : GetBlockerStatusData(int blocked_pid)
3978 : : {
3979 : : BlockedProcsData *data;
3980 : : PGPROC *proc;
3981 : : int i;
3982 : :
227 michael@paquier.xyz 3983 : 4124 : data = palloc_object(BlockedProcsData);
3984 : :
3985 : : /*
3986 : : * Guess how much space we'll need, and preallocate. Most of the time
3987 : : * this will avoid needing to do repalloc while holding the LWLocks. (We
3988 : : * assume, but check with an Assert, that MaxBackends is enough entries
3989 : : * for the procs[] array; the other two could need enlargement, though.)
3990 : : */
3806 tgl@sss.pgh.pa.us 3991 : 4124 : data->nprocs = data->nlocks = data->npids = 0;
1565 rhaas@postgresql.org 3992 : 4124 : data->maxprocs = data->maxlocks = data->maxpids = MaxBackends;
227 michael@paquier.xyz 3993 : 4124 : data->procs = palloc_array(BlockedProcData, data->maxprocs);
3994 : 4124 : data->locks = palloc_array(LockInstanceData, data->maxlocks);
3995 : 4124 : data->waiter_pids = palloc_array(int, data->maxpids);
3996 : :
3997 : : /*
3998 : : * In order to search the ProcArray for blocked_pid and assume that that
3999 : : * entry won't immediately disappear under us, we must hold ProcArrayLock.
4000 : : * In addition, to examine the lock grouping fields of any other backend,
4001 : : * we must hold all the hash partition locks. (Only one of those locks is
4002 : : * actually relevant for any one lock group, but we can't know which one
4003 : : * ahead of time.) It's fairly annoying to hold all those locks
4004 : : * throughout this, but it's no worse than GetLockStatusData(), and it
4005 : : * does have the advantage that we're guaranteed to return a
4006 : : * self-consistent instantaneous state.
4007 : : */
3806 tgl@sss.pgh.pa.us 4008 : 4124 : LWLockAcquire(ProcArrayLock, LW_SHARED);
4009 : :
4010 : 4124 : proc = BackendPidGetProcWithLock(blocked_pid);
4011 : :
4012 : : /* Nothing to do if it's gone */
4013 [ + - ]: 4124 : if (proc != NULL)
4014 : : {
4015 : : /*
4016 : : * Acquire lock on the entire shared lock data structure. See notes
4017 : : * in GetLockStatusData().
4018 : : */
4019 [ + + ]: 70108 : for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
4020 : 65984 : LWLockAcquire(LockHashPartitionLockByIndex(i), LW_SHARED);
4021 : :
4022 [ + + ]: 4124 : if (proc->lockGroupLeader == NULL)
4023 : : {
4024 : : /* Easy case, proc is not a lock group member */
4025 : 3806 : GetSingleProcBlockerStatusData(proc, data);
4026 : : }
4027 : : else
4028 : : {
4029 : : /* Examine all procs in proc's lock group */
4030 : : dlist_iter iter;
4031 : :
4032 [ + - + + ]: 765 : dlist_foreach(iter, &proc->lockGroupLeader->lockGroupMembers)
4033 : : {
4034 : : PGPROC *memberProc;
4035 : :
4036 : 447 : memberProc = dlist_container(PGPROC, lockGroupLink, iter.cur);
4037 : 447 : GetSingleProcBlockerStatusData(memberProc, data);
4038 : : }
4039 : : }
4040 : :
4041 : : /*
4042 : : * And release locks. See notes in GetLockStatusData().
4043 : : */
4044 [ + + ]: 70108 : for (i = NUM_LOCK_PARTITIONS; --i >= 0;)
4045 : 65984 : LWLockRelease(LockHashPartitionLockByIndex(i));
4046 : :
4047 [ - + ]: 4124 : Assert(data->nprocs <= data->maxprocs);
4048 : : }
4049 : :
4050 : 4124 : LWLockRelease(ProcArrayLock);
4051 : :
4052 : 4124 : return data;
4053 : : }
4054 : :
4055 : : /* Accumulate data about one possibly-blocked proc for GetBlockerStatusData */
4056 : : static void
4057 : 4253 : GetSingleProcBlockerStatusData(PGPROC *blocked_proc, BlockedProcsData *data)
4058 : : {
4059 : 4253 : LOCK *theLock = blocked_proc->waitLock;
4060 : : BlockedProcData *bproc;
4061 : : dlist_iter proclock_iter;
4062 : : dlist_iter proc_iter;
4063 : : dclist_head *waitQueue;
4064 : : int queue_size;
4065 : :
4066 : : /* Nothing to do if this proc is not blocked */
4067 [ + + ]: 4253 : if (theLock == NULL)
4068 : 2968 : return;
4069 : :
4070 : : /* Set up a procs[] element */
4071 : 1285 : bproc = &data->procs[data->nprocs++];
4072 : 1285 : bproc->pid = blocked_proc->pid;
4073 : 1285 : bproc->first_lock = data->nlocks;
4074 : 1285 : bproc->first_waiter = data->npids;
4075 : :
4076 : : /*
4077 : : * We may ignore the proc's fast-path arrays, since nothing in those could
4078 : : * be related to a contended lock.
4079 : : */
4080 : :
4081 : : /* Collect all PROCLOCKs associated with theLock */
1284 andres@anarazel.de 4082 [ + - + + ]: 3904 : dlist_foreach(proclock_iter, &theLock->procLocks)
4083 : : {
4084 : 2619 : PROCLOCK *proclock =
4085 : 2619 : dlist_container(PROCLOCK, lockLink, proclock_iter.cur);
3806 tgl@sss.pgh.pa.us 4086 : 2619 : PGPROC *proc = proclock->tag.myProc;
4087 : 2619 : LOCK *lock = proclock->tag.myLock;
4088 : : LockInstanceData *instance;
4089 : :
4090 [ - + ]: 2619 : if (data->nlocks >= data->maxlocks)
4091 : : {
1565 rhaas@postgresql.org 4092 :UBC 0 : data->maxlocks += MaxBackends;
3806 tgl@sss.pgh.pa.us 4093 : 0 : data->locks = (LockInstanceData *)
4094 : 0 : repalloc(data->locks, sizeof(LockInstanceData) * data->maxlocks);
4095 : : }
4096 : :
3806 tgl@sss.pgh.pa.us 4097 :CBC 2619 : instance = &data->locks[data->nlocks];
4098 : 2619 : memcpy(&instance->locktag, &lock->tag, sizeof(LOCKTAG));
4099 : 2619 : instance->holdMask = proclock->holdMask;
4100 [ + + ]: 2619 : if (proc->waitLock == lock)
4101 : 1326 : instance->waitLockMode = proc->waitLockMode;
4102 : : else
4103 : 1293 : instance->waitLockMode = NoLock;
874 heikki.linnakangas@i 4104 : 2619 : instance->vxid.procNumber = proc->vxid.procNumber;
4105 : 2619 : instance->vxid.localTransactionId = proc->vxid.lxid;
3806 tgl@sss.pgh.pa.us 4106 : 2619 : instance->pid = proc->pid;
4107 : 2619 : instance->leaderPid = proclock->groupLeader->pid;
4108 : 2619 : instance->fastpath = false;
4109 : 2619 : data->nlocks++;
4110 : : }
4111 : :
4112 : : /* Enlarge waiter_pids[] if it's too small to hold all wait queue PIDs */
4113 : 1285 : waitQueue = &(theLock->waitProcs);
1284 andres@anarazel.de 4114 : 1285 : queue_size = dclist_count(waitQueue);
4115 : :
3806 tgl@sss.pgh.pa.us 4116 [ - + ]: 1285 : if (queue_size > data->maxpids - data->npids)
4117 : : {
1565 rhaas@postgresql.org 4118 :UBC 0 : data->maxpids = Max(data->maxpids + MaxBackends,
4119 : : data->npids + queue_size);
3806 tgl@sss.pgh.pa.us 4120 : 0 : data->waiter_pids = (int *) repalloc(data->waiter_pids,
4121 : 0 : sizeof(int) * data->maxpids);
4122 : : }
4123 : :
4124 : : /* Collect PIDs from the lock's wait queue, stopping at blocked_proc */
1284 andres@anarazel.de 4125 [ + - + - ]:CBC 1305 : dclist_foreach(proc_iter, waitQueue)
4126 : : {
155 heikki.linnakangas@i 4127 : 1305 : PGPROC *queued_proc = dlist_container(PGPROC, waitLink, proc_iter.cur);
4128 : :
1389 drowley@postgresql.o 4129 [ + + ]: 1305 : if (queued_proc == blocked_proc)
3806 tgl@sss.pgh.pa.us 4130 : 1285 : break;
1389 drowley@postgresql.o 4131 : 20 : data->waiter_pids[data->npids++] = queued_proc->pid;
4132 : : }
4133 : :
3806 tgl@sss.pgh.pa.us 4134 : 1285 : bproc->num_locks = data->nlocks - bproc->first_lock;
4135 : 1285 : bproc->num_waiters = data->npids - bproc->first_waiter;
4136 : : }
4137 : :
4138 : : /*
4139 : : * Returns a list of currently held AccessExclusiveLocks, for use by
4140 : : * LogStandbySnapshot(). The result is a palloc'd array,
4141 : : * with the number of elements returned into *nlocks.
4142 : : *
4143 : : * XXX This currently takes a lock on all partitions of the lock table,
4144 : : * but it's possible to do better. By reference counting locks and storing
4145 : : * the value in the ProcArray entry for each backend we could tell if any
4146 : : * locks need recording without having to acquire the partition locks and
4147 : : * scan the lock table. Whether that's worth the additional overhead
4148 : : * is pretty dubious though.
4149 : : */
4150 : : xl_standby_lock *
6062 simon@2ndQuadrant.co 4151 : 1626 : GetRunningTransactionLocks(int *nlocks)
4152 : : {
4153 : : xl_standby_lock *accessExclusiveLocks;
4154 : : PROCLOCK *proclock;
4155 : : HASH_SEQ_STATUS seqstat;
4156 : : int i;
4157 : : int index;
4158 : : int els;
4159 : :
4160 : : /*
4161 : : * Acquire lock on the entire shared lock data structure.
4162 : : *
4163 : : * Must grab LWLocks in partition-number order to avoid LWLock deadlock.
4164 : : */
4165 [ + + ]: 27642 : for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
4562 rhaas@postgresql.org 4166 : 26016 : LWLockAcquire(LockHashPartitionLockByIndex(i), LW_SHARED);
4167 : :
4168 : : /* Now we can safely count the number of proclocks */
6062 simon@2ndQuadrant.co 4169 : 1626 : els = hash_get_num_entries(LockMethodProcLockHash);
4170 : :
4171 : : /*
4172 : : * Allocating enough space for all locks in the lock table is overkill,
4173 : : * but it's more convenient and faster than having to enlarge the array.
4174 : : */
4175 : 1626 : accessExclusiveLocks = palloc(els * sizeof(xl_standby_lock));
4176 : :
4177 : : /* Now scan the tables to copy the data */
4946 tgl@sss.pgh.pa.us 4178 : 1626 : hash_seq_init(&seqstat, LockMethodProcLockHash);
4179 : :
4180 : : /*
4181 : : * If lock is a currently granted AccessExclusiveLock then it will have
4182 : : * just one proclock holder, so locks are never accessed twice in this
4183 : : * particular case. Don't copy this code for use elsewhere because in the
4184 : : * general case this will give you duplicate locks when looking at
4185 : : * non-exclusive lock types.
4186 : : */
6062 simon@2ndQuadrant.co 4187 : 1626 : index = 0;
4188 [ + + ]: 13722 : while ((proclock = (PROCLOCK *) hash_seq_search(&seqstat)))
4189 : : {
4190 : : /* make sure this definition matches the one used in LockAcquire */
4191 [ + + ]: 12096 : if ((proclock->holdMask & LOCKBIT_ON(AccessExclusiveLock)) &&
4192 [ + + ]: 4766 : proclock->tag.myLock->tag.locktag_type == LOCKTAG_RELATION)
4193 : : {
5993 bruce@momjian.us 4194 : 2883 : PGPROC *proc = proclock->tag.myProc;
4195 : 2883 : LOCK *lock = proclock->tag.myLock;
2171 andres@anarazel.de 4196 : 2883 : TransactionId xid = proc->xid;
4197 : :
4198 : : /*
4199 : : * Don't record locks for transactions if we know they have
4200 : : * already issued their WAL record for commit but not yet released
4201 : : * lock. It is still possible that we see locks held by already
4202 : : * complete transactions, if they haven't yet zeroed their xids.
4203 : : */
5297 simon@2ndQuadrant.co 4204 [ + + ]: 2883 : if (!TransactionIdIsValid(xid))
4205 : 4 : continue;
4206 : :
4207 : 2879 : accessExclusiveLocks[index].xid = xid;
5993 bruce@momjian.us 4208 : 2879 : accessExclusiveLocks[index].dbOid = lock->tag.locktag_field1;
6062 simon@2ndQuadrant.co 4209 : 2879 : accessExclusiveLocks[index].relOid = lock->tag.locktag_field2;
4210 : :
4211 : 2879 : index++;
4212 : : }
4213 : : }
4214 : :
4799 tgl@sss.pgh.pa.us 4215 [ - + ]: 1626 : Assert(index <= els);
4216 : :
4217 : : /*
4218 : : * And release locks. We do this in reverse order for two reasons: (1)
4219 : : * Anyone else who needs more than one of the locks will be trying to lock
4220 : : * them in increasing order; we don't want to release the other process
4221 : : * until it can get all the locks it needs. (2) This avoids O(N^2)
4222 : : * behavior inside LWLockRelease.
4223 : : */
6062 simon@2ndQuadrant.co 4224 [ + + ]: 27642 : for (i = NUM_LOCK_PARTITIONS; --i >= 0;)
4562 rhaas@postgresql.org 4225 : 26016 : LWLockRelease(LockHashPartitionLockByIndex(i));
4226 : :
6062 simon@2ndQuadrant.co 4227 : 1626 : *nlocks = index;
4228 : 1626 : return accessExclusiveLocks;
4229 : : }
4230 : :
4231 : : /* Provide the textual name of any lock mode */
4232 : : const char *
7533 tgl@sss.pgh.pa.us 4233 : 16024 : GetLockmodeName(LOCKMETHODID lockmethodid, LOCKMODE mode)
4234 : : {
4235 [ + - - + ]: 16024 : Assert(lockmethodid > 0 && lockmethodid < lengthof(LockMethods));
4236 [ + - - + ]: 16024 : Assert(mode > 0 && mode <= LockMethods[lockmethodid]->numLockModes);
4237 : 16024 : return LockMethods[lockmethodid]->lockModeNames[mode];
4238 : : }
4239 : :
4240 : : #ifdef LOCK_DEBUG
4241 : : /*
4242 : : * Dump all locks in the given proc's myProcLocks lists.
4243 : : *
4244 : : * Caller is responsible for having acquired appropriate LWLocks.
4245 : : */
4246 : : void
4247 : : DumpLocks(PGPROC *proc)
4248 : : {
4249 : : int i;
4250 : :
4251 : : if (proc == NULL)
4252 : : return;
4253 : :
4254 : : if (proc->waitLock)
4255 : : LOCK_PRINT("DumpLocks: waiting on", proc->waitLock, 0);
4256 : :
4257 : : for (i = 0; i < NUM_LOCK_PARTITIONS; i++)
4258 : : {
4259 : : dlist_head *procLocks = &proc->myProcLocks[i];
4260 : : dlist_iter iter;
4261 : :
4262 : : dlist_foreach(iter, procLocks)
4263 : : {
4264 : : PROCLOCK *proclock = dlist_container(PROCLOCK, procLink, iter.cur);
4265 : : LOCK *lock = proclock->tag.myLock;
4266 : :
4267 : : Assert(proclock->tag.myProc == proc);
4268 : : PROCLOCK_PRINT("DumpLocks", proclock);
4269 : : LOCK_PRINT("DumpLocks", lock, 0);
4270 : : }
4271 : : }
4272 : : }
4273 : :
4274 : : /*
4275 : : * Dump all lmgr locks.
4276 : : *
4277 : : * Caller is responsible for having acquired appropriate LWLocks.
4278 : : */
4279 : : void
4280 : : DumpAllLocks(void)
4281 : : {
4282 : : PGPROC *proc;
4283 : : PROCLOCK *proclock;
4284 : : LOCK *lock;
4285 : : HASH_SEQ_STATUS status;
4286 : :
4287 : : proc = MyProc;
4288 : :
4289 : : if (proc && proc->waitLock)
4290 : : LOCK_PRINT("DumpAllLocks: waiting on", proc->waitLock, 0);
4291 : :
4292 : : hash_seq_init(&status, LockMethodProcLockHash);
4293 : :
4294 : : while ((proclock = (PROCLOCK *) hash_seq_search(&status)) != NULL)
4295 : : {
4296 : : PROCLOCK_PRINT("DumpAllLocks", proclock);
4297 : :
4298 : : lock = proclock->tag.myLock;
4299 : : if (lock)
4300 : : LOCK_PRINT("DumpAllLocks", lock, 0);
4301 : : else
4302 : : elog(LOG, "DumpAllLocks: proclock->tag.myLock = NULL");
4303 : : }
4304 : : }
4305 : : #endif /* LOCK_DEBUG */
4306 : :
4307 : : /*
4308 : : * LOCK 2PC resource manager's routines
4309 : : */
4310 : :
4311 : : /*
4312 : : * Re-acquire a lock belonging to a transaction that was prepared.
4313 : : *
4314 : : * Because this function is run at db startup, re-acquiring the locks should
4315 : : * never conflict with running transactions because there are none. We
4316 : : * assume that the lock state represented by the stored 2PC files is legal.
4317 : : *
4318 : : * When switching from Hot Standby mode to normal operation, the locks will
4319 : : * be already held by the startup process. The locks are acquired for the new
4320 : : * procs without checking for conflicts, so we don't get a conflict between the
4321 : : * startup process and the dummy procs, even though we will momentarily have
4322 : : * a situation where two procs are holding the same AccessExclusiveLock,
4323 : : * which isn't normally possible because the conflict. If we're in standby
4324 : : * mode, but a recovery snapshot hasn't been established yet, it's possible
4325 : : * that some but not all of the locks are already held by the startup process.
4326 : : *
4327 : : * This approach is simple, but also a bit dangerous, because if there isn't
4328 : : * enough shared memory to acquire the locks, an error will be thrown, which
4329 : : * is promoted to FATAL and recovery will abort, bringing down postmaster.
4330 : : * A safer approach would be to transfer the locks like we do in
4331 : : * AtPrepare_Locks, but then again, in hot standby mode it's possible for
4332 : : * read-only backends to use up all the shared lock memory anyway, so that
4333 : : * replaying the WAL record that needs to acquire a lock will throw an error
4334 : : * and PANIC anyway.
4335 : : */
4336 : : void
383 michael@paquier.xyz 4337 : 96 : lock_twophase_recover(FullTransactionId fxid, uint16 info,
4338 : : void *recdata, uint32 len)
4339 : : {
7708 tgl@sss.pgh.pa.us 4340 : 96 : TwoPhaseLockRecord *rec = (TwoPhaseLockRecord *) recdata;
383 michael@paquier.xyz 4341 : 96 : PGPROC *proc = TwoPhaseGetDummyProc(fxid, false);
4342 : : LOCKTAG *locktag;
4343 : : LOCKMODE lockmode;
4344 : : LOCKMETHODID lockmethodid;
4345 : : LOCK *lock;
4346 : : PROCLOCK *proclock;
4347 : : PROCLOCKTAG proclocktag;
4348 : : bool found;
4349 : : uint32 hashcode;
4350 : : uint32 proclock_hashcode;
4351 : : int partition;
4352 : : LWLock *partitionLock;
4353 : : LockMethod lockMethodTable;
4354 : :
7708 tgl@sss.pgh.pa.us 4355 [ - + ]: 96 : Assert(len == sizeof(TwoPhaseLockRecord));
4356 : 96 : locktag = &rec->locktag;
4357 : 96 : lockmode = rec->lockmode;
4358 : 96 : lockmethodid = locktag->locktag_lockmethodid;
4359 : :
7533 4360 [ + - - + ]: 96 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7708 tgl@sss.pgh.pa.us 4361 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7533 tgl@sss.pgh.pa.us 4362 :CBC 96 : lockMethodTable = LockMethods[lockmethodid];
4363 : :
7307 4364 : 96 : hashcode = LockTagHashCode(locktag);
4365 : 96 : partition = LockHashPartition(hashcode);
4366 : 96 : partitionLock = LockHashPartitionLock(hashcode);
4367 : :
7531 4368 : 96 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
4369 : :
4370 : : /*
4371 : : * Find or create a lock with this tag.
4372 : : */
7307 4373 : 96 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
4374 : : locktag,
4375 : : hashcode,
4376 : : HASH_ENTER_NULL,
4377 : : &found);
7708 4378 [ - + ]: 96 : if (!lock)
4379 : : {
7531 tgl@sss.pgh.pa.us 4380 :UBC 0 : LWLockRelease(partitionLock);
7708 4381 [ # # ]: 0 : ereport(ERROR,
4382 : : (errcode(ERRCODE_OUT_OF_MEMORY),
4383 : : errmsg("out of shared memory"),
4384 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
4385 : : }
4386 : :
4387 : : /*
4388 : : * if it's a new lock object, initialize it
4389 : : */
7708 tgl@sss.pgh.pa.us 4390 [ + + ]:CBC 96 : if (!found)
4391 : : {
4392 : 84 : lock->grantMask = 0;
4393 : 84 : lock->waitMask = 0;
1284 andres@anarazel.de 4394 : 84 : dlist_init(&lock->procLocks);
4395 : 84 : dclist_init(&lock->waitProcs);
7708 tgl@sss.pgh.pa.us 4396 : 84 : lock->nRequested = 0;
4397 : 84 : lock->nGranted = 0;
4398 [ + - + - : 504 : MemSet(lock->requested, 0, sizeof(int) * MAX_LOCKMODES);
+ - + - +
+ ]
4399 [ - + - - : 84 : MemSet(lock->granted, 0, sizeof(int) * MAX_LOCKMODES);
- - - - -
- ]
4400 : : LOCK_PRINT("lock_twophase_recover: new", lock, lockmode);
4401 : : }
4402 : : else
4403 : : {
4404 : : LOCK_PRINT("lock_twophase_recover: found", lock, lockmode);
4405 [ + - - + ]: 12 : Assert((lock->nRequested >= 0) && (lock->requested[lockmode] >= 0));
4406 [ + - - + ]: 12 : Assert((lock->nGranted >= 0) && (lock->granted[lockmode] >= 0));
4407 [ - + ]: 12 : Assert(lock->nGranted <= lock->nRequested);
4408 : : }
4409 : :
4410 : : /*
4411 : : * Create the hash key for the proclock table.
4412 : : */
7307 4413 : 96 : proclocktag.myLock = lock;
4414 : 96 : proclocktag.myProc = proc;
4415 : :
4416 : 96 : proclock_hashcode = ProcLockHashCode(&proclocktag, hashcode);
4417 : :
4418 : : /*
4419 : : * Find or create a proclock entry with this tag
4420 : : */
4421 : 96 : proclock = (PROCLOCK *) hash_search_with_hash_value(LockMethodProcLockHash,
4422 : : &proclocktag,
4423 : : proclock_hashcode,
4424 : : HASH_ENTER_NULL,
4425 : : &found);
7708 4426 [ - + ]: 96 : if (!proclock)
4427 : : {
4428 : : /* Oops, not enough shmem for the proclock */
7708 tgl@sss.pgh.pa.us 4429 [ # # ]:UBC 0 : if (lock->nRequested == 0)
4430 : : {
4431 : : /*
4432 : : * There are no other requestors of this lock, so garbage-collect
4433 : : * the lock object. We *must* do this to avoid a permanent leak
4434 : : * of shared memory, because there won't be anything to cause
4435 : : * anyone to release the lock object later.
4436 : : */
1284 andres@anarazel.de 4437 [ # # ]: 0 : Assert(dlist_is_empty(&lock->procLocks));
7307 tgl@sss.pgh.pa.us 4438 [ # # ]: 0 : if (!hash_search_with_hash_value(LockMethodLockHash,
1265 peter@eisentraut.org 4439 : 0 : &(lock->tag),
4440 : : hashcode,
4441 : : HASH_REMOVE,
4442 : : NULL))
7708 tgl@sss.pgh.pa.us 4443 [ # # ]: 0 : elog(PANIC, "lock table corrupted");
4444 : : }
7531 4445 : 0 : LWLockRelease(partitionLock);
7708 4446 [ # # ]: 0 : ereport(ERROR,
4447 : : (errcode(ERRCODE_OUT_OF_MEMORY),
4448 : : errmsg("out of shared memory"),
4449 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
4450 : : }
4451 : :
4452 : : /*
4453 : : * If new, initialize the new entry
4454 : : */
7708 tgl@sss.pgh.pa.us 4455 [ + + ]:CBC 96 : if (!found)
4456 : : {
3821 rhaas@postgresql.org 4457 [ - + ]: 88 : Assert(proc->lockGroupLeader == NULL);
4458 : 88 : proclock->groupLeader = proc;
7708 tgl@sss.pgh.pa.us 4459 : 88 : proclock->holdMask = 0;
4460 : 88 : proclock->releaseMask = 0;
4461 : : /* Add proclock to appropriate lists */
1284 andres@anarazel.de 4462 : 88 : dlist_push_tail(&lock->procLocks, &proclock->lockLink);
4463 : 88 : dlist_push_tail(&proc->myProcLocks[partition],
4464 : : &proclock->procLink);
4465 : : PROCLOCK_PRINT("lock_twophase_recover: new", proclock);
4466 : : }
4467 : : else
4468 : : {
4469 : : PROCLOCK_PRINT("lock_twophase_recover: found", proclock);
7708 tgl@sss.pgh.pa.us 4470 [ - + ]: 8 : Assert((proclock->holdMask & ~lock->grantMask) == 0);
4471 : : }
4472 : :
4473 : : /*
4474 : : * lock->nRequested and lock->requested[] count the total number of
4475 : : * requests, whether granted or waiting, so increment those immediately.
4476 : : */
4477 : 96 : lock->nRequested++;
4478 : 96 : lock->requested[lockmode]++;
4479 [ + - - + ]: 96 : Assert((lock->nRequested > 0) && (lock->requested[lockmode] > 0));
4480 : :
4481 : : /*
4482 : : * We shouldn't already hold the desired lock.
4483 : : */
4484 [ - + ]: 96 : if (proclock->holdMask & LOCKBIT_ON(lockmode))
7708 tgl@sss.pgh.pa.us 4485 [ # # ]:UBC 0 : elog(ERROR, "lock %s on object %u/%u/%u is already held",
4486 : : lockMethodTable->lockModeNames[lockmode],
4487 : : lock->tag.locktag_field1, lock->tag.locktag_field2,
4488 : : lock->tag.locktag_field3);
4489 : :
4490 : : /*
4491 : : * We ignore any possible conflicts and just grant ourselves the lock. Not
4492 : : * only because we don't bother, but also to avoid deadlocks when
4493 : : * switching from standby to normal mode. See function comment.
4494 : : */
7708 tgl@sss.pgh.pa.us 4495 :CBC 96 : GrantLock(lock, proclock, lockmode);
4496 : :
4497 : : /*
4498 : : * Bump strong lock count, to make sure any fast-path lock requests won't
4499 : : * be granted without consulting the primary lock table.
4500 : : */
5169 rhaas@postgresql.org 4501 [ + - + + : 96 : if (ConflictsWithRelationFastPath(&lock->tag, lockmode))
+ - + + ]
4502 : : {
5158 bruce@momjian.us 4503 : 18 : uint32 fasthashcode = FastPathStrongLockHashPartition(hashcode);
4504 : :
5485 rhaas@postgresql.org 4505 : 18 : SpinLockAcquire(&FastPathStrongRelationLocks->mutex);
4506 : 18 : FastPathStrongRelationLocks->count[fasthashcode]++;
4507 : 18 : SpinLockRelease(&FastPathStrongRelationLocks->mutex);
4508 : : }
4509 : :
7531 tgl@sss.pgh.pa.us 4510 : 96 : LWLockRelease(partitionLock);
7708 4511 : 96 : }
4512 : :
4513 : : /*
4514 : : * Re-acquire a lock belonging to a transaction that was prepared, when
4515 : : * starting up into hot standby mode.
4516 : : */
4517 : : void
383 michael@paquier.xyz 4518 :UBC 0 : lock_twophase_standby_recover(FullTransactionId fxid, uint16 info,
4519 : : void *recdata, uint32 len)
4520 : : {
6062 simon@2ndQuadrant.co 4521 : 0 : TwoPhaseLockRecord *rec = (TwoPhaseLockRecord *) recdata;
4522 : : LOCKTAG *locktag;
4523 : : LOCKMODE lockmode;
4524 : : LOCKMETHODID lockmethodid;
4525 : :
4526 [ # # ]: 0 : Assert(len == sizeof(TwoPhaseLockRecord));
4527 : 0 : locktag = &rec->locktag;
4528 : 0 : lockmode = rec->lockmode;
4529 : 0 : lockmethodid = locktag->locktag_lockmethodid;
4530 : :
4531 [ # # # # ]: 0 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
4532 [ # # ]: 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
4533 : :
4534 [ # # ]: 0 : if (lockmode == AccessExclusiveLock &&
4535 [ # # ]: 0 : locktag->locktag_type == LOCKTAG_RELATION)
4536 : : {
383 michael@paquier.xyz 4537 : 0 : StandbyAcquireAccessExclusiveLock(XidFromFullTransactionId(fxid),
4538 : : locktag->locktag_field1 /* dboid */ ,
4539 : : locktag->locktag_field2 /* reloid */ );
4540 : : }
6062 simon@2ndQuadrant.co 4541 : 0 : }
4542 : :
4543 : :
4544 : : /*
4545 : : * 2PC processing routine for COMMIT PREPARED case.
4546 : : *
4547 : : * Find and release the lock indicated by the 2PC record.
4548 : : */
4549 : : void
383 michael@paquier.xyz 4550 :CBC 852 : lock_twophase_postcommit(FullTransactionId fxid, uint16 info,
4551 : : void *recdata, uint32 len)
4552 : : {
7708 tgl@sss.pgh.pa.us 4553 : 852 : TwoPhaseLockRecord *rec = (TwoPhaseLockRecord *) recdata;
383 michael@paquier.xyz 4554 : 852 : PGPROC *proc = TwoPhaseGetDummyProc(fxid, true);
4555 : : LOCKTAG *locktag;
4556 : : LOCKMETHODID lockmethodid;
4557 : : LockMethod lockMethodTable;
4558 : :
7708 tgl@sss.pgh.pa.us 4559 [ - + ]: 852 : Assert(len == sizeof(TwoPhaseLockRecord));
4560 : 852 : locktag = &rec->locktag;
4561 : 852 : lockmethodid = locktag->locktag_lockmethodid;
4562 : :
7533 4563 [ + - - + ]: 852 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
7708 tgl@sss.pgh.pa.us 4564 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
7533 tgl@sss.pgh.pa.us 4565 :CBC 852 : lockMethodTable = LockMethods[lockmethodid];
4566 : :
5537 rhaas@postgresql.org 4567 : 852 : LockRefindAndRelease(lockMethodTable, proc, locktag, rec->lockmode, true);
7708 tgl@sss.pgh.pa.us 4568 : 852 : }
4569 : :
4570 : : /*
4571 : : * 2PC processing routine for ROLLBACK PREPARED case.
4572 : : *
4573 : : * This is actually just the same as the COMMIT case.
4574 : : */
4575 : : void
383 michael@paquier.xyz 4576 : 178 : lock_twophase_postabort(FullTransactionId fxid, uint16 info,
4577 : : void *recdata, uint32 len)
4578 : : {
4579 : 178 : lock_twophase_postcommit(fxid, info, recdata, len);
7708 tgl@sss.pgh.pa.us 4580 : 178 : }
4581 : :
4582 : : /*
4583 : : * VirtualXactLockTableInsert
4584 : : *
4585 : : * Take vxid lock via the fast-path. There can't be any pre-existing
4586 : : * lockers, as we haven't advertised this vxid via the ProcArray yet.
4587 : : *
4588 : : * Since MyProc->fpLocalTransactionId will normally contain the same data
4589 : : * as MyProc->vxid.lxid, you might wonder if we really need both. The
4590 : : * difference is that MyProc->vxid.lxid is set and cleared unlocked, and
4591 : : * examined by procarray.c, while fpLocalTransactionId is protected by
4592 : : * fpInfoLock and is used only by the locking subsystem. Doing it this
4593 : : * way makes it easier to verify that there are no funny race conditions.
4594 : : *
4595 : : * We don't bother recording this lock in the local lock table, since it's
4596 : : * only ever released at the end of a transaction. Instead,
4597 : : * LockReleaseAll() calls VirtualXactLockTableCleanup().
4598 : : */
4599 : : void
5469 rhaas@postgresql.org 4600 : 427828 : VirtualXactLockTableInsert(VirtualTransactionId vxid)
4601 : : {
4602 [ - + ]: 427828 : Assert(VirtualTransactionIdIsValid(vxid));
4603 : :
2262 tgl@sss.pgh.pa.us 4604 : 427828 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
4605 : :
874 heikki.linnakangas@i 4606 [ - + ]: 427828 : Assert(MyProc->vxid.procNumber == vxid.procNumber);
5469 rhaas@postgresql.org 4607 [ - + ]: 427828 : Assert(MyProc->fpLocalTransactionId == InvalidLocalTransactionId);
4608 [ - + ]: 427828 : Assert(MyProc->fpVXIDLock == false);
4609 : :
4610 : 427828 : MyProc->fpVXIDLock = true;
4611 : 427828 : MyProc->fpLocalTransactionId = vxid.localTransactionId;
4612 : :
2262 tgl@sss.pgh.pa.us 4613 : 427828 : LWLockRelease(&MyProc->fpInfoLock);
5469 rhaas@postgresql.org 4614 : 427828 : }
4615 : :
4616 : : /*
4617 : : * VirtualXactLockTableCleanup
4618 : : *
4619 : : * Check whether a VXID lock has been materialized; if so, release it,
4620 : : * unblocking waiters.
4621 : : */
4622 : : void
4622 tgl@sss.pgh.pa.us 4623 : 428356 : VirtualXactLockTableCleanup(void)
4624 : : {
4625 : : bool fastpath;
4626 : : LocalTransactionId lxid;
4627 : :
874 heikki.linnakangas@i 4628 [ - + ]: 428356 : Assert(MyProc->vxid.procNumber != INVALID_PROC_NUMBER);
4629 : :
4630 : : /*
4631 : : * Clean up shared memory state.
4632 : : */
2262 tgl@sss.pgh.pa.us 4633 : 428356 : LWLockAcquire(&MyProc->fpInfoLock, LW_EXCLUSIVE);
4634 : :
5469 rhaas@postgresql.org 4635 : 428356 : fastpath = MyProc->fpVXIDLock;
4636 : 428356 : lxid = MyProc->fpLocalTransactionId;
4637 : 428356 : MyProc->fpVXIDLock = false;
4638 : 428356 : MyProc->fpLocalTransactionId = InvalidLocalTransactionId;
4639 : :
2262 tgl@sss.pgh.pa.us 4640 : 428356 : LWLockRelease(&MyProc->fpInfoLock);
4641 : :
4642 : : /*
4643 : : * If fpVXIDLock has been cleared without touching fpLocalTransactionId,
4644 : : * that means someone transferred the lock to the main lock table.
4645 : : */
5469 rhaas@postgresql.org 4646 [ + + + + ]: 428356 : if (!fastpath && LocalTransactionIdIsValid(lxid))
4647 : : {
4648 : : VirtualTransactionId vxid;
4649 : : LOCKTAG locktag;
4650 : :
874 heikki.linnakangas@i 4651 : 300 : vxid.procNumber = MyProcNumber;
5469 rhaas@postgresql.org 4652 : 300 : vxid.localTransactionId = lxid;
4653 : 300 : SET_LOCKTAG_VIRTUALTRANSACTION(locktag, vxid);
4654 : :
4655 : 300 : LockRefindAndRelease(LockMethods[DEFAULT_LOCKMETHOD], MyProc,
4656 : : &locktag, ExclusiveLock, false);
4657 : : }
4658 : 428356 : }
4659 : :
4660 : : /*
4661 : : * XactLockForVirtualXact
4662 : : *
4663 : : * If TransactionIdIsValid(xid), this is essentially XactLockTableWait(xid,
4664 : : * NULL, NULL, XLTW_None) or ConditionalXactLockTableWait(xid). Unlike those
4665 : : * functions, it assumes "xid" is never a subtransaction and that "xid" is
4666 : : * prepared, committed, or aborted.
4667 : : *
4668 : : * If !TransactionIdIsValid(xid), this locks every prepared XID having been
4669 : : * known as "vxid" before its PREPARE TRANSACTION.
4670 : : */
4671 : : static bool
1736 noah@leadboat.com 4672 : 334 : XactLockForVirtualXact(VirtualTransactionId vxid,
4673 : : TransactionId xid, bool wait)
4674 : : {
4675 : 334 : bool more = false;
4676 : :
4677 : : /* There is no point to wait for 2PCs if you have no 2PCs. */
4678 [ + + ]: 334 : if (max_prepared_xacts == 0)
4679 : 139 : return true;
4680 : :
4681 : : do
4682 : : {
4683 : : LockAcquireResult lar;
4684 : : LOCKTAG tag;
4685 : :
4686 : : /* Clear state from previous iterations. */
4687 [ - + ]: 195 : if (more)
4688 : : {
1736 noah@leadboat.com 4689 :UBC 0 : xid = InvalidTransactionId;
4690 : 0 : more = false;
4691 : : }
4692 : :
4693 : : /* If we have no xid, try to find one. */
1736 noah@leadboat.com 4694 [ + + ]:CBC 195 : if (!TransactionIdIsValid(xid))
4695 : 92 : xid = TwoPhaseGetXidByVirtualXID(vxid, &more);
4696 [ + + ]: 195 : if (!TransactionIdIsValid(xid))
4697 : : {
4698 [ - + ]: 81 : Assert(!more);
4699 : 81 : return true;
4700 : : }
4701 : :
4702 : : /* Check or wait for XID completion. */
4703 : 114 : SET_LOCKTAG_TRANSACTION(tag, xid);
4704 : 114 : lar = LockAcquire(&tag, ShareLock, false, !wait);
4705 [ - + ]: 114 : if (lar == LOCKACQUIRE_NOT_AVAIL)
1736 noah@leadboat.com 4706 :UBC 0 : return false;
1736 noah@leadboat.com 4707 :CBC 114 : LockRelease(&tag, ShareLock, false);
4708 [ - + ]: 114 : } while (more);
4709 : :
4710 : 114 : return true;
4711 : : }
4712 : :
4713 : : /*
4714 : : * VirtualXactLock
4715 : : *
4716 : : * If wait = true, wait as long as the given VXID or any XID acquired by the
4717 : : * same transaction is still running. Then, return true.
4718 : : *
4719 : : * If wait = false, just check whether that VXID or one of those XIDs is still
4720 : : * running, and return true or false.
4721 : : */
4722 : : bool
5469 rhaas@postgresql.org 4723 : 394 : VirtualXactLock(VirtualTransactionId vxid, bool wait)
4724 : : {
4725 : : LOCKTAG tag;
4726 : : PGPROC *proc;
1736 noah@leadboat.com 4727 : 394 : TransactionId xid = InvalidTransactionId;
4728 : :
5469 rhaas@postgresql.org 4729 [ - + ]: 394 : Assert(VirtualTransactionIdIsValid(vxid));
4730 : :
1736 noah@leadboat.com 4731 [ + + ]: 394 : if (VirtualTransactionIdIsRecoveredPreparedXact(vxid))
4732 : : /* no vxid lock; localTransactionId is a normal, locked XID */
4733 : 1 : return XactLockForVirtualXact(vxid, vxid.localTransactionId, wait);
4734 : :
5469 rhaas@postgresql.org 4735 : 393 : SET_LOCKTAG_VIRTUALTRANSACTION(tag, vxid);
4736 : :
4737 : : /*
4738 : : * If a lock table entry must be made, this is the PGPROC on whose behalf
4739 : : * it must be done. Note that the transaction might end or the PGPROC
4740 : : * might be reassigned to a new backend before we get around to examining
4741 : : * it, but it doesn't matter. If we find upon examination that the
4742 : : * relevant lxid is no longer running here, that's enough to prove that
4743 : : * it's no longer running anywhere.
4744 : : */
874 heikki.linnakangas@i 4745 : 393 : proc = ProcNumberGetProc(vxid.procNumber);
5401 rhaas@postgresql.org 4746 [ + + ]: 393 : if (proc == NULL)
1736 noah@leadboat.com 4747 : 4 : return XactLockForVirtualXact(vxid, InvalidTransactionId, wait);
4748 : :
4749 : : /*
4750 : : * We must acquire this lock before checking the procNumber and lxid
4751 : : * against the ones we're waiting for. The target backend will only set
4752 : : * or clear lxid while holding this lock.
4753 : : */
2262 tgl@sss.pgh.pa.us 4754 : 389 : LWLockAcquire(&proc->fpInfoLock, LW_EXCLUSIVE);
4755 : :
874 heikki.linnakangas@i 4756 [ + - ]: 389 : if (proc->vxid.procNumber != vxid.procNumber
5469 rhaas@postgresql.org 4757 [ + + ]: 389 : || proc->fpLocalTransactionId != vxid.localTransactionId)
4758 : : {
4759 : : /* VXID ended */
2262 tgl@sss.pgh.pa.us 4760 : 43 : LWLockRelease(&proc->fpInfoLock);
1736 noah@leadboat.com 4761 : 43 : return XactLockForVirtualXact(vxid, InvalidTransactionId, wait);
4762 : : }
4763 : :
4764 : : /*
4765 : : * If we aren't asked to wait, there's no need to set up a lock table
4766 : : * entry. The transaction is still in progress, so just return false.
4767 : : */
5469 rhaas@postgresql.org 4768 [ + + ]: 346 : if (!wait)
4769 : : {
2262 tgl@sss.pgh.pa.us 4770 : 35 : LWLockRelease(&proc->fpInfoLock);
5469 rhaas@postgresql.org 4771 : 35 : return false;
4772 : : }
4773 : :
4774 : : /*
4775 : : * OK, we're going to need to sleep on the VXID. But first, we must set
4776 : : * up the primary lock table entry, if needed (ie, convert the proc's
4777 : : * fast-path lock on its VXID to a regular lock).
4778 : : */
4779 [ + + ]: 311 : if (proc->fpVXIDLock)
4780 : : {
4781 : : PROCLOCK *proclock;
4782 : : uint32 hashcode;
4783 : : LWLock *partitionLock;
4784 : :
4785 : 300 : hashcode = LockTagHashCode(&tag);
4786 : :
4946 tgl@sss.pgh.pa.us 4787 : 300 : partitionLock = LockHashPartitionLock(hashcode);
4788 : 300 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
4789 : :
5469 rhaas@postgresql.org 4790 : 300 : proclock = SetupLockInTable(LockMethods[DEFAULT_LOCKMETHOD], proc,
4791 : : &tag, hashcode, ExclusiveLock);
4792 [ - + ]: 300 : if (!proclock)
4793 : : {
4946 tgl@sss.pgh.pa.us 4794 :UBC 0 : LWLockRelease(partitionLock);
2262 4795 : 0 : LWLockRelease(&proc->fpInfoLock);
5469 rhaas@postgresql.org 4796 [ # # ]: 0 : ereport(ERROR,
4797 : : (errcode(ERRCODE_OUT_OF_MEMORY),
4798 : : errmsg("out of shared memory"),
4799 : : errhint("You might need to increase \"%s\".", "max_locks_per_transaction")));
4800 : : }
5469 rhaas@postgresql.org 4801 :CBC 300 : GrantLock(proclock->tag.myLock, proclock, ExclusiveLock);
4802 : :
4946 tgl@sss.pgh.pa.us 4803 : 300 : LWLockRelease(partitionLock);
4804 : :
5469 rhaas@postgresql.org 4805 : 300 : proc->fpVXIDLock = false;
4806 : : }
4807 : :
4808 : : /*
4809 : : * If the proc has an XID now, we'll avoid a TwoPhaseGetXidByVirtualXID()
4810 : : * search. The proc might have assigned this XID but not yet locked it,
4811 : : * in which case the proc will lock this XID before releasing the VXID.
4812 : : * The fpInfoLock critical section excludes VirtualXactLockTableCleanup(),
4813 : : * so we won't save an XID of a different VXID. It doesn't matter whether
4814 : : * we save this before or after setting up the primary lock table entry.
4815 : : */
1736 noah@leadboat.com 4816 : 311 : xid = proc->xid;
4817 : :
4818 : : /* Done with proc->fpLockBits */
2262 tgl@sss.pgh.pa.us 4819 : 311 : LWLockRelease(&proc->fpInfoLock);
4820 : :
4821 : : /* Time to wait. */
5469 rhaas@postgresql.org 4822 : 311 : (void) LockAcquire(&tag, ShareLock, false, false);
4823 : :
4824 : 286 : LockRelease(&tag, ShareLock, false);
1736 noah@leadboat.com 4825 : 286 : return XactLockForVirtualXact(vxid, xid, wait);
4826 : : }
4827 : :
4828 : : /*
4829 : : * LockWaiterCount
4830 : : *
4831 : : * Find the number of lock requester on this locktag
4832 : : */
4833 : : int
3760 rhaas@postgresql.org 4834 : 91495 : LockWaiterCount(const LOCKTAG *locktag)
4835 : : {
4836 : 91495 : LOCKMETHODID lockmethodid = locktag->locktag_lockmethodid;
4837 : : LOCK *lock;
4838 : : bool found;
4839 : : uint32 hashcode;
4840 : : LWLock *partitionLock;
4841 : 91495 : int waiters = 0;
4842 : :
4843 [ + - - + ]: 91495 : if (lockmethodid <= 0 || lockmethodid >= lengthof(LockMethods))
3760 rhaas@postgresql.org 4844 [ # # ]:UBC 0 : elog(ERROR, "unrecognized lock method: %d", lockmethodid);
4845 : :
3760 rhaas@postgresql.org 4846 :CBC 91495 : hashcode = LockTagHashCode(locktag);
4847 : 91495 : partitionLock = LockHashPartitionLock(hashcode);
4848 : 91495 : LWLockAcquire(partitionLock, LW_EXCLUSIVE);
4849 : :
4850 : 91495 : lock = (LOCK *) hash_search_with_hash_value(LockMethodLockHash,
4851 : : locktag,
4852 : : hashcode,
4853 : : HASH_FIND,
4854 : : &found);
4855 [ + + ]: 91495 : if (found)
4856 : : {
4857 [ - + ]: 7 : Assert(lock != NULL);
4858 : 7 : waiters = lock->nRequested;
4859 : : }
4860 : 91495 : LWLockRelease(partitionLock);
4861 : :
4862 : 91495 : return waiters;
4863 : : }
|