Avatar for Username

Tìm kiếm hỗ trợ

Tránh các lừa đảo về hỗ trợ. Chúng tôi sẽ không bao giờ yêu cầu bạn gọi hoặc nhắn tin đến số điện thoại hoặc chia sẻ thông tin cá nhân. Vui lòng báo cáo hoạt động đáng ngờ bằng cách sử dụng tùy chọn "Báo cáo lạm dụng".

Learn More

Chủ đề này đã được lưu trữ. Vui lòng hỏi một câu hỏi mới nếu bạn cần giúp đỡ.

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

  • 1 trả lời
  • 1 gặp vấn đề này
  • 17 lượt xem
  • Trả lời mới nhất được viết bởi 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!

Được chỉnh sửa bởi dmfigol vào

Tất cả các câu trả lời (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