Firefox now holds a lock for places.db during the whole time it is open
Since the last couple of days, I see that Firefox holds a lock for places.db for the whole time while Firefox is open. The problem manifests itself when I use alfred workflow to do a search for a firefox bookmark by a keyword. I see that the workflow written in Python crashes with
`sqlite3.OperationalError: database is locked`
When I close Firefox, the script is working fine. When I open it again - the script is not operational again. Tried safe mode - the same result.
This was working fine for years and the symptom points that it was changed recently and now Firefox holds a lock during the whole time it is open. I guess previously the database lock was acquired per bookmark write transaction.
FF 63.0 macOS
Is it a known issue? Why was this change made?
Modified by dmfigol
Additional System Details
- User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:63.0) Gecko/20100101 Firefox/63.0
As far as I know this is not a known issue, I suggest filing a bug at bugzilla.mozilla.org and pasting the link here.
My guess is that writing python workflows on Alfred for OS X is something so obscure it won't be prioritized highly (and I doubt that depending on the locking behaviour of a sqlite database is also not common and not something firefox developers ever thought others would care about!). But that's only a guess based on the fact I've never heard of anybody doing this before :-) !