"GenericJDBCException - Cannot open connection" for all active users. Database corruption results in FECRU outage.

[Charlton Port]

A database exception results from normal user login and app-access (People or Reviews access.) FECRU becomes unusable for _all_ users.

Appears to be related to malformed/unavailable LDAP attribute: (real user names changed to 'xuser' and 'yuser')

==SNIP atlassian-fisheye.log

WARN btpool0-758 fisheye LDAPAuth-extract - Could not find the attribute 'mail' in LDAP

...

ERROR ThreadPool5 org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - Batch entry 0 insert into cru_recently_visited (cru_last_viewed, cru_user_name, cru_item_type, cru_entity_id) values ('1361382326880', 'xuser', 'atlassian-user', 'yuser') was aborted. Call getNextException to see the cause.

WARN ThreadPool5 org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - SQL Error: 0, SQLState : 23505

ERROR ThreadPool5 org.hibernate.util.JDBCExceptionReporter JDBCExceptionReporter-logExceptions - ERROR: duplicate key value violates unique constraint cru_recently_visited_pkey

Detail: Key (cru_user_name, cru_item_type, cru_entity_id)=(xuser, atlassian-user, yuser) already exists

==/SNIP

==SNIP PostgreSQL logs

UTC ERROR: duplicate key value violates unique constraint cru_recently_visited_pkey

UTC DETAIL: Key (cru_user_name, cru_item_type, cru_entity_id)=(xuser, atlassian-user, yuser) already exists.

UTC STATEMENT: insert into cru_recently_visited (cru_last_viewed, cru_user_name, cru_item_type, cru_entity_id) values ($1, $2, $3, $4)

UTC ERROR: current transaction is aborted, commands ignored until end of transaction block

...

==/SNIP

[Charlton Port · Accepted solution]

From Atlassian:

Unfortunately you seem to be experiencing a known bug, as documented here:

https://jira.atlassian.com/browse/CRUC-6385