{"id":164600,"date":"2026-03-14T11:12:15","date_gmt":"2026-03-14T09:12:15","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal"},"modified":"2026-03-14T11:12:15","modified_gmt":"2026-03-14T09:12:15","slug":"sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal","status":"publish","type":"post","link":"https:\/\/prohoster.info\/da\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal","title":{"rendered":"SQLite 3.51.3 med en rettelse til en potentiel databasebeskadigelse i WAL-tilstand","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"SQLite 3.51.3 med en rettelse til en potentiel databasebeskadigelse i WAL-tilstand\" src=\"\/wp-content\/uploads\/2026\/03\/3c442654f8b6d86974735255e8214cfe.jpg\" style=\"display:block;margin: 0 auto;\" \/>                              <noindex>      <noindex><\/p>\n<p>Den 13. marts blev der udgivet en korrigerende version 3.51.3 af den kompakte indbyggede DBMS <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>. Projektkoden er skrevet i C og distribueres som public domain.<\/p>\n<p><\/noindex><\/noindex> <noindex><\/p>\n<p>P\u00e5 grund af tilbagef\u00f8rselskompatibilitetsproblemer i forbindelse med nogle nye funktioner, blev versionen <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_52_0.html\">3.52.0<\/a> (udgivet den 6. marts) trukket tilbage.<\/p>\n<p><\/noindex>  <\/p>\n<p>\u00c6ndringslisten for version 3.51.3:<\/p>\n<ul>\n<li>Den 3. marts opdagede og rettede en af udviklerne af SQLite (Dan) en fejl, der i sj\u00e6ldne tilf\u00e6lde kunne f\u00f8re til databasebeskadigelse, kaldet <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/wal.html#walresetbug\">\u00abWAL-reset fejl\u00bb<\/a>:\n<ul>\n<li>Denne fejl opst\u00e5r kun i databaser, der k\u00f8rer i WAL-tilstand, hvis der er \u00e5bnet to eller flere forbindelser til den samme fil i forskellige tr\u00e5de eller processer, og hvis disse to forbindelser fors\u00f8ger at udf\u00f8re en skrivning eller oprette et kontrolpunkt samtidig.<\/li>\n<li>Fejlen er relateret til dataadgangskonflikter under strenge tidsbegr\u00e6nsninger. Under normale driftsforhold opst\u00e5r den ekstremt sj\u00e6ldent. Udviklerne har ikke v\u00e6ret i stand til at genskabe denne fejl under naturlige forhold og m\u00e5tte tilf\u00f8je en speciel testlogik til SQLite, der bevidst skaber betingelser for at fremkalde fejlen for at sikre, at problemet er l\u00f8st.<\/li>\n<li>Fejlen opst\u00e5r n\u00e5r:\n<ol>\n<li>En forbindelse udf\u00f8rer en kontrolpunktkontrol. Denne f\u00f8rste kontrol skal v\u00e6re afsluttet. Med andre ord skal hele indholdet af WAL-filen succesfuldt kopieres tilbage til databasen, og WAL-filen skal bringes i en tilstand, hvor den kan nulstilles.<\/li>\n<li>Straks efter afslutningen af den f\u00f8rste kontrolpunkt, startes den anden.<\/li>\n<li>Mens den anden kontrolpunkt fra trin 2 starter, bogf\u00f8rer en anden databaseforbindelse en transaktion, der nulstiller WAL-filen og skriver nyt indhold i begyndelsen af WAL-filen.<\/li>\n<li>P\u00e5 grund af dataadgangskonflikten tager den anden kontrolpunkt fra trin 2 ikke hensyn til, at WAL-filen blev nulstillet som f\u00f8lge af transaktionsbogf\u00f8ringen i trin 3. Den anden kontrolpunkt s\u00e6tter en forkert v\u00e6rdi for et af felterne i WAL-indeksoverskriften. Dette felt angiver, at en del af WAL-filen allerede er blevet bogf\u00f8rt i kontrolpunktet, selvom det faktisk ikke er tilf\u00e6ldet.<\/li>\n<li>Registrering af yderligere transaktioner f\u00f8rer til en stigning i antallet af sider i WAL-filen, som overstiger antallet af sider, der eksisterede p\u00e5 tidspunktet for det f\u00f8rste kontrolpunkt fra trin 1.<\/li>\n<li>Senere, n\u00e5r det tredje kontrolpunkt opst\u00e5r, springer det over hele eller dele af transaktionen, der blev registreret i trin 3. Dermed n\u00e5r dele af transaktionen fra trin 3 ikke ind i databasefilen, hvilket resulterer i, at databasefilen bliver beskadiget.<\/li>\n<\/ol>\n<\/li>\n<li>Fejlen er sandsynligvis til stede i alle versioner af SQLite, fra 3.7.0 (21.07.2010) til 3.51.2. Der er ogs\u00e5 udgivet rettelser for nogle tidligere versioner: <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/863c171b76cd36e0\">3.44.6<\/a> og <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/c7facf7ac58d2cda\">3.50.7<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>Andre mindre rettelser.<\/li>\n<\/ul>\n<p>Kilde: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.linux.org.ru\/news\/opensource\/18241537\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>13-\u0433\u043e \u043c\u0430\u0440\u0442\u0430 \u0441\u043e\u0441\u0442\u043e\u044f\u043b\u0441\u044f \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0439 \u0432\u044b\u043f\u0443\u0441\u043a 3.51.3 \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e\u0439 \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u043e\u0439 \u0421\u0423\u0411\u0414 SQLite. \u041a\u043e\u0434 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 C \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043a\u0430\u043a \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0435 \u0434\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 (public domain). \u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430\u043c\u0438 \u043e\u0431\u0440\u0430\u0442\u043d\u043e\u0439 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u0438, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u043c\u0438 \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043d\u043e\u0432\u044b\u043c\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u044f\u043c\u0438, \u0432\u0435\u0440\u0441\u0438\u044f 3.52.0 (\u0432\u044b\u0448\u0435\u0434\u0448\u0430\u044f 6-\u0433\u043e \u043c\u0430\u0440\u0442\u0430) \u0431\u044b\u043b\u0430 \u043e\u0442\u043e\u0437\u0432\u0430\u043d\u0430. \u0421\u043f\u0438\u0441\u043e\u043a \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432\u0435\u0440\u0441\u0438\u0438 3.51.3: 3-\u0433\u043e \u043c\u0430\u0440\u0442\u0430 \u043e\u0434\u0438\u043d \u0438\u0437 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 SQLite (Dan) \u043e\u0431\u043d\u0430\u0440\u0443\u0436\u0438\u043b \u0438 \u0443\u0441\u0442\u0440\u0430\u043d\u0438\u043b [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":8,"featured_media":164601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-164600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\".\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Erik Peterson\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/da\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47SQLite 3.51.3 \u0441 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0433\u043e \u043f\u043e\u0432\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 WAL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\".\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/da\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-03-14T09:12:15+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-03-14T09:12:15+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47SQLite 3.51.3 med rettelse af mulig databasebeskadigelse i WAL-tilstand | ProHoster","description":".","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47SQLite 3.51.3 \u0441 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0433\u043e \u043f\u043e\u0432\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 WAL | ProHoster","og:description":".","og:url":"https:\/\/prohoster.info\/da\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2026-03-14T09:12:15+00:00","article:modified_time":"2026-03-14T09:12:15+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/164600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=164600"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/164600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media\/164601"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=164600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=164600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=164600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}