搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊,或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

了解更多

places.sqlite.corruptappears everytime Firefox restarts

  • 8 回覆
  • 0 有這個問題
  • 1 次檢視
  • 最近回覆由 exclusive01

more options

Every time I restart Firefox, places.sqlite which is currently 105MBs changes to only 5MBs and a new file named places.sqlite.corrupt appears. If I open Firefox, all my history is gone. If I rename the .corrupt file to places.sqlite my history comes back. I want to know why it gets corrupted? It happens when Firefox closes and it doesn't matter if there's a power cut, closing with X , or Exit, Firefox restarts and I have to rename the places.sqlite.corrupt file again. This has been happening for almost two years now. My computer stays on 24/7 and I may restart it once every 2-3 months, but sometimes you have to restart it many times a day because of issues and it's a pain in the behind to rename the places.sqlite.corrupt every single time. Any ideas?! Could an add-on be affecting it? I don't have a lot of them. Just basic AdBlocks.

Thank you.

Every time I restart Firefox, places.sqlite which is currently 105MBs changes to only 5MBs and a new file named places.sqlite.corrupt appears. If I open Firefox, all my history is gone. If I rename the .corrupt file to places.sqlite my history comes back. I want to know why it gets corrupted? It happens when Firefox closes and it doesn't matter if there's a power cut, closing with X , or Exit, Firefox restarts and I have to rename the places.sqlite.corrupt file again. This has been happening for almost two years now. My computer stays on 24/7 and I may restart it once every 2-3 months, but sometimes you have to restart it many times a day because of issues and it's a pain in the behind to rename the places.sqlite.corrupt every single time. Any ideas?! Could an add-on be affecting it? I don't have a lot of them. Just basic AdBlocks. Thank you.

被選擇的解決方法

When you rename the file, Firefox doesn't know it is corrupt until the next time its integrity is checked.

History Export version 0.4 released a few hours ago works for me.

從原來的回覆中察看解決方案 👍 1

所有回覆 (8)

more options

Go to about:support, scroll down to the "Places Database" heading, click the "Verify Integrity" button and see what the output says.

more options

zeroknight said

Go to about:support, scroll down to the "Places Database" heading, click the "Verify Integrity" button and see what the output says.

> Task: checkIntegrity - Unable to fix corruption, places.sqlite will be replaced on next startup > Task: invalidateCaches - The task queue was cleared by an error in another task. > Task: checkCoherence - The task queue was cleared by an error in another task. > Task: expire - The task queue was cleared by an error in another task. > Task: originFrecencyStats - The task queue was cleared by an error in another task. > Task: vacuum - The task queue was cleared by an error in another task. > Task: stats - The task queue was cleared by an error in another task. > Task: _refreshUI - The task queue was cleared by an error in another task.

more options

It's not realistic to continue to use a corrupted database. You should be able to keep your bookmarks in the new rebuilt database, only the history is lost. If you really need that history, you could try various database recovery tools.

more options

zeroknight said

It's not realistic to continue to use a corrupted database. You should be able to keep your bookmarks in the new rebuilt database, only the history is lost. If you really need that history, you could try various database recovery tools.

I have been using the "corrupt" file for over two years now and it has history since 2014 and I don't want to lose it. Can you suggest any database recovery tool? I took your advice and tried DB Browser for SQLite, but the Integrity Check showed no errors. Any other tool that can help?

more options

You could try using an extension like History Export to transfer history from the corrupted database into the good one.

more options

zeroknight said

You could try using an extension like History Export to transfer history from the corrupted database into the good one.

Thank you but it didn't work. It exports the history to a file, but when importing, nothing happens. History doesn't come back. And of course, everytime I restart Firefox, I have to rename the old corrupt file again and again. I tried to repair the SQLite file with SQLite Expert, but Firefox wouldn't read it and always created a new file even after renaming the old corrupt file. What I don't understand is if the file is corrupt, why does it work after renaming.

more options

選擇的解決方法

When you rename the file, Firefox doesn't know it is corrupt until the next time its integrity is checked.

History Export version 0.4 released a few hours ago works for me.

more options

zeroknight said

When you rename the file, Firefox doesn't know it is corrupt until the next time its integrity is checked. History Export version 0.4 released a few hours ago works for me.

Thank you, it finally worked and solved the issue. The new places file is 90mbs, 15 mb smaller than the last one, but that's okay. Thank you for your help.

由 exclusive01 於 修改