View Issue Details

IDProjectCategoryView StatusLast Update
0004048SymmetricDS ProBugpublic2019-07-17 15:00
ReporterpmarzulloAssigned Topmarzullo 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.3 
Target Version3.10.4Fixed in Version3.10.4 
Summary0004048: Table reload request- routing service can break up table reload requests into multiple load requests
DescriptionWhen the request to reload tables is made, currently the table reload requests are put in the database not using a database transaction.

So, if there are a lot of tables, the routing service can pick up a subset of the tables, and break the reload requests into multiple load requests, which causes issues with foreign key constraints.
Steps To ReproduceTiming issue, can probably be reproduced by having a very short time to run the routing job, and requesting a bunch of tables to reload (hundreds).
TagsNo tags attached.

Activities

pmarzullo

2019-07-17 12:46

developer   ~0001560

Also fixed in 3.9.22 using:
0004047: Table reload request- routing service can break up table reload requests into multiple load requests

Related Changesets

SymmetricDS: 3.10 4bdab41f

2019-07-17 12:45:41

Philip Marzullo

Details Diff
0004048: Table reload request- routing service can break up table reload
requests into multiple load requests

0004048
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/DataService.java Diff File

SymmetricDS: 3.10 82973dc6

2019-07-17 14:12:56

Philip Marzullo

Details Diff
0004048: Table reload request- routing service can break up table reload
requests into multiple load requests

0004048
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.10 71dc877e

2019-07-17 14:15:49

Philip Marzullo

Details Diff
0004048: Table reload request- routing service can break up table reload
requests into multiple load requests

0004048
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java Diff File

Issue History

Date Modified Username Field Change
2019-07-17 11:21 pmarzullo New Issue
2019-07-17 11:21 pmarzullo Status new => assigned
2019-07-17 11:21 pmarzullo Assigned To => pmarzullo
2019-07-17 12:46 pmarzullo Status assigned => resolved
2019-07-17 12:46 pmarzullo Resolution open => fixed
2019-07-17 12:46 pmarzullo Fixed in Version => 3.10.4
2019-07-17 12:46 pmarzullo Note Added: 0001560
2019-07-17 13:00 Changeset attached => SymmetricDS 3.10 4bdab41f
2019-07-17 15:00 Changeset attached => SymmetricDS 3.10 71dc877e
2019-07-17 15:00 Changeset attached => SymmetricDS 3.10 82973dc6