Overview:
In a multi-tenant environment, the mod-password-validator-2.1.0 upgrade from v2.0.2 fails with an error like this:

This is appears to be due to the fact that the upgrade script attempts to remove the f_unaccent function, which is used in index definitions for previous versions of mod-password-validator. If there are multiple tenants on a system, the upgrade fails, because not all tenants can be upgraded simultaneously.

There is no workaround that I can see other than to leave mod-password-validator at v2.0.2.

Update RMB-cleanup scripts with specifying the schema. This is possible with ${database.defaultSchemaName}