org.h2.jdbc.JdbcSQLException: Constraint "FK_QUERYEXECUTION_REF_QUERY_ID" not found; SQL statement: ALTER TABLE PUBLIC.query_queryexecution DROP CONSTRAINT fk_queryexecution_ref_query_id; [90057-192]

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

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via GitHub by pratapsingh
, 1 year ago
Constraint "FK_QUERYEXECUTION_REF_QUERY_ID" not found; SQL statement: ALTER TABLE PUBLIC.query_queryexecution DROP CONSTRAINT fk_queryexecution_ref_query_id; [90057-192]
via Google Groups by Meni Hillel, 1 year ago
Constraint "UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9" not found; SQL statement: ALTER TABLE SUBSCRIPTION DROP CONSTRAINT UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9 [90057-191]
via Google Groups by Uli, 2 years ago
File corrupted while reading record: "page[61779266] b-tree leaf table:212525 entries:0". Possible solution: use the recovery tool; SQL statement: <-- as described in previous posts -->
via Stack Overflow by jasiek.miko
, 2 months ago
IO Exception: "java.net.SocketException: Permission denied: Not allowed to issue a socket bind: permission denied."; "port: 0 ssl: false" [90031-168]
via Stack Overflow by Volodymyr Bakhmatiuk
, 10 months ago
NULL not allowed for column "MY_CONFIG_ID"; SQL statement: insert into my_config (value, id) values (?, ?) [23502-190]
via Google Groups by Brecht Yperman, 2 years ago
Database may be already in use: "Server is running". Possible solutions: close all other connection(s); use the server mode; SQL statement: 192.168.100.93:59696/149aafb32a4d719e242120aefe36f5993976858617d [90020-172]
org.h2.jdbc.JdbcSQLException: Constraint "FK_QUERYEXECUTION_REF_QUERY_ID" not found; SQL statement: ALTER TABLE PUBLIC.query_queryexecution DROP CONSTRAINT fk_queryexecution_ref_query_id; [90057-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.command.ddl.AlterTableDropConstraint.update(AlterTableDropConstraint.java:41)
at org.h2.command.CommandContainer.update(CommandContainer.java:98)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
at clojure.java.jdbc$db_do_execute_prepared_statement$fn__2799.invoke(jdbc.clj:784)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:637)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:783)
at clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:778)
at clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:814)
at clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:795)
at clojure.java.jdbc$execute_BANG_$execute_helper__2842.invoke(jdbc.clj:961)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:963)
at clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:943)
at clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:954)
at metabase.db$migrate_up_if_needed_BANG_.invokeStatic(db.clj:165)
at metabase.db$migrate_up_if_needed_BANG_.invoke(db.clj:152)
at metabase.db$migrate_BANG_$fn__5602.invoke(db.clj:225)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:613)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:629)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
at metabase.db$migrate_BANG_.invokeStatic(db.clj:214)
at metabase.db$migrate_BANG_.invoke(db.clj:197)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:351)
at metabase.db$setup_db_BANG_.doInvoke(db.clj:338)
at clojure.lang.RestFn.invoke(RestFn.java:421)
at metabase.core$init_BANG_.invokeStatic(core.clj:111)
at metabase.core$init_BANG_.invoke(core.clj:91)
at metabase.core$start_normally.invokeStatic(core.clj:195)
at metabase.core$start_normally.invoke(core.clj:189)
at metabase.core$_main.invokeStatic(core.clj:229)
at metabase.core$_main.doInvoke(core.clj:224)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)

Users with the same issue

Once, 4 months ago
2 times, 3 months ago
Once, 6 months ago
Once, 7 months ago
3 times, 6 months ago
150 more bugmates

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