smalldatalab / omh-dsu

Omh DSU + Google Sign-In + Survey Management + Shim Server Integration
Apache License 2.0
3 stars 1 forks source link

Duplicate authentication id when refreshing token #8

Open changun opened 7 years ago

changun commented 7 years ago

Fabian report an issue about refresh token. It is hard to reproduce this issue, but it might have something to do with this known issue of spring oauth. https://github.com/spring-projects/spring-security-oauth/issues/276

when i try to refresh pam token i get this error { "error": "server_error", "error_description": "PreparedStatementCallback; SQL [insert into oauth_access_token (token_id, token, authentication_id, user_name, client_id, authentication, refresh_token) values (?, ?, ?, ?, ?, ?, ?)]; ERROR: duplicate key value violates unique constraint \"unique_auth_id\"\n Detail: Key (authentication_id)=(43758735ae5ac84bb35a22c6f6c5487a) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint \"unique_auth_id\"\n Detail: Key (authentication_id)=(43758735ae5ac84bb35a22c6f6c5487a) already exists."

}

kopax commented 6 years ago

I have the same issue when requesting my server asynchronously. did you solve your issue?