Corrupted pkg db. Recoverable?

From: Jonathan Adams <jfadams1963_at_proton.me>
Date: Sat, 15 Mar 2025 01:45:50 UTC
Hi all,
  I'm running 14.2-RELEASE-p2 with packages pulled from latest in Qemu running within Termux on an Android device. (I guess I like to create interesting challenges!)

  I recently ran `pkg upgrade`, then selected 'n' to cancel. (Too many packages.) Moments later, I decided to upgrade Vim only, and got this:

# pkg install vim
Updating FreeBSD repository catalogue...
pkg: An error occured while fetching package: No error
pkg: An error occured while fetching package: No error
repository FreeBSD has no meta file, using default settings
pkg: An error occured while fetching package: No error
pkg: An error occured while fetching package: No error
pkg: An error occured while fetching package: No error
pkg: An error occured while fetching package: No error
Unable to update repository FreeBSD
Error updating repositories!

  I'm now unable to install|upgrade packages, though I can do `pkg delete <pkg>` and `pkg autoremove` just fine.
  Is there a way to rebuild the pkg db, or in any way recover the ability to install|upgrade packages? I have backups of the drive images from before I updated to p2, but I'd like to try to fix the current install first.

Thanks much!

- Jonathan
____________________________________________
"Before Turing, things were done to numbers.
After Turing, numbers began doing things"