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 | 5 months ago
  1. 0

    Unable to remove constraint

    Google Groups | 5 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

    SymmetricDS 3.8 demo not working

    symmetricds | 2 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 0

    H2 db: how to run a SQL script in the current directory

    Stack Overflow | 3 years ago | Micdev42
    org.h2.jdbc.JdbcSQLException: IO Exception: "java.io. FileNotFoundException: resource /DropSchemas.sql"; "classpath:/DropSchemas.sql"; SQL statement:</p> <pre><code>runscript from 'classpath:/DropSchemas.sql' [90031-172]

  1. andyglick 352 times, last 9 months ago
16 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