How to restart face recognition

[lintujuh]

I think my face recognition is somehow corrupted as I get errors 

duplicate key value violates unique constraint "people_file_pkey"

What I need to do to restart from scratch? I don't want to delete the People tags as @rene in 

Which tables should I clean and are there some cache files that should be deleted?

[Oleg.Ross]

Hello, can you get to me in more detail about what happened?
Did you delete people tags and try to add person with same name?
Why do you need to restart all? 

 

 

 

[lintujuh]

I noticed same face thumbnails reappearing in the tagging window. When I checked the logs I saw several duplicate key errors.

I had started face recognition with Postgres 9.6 and after that I upgraded to Postgres 12, but at the same time I also my catalog name. I suspect that this has caused some inconsistencies and that's why I thought it would be better to restart from an "emtpy table".

[Oleg.Ross]

Please, make a backup before doing this operation.

Postgres query:

drop table faces; drop table similarclusters; drop table persons; drop table predictions; delete from processedfaces;

 

[lintujuh]

Thank you @Oleg.Ross. I have tested this now few days and it looks it solved my problems.

Happy New Year!