View Issue Details

IDProjectCategoryView StatusLast Update
0004559SymmetricDSBugpublic2021-04-21 16:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.11.5 
Fixed in Version3.11.14 
Summary0004559: Initial Load Status does not always capture complete set of batches completed
DescriptionSometimes, when a table reload request is created, the table reload status table does not get updated with all of the data batches loaded.
When this happens, the number in the column data_batch_count is greater than the data_batch_loaded value, the completed flag never gets set to 1, and the user interface does not show that the load is complete (does not remove it from the active screen).

This is confusing to the user because the load never shows up as completed.
Steps To Reproduce1. Run an initial load
2. Force the update of table reload request and table reload status records to fail (deadlock, timeout, whatever).
3. Let the initial load finish.
4. Status will be incomplete, even though the initial load is complete.
Tagsinitial/partial load

Activities

pmarzullo

2021-04-21 15:53

developer   ~0001920

Solved by putting the update of extract request and load status in the same transaction as the update of the outgoing batch.

Related Changesets

SymmetricDS: 3.11 ae82bcc0

2021-04-21 15:20:37

pmarzullo

Details Diff
0004559: Initial Load Status does not always capture complete set of
batches completed
Affected Issues
0004559
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

SymmetricDS: 3.12 b93fabea

2021-04-21 15:20:37

pmarzullo

Details Diff
0004559: Initial Load Status does not always capture complete set of
batches completed
# Conflicts:
# symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java
# symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java
Affected Issues
0004559
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AcknowledgeService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2020-09-18 19:28 pmarzullo New Issue
2020-09-18 19:28 pmarzullo Tag Attached: initial/partial load
2021-04-21 15:12 pmarzullo Steps to Reproduce Updated View Revisions
2021-04-21 15:12 pmarzullo Assigned To => pmarzullo
2021-04-21 15:12 pmarzullo Status new => assigned
2021-04-21 15:53 pmarzullo Status assigned => resolved
2021-04-21 15:53 pmarzullo Resolution open => fixed
2021-04-21 15:53 pmarzullo Fixed in Version => 3.11.14
2021-04-21 15:53 pmarzullo Note Added: 0001920
2021-04-21 16:00 pmarzullo Changeset attached => SymmetricDS 3.11 ae82bcc0
2021-04-21 16:00 pmarzullo Changeset attached => SymmetricDS 3.12 b93fabea