org.jooq.exception.DataAccessException: SQL [insert into secrets (name, createdat, updatedat, description, createdby, updatedby, type, options) values (?, cast(? as timestamp), cast(? as timestamp), ?, ?, ?, ?, ?) returning secrets.id]; duplicate key value violates unique constraint "secrets_pkey"

GitHub | sureshg | 2 weeks ago
  1. 0

    Postgresql unit test are failing

    GitHub | 2 weeks ago | sureshg
    org.jooq.exception.DataAccessException: SQL [insert into secrets (name, createdat, updatedat, description, createdby, updatedby, type, options) values (?, cast(? as timestamp), cast(? as timestamp), ?, ?, ?, ?, ?) returning secrets.id]; duplicate key value violates unique constraint "secrets_pkey"
  2. 0

    Failing unit test? testEscaping(com.impossibl.postgres.jdbc.DatabaseMetaDataTest)

    GitHub | 1 year ago | dstipp
    com.impossibl.postgres.jdbc.PGSQLSimpleException: LIKE pattern must not end with escape character
  3. 0

    Problem with generated keys

    GitHub | 4 months ago | obraliar
    com.impossibl.postgres.jdbc.PGSQLSimpleException: column "id" does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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 [insert into secrets (name, createdat, updatedat, description, createdby, updatedby, type, options) values (?, cast(? as timestamp), cast(? as timestamp), ?, ?, ?, ?, ?) returning secrets.id]; duplicate key value violates unique constraint "secrets_pkey"

      at com.impossibl.postgres.jdbc.ErrorUtils.makeSQLException()
    2. PGJDBC-NG
      PGPreparedStatement.executeQuery
      1. com.impossibl.postgres.jdbc.ErrorUtils.makeSQLException(ErrorUtils.java:154)
      2. com.impossibl.postgres.jdbc.ErrorUtils.makeSQLException(ErrorUtils.java:136)
      3. com.impossibl.postgres.jdbc.PGConnectionImpl.execute(PGConnectionImpl.java:438)
      4. com.impossibl.postgres.jdbc.PGStatement.executeStatement(PGStatement.java:375)
      5. com.impossibl.postgres.jdbc.PGPreparedStatement.execute(PGPreparedStatement.java:261)
      6. com.impossibl.postgres.jdbc.PGPreparedStatement.executeQuery(PGPreparedStatement.java:277)
      7. com.impossibl.postgres.jdbc.PGPreparedStatement.executeQuery(PGPreparedStatement.java:92)
      7 frames
    3. jOOQ
      UpdatableRecordImpl.store
      1. org.jooq.tools.jdbc.DefaultPreparedStatement.executeQuery(DefaultPreparedStatement.java:83)
      2. org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:376)
      3. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:342)
      4. org.jooq.impl.TableRecordImpl.storeInsert0(TableRecordImpl.java:176)
      5. org.jooq.impl.TableRecordImpl$1.operate(TableRecordImpl.java:142)
      6. org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:123)
      7. org.jooq.impl.TableRecordImpl.storeInsert(TableRecordImpl.java:138)
      8. org.jooq.impl.UpdatableRecordImpl.store0(UpdatableRecordImpl.java:185)
      9. org.jooq.impl.UpdatableRecordImpl.access$000(UpdatableRecordImpl.java:85)
      10. org.jooq.impl.UpdatableRecordImpl$1.operate(UpdatableRecordImpl.java:135)
      11. org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:123)
      12. org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:131)
      13. org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:123)
      13 frames
    4. keywhiz.service.daos
      SecretDAO.lambda$createSecret$17
      1. keywhiz.service.daos.SecretSeriesDAO.createSecretSeries(SecretSeriesDAO.java:91)
      2. keywhiz.service.daos.SecretDAO.lambda$createSecret$17(SecretDAO.java:93)
      2 frames
    5. jOOQ
      DefaultDSLContext.transactionResult
      1. org.jooq.impl.DefaultDSLContext.transactionResult(DefaultDSLContext.java:318)
      1 frame
    6. keywhiz.service.daos
      SecretDAOTest.createOrUpdateSecretWhenSecretExists
      1. keywhiz.service.daos.SecretDAO.createSecret(SecretDAO.java:79)
      2. keywhiz.service.daos.SecretDAOTest.createOrUpdateSecretWhenSecretExists(SecretDAOTest.java:247)
      2 frames