Avatar for Username

Поиск в Поддержке

Избегайте мошенников, выдающих себя за службу поддержки. Мы никогда не попросим вас позвонить, отправить текстовое сообщение или поделиться личной информацией. Сообщайте о подозрительной активности, используя функцию «Пожаловаться».

Learn More

Эта тема была архивирована. Если вам нужна помощь, задайте новый вопрос.

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

  • 1 ответ
  • 1 имеет эту проблему
  • 25 просмотров
  • Последний ответ от 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!

Изменено dmfigol

Все ответы (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