Unable to use pkg update after disk filled up

[hhartzer]

I was doing some testing and deliberately filled the disk. Fresh 14.0-RELEASE install. I had used pkg to install a couple of small packages.

After filling the disk, I rebooted. I then deleted the large file and confirmed I have ample space.

I get this error repeatedly during pkg update.

Updating FreeBSD repository catalogue...
Fetching meta.conf: . done
Fetching data.pkg: .......... done
Processing entries: ......
pkg: sqlite error while executing INSERT OR ROLLBACK INTO pkg_annotation(package_id, tag_id, value_id) VALUES (?1, (SELECT annotation_id FROM annotation WHERE annotation=?2), (SELECT annotation_id FROM annotation WHERE annotation=?3)) in file update.c:268: database or disk is full
Processing entries...
pkg: openat(repo groups): No space left on device
pkg: sqlite error while executing ROLLBACK TO SAVEPOINT REPO in file pkgdb.c:1157: no such savepoint: REPO
pkg: sqlite error while executing RELEASE SAVEPOINT REPO in file pkgdb.c:1157: no such savepoint: REPO
Unable to update repository FreeBSD
Error updating repositories!

I assume there's a way to work around this, probably removing the package database. Is there a better method? I'm a little surprised this happened in the first place.

Thank you!