We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

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

Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed

more options

In linux Centos7 I found that all my bookmarks disapeared. In about:support if I select verify integrity I get this-

> Task: checkIntegrity - Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed > 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

How can it be fixed? Thanks for any help!

In linux Centos7 I found that all my bookmarks disapeared. In about:support if I select verify integrity I get this- > Task: checkIntegrity - Unable to check places.sqlite integrity: Error: Error(s) encountered during statement execution: database disk image is malformed > 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 How can it be fixed? Thanks for any help!

All Replies (1)

more options

"database disk image is malformed" generally means the file is corrupted. To rule out a locked file, you could do a regular Firefox exit, and a regular shut down and restart of your system. But assuming the problem continues, we generally suggest giving up on the file and starting fresh. Firefox will migrate your last bookmark backup but you won't have any history. I'll give the steps for that in a moment.

Meanwhile, if you are a tinkerer, you could look at the following article: https://developer.mozilla.org/docs/Mozilla/Tech/Places/places.sqlite_Database_Troubleshooting


Open your current Firefox settings (AKA Firefox profile) folder using either

  • "3-bar" menu button > "?" Help > Troubleshooting Information
  • (menu bar) Help > Troubleshooting Information
  • type or paste about:support in the address bar and press Enter/Return

In the first table on the page, on the Profile Folder row, click the "Open Directory" button (the label on this button may vary). This should launch a new window listing various files and folders in your file browser.

Leaving that window open, switch back to Firefox and Exit/Quit, either:

  • "3-bar" menu button > Exit/Quit
  • (menu bar) File > Exit/Quit

Pause while Firefox finishes its cleanup, then rename places.sqlite to something like placesBAD.sqlite. If you see journaling files named places.sqlite-shm and/or places.sqlite-wal, I think it's best to remove those or similarly hide them by renaming.

Start Firefox back up again. Does Firefox recover your bookmarks?