View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002216 | SymmetricDS | Bug | public | 2015-02-24 16:12 | 2019-04-12 12:49 |
| Reporter | ondrejhala | Assigned To | chenson | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.6 | ||||
| Target Version | 3.7.9 | Fixed in Version | 3.7.9 | ||
| Summary | 0002216: Replication of rows with NULL in large object column on PostgreSQL throws exception | ||||
| Description | Unable to sync rows with NULL in large object column on PostgreSQL. method getBlobAsBytes throws NullPointerException. | ||||
| Steps To Reproduce | Insert a row with NULL in column of type lo to table in running replication system. or Insert a row with NULL in column of type lo to table. Install SymmetricDS on two nodes and start initial load. | ||||
| Additional Information | Table with lo column. CREATE TABLE attachment ( id bigint NOT NULL, packed_len bigint NOT NULL, packed_len_id bigint NOT NULL, buffer lo ) WITH ( OIDS=FALSE ); LOG Entry: ERROR [ta-master-1-pilsen] [NodeCommunicationService] [ta-master-1-pilsen-extract-17] Failed to execute EXTRACT for node ta-postgres-master-server-2-pilsen java.lang.NullPointerException at org.springframework.jdbc.support.lob.DefaultLobHandler.getBlobAsBytes(DefaultLobHandler.java:147) at org.jumpmind.db.platform.postgresql.PostgresLobHandler.getBlobAsBytes(PostgresLobHandler.java:49) at org.jumpmind.db.sql.JdbcSqlTemplate$2.execute(JdbcSqlTemplate.java:184) at org.jumpmind.db.sql.JdbcSqlTemplate$2.execute(JdbcSqlTemplate.java:170) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:430) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForBlob(JdbcSqlTemplate.java:170) at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.enhanceWithLobsFromSourceIfNeeded(ExtractDataReader.java:179) at org.jumpmind.symmetric.io.data.reader.ExtractDataReader.nextData(ExtractDataReader.java:123) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:190) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:169) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:115) at org.jumpmind.symmetric.service.impl.DataExtractorService.extractOutgoingBatch(DataExtractorService.java:707) at org.jumpmind.symmetric.service.impl.DataExtractorService.execute(DataExtractorService.java:1069) at org.jumpmind.symmetric.service.impl.NodeCommunicationService$2.run(NodeCommunicationService.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) | ||||
| Tags | dialect: postgresql, large objects | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-02-24 16:12 | ondrejhala | New Issue | |
| 2015-02-24 16:13 | ondrejhala | Tag Attached: large objects | |
| 2015-02-24 16:13 | ondrejhala | Tag Attached: lo | |
| 2015-02-24 16:13 | ondrejhala | Tag Attached: postgres | |
| 2015-02-24 16:13 | ondrejhala | Tag Attached: postgresql | |
| 2015-03-01 21:28 | chenson | Assigned To | => chenson |
| 2015-03-01 21:28 | chenson | Status | new => assigned |
| 2015-03-01 21:28 | chenson | Fixed in Version | => 3.7.9 |
| 2015-03-01 21:28 | chenson | Target Version | => 3.7.9 |
| 2015-03-01 21:28 | chenson | Status | assigned => resolved |
| 2015-03-01 21:28 | chenson | Resolution | open => fixed |
| 2015-03-01 22:00 | chenson | Changeset attached | => SymmetricDS trunk r9384 |
| 2015-03-06 15:16 | chenson | Status | resolved => closed |
| 2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master cd05142b |
| 2019-04-12 12:49 | admin | Tag Detached: postgres | |
| 2019-04-12 12:49 | admin | Tag Detached: lo | |
| 2019-04-23 20:50 | admin | Tag Renamed | postgresql => dialect: postgresql |