SQLite Python Traceback - DatabaseError: UNIQUE constraint failed

[bleachbit]

SQLite Python Traceback - DatabaseError: UNIQUE constraint failed

[az0]

This looks like an error I have heard reported once on either Windows or Linux, but I have not reproduced it.

The SQL code that cleans history from Firefox/Mozilla places.sqlite is slightly complicated. One option is you could privately email me your places.sqlite file, and I could try to troubleshoot it here.

[az0]

If you prefer to work on this yourself, look at the function delete_mozilla_url_history, and try to isolate the error to a specific SQL command

[brahmastra2016]

thank for reply :) , let me spend sometime working on it and will let you know if hit stone wall.

it is exactly same as below bug on Linux and same workaround works too.

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

Workaround :
Disable "Overwrite files to hide contents".

[brahmastra2016]

This is what i am observing based on some debug, query with randomblob work but the next query with zeroblob fails.

Need somebody with SQL experience and expertise to guide as how to fix it Or explain as why we see this behavior.

SQL Query with randomblob works :)
#1
update moz_places set url = randomblob(length(url)),rev_host = randomblob(length(rev_host)),title = randomblob(length(title)) where id in (select moz_places.id from moz_places left join moz_bookmarks on moz_bookmarks.fk = moz_places.id where moz_bookmarks.id is null)

But the next command with zeroblob fails.
#2
update moz_places set url = zeroblob(length(url)),rev_host = zeroblob(length(rev_host)),title = zeroblob(length(title)) where id in (select moz_places.id from moz_places left join moz_bookmarks on moz_bookmarks.fk = moz_places.id where moz_bookmarks.id is null)

[az0]

Zeroblob sets the existing data to zeros, and it makes sense that this could violate a constraint that the values are unique. In Special.py on line 47 try changing update %s to update or ignore %s. Does it help?

[brahmastra2016]

i found that best solution so far is to completed disable (commented out) the zeroblob section under shred_sqlite_char_columns in special.py

this is required for both Mac OSx and Windows.

#######
Change :
#######

def __shred_sqlite_char_columns(table, cols=None, where=""):
"""Create an SQL command to shred character columns"""
cmd = ""
if cols and options.get('shred'):
# cmd += "update %s set %s %s;" %
# (table, ",".join(["%s = zeroblob(length(%s))" % (col, col)
# for col in cols if col != "url"]), where)
cmd += "update %s set %s %s;" %
(table, ",".join(["%s = zeroblob(length(%s))" % (col, col)
for col in cols if col != "url"]), where)

[az0]

I think this was fixed by c43077d

If you see this with later code, please reopen