Job composer and "unable to open database file"

Get Help
1

​Hi, everyone –

First time I’ve encountered this. End-user is trying to use job composer, and is encountering error in ood interface. In the ondemand logs for end-user, I’m finding:
SQLite3::CantOpenException: unable to open database file

I lack insight/experience with this. Is someone able to help?

Thanks

2

The file in question is ~/ondemand/data/sys/myjobs/production.sqlite3 (unless you changed the OOD_DATAROOT). I’d check the permissions on said file for that user.

3

I had checked that:
-rw-r–r-- 1 xxxxx yyy 65536 Jun 17 00:50 production.sqlite3

Could a quota lock on the /home filesystem generate this same error?
But then how would signin succeed…??? I need end-user to divulge more details.

Thanks for checking, Jeff

4

Logins could work under a quota lock if everything we need is already there. I.e., no need for OOD to modify any files.

But for a sqlite3 database maybe it’s trying to modify it just by reading it? Maybe some hidden access time table or something.

5

Thanks, Jeff – That’s what we’re currently thinking, too.
Still pending confirmation from our end-user.

Take care.