FreeBSD, bootstrapping pkg, "pkg-static: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search"

You can try removing everything in /var/db/pkg/ directory, but the proper solution is to upgrade to supported FreeBSD release (10.4 or 11.2)