본 사이트는 여러분의 사용자 경험을 개선하기 위해 유지 보수를 진행하는 동안 기능이 제한됩니다. 도움말로 문제가 해결되지 않고 질문을 하고 싶다면 Twitter의 @FirefoxSupport 및 Reddit의 /r/firefox 채널을 활용하세요.

Mozilla 도움말 검색

고객 지원 사기를 피하세요. 저희는 여러분께 절대로 전화를 걸거나 문자를 보내거나 개인 정보를 공유하도록 요청하지 않습니다. "악용 사례 신고"옵션을 사용하여 의심스러운 활동을 신고해 주세요.

자세히 살펴보기

places.sqlite always corrupting when opening Firefox

  • 12 답장
  • 1 이 문제를 만남
  • 1 보기
  • 최종 답변자: exclusive01

more options

Prior to today, occasionally I would need to restore from a Time Machine backup the files "places.sqlite", "places.sqlite-shm", and "places.sqlite-wal" into my default profile, because I would lose my bookmarks & history.

However, beginning this morning, that procedure did not work. Every time I open up Firefox, the "places.sqlite" file would corrupt immediately and no attempt at restoring (from any backup date/time) would fix the issue.

I am running Mac OS 11.7.2 (Big Sur) and Firefox 111.0.

This is VERY frustrating, because I rely heavily on my bookmarks and passwords.

PLEASE HELP!!!!!!

Prior to today, occasionally I would need to restore from a Time Machine backup the files "places.sqlite", "places.sqlite-shm", and "places.sqlite-wal" into my default profile, because I would lose my bookmarks & history. However, beginning this morning, that procedure did not work. Every time I open up Firefox, the "places.sqlite" file would corrupt immediately and no attempt at restoring (from any backup date/time) would fix the issue. I am running Mac OS 11.7.2 (Big Sur) and Firefox 111.0. This is VERY frustrating, because I rely heavily on my bookmarks and passwords. PLEASE HELP!!!!!!

선택된 해결법

@cor-el It's the stupid new version, dude. I un-installed 111 and reinstalled 110 and disabled updates, plus --allow down-grade and it worked.

Already tried everything you said before posting this thread.

Thank you.

문맥에 따라 이 답변을 읽어주세요 👍 0

모든 댓글 (12)

more options

You would normally only have places.sqlite to restore and there wouldn't be places.sqlite-shm and places.sqlite-wal temp SQlite files present unless this backup got created when Firefox was running (i.e. you hadn't Exit/Quit Firefox).

Note that on Mac closing Firefox can be more complicated because you can close all open windows, but keep Firefox running with the menu bar visible or minimized in the Doc. Make sure to use "Quit Firefox" with all windows still open, especially if you want to use "Restore Previous Session".

more options

Really? No one has any ideas???

more options

Are those places.sqlite-shm and places.sqlite-wal temp files still present after you have closed Firefox ? You could try to start with a clean/fresh places.sqlite and restore the bookmarks from a recent backup in the bookmarkbackups folder or create a backup yourself. You will lose the history this way.


Make sure to use "Quit Firefox" with all windows you may want to restore still open, especially if you want to use "Restore Previous Session" to ensure Firefox closes properly.

more options

I truly appreciate your input. Sadly, this didn't work. I removed any "places..." file and the bookmarkbackups folder and replaced them with fresh files from my back up that at one time were good.

Somehow, I think the problem may be with Firefox itself. Each time I open up the app, a "places.sqlite.corrupt" file is created and my old bookmarks are not present.

Maybe, I'll just uninstall Firefox and install a fresh copy.

more options

Well, that didn't work either...

more options

Same. I have had this issue for almost a year now. Every time Firefox was closed, it'd corrupt the places.sqlite file and rename it as places.sqlite.corrupt, which I'd just rename and it'd work. My PC is on 24/7, so I had to do it maybe once every 3 weeks or 3 months, but since the last update that happened a few hours ago, this doesn't work. Every time I open Firefox, it renames the old places.sqlite file to places.sqlite.corrupt and creates a new one and I lose all my history. Note that places.sqlite.corrupt is about 95MB, so it has all my history since 2015, and the new one is only 5mb. I have been loyal to Firefox since 2008, and they're making it so hard with stupid updates trying to become Chrome. We like you because you're not Chrome. You don't start slapping yourself just because someone else has reddish cheeks. Should I just switch to Chrome?

more options

It is not normal that you get a places.sqlite.corrupt file, so it is possible that other software prevents access to the file and forces Firefox to create a fresh file.

What security software do you have?


You can create a new profile as a quick test to see if your current profile is causing the problem.

See "Creating a profile":

If the new profile works, you can transfer files from a previously used profile to the new profile, but be cautious not to copy corrupted files to avoid carrying over problems.

more options

선택된 해결법

@cor-el It's the stupid new version, dude. I un-installed 111 and reinstalled 110 and disabled updates, plus --allow down-grade and it worked.

Already tried everything you said before posting this thread.

Thank you.

more options

Downgrading to 110 seemed to work. I don't think it saved any of my passwords, but at least my bookmarks have returned.

Thanks for all your help.

more options

Don't you have an old backup of your profile? I generally take a backup every 3-4 months of all the profiles of all browsers I use. I didn't know about --allow down-grade feature, otherwise I was happy with version 96 and would still be using it if I wasn't forced to update.

more options

I have restored my profile from a TimeMachine backup from early March of this year. It did not restore my passwords. Is there another file that stores the passwords?

Also, where is the "allow down-grade feature" option?

more options

No idea about that. I copy whole profile and paste it in D drive. I don't know where passes or any other infos are stored, I'm quite dumb. The only reason I know about places.sqlite is it's been happening to me since 2017 in some capacity and a lot after the version 96.

Windows key+ R, and in there paste "firefox --allow-downgrade" without quotes and run it. It will allow an older version of Firefox work with a profile made with a newer version of Firefox. Generally speaking, you can't run a profile made with 110 on 109 version, even though it's only one beta between them.