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)

Google Groups | Matthew Halder | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    db-seed issues

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

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

    Stack Overflow | 6 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

    Root Cause Analysis

    1. 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)

      at org.jooq.impl.AbstractQuery.execute()
    2. jOOQ
      AbstractDelegatingQuery.execute
      1. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356)
      2. org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
      2 frames
    3. keywhiz.commands
      DbSeedCommand.run
      1. keywhiz.commands.DbSeedCommand.doImport(DbSeedCommand.java:88)
      2. keywhiz.commands.DbSeedCommand.run(DbSeedCommand.java:70)
      3. keywhiz.commands.DbSeedCommand.run(DbSeedCommand.java:50)
      3 frames
    4. Dropwizard
      Application.run
      1. io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:76)
      2. io.dropwizard.cli.Cli.run(Cli.java:70)
      3. io.dropwizard.Application.run(Application.java:73)
      3 frames
    5. keywhiz
      KeywhizService.main
      1. keywhiz.KeywhizService.main(KeywhizService.java:71)
      1 frame