Firefox places.sqlite - UNIQUE constraint failed: moz_hosts.host error

[danjackson1]

Cleaning with Bleachbit 1.8 on Debian Jessie gives an error "UNIQUE constraint failed: moz_hosts.host: /home/username/.mozilla/firefox/49jq2j7q.default-1434440667292/places.sqlite" This happens in multiple desktop environments on Debian (http://bleachbit.sourceforge.net/forum/three-errors-i-found-when-using-kde-linux). The error does not occur on Ubuntu 14.04 based distributions.

[gravy45 (gravy45)]

There is a unique constraint on the 'host' column in the moz_hosts..so look in that table in places.sqlite and see if you have two or more database records that have hosts with the same length/number of characters...if so, what is happening is that there is a database update statement attempted, and it is trying to write the same blob of 00s in more than one row.

https://bugs.launchpad.net/bleachbit/+bug/1464299

[Andrew Ziem (ahziem1)]

Fix committed in git commit c43077d for the next release. Thank you for reporting this bug.

[Andrew Ziem (ahziem1)]

To confirm the fix, please test the fix in BleachBit 1.11 beta
https://www.bleachbit.org/news/bleachbit-1110-beta

[danjackson1 (danjackson1)]

Fix works for Firefox 45.0.2 in Debian Jessie - no unique constraint error. Thank you.