Login fails if total number of failed login attempts is too large

A user will fail to login if the total number of failed login attempt is too large. Resetting the current failed login count in Confluence Admin >> Manage Users will not resolve the issue either. This affects all pre-4.0 Confluence versions.

Workaround

Reset the total failed login count by running this query in the database:

UPDATE os_propertyentry SET INT_VAL = 0 WHERE entity_key = 'user.login.total_number_failed_login_attempts' AND entity_name = 'CWD_<username>';

Replace <username> with the affected user's username.

Note that this is resolved in Confluence 4.0 and above, which uses the logininfo table, instead of os_propertyentry to record failed login attempts.