Error: database disk image is malformed

[Paul Beard]

Is there a fix for this? 

sqlite> pragma integrity_check;
row 1511 missing from index deps_unique
row 1 missing from index pkg_shlibs_provided_package_id
row 1 missing from index pkg_shlibs_required_package_id
row 1 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 2 missing from index pkg_shlibs_required_package_id
row 2 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 3 missing from index pkg_shlibs_required_package_id
row 3 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 4 missing from index pkg_shlibs_required_package_id
row 4 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 5 missing from index pkg_shlibs_required_package_id
row 5 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 6 missing from index pkg_shlibs_required_package_id
row 6 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 7 missing from index pkg_shlibs_required_package_id
row 7 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 8 missing from index pkg_shlibs_required_package_id
row 8 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 9 missing from index pkg_shlibs_required_package_id
row 9 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 10 missing from index pkg_shlibs_required_package_id
row 10 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 11 missing from index pkg_shlibs_required_package_id
row 11 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 12 missing from index pkg_shlibs_required_package_id
row 12 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 13 missing from index pkg_shlibs_required_package_id
row 13 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 14 missing from index pkg_shlibs_required_package_id
row 14 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 15 missing from index pkg_shlibs_required_package_id
row 15 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 16 missing from index pkg_shlibs_required_package_id
row 16 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 17 missing from index pkg_shlibs_required_package_id
row 17 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 18 missing from index pkg_shlibs_required_package_id
row 18 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 19 missing from index pkg_shlibs_required_package_id
row 19 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 20 missing from index pkg_shlibs_required_package_id
row 20 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 21 missing from index pkg_shlibs_required_package_id
row 21 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 22 missing from index pkg_shlibs_required_package_id
row 22 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 23 missing from index pkg_shlibs_required_package_id
row 23 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 24 missing from index pkg_shlibs_required_package_id
row 24 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 25 missing from index pkg_shlibs_required_package_id
row 25 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 26 missing from index pkg_shlibs_required_package_id
row 26 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 27 missing from index pkg_shlibs_required_package_id
row 27 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 28 missing from index pkg_shlibs_required_package_id
row 28 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 29 missing from index pkg_shlibs_required_package_id
row 29 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 30 missing from index pkg_shlibs_required_package_id
row 30 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 31 missing from index pkg_shlibs_required_package_id
row 31 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 32 missing from index pkg_shlibs_required_package_id
row 32 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 33 missing from index pkg_shlibs_required_package_id
row 33 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 34 missing from index pkg_shlibs_required_package_id
row 34 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 35 missing from index pkg_shlibs_required_package_id
row 35 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 36 missing from index pkg_shlibs_required_package_id
row 36 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 37 missing from index pkg_shlibs_required_package_id
row 37 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 38 missing from index pkg_shlibs_required_package_id
row 38 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 39 missing from index pkg_shlibs_required_package_id
row 39 missing from index sqlite_autoindex_pkg_shlibs_required_1
row 40 missing from index pkg_shlibs_required_package_id
row 40 missing from index sqlite_autoindex_pkg_shlibs_required_1
wrong # of entries in index pkg_shlibs_required_package_id
wrong # of entries in index sqlite_autoindex_pkg_shlibs_required_1
Error: database disk image is malformed

Worst case, what is the regex to break out the port name so I can rebuild from the output of `pkg info | cut -d" " -f1`? Hard to work out to match everything up to the last hyphen…