pkgdb.c:1307 disk I/O error

[eponymous]

Hi all,

OPNSense 21.7.7, brand new install on a brand new mSATA disk. SMART tests passing every night and no other signs of disk issues in SMART data. Memory : 4GB on a Netgate SG-2440 (Intel Atom C2358 Dual Core)

I've noticed the following messages which seem to occur a couple of times a day:

Code Select Expand

config.py[74076]: [<redacted>] Script action stderr returned "b'pkg: sqlite error while executing DROP TABLE repo_update; in file pkgdb.c:2489: attempt to write a readonly database'"

Followed immediately by:

Code Select Expand

config.py[74076]: [<redacted>] Script action stderr returned "b'pkg: sqlite error while executing RELEASE SAVEPOINT REPO in file pkgdb.c:1307 disk I/O error'"

I was initially worried by the "disk I/O error" message, but as I say, this is a brand new Micron mSATA disk which is passing all SMART tests and doesn't show any other issues that it might be failing. I suspect the disk I/O error message is related to the attempt to write to a read-only database but can't be sure.

Any ideas on what's causing this?

[eponymous]

Not sure if this is relevant or not:

https://stackoverflow.com/questions/9993555/disk-i-o-error-with-sqlite

"When the database file isn't writable, you get a "readonly database" error. When it's writable, but the journal file is not, you get "I/O error" instead."