Musi wa13 Kurume, kuburitswa kwe3.51.3 yecompact embedded DBMS kwakaburitswa. SQLiteKodhi yepurojekiti yakanyorwa neC uye inogoverwa pachena.
Nekuda kwematambudziko ekuenderana nekumashure nemamwe maficha matsva, shanduro 3.52.0 (yakaburitswa musi wa6 Kurume) yakabviswa.
Rondedzero yeshanduko mushanduro 3.51.3:
- Musi wa3 Kurume, mumwe wevagadziri veSQLite (Dan) akawana ndokugadzirisa bug iyo, mune zvisingawanzoitiki, yaigona kukonzera kuora kwedatabase uye inonzi Chikanganiso chekugadzirisazve WAL:
- Kukanganisa uku kunoitika chete mumadhatabhesi ari kushanda muWAL mode kana maviri kana anopfuura akavhurika kune faira rimwe chete mumitsetse yakasiyana kana maitiro, uye kana maviri acho akaedza kunyora kana kugadzira checkpoint panguva imwe chete.
- Chikanganiso ichi chine chekuita nekusawirirana kwekuwana data pasi penguva yakatarwa. Mumamiriro ekushanda akajairwa, hazviwanzoitiki. Vagadziri vemapurogiramu havana kukwanisa kuburitsazve chikanganiso ichi vari musango, uye vakamanikidzwa kuwedzera logic yekuyedza kuSQLite iyo inogadzira nemaune mamiriro ekuti chikanganiso chigadziriswe kuitira kuti dambudziko rigadziriswe.
- Chikanganiso chinoitika kana:
- Imwe connection inoita checkpoint. Iyi checkpoint yekutanga inofanira kupedzwa. Nemamwe mashoko, checkpoint inofanira kukopa zvese zviri muWAL file kudzokera kudatabase uye kudzosa WAL file kune mamiriro anobvumidza kuti itsvedzwe.
- Pakarepo mushure mekunge nzvimbo yekutanga yapera, yechipiri inotangwa.
- Panguva iyo checkpoint yechipiri kubva padanho rechipiri iri kushanda, imwe dhatabhesi yekubatanidza inoita transaction inobvisa faira reWAL uye inonyora zvirimo zvitsva pakutanga kwefaira reWAL.
- Nekuda kwekupesana kwekuwana data, nzvimbo yechipiri yekutarisa kubva padanho rechipiri haifungi kuti faira reWAL rakabviswa nekuda kwekuita kwekutengeserana mudanho rechitatu. Nzvimbo yechipiri yekutarisa inoisa kukosha kusina kururama kune imwe yeminda iri muWAL index header. Iyi nzvimbo inoratidza kuti chikamu chefaira reWAL chakanga chatoitwa panzvimbo yekutarisa, kunyangwe hazvo izvi zvisiri izvo.
- Kuita mamwe mabasa ekuwedzera kunoita kuti huwandu hwemapeji ari mufaira reWAL huwedzere kupfuura huwandu hwemapeji aivapo panguva yekutarisa kwekutanga padanho rekutanga.
- Gare gare, kana nzvimbo yekutarisa yechitatu yaitika, inodarika zvese kana chikamu chekutengeserana kwakanyorwa muchikamu chechitatu. Saka, zvikamu zvekutengeserana kubva pachikamu chechitatu hazvimbofi zvakapinda mufaira redhatabhesi, zvichikonzera kuora kwefaira redhatabhesi.
- Chikanganiso ichi chinoratidzika kunge chiripo mushanduro dzese dzeSQLite, kutanga ne3.7.0 (2010-07-21) uye kupera ne3.51.2. Hotfixes dzakaburitswawo kune dzimwe shanduro dzekare: 3.44.6 и 3.50.7.
- Zvimwe zvigadziriso zvidiki.
Source: linux.org.ru
