Recently when developing my kernel module I experienced multiple crashes, mostly as a result of giving bad pointer to some kernel function which resulted in random writes to crucial kernel memory. That manifested as kernel crashing at some point of time in the future, locking up the system completely. Well, reboot and no big deal, right? Except when file system data gets corrupted. <\/p>\n\n\n\n
At some point I noticed Firefox acting weirdly. It didn’t remember new visited links and other small issues like that. Moreover when trying to show history it showed up as empty (which does pose a problem as I was trying to find a site I visited), and trying to clear history did nothing either. At this point I was pretty sure something weird was going on as some parts of Firefox clearly remembered history, so I decided to do a check on the SQLite database Oops, no wonder it didn’t work properly. Though apparently Firefox didn’t care much as it said nothing. So I tried to recover and rebuild the database by running:<\/p>\n\n\n\n I did take a look at the generated SQL and everything seemed to be in order. However, when launching Firefox this time around it moved the new After doing some searching on the net I came across this superuser post<\/a> that immediately showed where the issue was: Firefox is using I’m running Firefox 105 so I get:<\/p>\n\n\n\n So I prepended <\/p>\n\n\n\n to And hurray, this time everything worked (except the missing history earlier from the day that has now disappeared from existence.)<\/p>\n","protected":false},"excerpt":{"rendered":" Recently when developing my kernel module I experienced multiple crashes, mostly as a result of giving bad pointer to some kernel function which resulted in random writes to crucial kernel memory. That manifested as kernel crashing at some point of time in the future, locking up the system completely. Well, reboot and no big deal, … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-computers"],"_links":{"self":[{"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":15,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":188,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/posts\/169\/revisions\/188"}],"wp:attachment":[{"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pii.icu\/blog\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}places.sqlite<\/code> that Firefox uses to record history, download, bookmarks and etc. Nowadays Firefox locks the database so when trying to open it Firefox should be closed first (or it also could be copied). <\/p>\n\n\n\n> cd ~\/.mozilla\/firefox\/profile<\/i>\/\n> sqlite3 places.sqlite\nsqlite> PRAGMA integrity_check;\n*** in database main ***\nPage 1040: btreeInitPage() returns error code 11\nPage 1041: btreeInitPage() returns error code 11\nRuntime error: database disk image is malformed (11)<\/code><\/pre>\n\n\n\n> mv places.sqlite places.sqlite.old\n> sqlite3 places.sqlite.old '.recover' > places.sql\n> sqlite3 -init places.sql places.sqlite<\/code><\/pre>\n\n\n\nplaces.sqlite<\/code> to places.sqlite.corrupt<\/code> and generated a new database. So there was still something missing in the places.sql<\/code> that made Firefox reject it, but I couldn’t see anything wrong in the SQL statements.<\/p>\n\n\n\nPRAGMA user_version<\/code> to store a schema version and as it didn’t see a proper version it decided that the database was corrupted. <\/p>\n\n\n\n> sqlite3 places.sqlite.old 'PRAGMA user_version;'\n69<\/code><\/pre>\n\n\n\nPRAGMA user_version = 69;\nPRAGMA journal_mode = truncate;\nPRAGMA page_size = 32768;\nVACUUM;\nPRAGMA journal_mode = wal;\n<\/code><\/pre>\n\n\n\nplaces.sql<\/code> and generated a new SQLite database. <\/p>\n\n\n\n