{"id":49,"date":"2026-10-10T16:36:00","date_gmt":"2026-10-10T16:36:00","guid":{"rendered":"https:\/\/www.akifsen.com.tr\/blog\/2026\/10\/10\/optimistic-locking-lost-update\/"},"modified":"2026-10-10T16:36:00","modified_gmt":"2026-10-10T16:36:00","slug":"optimistic-locking-lost-update","status":"publish","type":"post","link":"https:\/\/www.akifsen.com.tr\/blog\/2026\/10\/10\/optimistic-locking-lost-update\/","title":{"rendered":"Son Yazan Kazan\u0131r Bir Strateji De\u011fildir: Optimistic Locking"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Bir admin paneli d\u00fc\u015f\u00fcn\u00fcn.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ahmet bir \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 g\u00fcncellemek i\u00e7in d\u00fczenleme ekran\u0131n\u0131 a\u00e7\u0131yor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ayn\u0131 anda Zeynep de ayn\u0131 \u00fcr\u00fcn\u00fcn a\u00e7\u0131klamas\u0131n\u0131 d\u00fczeltmek i\u00e7in ekran\u0131 a\u00e7\u0131yor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ahmet fiyat\u0131 de\u011fi\u015ftirip kaydediyor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130ki dakika sonra Zeynep a\u00e7\u0131klamay\u0131 d\u00fczeltip kaydediyor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Zeynep&#8217;in ekran\u0131ndaki form eski fiyat\u0131 i\u00e7erdi\u011fi i\u00e7in, kaydetti\u011fi anda Ahmet&#8217;in fiyat de\u011fi\u015fikli\u011fi sessizce geri al\u0131n\u0131yor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hata yok. Exception yok. Log yok.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sadece kaybolmu\u015f bir de\u011fi\u015fiklik var.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Lost update<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bu probleme lost update deniyor ve veritaban\u0131 transaction&#8217;lar\u0131 tek ba\u015f\u0131na bunu engellemiyor.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c7\u00fcnk\u00fc iki i\u015flem ayn\u0131 transaction i\u00e7inde de\u011fil. Okuma ile yazma aras\u0131nda kullan\u0131c\u0131n\u0131n formu doldurdu\u011fu dakikalar var. Hi\u00e7bir transaction bu kadar uzun s\u00fcre a\u00e7\u0131k tutulmamal\u0131.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Problem veritaban\u0131 seviyesinde de\u011fil, uygulama seviyesinde \u00e7\u00f6z\u00fclmeli.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Version kolonu<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Optimistic locking&#8217;in fikri basit: kayd\u0131 okurken bir version de\u011feri al, yazarken o version&#8217;\u0131n h\u00e2l\u00e2 ge\u00e7erli oldu\u011funu kontrol et.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE products\nSET price = 1299,\n    version = version + 1\nWHERE id = 42\n  AND version = 7;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Etkilenen sat\u0131r say\u0131s\u0131 1 ise g\u00fcncelleme ba\u015far\u0131l\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">0 ise, kay\u0131t bu arada ba\u015fka biri taraf\u0131ndan de\u011fi\u015ftirilmi\u015f demektir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">JPA taraf\u0131nda bu davran\u0131\u015f tek anotasyonla gelir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@Version\nprivate Long version;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Hibernate \u00e7ak\u0131\u015fma durumunda <code>OptimisticLockException<\/code> f\u0131rlat\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Burada \u00f6nemli bir detay var: version de\u011feri client&#8217;a kadar gitmeli ve geri gelmelidir. Form a\u00e7\u0131l\u0131rken okunan version, kay\u0131t iste\u011fiyle birlikte g\u00f6nderilmezse kontrol anlams\u0131zla\u015f\u0131r. Backend kayd\u0131 yeniden okur, en g\u00fcncel version&#8217;\u0131 al\u0131r ve \u00e7ak\u0131\u015fma hi\u00e7 tespit edilmez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">REST API&#8217;lerde bunun standart yolu <code>ETag<\/code> ve <code>If-Match<\/code> header&#8217;lar\u0131d\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GET \/products\/42\nETag: \"7\"\n\nPUT \/products\/42\nIf-Match: \"7\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Version uyu\u015fmazsa sunucu <code>412 Precondition Failed<\/code> d\u00f6ner.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c7ak\u0131\u015fma olunca ne yap\u0131lacak?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Exception yakalamak i\u015fin kolay k\u0131sm\u0131.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kullan\u0131c\u0131ya ne s\u00f6ylenece\u011fi daha zor bir soru.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;Bir hata olu\u015ftu&#8221; mesaj\u0131 yanl\u0131\u015ft\u0131r. Kullan\u0131c\u0131 yeniden dener ve bu sefer ba\u015far\u0131l\u0131 olur, yani Ahmet&#8217;in de\u011fi\u015fikli\u011fini yine ezer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Daha iyi bir deneyim, kayd\u0131n ba\u015fkas\u0131 taraf\u0131ndan de\u011fi\u015ftirildi\u011fini s\u00f6ylemek ve g\u00fcncel hali g\u00f6stermektir. Baz\u0131 uygulamalar alan baz\u0131nda birle\u015ftirme yapabilir: Zeynep sadece a\u00e7\u0131klamay\u0131 de\u011fi\u015ftirdiyse ve Ahmet sadece fiyat\u0131, ikisi de korunabilir.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pessimistic locking ne zaman?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Alternatif yakla\u015f\u0131m kayd\u0131 okurken kilitlemektir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM accounts\nWHERE id = 42\nFOR UPDATE;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Transaction bitene kadar ba\u015fka kimse bu sat\u0131r\u0131 de\u011fi\u015ftiremez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">K\u0131sa s\u00fcren ve \u00e7ak\u0131\u015fman\u0131n s\u0131k oldu\u011fu i\u015flemler i\u00e7in mant\u0131kl\u0131d\u0131r. Bir bakiye d\u00fc\u015fme i\u015flemi, stok azaltma veya s\u0131ra numaras\u0131 \u00fcretme gibi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kullan\u0131c\u0131 etkile\u015fimi i\u00e7eren uzun s\u00fcreli i\u015flemler i\u00e7in ise uygun de\u011fildir. Ekran\u0131 a\u00e7\u0131k b\u0131rak\u0131p \u00f6\u011fle yeme\u011fine \u00e7\u0131kan bir kullan\u0131c\u0131n\u0131n kayd\u0131 saatlerce kilitlemesini istemeyiz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kabaca \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcyorum: \u00e7ak\u0131\u015fma nadirse ve okuma ile yazma aras\u0131nda insan varsa optimistic. \u00c7ak\u0131\u015fma s\u0131ksa ve i\u015flem milisaniyeler s\u00fcr\u00fcyorsa pessimistic.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Atomik g\u00fcncelleme bazen yeterli<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Her e\u015fzamanl\u0131l\u0131k problemi i\u00e7in lock gerekmez.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Stok azaltmak i\u00e7in \u00f6nce okuyup sonra yazmak yerine:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE products\nSET stock = stock - 1\nWHERE id = 42\n  AND stock &gt; 0;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Tek bir atomik sorgu hem kontrol\u00fc hem g\u00fcncellemeyi yapar. Etkilenen sat\u0131r say\u0131s\u0131 s\u0131f\u0131rsa stok kalmam\u0131\u015ft\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Okuma ile yazma aras\u0131na i\u015f mant\u0131\u011f\u0131 girmedi\u011fi s\u00fcrece bu yakla\u015f\u0131m hem en basit hem de en h\u0131zl\u0131 olan\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lost update problemi testlerde neredeyse hi\u00e7 ortaya \u00e7\u0131kmaz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Production&#8217;da ise genellikle bir m\u00fc\u015fteri &#8220;de\u011fi\u015fikli\u011fim kayboldu&#8221; dedi\u011finde fark edilir. O noktada log&#8217;larda da hi\u00e7bir iz bulunmaz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130ki kullan\u0131c\u0131 ayn\u0131 kayd\u0131 ayn\u0131 anda d\u00fczenledi\u011finde biri di\u011ferinin de\u011fi\u015fikli\u011fini fark etmeden siler. Lost update problemi, version kolonu ve pessimistic lock fark\u0131.<\/p>\n","protected":false},"author":1,"featured_media":48,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-49","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani"],"_links":{"self":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":0,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media\/48"}],"wp:attachment":[{"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.akifsen.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}