Local database is locked

[olivhoenen]

Something I encountered when using a production client 0.15.2 while my local database has been updated from previous tests with develop (0.15.3.dev253)

$ simdb sim list
Error: (sqlite3.OperationalError) database is locked
[SQL: 
CREATE TABLE metadata (
	id INTEGER NOT NULL, 
	sim_id INTEGER, 
	element VARCHAR(250) NOT NULL, 
	value BLOB, 
	PRIMARY KEY (id), 
	FOREIGN KEY(sim_id) REFERENCES simulations (id)
)

]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

$ simdb --version
simdb, version 0.15.2

[olivhoenen]

To replicate, on a new DB (move your ~/.local/share/simdb/sim.db):

(develop) simdb sim list
Local database has not been initialized. Initialize now? [y/n]: y
No simulations found

(0.15.2) simdb sim list
Error: (sqlite3.OperationalError) database is locked
[SQL: 
CREATE TABLE metadata (
	id INTEGER NOT NULL, 
	sim_id INTEGER, 
	element VARCHAR(250) NOT NULL, 
	value BLOB, 
	PRIMARY KEY (id), 
	FOREIGN KEY(sim_id) REFERENCES simulations (id)
)

]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

[Yannicked]

This happens when you downgrade your local client version. In my opinion it's not worth the effort supporting this, given that it is a rare edge case. If you need to revert you can manually restore the database using the backup at ~/.local/share/simdb/backups./*.db

[olivhoenen]

Indeed, just wondering if there is a chance of providing to the user a more insightful message? If not we will need a clear and easy to find information in the documentation.