Create hook_update to remove duplicated entries in password_policy_history

this hook is mysql specific and fails of sqlite

There's docs for it https://www.drupal.org/docs/7/guidelines-for-sql/writing-code-compliant-... →

Good catch @andypost. I suspect a new ticket will need to be opened to address that.
In the meantime altering the code to read

$query = \Drupal::database()->query('DELETE t1 FROM {' . $table_name . '} t1 USING {' . $table_name . '} AS t2 WHERE t1.id < t2.id AND t1.pass_hash = t2.pass_hash AND t1.timestamp = t2.timestamp');

may probably work.
I can create a new MR if a new ticket is created.

This seems to be related? https://www.drupal.org/project/password_policy/issues/3325587 ✨ Revenge of password_policy_update_8302 takes too long for a large amount of users Needs review