org.jooq.exception.DataAccessException: SQL [update `mz_db`.`payment_gateway_subscription` set `mz_db`.`payment_gateway_subscription`.`subscription_event_type_id` = ? where `mz_db`.`payment_gateway_subscription`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction

Stack Overflow | displayname | 3 months ago
  1. 0

    DataAccessException: Deadlock found when trying to get lock; try restarting transaction

    Stack Overflow | 3 months ago | displayname
    org.jooq.exception.DataAccessException: SQL [update `mz_db`.`payment_gateway_subscription` set `mz_db`.`payment_gateway_subscription`.`subscription_event_type_id` = ? where `mz_db`.`payment_gateway_subscription`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction
  2. 0

    Clock crashed

    GitHub | 2 years ago | phxql
    org.jooq.exception.DataAccessException: SQL [insert into "PUBLIC"."TECHNOLOGY" ("ID", "TYPE", "PLAYER_ID", "LEVEL") values (cast(? as uuid), cast(? as int), cast(? as uuid), cast(? as int))]; Eindeutiger Index oder Primärschlüssel verletzt: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')" Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')"; SQL statement: insert into "PUBLIC"."TECHNOLOGY" ("ID", "TYPE", "PLAYER_ID", "LEVEL") values (cast(? as uuid), cast(? as int), cast(? as uuid), cast(? as int)) [23505-176]
  3. 0

    Database deadlock

    GitHub | 2 years ago | phxql
    org.jooq.exception.DataAccessException: SQL [insert into "PUBLIC"."EVENT" ("ID", "PLAYER_ID", "PLANET_ID", "TYPE", "ROUND", "FIGHT_ID") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as int), cast(? as bigint), cast(? as uuid))]; Eine Verklemmung (Deadlock) ist aufgetreten. Die aktuelle Transaktion wurde rückgängig gemacht. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)." Deadlock detected. The current transaction was rolled back. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)."; SQL statement: insert into "PUBLIC"."EVENT" ("ID", "PLAYER_ID", "PLANET_ID", "TYPE", "ROUND", "FIGHT_ID") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as int), cast(? as bigint), cast(? as uuid)) [40001-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db-seed issues

    Google Groups | 3 months ago | Matthew Halder
    org.jooq.exception.DataAccessException: SQL [insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint))]; Cannot parse "TIMESTAMP" constant "1340289489"; SQL statement:insert into groups (id, name, createdat, updatedat) values (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)), (cast(? as bigint), cast(? as varchar), cast(? as bigint), cast(? as bigint)) -- (CAST(?1 AS BIGINT), CAST(?2 AS VARCHAR), CAST(?3 AS BIGINT), CAST(?4 AS BIGINT)) [22007-187] at org.jooq.impl.Utils.translate(Utils.java:1645) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:661)
  6. 0

    Connection is read-only. Queries leading to data modification are not allowed

    Google Groups | 12 months ago | Unknown author
    org.jooq.exception.DataAccessException: SQL [insert into `Database`.`MyTable` (`field_one`, `field_two`, `field_three`) values (?, ?, ?)]; Connection is read-only. Queries leading to data modification are not allowed

    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.jooq.exception.DataAccessException

      SQL [update `mz_db`.`payment_gateway_subscription` set `mz_db`.`payment_gateway_subscription`.`subscription_event_type_id` = ? where `mz_db`.`payment_gateway_subscription`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction

      at org.jooq.impl.Utils.translate()
    2. jOOQ
      AbstractDelegatingQuery.execute
      1. org.jooq.impl.Utils.translate(Utils.java:1690)
      2. org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:660)
      3. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356)
      4. org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
      4 frames
    3. com.mz.server
      PaymentGatewaySubscriptionEventRepository.lambda$0
      1. com.mz.server.repository.jooq.payment.PaymentGatewaySubscriptionEventRepository.lambda$0(PaymentGatewaySubscriptionEventRepository.java:73)
      1 frame
    4. jOOQ
      DefaultDSLContext.transaction
      1. org.jooq.impl.DefaultDSLContext$1.run(DefaultDSLContext.java:370)
      2. org.jooq.impl.DefaultDSLContext$1.run(DefaultDSLContext.java:367)
      3. org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:339)
      4. org.jooq.impl.DefaultDSLContext.transaction(DefaultDSLContext.java:367)
      4 frames