java.sql.SQLException: Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]

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

Solutions on the web

via Atlassian JIRA by Jeff Curry [Atlassian], 1 year ago
Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]
via Atlassian JIRA by Jeff Curry [Atlassian], 1 year ago
Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]
via Stack Overflow by JavaLady
, 2 years ago
Unexpected end of command: REFERENCING in statement [CREATE TRIGGER t BEFORE UPDATE ON SUBJECTS REFERENCING]
via empire-user by Francis De Brabandere, 1 year ago
Primary or unique constraint required on main >> table: >> > VOTERS in statement [-- creating foreign key constraint >> > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT >> > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES >> > voters (id)]
via empire-user by Francis De Brabandere, 1 year ago
Primary or unique constraint required on main table: > VOTERS in statement [-- creating foreign key constraint > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT absentee_ballo_registrant_i_FK > FOREIGN KEY (registrant_id) REFERENCES voters (id)]
via empire-user by Rainer Döbele, 1 year ago
Primary or unique constraint required on main > table: > > VOTERS in statement [-- creating foreign key constraint > > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT > > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES > > voters (id)]
java.sql.SQLException: Constraint not found FK_AO_E8B6CC_MESSAGE_QUEUE_ITEM_MESSAGE_ID in table: AO_E8B6CC_MESSAGE_QUEUE_ITEM in statement [ALTER TABLE PUBLIC.AO_E8B6CC_MESSAGE_QUEUE_ITEM DROP CONSTRAINT fk_ao_e8b6cc_message_queue_item_message_id]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2352)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2422)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2385)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:44)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:74)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:68)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
11 more bugmates

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