Skip to content

Login: Cannot delete orcid user due to new constraint violation. #4356

@kcondon

Description

@kcondon

Cannot delete oauth users with latest orcid 2 changes, required a new db table, which delete does not know about:

[2017-12-05T12:52:37.664-0500] [glassfish 4.1] [WARNING] [] [org.eclipse.persistence.session.file:/usr/local/glassfish4/glassfish
/domains/domain1/applications/dataverse-4.8.3/WEB-INF/classes/_VDCNet-ejbPU] [tid: _ThreadID=28 _ThreadName=http-listener-1(1)] [
timeMillis: 1512496357664] [levelValue: 900] [[

Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.Databas
eException
Internal Exception: org.postgresql.util.PSQLException: ERROR: update or delete on table "authenticateduser" violates foreign key
constraint "fk_oauth2tokendata_user_id" on table "oauth2tokendata"
Detail: Key (id)=(7) is still referenced from table "oauth2tokendata".
Error Code: 0
Call: DELETE FROM AUTHENTICATEDUSER WHERE (ID = ?)
bind => [1 parameter bound]
Query: DeleteObjectQuery([AuthenticatedUser identifier:@kcorcid])

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions