View Issue Details

IDProjectCategoryView StatusLast Update
0005823SymmetricDSImprovementpublic2023-05-09 17:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.6 
Target Version3.14.7Fixed in Version3.14.7 
Summary0005823: Capture timings when running Sync Triggers
DescriptionAdding the following timing statistics to the end of Sync Triggers:
fixMultipleActiveTriggerHistoriesTime - length of time to run fixMultipleActiveTriggerHistories()
triggersForCurrentNodeTime - length of time to run getTriggersForCurrentNode()
syncTriggersStartedTime - length of time to run syncTriggersStarted extensions
activeTriggerHistoriesTime - length of time to run getActiveTriggerHistories()
updateOrCreateDdlTriggersTime - length of time to run updateOrCreateDdlTriggers()
syncTriggersEndedTime - length of time to run syncTriggersEnded extensions
tablesForTriggerTime - length of time to run getTablesForTrigger()
dropTriggerTime - length of time to run dropTrigger()
doesTriggerExistTime - length of time to run doesTriggerExist()
inactivateTriggerHistTime - length of time to run inactivateTriggerHistTime()
triggerToTableSupportingInfoTime - length of time to run getTriggerToTableSupportingInfo()
tableDoesNotExistTime - length of time to run tablesDoesNotExist()
updateOrCreateDatabaseTriggersTime - length of time to run updateOrCreateDatabaseTriggers()
triggerInactivatedTime - length of time to run triggerInactivated()
Tagssync-trigger

Activities

pmarzullo

2023-05-05 20:21

developer   ~0002318

Also fixed multiple thread sync triggers (needed to synchronize the use and update of activeTriggerHistories object)

pmarzullo

2023-05-09 16:29

developer   ~0002319

More threading issues

pmarzullo

2023-05-09 16:38

developer   ~0002320

More threading issues fixed

Related Changesets

SymmetricDS: 3.14 60fd4fc2

2023-05-05 20:19:10

pmarzullo

Details Diff
0005823: Capture timings when running Sync Triggers Affected Issues
0005823
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/config/ITableResolver.java Diff File
add - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterContext.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

SymmetricDS: 3.14 3e80a4d0

2023-05-09 16:37:59

pmarzullo

Details Diff
0005823: Capture timings when running Sync Triggers Affected Issues
0005823
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2023-05-05 20:13 pmarzullo New Issue
2023-05-05 20:13 pmarzullo Status new => assigned
2023-05-05 20:13 pmarzullo Assigned To => pmarzullo
2023-05-05 20:13 pmarzullo Tag Attached: sync-trigger
2023-05-05 20:21 pmarzullo Status assigned => resolved
2023-05-05 20:21 pmarzullo Resolution open => fixed
2023-05-05 20:21 pmarzullo Fixed in Version => 3.14.7
2023-05-05 20:21 pmarzullo Note Added: 0002318
2023-05-05 21:00 pmarzullo Changeset attached => SymmetricDS 3.14 60fd4fc2
2023-05-09 16:29 pmarzullo Status resolved => new
2023-05-09 16:29 pmarzullo Resolution fixed => reopened
2023-05-09 16:29 pmarzullo Note Added: 0002319
2023-05-09 16:38 pmarzullo Status new => resolved
2023-05-09 16:38 pmarzullo Note Added: 0002320
2023-05-09 16:38 pmarzullo Resolution reopened => fixed
2023-05-09 17:00 pmarzullo Changeset attached => SymmetricDS 3.14 3e80a4d0
2023-05-12 19:49 admin Status resolved => closed