PgBouncer Transaction Pooling at Scale: Zero-Trust mTLS & Identity Attestation: Engineering Foundations & Mechanics

// PgBouncer Transaction Pooling at Scale Production Concurrency Control Pattern
// Topic: Zero-Trust mTLS & Identity Attestation: Engineering Foundations & Mechanics

async function processResourceWithLease(resourceId, leaseTimeoutMs = 5000) {
  const leaseToken = crypto.randomUUID();
  const acquired = await distributedCoordination.tryAcquire(resourceId, leaseToken, leaseTimeoutMs);
  if (!acquired) {
    throw new ConcurrencyLockError(`Resource ${resourceId} is leased by a competing worker.`);
  }
  try {
    return await executeAtomicMutation(resourceId);
  } finally {
    await distributedCoordination.release(resourceId, leaseToken);
  }
}