org.jumpmind.db.sql.SqlException: ERROR: syntax error at or near "symmetric" (seg0 b99744612d0b:40000 pid=7357)

Stack Overflow | lilyyu | 2 months ago
  1. 0

    symmetricDS with greenplum

    Stack Overflow | 2 months ago | lilyyu
    org.jumpmind.db.sql.SqlException: ERROR: syntax error at or near "symmetric" (seg0 b99744612d0b:40000 pid=7357)
  2. 0

    using online and offline nodes in the same network

    symmetricds | 1 year ago | emmedierre
    org.jumpmind.db.sql.SqlException: ERRORE: un valore chiave duplicato viola il vincolo univoco "sym_incoming_batch_pkey"
  3. 0

    0002462: Replication does not restart after network reconnection between servers - SymmetricDS Issues

    symmetricds.org | 6 months ago
    org.jumpmind.db.sql.SqlException: ERROR: duplicate key value violates unique constraint "sym_incoming_batch_pkey"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    nutz 1.4.2 postgresql 的问题

    GitHub | 5 years ago | csg0328
    org.postgresql.util.PSQLException: ERROR: column "article_createdate" of relation "t_article" does not exist 位置:114
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 "symmetric" (seg0 b99744612d0b:40000 pid=7357)

    at org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecutorImpl.java:574)
    2. org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:497)
    3. org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
    4. org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:616)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:466)
    7. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:459)
    7 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.prepareAndExecute
    1. org.jumpmind.db.sql.JdbcSqlTransaction$6.execute(JdbcSqlTransaction.java:357)
    2. org.jumpmind.db.sql.JdbcSqlTransaction$6.execute(JdbcSqlTransaction.java:347)
    3. org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:379)
    4. org.jumpmind.db.sql.JdbcSqlTransaction.prepareAndExecute(JdbcSqlTransaction.java:347)
    4 frames
  5. org.jumpmind.symmetric
    DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call
    1. org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect.disableSyncTriggers(PostgreSqlSymmetricDialect.java:198)
    2. org.jumpmind.symmetric.service.impl.DataLoaderService$ManageIncomingBatchListener.afterBatchStarted(DataLoaderService.java:1013)
    3. org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:107)
    4. org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:925)
    5. org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$1.call(DataLoaderService.java:911)
    5 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    4. java.lang.Thread.run(Thread.java:745)
    4 frames