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

Cuireadh an snáithe seo sa chartlann. Cuir ceist nua má tá cabhair uait.

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

  • 1 freagra
  • 1 leis an bhfadhb seo
  • 24 views
  • Freagra is déanaí ó Roland Tanglao

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!

Athraithe ag dmfigol ar

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