Error with pkg regen : Can't copy sqlports to memory

[lcheylus]

On OpenBSD 7.1-current (amd64), with the last version of your pkg tool, I have an error with I try to regen DB :

$ pkg regen
Creating full text database...DBD::SQLite::db sqlite_backup_to_file failed: 
sqlite_backup_to_file failed with error not an error at /usr/local/sbin/pkg line 87.
Can't copy sqlports to memory! at /usr/local/sbin/pkg line 87.

This error occurred after i updated my packages with pkg_add -u : sqlports-7.36p0

[qbit]

I have noticed a few situations where it gets into a strange state.

• running as root before the /tmp/sqlports.ts db exists (it's then owned by root).
• randomly for reasons I haven't tracked down yet.

I was planning on re-working the way the commands are parsed. Hopefully I have some time this week!

[lcheylus]

After upgrade (sysupgrade for OpenBSD 7.1-current and pkg_add -u), this issue is gone. Version for sqlports is still 7.36p0