Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Firefox now holds a lock for places.db during the whole time it is open

dmfigol
dmfigol
more options

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?

Thanks!

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? Thanks!

Modified by dmfigol

All Replies (1)

Roland Tanglao
Roland Tanglao
  • Moderator
more options

Hi dmfigol

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 :-) !

Cheers!

...Roland