org.jumpmind.db.sql.UniqueKeyException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "customer_phone_number_unique" Detail: Key (phone_number)=(+18004755000) already exists.

symmetricds | dahlajn | 7 months ago
  1. 0

    PostgreSQL: Primary Key / Unique conflict detection issues

    symmetricds | 7 months ago | dahlajn
    org.jumpmind.db.sql.UniqueKeyException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "customer_phone_number_unique" Detail: Key (phone_number)=(+18004755000) already exists.
  2. 0

    Extract/Send starts when the batch is still processing

    symmetricds | 3 years ago | namecips
    org.jumpmind.db.sql.UniqueKeyException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "TABLE_pkey"
  3. 0

    SymmetricDS 3.6.6 Initial Load of PostGIS

    symmetricds | 2 years ago | stevenjohnson78
    org.jumpmind.db.sql.SqlException: ERROR: parse error - invalid geometry Hint: "...0E6100000010000000103000000010000004A" <-- parse error at position 46 within geometry
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Postgresql - Problems with macaddr type

    symmetricds | 1 year ago | dfonseca
    org.jumpmind.db.sql.SqlException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  6. 0

    Issue with geometry columns in 3.7.6

    symmetricds | 2 years ago | stevenjohnson78
    org.jumpmind.db.sql.SqlException: ERROR: parse error - invalid geometry Hint: "...20E610000005000000010200000031000000C" <-- parse error at position 45 within geometry
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: duplicate key value violates unique constraint "customer_phone_number_unique" Detail: Key (phone_number)=(+18004755000) already exists.

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:616)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:466)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:459)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.execute
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    2 frames
  4. org.jumpmind.db
    JdbcSqlTransaction.addRow
    1. org.jumpmind.db.sql.JdbcSqlTransaction.addRow(JdbcSqlTransaction.java:406)
    1 frame
  5. org.jumpmind.symmetric
    NodeCommunicationService$2.run
    1. org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.execute(DefaultDatabaseWriter.java:786)
    2. org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.update(DefaultDatabaseWriter.java:456)
    3. org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:152)
    4. org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    5. org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:65)
    6. org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
    7. org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:204)
    8. org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:200)
    9. org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:170)
    10. org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:116)
    11. org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(DataLoaderService.java:850)
    12. org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(StagingDataWriter.java:75)
    13. org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(AbstractProtocolDataWriter.java:220)
    14. org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:130)
    15. org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.java:458)
    16. org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:268)
    17. org.jumpmind.symmetric.service.impl.PullService.execute(PullService.java:132)
    18. org.jumpmind.symmetric.service.impl.NodeCommunicationService$2.run(NodeCommunicationService.java:396)
    18 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames