View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006847 | SymmetricDS | Bug | public | 2025-04-24 20:46 | 2025-04-24 21:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.2 | Fixed in Version | 3.16.2 | ||
| Summary | 0006847: Postgres money data type error from initial load | ||||
| Description | On PostgreSQL, use of the money data type on a table causes the initial load extraction to fail. The driver complains that it can't parse the value. The PG JDBC project has acknowledged the problem but won't fix it unless something changes in Postgres server to make the situation better for driver implementers. https://github.com/pgjdbc/pgjdbc/issues/425 2025-04-24 16:29:43,605 ERROR [central] [NodeCommunicationService] [central-extract-reload!0-1] Failed to execute EXTRACT for node 1 and channel reload!0 org.jumpmind.db.sql.SqlException: Bad value for type double : 35,736.66 at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:125) at org.jumpmind.symmetric.extract.SelectFromTableSource.selectNext(SelectFromTableSource.java:206) at org.jumpmind.symmetric.extract.SelectFromTableSource.next(SelectFromTableSource.java:124) at org.jumpmind.symmetric.extract.SelectFromSymDataSource.processReloadEvent(SelectFromSymDataSource.java:237) at org.jumpmind.symmetric.extract.SelectFromSymDataSource.next(SelectFromSymDataSource.java:147) at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.nextTable(ExtractDataReader.java:114) at com.jumpmind.symmetric.db.ProExtractDataReader.nextTable(ProExtractDataReader.java:95) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:151) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:108) at org.jumpmind.symmetric.service.impl.DataExtractorService.extractOutgoingBatch(DataExtractorService.java:909) at org.jumpmind.symmetric.service.impl.DataExtractorService.execute(DataExtractorService.java:1975) at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:553) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: org.postgresql.util.PSQLException: Bad value for type double : 35,736.66 at org.postgresql.jdbc.PgResultSet.toDouble(PgResultSet.java:3441) at org.postgresql.jdbc.PgResultSet.getDouble(PgResultSet.java:2748) at org.postgresql.jdbc.PgResultSet.internalGetObject(PgResultSet.java:240) at org.postgresql.jdbc.PgResultSet.getObject(PgResultSet.java:3061) at org.apache.commons.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:732) at org.apache.commons.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:732) at org.jumpmind.db.sql.JdbcSqlTemplate.getResultSetValue(JdbcSqlTemplate.java:578) at org.jumpmind.db.sql.JdbcSqlReadCursor.getMapForRow(JdbcSqlReadCursor.java:134) at org.jumpmind.db.sql.JdbcSqlReadCursor.next(JdbcSqlReadCursor.java:115) ... 14 more | ||||
| Tags | data type, dialect: postgresql | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-04-24 20:46 | elong | New Issue | |
| 2025-04-24 20:46 | elong | Status | new => assigned |
| 2025-04-24 20:46 | elong | Assigned To | => elong |
| 2025-04-24 20:46 | elong | Tag Attached: data type | |
| 2025-04-24 20:46 | elong | Tag Attached: dialect: postgresql | |
| 2025-04-24 20:59 | elong | Status | assigned => resolved |
| 2025-04-24 20:59 | elong | Resolution | open => fixed |
| 2025-04-24 20:59 | elong | Fixed in Version | => 3.16.2 |
| 2025-04-24 21:00 | admin | Changeset attached | => SymmetricDS 3.16 7f897df6 |