org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 72

GitHub | jozi-k | 5 months ago
  1. 0

    Cannot call insertOrUpdate when pk is generated via AbstractTable.primaryKey instead of ColumnOptions.PrimaryKey

    GitHub | 5 months ago | jozi-k
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 72
  2. 0

    JPA does not insert new childs from one to many relationship when we use merge

    Stack Overflow | 9 months ago | Klinsman Maia
    org.postgresql.util.PSQLException: ERRO: ERROR: null value in column "nrorder" violates not-null constraint Detail: Failing row contains(null, 10, null, null, null).
  3. 0

    GitHub comment 1297#125896674

    GitHub | 1 year ago | MihaiBogdanEugen
    org.postgresql.util.PSQLException: ERROR: type "double" does not exist Position: 560
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    exception on refreshing all aspects (deadlock)

    GitHub | 1 year ago | afischer211
    org.postgresql.util.PSQLException: FEHLER: Verklemmung (Deadlock) entdeckt Detail: Prozess 2839 wartet auf ShareLock-Sperre auf Transaktion 117322; blockiert von Prozess 2854. Prozess 2854 wartet auf ShareLock-Sperre auf Transaktion 117320; blockiert von Prozess 2839. Hinweis: Einzelheiten zur Anfrage finden Sie im Serverlog. Error Code: 0 Call: DELETE FROM ARTIFACTS WHERE (ID = ?) bind => [1 parameter bound] Query: DeleteObjectQuery(de.dentrassi.pm.storage.jpa.VirtualArtifactEntity@a7246323)
  6. 0

    Cataloger ERROR: value too long for type character varying(255)

    GitHub | 2 years ago | JPrevost
    org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)

  1. silex 2 times, last 3 weeks ago
  2. silex 18 times, last 6 months ago
20 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.postgresql.util.PSQLException

    ERROR: syntax error at or near ")" Position: 72

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:366)
    6 frames
  3. slick.driver
    JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction$$anonfun$nativeUpsert$1.apply
    1. slick.driver.JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction$$anonfun$nativeUpsert$1.apply(JdbcActionComponent.scala:560)
    2. slick.driver.JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction$$anonfun$nativeUpsert$1.apply(JdbcActionComponent.scala:557)
    2 frames
  4. slick.jdbc
    JdbcBackend$BaseSession.withPreparedStatement
    1. slick.jdbc.JdbcBackend$SessionDef$class.withPreparedStatement(JdbcBackend.scala:347)
    2. slick.jdbc.JdbcBackend$BaseSession.withPreparedStatement(JdbcBackend.scala:407)
    2 frames