org.h2.jdbc.JdbcSQLException: Constraint "UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9" not found; SQL statement: ALTER TABLE SUBSCRIPTION DROP CONSTRAINT UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9 [90057-191]

Google Groups | Meni Hillel | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unable to remove constraint

    Google Groups | 8 months ago | Meni Hillel
    org.h2.jdbc.JdbcSQLException: Constraint "UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9" not found; SQL statement: ALTER TABLE SUBSCRIPTION DROP CONSTRAINT UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9 [90057-191]
  2. 0

    mvcc

    Google Groups | 6 years ago | Rami Ojares
    org.h2.jdbc.JdbcSQLException: Cannot change the setting "MVCC" when the database is already open; SQL statement: SET MVCC TRUE [90133-147]
  3. 0

    Connection.getMetaData().getTables(…) Fails

    Google Groups | 6 years ago | Jason Osgood
    org.h2.jdbc.JdbcSQLException: Column TYPE_NAME not found; SQL statement: SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM, TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG LIKE ? ESCAPE '\' AND TABLE_SCHEMA LIKE ? ESCAPE '\' AND TABLE_NAME LIKE ? ESCAPE '\' AND (TRUE) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME [42122-112]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SymmetricDS 3.8 demo not working

    symmetricds | 5 months ago | mike182764
    org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]
  6. 0

    しばらく使っているとInternal Server Errorが出る

    GitHub | 2 years ago | yoshimov
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.183/4]"; SQL statement: ROLLBACK [50000-183]

  1. andyglick 352 times, last 12 months ago
17 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 "UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9" not found; SQL statement: ALTER TABLE SUBSCRIPTION DROP CONSTRAINT UK_1PT73622HFCLVE5LRHRQTITBK_INDEX_9 [90057-191]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    TcpServerThread.run
    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.server.TcpServerThread.process(TcpServerThread.java:345)
    8. org.h2.server.TcpServerThread.run(TcpServerThread.java:159)
    8 frames
  3. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame