org.postgresql.util.PSQLException: ERROR: update or delete on table "label" violates foreign key constraint "fk594acc827072aef" on table "notifications" Detail: Key (labelid)=(2031993) is still referenced from table "notifications".

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

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Atlassian JIRA by Matthew Erickson [Atlassian], 1 year ago
ERROR: update or delete on table "label" violates foreign key constraint "fk594acc827072aef" on table "notifications" Detail: Key (labelid)=(2031993) is still referenced from table "notifications".
via Atlassian JIRA by Matthew Erickson [Atlassian], 1 year ago
ERROR: update or delete on table "label" violates foreign key constraint "fk594acc827072aef" on table "notifications" Detail: Key (labelid)=(2031993) is still referenced from table "notifications".
via https://bugzilla.redhat.com/bugzilla/ by Elad, 1 year ago
(1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: The column name disk_storage_type was not found in this ResultSet.: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT
via Atlassian JIRA by David Yu, 1 year ago
ERROR: update or delete on table "attachments" violates foreign key constraint "fka768048734a4917e" on table "imagedetails" Detail: Key (attachmentid)=(46497891) is still referenced from table "imagedetails".
via atomikos.com by Unknown author, 1 year ago
via symmetricds by skuda
, 1 year ago
ERROR: relation "idx_de_batched_nodeid_channel" already exists
org.postgresql.util.PSQLException: ERROR: update or delete on table "label" violates foreign key constraint "fk594acc827072aef" on table "notifications" Detail: Key (labelid)=(2031993) is still referenced from table "notifications".
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findByLabel(HibernateLabelDao.java:117)
at com.atlassian.confluence.labels.DefaultLabelManager.getLabel(DefaultLabelManager.java:623)
at com.atlassian.confluence.labels.DefaultLabelManager.deleteLabel(DefaultLabelManager.java:561)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 year ago

Write tip

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