org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Atlassian JIRA by Michael Heemskerk, 1 year ago
ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.
via Atlassian JIRA by Michael Heemskerk, 1 year ago
ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.
via Stack Overflow by Nixxon
, 1 year ago
ERROR: duplicate key value violates unique constraint "requestlogging_pkey" Detail: Key (id, "timestamp")=(a7813f97-7c0d-4739-b20b-a2a6ab2f32a3, 1470137399294243) already exists.
via Stack Overflow by membersound
, 1 year ago
ERROR: Insert or Update in table "my_entity" violates forgein key constraint "fk_id". Detail: Key (some_id)=(940) is not contained within table "my_object_table".
via atlassian.com by Unknown author, 1 year ago
ERROR: update or delete on table "repository_changeset" violates foreign key constraint "fk34a3e6e3cbadfcbd" on table "relevant_changesets" Detail: Key (repository_changeset_id)=(6815755) is still referenced from table "relevant_changesets".
via Stack Overflow by Chitresh
, 2 years ago
ERROR: null value in column "customer_ui_id" violates not-null constraint
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "uk_trusted_app_restrict" Detail: Key (trusted_app_id, restriction_type, restriction_value)=(3, 0, 127.0.0.1) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:149)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 2 days ago
Once, 6 days ago
Samebug visitor profile picture
Unknown user
Once, 6 days ago
100 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.