Re: newnfs pkgng database corruption?

Hi,

On Apr 10, 2013, at 10:02, Baptiste Daroussin <bapt_at_freebsd.org> wrote:
> This can usually happen when a user do not have the nfs lock system started.
> Are you sure that nfs lock is correctly started?

with NFSv4, the locking system is integrated with the main protocol, it's no 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_at_stanley ~]$ sqlite3 local/db/local.sqlite 
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; 
*** 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 min 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