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]

GitHub | pratapsingh | 2 months ago
  1. 0

    GitHub comment 3560#253595226

    GitHub | 2 months ago | pratapsingh
    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]
  2. 0

    H2 "OTHER" data type throws Exception when storing String or Boolean

    Stack Overflow | 1 year ago | Steve McLeod
    org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "foobar"; SQL statement: insert into test (key, value) values (?, ?) -- (?1, ?2) [90004-188]
  3. 0

    Unable to generate an api-token on rundeck 1.5

    GitHub | 4 years ago | connaryscott
    org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement: insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    creating a job on the UI leads to "value too long for column USER_RULE_LIST..."

    GitHub | 3 years ago | connaryscott
    org.h2.jdbc.JdbcSQLException: Value too long for column USER_ROLE_LIST VARCHAR(255): 'SNC-Ecommerce Search,GS-Members-MISMO-CORP,$MISMO,GS-PrivNAS-AK-CORP,GS-APMQALDAP,GS-APMPRDLDAP,IT eCommerce Organization,SNC-E... (412); SQL statement: insert into scheduled_execution (id, version, adhoc_execution, adhoc_filepath, adhoc_local_string, adhoc_remote_string, arg_string, date_created, day_of_month, day_of_week, description, do_nodedispatch, exec_count, group_path, hour, job_name, last_updated, loglevel, minute, month, multiple_executions, next_execution, node_exclude, node_exclude_name, node_exclude_os_arch, node_exclude_os_family, node_exclude_os_name, node_exclude_os_version, node_exclude_precedence, node_exclude_tags, node_include, node_include_name, node_include_os_arch, node_include_os_family, node_include_os_name, node_include_os_version, node_include_tags, node_keepgoing, node_rank_attribute, node_rank_order_ascending, node_threadcount, project, scheduled, seconds, total_time, rduser, user_role_list, uuid, workflow_id, year) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-112]
  6. 0

    Error occured when use Run Again failed and Node's name filter is too long

    GitHub | 3 years ago | 20rostantino12
    org.h2.jdbc.JdbcSQLException: Value too long for column "FILTER VARCHAR(255)": "'name: server137-MAPI,server138-MAS,server139-MAPI,server140-MAS,server141-MAPI,server142-MAS,FRPA... (378)"; SQL statement: insert into execution (id, version, abortedby, arg_string, cancelled, date_completed, date_started, do_nodedispatch, failed_node_list, filter, loglevel, node_exclude, node_exclude_name, node_exclude_os_arch, node_exclude_os_family, node_exclude_os_name, node_exclude_os_version, node_exclude_precedence, node_exclude_tags, node_include, node_include_name, node_include_os_arch, node_include_os_family, node_include_os_name, node_include_os_version, node_include_tags, node_keepgoing, node_rank_attribute, node_rank_order_ascending, node_threadcount, outputfilepath, project, scheduled_execution_id, server_nodeuuid, status, succeeded_node_list, rduser, workflow_id) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-164]

  1. tvrmsmith 1 times, last 3 days ago
  2. j.kienzle 2 times, last 1 month ago
  3. Shadd518 4 times, last 4 months ago
  4. MoYapro 1 times, last 4 months ago
11 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. H2 Database Engine
    JdbcPreparedStatement.executeUpdate
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.command.ddl.AlterTableDropConstraint.update(AlterTableDropConstraint.java:41)
    5. org.h2.command.CommandContainer.update(CommandContainer.java:98)
    6. org.h2.command.Command.executeUpdate(Command.java:258)
    7. org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
    8. org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
    8 frames
  3. Clojure
    jdbc$execute_BANG_.invoke
    1. clojure.java.jdbc$db_do_execute_prepared_statement$fn__2799.invoke(jdbc.clj:784)
    2. clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:637)
    3. clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
    4. clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
    5. clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
    6. clojure.java.jdbc$db_do_execute_prepared_statement.invokeStatic(jdbc.clj:783)
    7. clojure.java.jdbc$db_do_execute_prepared_statement.invoke(jdbc.clj:778)
    8. clojure.java.jdbc$db_do_prepared.invokeStatic(jdbc.clj:814)
    9. clojure.java.jdbc$db_do_prepared.invoke(jdbc.clj:795)
    10. clojure.java.jdbc$execute_BANG_$execute_helper__2842.invoke(jdbc.clj:961)
    11. clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:963)
    12. clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:943)
    13. clojure.java.jdbc$execute_BANG_.invokeStatic(jdbc.clj:954)
    14. clojure.java.jdbc$execute_BANG_.invoke(jdbc.clj:943)
    14 frames
  4. metabase
    db$migrate_BANG_$fn__5602.invoke
    1. metabase.db$migrate_up_if_needed_BANG_.invokeStatic(db.clj:165)
    2. metabase.db$migrate_up_if_needed_BANG_.invoke(db.clj:152)
    3. metabase.db$migrate_BANG_$fn__5602.invoke(db.clj:225)
    3 frames
  5. Clojure
    jdbc$db_transaction_STAR_.invoke
    1. clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:613)
    2. clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
    3. clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:629)
    4. clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
    5. clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
    6. clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
    6 frames
  6. metabase
    db$setup_db_BANG_.doInvoke
    1. metabase.db$migrate_BANG_.invokeStatic(db.clj:214)
    2. metabase.db$migrate_BANG_.invoke(db.clj:197)
    3. metabase.db$setup_db_BANG_.invokeStatic(db.clj:351)
    4. metabase.db$setup_db_BANG_.doInvoke(db.clj:338)
    4 frames
  7. Clojure
    RestFn.invoke
    1. clojure.lang.RestFn.invoke(RestFn.java:421)
    1 frame
  8. metabase
    core$_main.doInvoke
    1. metabase.core$init_BANG_.invokeStatic(core.clj:111)
    2. metabase.core$init_BANG_.invoke(core.clj:91)
    3. metabase.core$start_normally.invokeStatic(core.clj:195)
    4. metabase.core$start_normally.invoke(core.clj:189)
    5. metabase.core$_main.invokeStatic(core.clj:229)
    6. metabase.core$_main.doInvoke(core.clj:224)
    6 frames
  9. Clojure
    RestFn.applyTo
    1. clojure.lang.RestFn.invoke(RestFn.java:397)
    2. clojure.lang.AFn.applyToHelper(AFn.java:152)
    3. clojure.lang.RestFn.applyTo(RestFn.java:132)
    3 frames
  10. metabase
    core.main
    1. metabase.core.main(Unknown Source)
    1 frame