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 |