Date: Wed, 10 Apr 2013 08:09:42 +0000 From: "Eggert, Lars" <lars@netapp.com> To: Baptiste Daroussin <bapt@freebsd.org> Cc: "current@freebsd.org" <current@freebsd.org> Subject: Re: newnfs pkgng database corruption? Message-ID: <2F60DB6E-768F-426C-9BE6-737B144D4776@netapp.com> In-Reply-To: <20130410080228.GB74304@ithaqua.etoilebsd.net> References: <4C9A5BAE-8607-4E3A-8E69-E3993EA9873F@netapp.com> <20130410080228.GB74304@ithaqua.etoilebsd.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, On Apr 10, 2013, at 10:02, Baptiste Daroussin <bapt@freebsd.org> wrote: > This can usually happen when a user do not have the nfs lock system start= ed. > Are you sure that nfs lock is correctly started? with NFSv4, the locking system is integrated with the main protocol, it's n= o longer separate. > If that is the case, there is anyway a bug in pkgng that should catch the > problem and refuse to operate in such situation, I know sqlite to provide= a > mechanism that allow us to be able to catch this, I'm not sure yet to use= it. Not sure about that. In case anyone wonders, the corruption is quite substantial: [elars@stanley ~]$ sqlite3 local/db/local.sqlite=20 SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA integrity_check;=20 *** in database main *** On tree page 1238 cell 17: 2nd reference to page 1237 On tree page 1238 cell 17: Child page depth differs On tree page 1238 cell 18: Child page depth differs On tree page 1241 cell 6: Rowid 17518 out of order (max larger than parent = max of 12550) On tree page 1242 cell 3: Rowid 17566 out of order (max larger than parent = max of 12557) On tree page 1243 cell 6: Rowid 12558 out of order (min less than parent mi= n of 17566) On tree page 2867 cell 28: 2nd reference to page 1241 On tree page 2867 cell 28: Child page depth differs On tree page 2867 cell 29: 2nd reference to page 1242 On tree page 2867 cell 30: Child page depth differs On tree page 1417 cell 66: 2nd reference to page 1239 On tree page 1417 cell 66: Child page depth differs On tree page 1417 cell 67: 2nd reference to page 1240 On tree page 1417 cell 68: Child page depth differs rowid 62 missing from index sqlite_autoindex_packages_1 wrong # of entries in index sqlite_autoindex_packages_1 rowid 96 missing from index scripts_package_id rowid 96 missing from index sqlite_autoindex_scripts_1 rowid 97 missing from index scripts_package_id rowid 97 missing from index sqlite_autoindex_scripts_1 rowid 98 missing from index scripts_package_id rowid 98 missing from index sqlite_autoindex_scripts_1 wrong # of entries in index scripts_package_id wrong # of entries in index sqlite_autoindex_scripts_1 rowid 12509 missing from index sqlite_autoindex_files_1 rowid 12510 missing from index sqlite_autoindex_files_1 rowid 12511 missing from index sqlite_autoindex_files_1 rowid 12512 missing from index sqlite_autoindex_files_1 rowid 86 missing from index files_package_id rowid 86 missing from index sqlite_autoindex_files_1 rowid 87 missing from index files_package_id rowid 87 missing from index sqlite_autoindex_files_1 Error: database disk image is malformed Lars=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2F60DB6E-768F-426C-9BE6-737B144D4776>