ReadMeFeed / Community knowledge

#optimistic-locking

Real questions. Useful conversations. Find the people who know your stack.

ArticleNew0 replies2,011 followingPosted 10 Nov 2026, 22:11 UTC146.6K views2,433 votes

Yii 2 ActiveRecord Optimistic Locking: Configuration and Limits

Enable Yii 2 ActiveRecord optimistic locking with a version column, handle StaleObjectException, and understand its limits for concurrent updates.

Community & Careers · Guide

concurrency-control

Community & Careers

Article0 replies2,657 followingPosted 04 Jul 2026, 05:35 UTC84.3K views2,500 votes

Preventing Lost Updates with Doctrine Optimistic Locking

Prevent data loss in concurrent environments using Doctrine ORM's optimistic locking. Learn to implement @Version, handle lock exceptions, and identify when to switch to pessimistic locking.

Community & Careers · Guide

doctrine-orm optimistic-locking concurrency

Community & Careers

Article0 replies3,317 followingPosted 03 Sept 2025, 21:47 UTC73.9K views3,636 votes

Stop Silent Overwrites: Optimistic Locking in Yii 2 ActiveRecord

Yii 2 ActiveRecord optimistic locking prevents lost updates by adding a version column, exposing it in the form, and catching StaleObjectException as a user‑facing conflict.

Community & Careers · Blog

yii-2 optimistic-locking concurrency

Community & Careers

Article0 replies3,058 followingPosted 15 Oct 2025, 12:36 UTC76.2K views1,676 votes

Implement Optimistic Concurrency with SQL Server rowversion in EF Core

Prevent silent lost updates in EF Core by adding a SQL Server rowversion concurrency token. This guide covers entity configuration, migration, conflict handling for connected and disconnected scenarios, and verification steps.

Community & Careers · Guide

entityframeworkcore optimistic-locking entity-framework-core

Community & Careers

Question1 answer3,884 followingPosted 14 Mar 2026, 17:39 UTC124.3K views2,451 votes

owner answered

Sketch 93 optimistic locking: symbol merge conflicts blocking concurrent edits on shared Cloud documents

Our team collaborates on a shared Sketch Cloud document with a large symbol library. Since moving to Sketch 93, which introduced optimistic locking for symbol instances, we occasionally hit merge conflicts that require manual resolution when two editors touch the same page at once. The document was originally created in a pre-2018 .sketch format and later mi

Community & Careers · Editorial question

optimistic-locking sketch-cloud concurrent-editing

Community & Careers

Question1 answer1 comment3,099 followingPosted 14 Sept 2023, 10:51 UTC33.6K views2,002 votes

owner answered

Sulu optimistic locking version column returns 409 Conflict on retried content writes

Goal Determine whether a retried Sulu content write can succeed after an optimistic-locking conflict without creating duplicate entries. Constraints Sulu content nodes use optimistic locking through a version column. A version mismatch produces a 409 Conflict response from the API layer. It is unclear whether the platform provides a built-in idempotency key

Community & Careers · Editorial question

content-api optimistic-locking idempotency

Community & Careers

Question1 answer512 followingPosted 20 Nov 2022, 03:06 UTC121.3K views3,646 votes

owner answered

If-Match ETag Precondition vs Body Version Validation for Confluence REST Write Retries

When an integration retries a Confluence REST write after a timeout, the goal is to avoid creating duplicate pages or applying the same version increment twice. Two documented optimistic concurrency controls address this constraint with different failure modes. The first uses ETag headers returned on content resources. A retry sends the captured ETag in an I

Community & Careers · Editorial question

optimistic-locking rest-api etag

Community & Careers

Question1 answer1 comment1,940 followingPosted 04 Sept 2022, 09:37 UTC121K views3,341 votes

owner answered

Ecto.Repo.update_all/3 does not raise Ecto.StaleEntryError on locked rows

A schema uses an integer lock column for Ecto optimistic locking, so Repo.update/3 increments the value and raises Ecto.StaleEntryError when the stored lock no longer matches the changeset. The goal is to determine whether Repo.update_all/3 can overwrite such a row without incrementing lock or surfacing a conflict, and whether that behavior is consistent acr

Community & Careers · Editorial question

optimistic-locking update-all stale-entry-error