From owner-freebsd-current@FreeBSD.ORG Wed Apr 10 08:09:44 2013 Return-Path: Delivered-To: current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 1CEA4605; Wed, 10 Apr 2013 08:09:44 +0000 (UTC) (envelope-from lars@netapp.com) Received: from mx12.netapp.com (mx12.netapp.com [216.240.18.77]) by mx1.freebsd.org (Postfix) with ESMTP id 03882BDB; Wed, 10 Apr 2013 08:09:43 +0000 (UTC) X-IronPort-AV: E=Sophos;i="4.87,444,1363158000"; d="scan'208";a="39045942" Received: from smtp2.corp.netapp.com ([10.57.159.114]) by mx12-out.netapp.com with ESMTP; 10 Apr 2013 01:09:43 -0700 Received: from vmwexceht02-prd.hq.netapp.com (vmwexceht02-prd.hq.netapp.com [10.106.76.240]) by smtp2.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id r3A89hmZ015906; Wed, 10 Apr 2013 01:09:43 -0700 (PDT) Received: from SACEXCMBX01-PRD.hq.netapp.com ([169.254.2.218]) by vmwexceht02-prd.hq.netapp.com ([10.106.76.240]) with mapi id 14.02.0342.003; Wed, 10 Apr 2013 01:09:43 -0700 From: "Eggert, Lars" To: Baptiste Daroussin Subject: Re: newnfs pkgng database corruption? Thread-Topic: newnfs pkgng database corruption? Thread-Index: AQHONb70L4N2OxTqe06kCtiGiwd7apjPjVcAgAACBgA= Date: Wed, 10 Apr 2013 08:09:42 +0000 Message-ID: <2F60DB6E-768F-426C-9BE6-737B144D4776@netapp.com> References: <4C9A5BAE-8607-4E3A-8E69-E3993EA9873F@netapp.com> <20130410080228.GB74304@ithaqua.etoilebsd.net> In-Reply-To: <20130410080228.GB74304@ithaqua.etoilebsd.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.53.51] Content-Type: text/plain; charset="us-ascii" Content-ID: <360360C344A5434AAACD0B7DC4E246A9@tahoe.netapp.com> Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 Cc: "current@freebsd.org" X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 10 Apr 2013 08:09:44 -0000 Hi, On Apr 10, 2013, at 10:02, Baptiste Daroussin 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=