View Issue Details

IDProjectCategoryView StatusLast Update
0003853SymmetricDSImprovementpublic2019-04-11 19:20
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003853: Defer indexes and foreign key constraints for table creation until after initial load
DescriptionWhen the user requests table to be created as part of the initial load, create the table without foreign keys and indexes so the load will perform better. After each table is extracted, queue another table creation -- this time on the regular channel for the trigger -- that will alter the table to add foreign keys and indexes. By queuing the alters on the regular channel instead of the reload channel, the change capture should bring the table into consistency. Allow enable/disable with parameter initial.load.defer.create.constraints=true.
TagsNo tags attached.

Relationships

related to 0001341 closedelong Initial loads on table with FK to itself may fail with FK violations 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 f38f4ccf

2019-01-10 12:58:02

admin

Details Diff
0003853: Defer indexes and foreign key constraints for table creation
until after initial load
Affected Issues
0003853
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.10 d15cd722

2019-01-11 12:17:36

admin

Details Diff
0003853: Defer indexes and foreign key constraints for table creation
until after initial load
Affected Issues
0003853
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.10 9a9cc305

2019-02-25 13:56:43

admin

Details Diff
0003853: Defer indexes and foreign key constraints for table creation Affected Issues
0003853
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java Diff File

Issue History

Date Modified Username Field Change
2019-01-10 14:05 elong New Issue
2019-01-10 14:05 elong Status new => assigned
2019-01-10 14:05 elong Assigned To => elong
2019-01-10 18:00 admin Changeset attached => SymmetricDS 3.10 f38f4ccf
2019-01-10 23:36 elong Status assigned => resolved
2019-01-10 23:36 elong Resolution open => fixed
2019-01-10 23:36 elong Fixed in Version => 3.10.0
2019-01-11 18:00 admin Changeset attached => SymmetricDS 3.10 d15cd722
2019-02-25 19:00 admin Changeset attached => SymmetricDS 3.10 9a9cc305
2019-03-14 12:48 admin Status resolved => closed
2019-04-11 19:20 elong Relationship added related to 0001341