{"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\/sq\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal","title":{"rendered":"SQLite 3.51.3 me korrigjimin p\u00ebr mund\u00ebsin\u00eb e d\u00ebmtimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb modalitetin WAL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"SQLite 3.51.3 me korrigjimin p\u00ebr mund\u00ebsin\u00eb e d\u00ebmtimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb modalitetin WAL\" src=\"\/wp-content\/uploads\/2026\/03\/3c442654f8b6d86974735255e8214cfe.jpg\" style=\"display:block;margin: 0 auto;\" \/>                              <noindex>      <noindex><\/p>\n<p>M\u00eb 13 mars, u realizua nj\u00eb version korrigjues 3.51.3 t\u00eb databaz\u00ebs kompakte t\u00eb integruar. <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\">SQLite<\/a>. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet si pron\u00eb publike (public domain).<\/p>\n<p><\/noindex><\/noindex> <noindex><\/p>\n<p>N\u00eb lidhje me problemet e nd\u00ebrsjelljes, q\u00eb lidhen me disa funksione t\u00eb reja, versioni <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/releaselog\/3_52_0.html\">3.52.0<\/a> (i dal\u00eb m\u00eb 6 mars) u t\u00ebrhoq.<\/p>\n<p><\/noindex>  <\/p>\n<p>Lista e ndryshimeve p\u00ebr versionin 3.51.3:<\/p>\n<ul>\n<li>M\u00eb 3 mars, nj\u00eb nga zhvilluesit e SQLite (Dan) zbuloi dhe rregulloi nj\u00eb gabim, i cili n\u00eb raste t\u00eb rralla mund t\u00eb \u00e7onte n\u00eb d\u00ebmtimin e databaz\u00ebs dhe quhej <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/wal.html#walresetbug\">\u00abWAL-reset bug\u00bb<\/a>:\n<ul>\n<li>Ky gabim ndodh vet\u00ebm n\u00eb databaza q\u00eb punojn\u00eb n\u00eb modalitetin WAL, n\u00ebse p\u00ebr nj\u00eb sked\u00eb t\u00eb nj\u00ebjt\u00eb jan\u00eb hapur dy ose m\u00eb shum\u00eb lidhje n\u00eb procese ose tela t\u00eb ndryshme, dhe n\u00ebse k\u00ebto dy lidhje p\u00ebrpiqen t\u00eb kryejn\u00eb nj\u00eb shkres\u00eb ose t\u00eb krijojn\u00eb nj\u00eb pik\u00eb kontrolli n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb.<\/li>\n<li>Gabimi lidhet me nj\u00eb konflikt aksesesh n\u00eb t\u00eb dh\u00ebna n\u00ebn kufij t\u00eb fort\u00eb temporal\u00eb. N\u00ebn kushte normale p\u00ebrdorimi, ai ndodh shum\u00eb rrall\u00eb. Zhvilluesit nuk arrit\u00ebn kurr\u00eb ta riprodhonin k\u00ebt\u00eb gabim n\u00eb kushte natyrore dhe duhej t\u00eb shtonin n\u00eb SQLite nj\u00eb logjik\u00eb t\u00eb ve\u00e7ant\u00eb testuese, e cila krijonte me q\u00ebllim kushte p\u00ebr shfaqjen e gabimit, p\u00ebr t'u siguruar se problemi ishte zgjidhur.<\/li>\n<li>Gabimi ndodh kur:\n<ol>\n<li>Nj\u00eb lidhje ekzekuton verifikimin e pik\u00ebs kontrolli. Kjo verifikues e par\u00eb duhet t\u00eb p\u00ebrfundoj\u00eb. Me fjal\u00eb t\u00eb tjera, gjat\u00eb verifikimit duhet t\u00eb kopjohet me sukses t\u00eb gjith\u00eb p\u00ebrmbajtja e sked\u00ebs WAL prapa n\u00eb databaz\u00eb dhe t\u00eb vendoset skeda WAL n\u00eb nj\u00eb gjendje ku mund t\u00eb rivendoset.<\/li>\n<li>Menj\u00ebher\u00eb pas p\u00ebrfundimit t\u00eb veprimit t\u00eb par\u00eb t\u00eb kontrollit, fillon i dyti.<\/li>\n<li>Nd\u00ebrsa fillon pik\u00eb kontrolli e dyt\u00eb nga hapi 2, nj\u00eb lidhje tjet\u00ebr me databaz\u00ebn regjistron nj\u00eb transaksion q\u00eb rivendos sked\u00ebn WAL dhe sh\u00ebnjon p\u00ebrmbajtje t\u00eb re n\u00eb fillim t\u00eb sked\u00ebs WAL.<\/li>\n<li>P\u00ebr shkak t\u00eb konfliktit t\u00eb aksesit n\u00eb t\u00eb dh\u00ebna, pika e dyt\u00eb e kontrollit nga hapi 2 nuk e merr parasysh se skeda WAL \u00ebsht\u00eb rivendosur si rezultat i regjistrimit t\u00eb transaksionit n\u00eb hapin 3. Pika e dyt\u00eb e kontrollit vendos nj\u00eb vler\u00eb t\u00eb gabuar p\u00ebr nj\u00eb nga fushat n\u00eb titullin e indeksit WAL. Kjo fush\u00eb tregon se nj\u00eb pjes\u00eb e sked\u00ebs WAL tashm\u00eb \u00ebsht\u00eb regjistruar n\u00eb pik\u00ebn e kontrollit, kur n\u00eb fakt kjo nuk \u00ebsht\u00eb e v\u00ebrtet\u00eb.<\/li>\n<li>Regjistrimi i transaksioneve t\u00eb tjera \u00e7on n\u00eb rritjen e numrit t\u00eb faqeve n\u00eb sked\u00ebn WAL, e cila kalon numrin e faqeve ekzistues n\u00eb momentin e pik\u00ebs s\u00eb kontrollit t\u00eb par\u00eb nga hapi 1.<\/li>\n<li>M\u00eb von\u00eb, kur shfaqet pik\u00eb kontrolli e tret\u00eb, ajo kalon t\u00ebr\u00eb ose pjes\u00ebrisht transaksionin e regjistruar n\u00eb faz\u00ebn 3. K\u00ebshtu, pjes\u00ebt e transaksionit nga faza 3 nuk arrijn\u00eb kurr\u00eb n\u00eb skedarin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, duke rezultuar n\u00eb d\u00ebmtimin e skedarit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave.<\/li>\n<\/ol>\n<\/li>\n<li>Gabimi \u00ebsht\u00eb me t\u00eb theksuar se \u00ebsht\u00eb i pranish\u00ebm n\u00eb t\u00eb gjitha versionet e SQLite, duke filluar nga 3.7.0 (21.07.2010) dhe duke p\u00ebrfunduar n\u00eb 3.51.2. Jan\u00eb publikuar gjithashtu rregullime p\u00ebr disa versione m\u00eb t\u00eb hershme: <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/863c171b76cd36e0\">3.44.6<\/a> dhe <a rel=\"nofollow\" href=\"https:\/\/sqlite.org\/src\/info\/c7facf7ac58d2cda\">3.50.7<\/a>.<\/li>\n<\/ul>\n<\/li>\n<li>Rregullime t\u00eb tjera t\u00eb vogla.<\/li>\n<\/ul>\n<p>Burimi: <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.2 - 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\/sq\/blog\/news\/sqlite-3-51-3-s-ispravleniem-vozmozhnogo-povrezhdeniya-bazy-dannyh-v-rezhime-wal\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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 me rregullimin e mundsh\u00ebm t\u00eb d\u00ebmtimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb modin WAL | ProHoster","description":".","canonical_url":"https:\/\/prohoster.info\/sq\/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":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/164600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=164600"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/164600\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/164601"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=164600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=164600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=164600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}