View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001419||SymmetricDS||Bug||public||2013-09-12 12:13||2014-02-03 01:53|
|Target Version||3.5.7||Fixed in Version||3.5.7|
|Summary||0001419: USE_STREAM_LOBS=1 in Oracle does not replicate LOB data|
|Description||We just upgraded Symmetricds from 3.4.x to latest 3.5.6 and now none of the BLOB data is replicated between the systems. The sym_triggers are configured to have USE_STREAM_LOBS=1 and USE_CAPTURE_LOBS=0. All the LOB data is now replicated as NULL to another system.|
LOB replication did work fine with 3.4.x SymmetricDS
I have tried to change the configuration to USE_STREAM_LOBS=1 and USE_CAPTURE_LOBS=1, but it did not help.
I also tried to change configuration to USE_STREAM_LOBS=0 and USE_CAPTURE_LOBS=1, but this causes the SymmetricDS basically freeze. It will take so much time to process the rows that the replication cannot keep up with the incoming rows. The CPU for SymmetricDS is in top all the time with this setting.
We are having three node system with two masters (read&write) and one read-only database.
Master 1 is running on Windows Server 2008 R2 + Oracle 11gR2 220.127.116.11
Master 2 is running on Oracle Linux 6.4 + Oracle 11gR2 18.104.22.168
Backup db is running on Oracle Linux 6.4 + Oracle 11gR2 22.214.171.124
This is our production system and the data is currently corropting quickly. I had to take master 2 offline and to stop replication to prevent data corruption.
Oracle databases are performing OK all the time, only problem right now is the replication.
Could you please help urgently with this.
|Steps To Reproduce||create a table which have big LOB values in Oracle, set the sym_trigger for it to USE_STREAM_LOBS=1 and USE_CAPTURE_LOBS=0|
=> the LOB data is replivated as NULL to another system
|Tags||No tags attached.|
SymmetricDS: master 5f5b6c10
2013-09-13 08:42:49Details Diff
|0001419: USE_STREAM_LOBS=1 in Oracle does not replicate LOB data||
|mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java||Diff File|
|mod - symmetric-core/src/test/java/org/jumpmind/symmetric/test/TestTablesService.java||Diff File|
|mod - symmetric-server/src/test/java/org/jumpmind/symmetric/test/SimpleIntegrationTest.java||Diff File|
|2013-09-12 12:13||jarmos||New Issue|
|2013-09-13 07:02||jarmos||Note Added: 0000377|
|2013-09-13 11:52||chenson||Assigned To||=> chenson|
|2013-09-13 11:52||chenson||Status||new => assigned|
|2013-09-13 11:52||chenson||Target Version||=> 3.5.7|
|2013-09-13 12:44||chenson||Status||assigned => resolved|
|2013-09-13 12:44||chenson||Fixed in Version||=> 3.5.7|
|2013-09-13 12:44||chenson||Resolution||open => fixed|
|2013-09-14 21:24||chenson||Status||resolved => closed|
|2014-02-03 01:53||Changeset attached||=> SymmetricDS trunk r7693|
|2015-07-31 01:49||chenson||Changeset attached||=> SymmetricDS master 5f5b6c10|