sqlite - Why am I getting an sqlite3 error 14 (unable to open database) when calling step on an sqlite3_stmt?

Question

I am experiencing an SQLite error when attempting to step on an sqlite3_stmt. Surprisingly, I got the error 14: unable to open database file.

This is confusing as I opened the database earlier, and successfully submitted an insert into one of the tables. At no point did I close the database.

BEGIN TRANSACTION
INSERT to table A
INSERT to table B
END TRANSACTION

When I attempt to run the second insert command, I get the failure.

Does anyone have any idea of what might cause this issue?

Answer 1

This solution worked for me. chowning the dir to the user opening the db https://www.pantz.org/software/sqlite/unabletoopendbsqliteerror.html