View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006198 | SymmetricDS | Improvement | public | 2024-01-22 20:48 | 2024-08-29 19:53 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.3 | Fixed in Version | 3.15.3 | ||
| Summary | 0006198: Record failed sync trigger attempts to database in trigger history and stats | ||||
| Description | Record failed sync trigger attempts and error message as an inactive trigger history entry and in sym_node_host_job_stats. - track error messages for tables not found and failure to manage triggers - track individual errors in sym_trigger_hist as an inactive entry - track summary of errors in sym_node_host_job_stats - if table not found, and trigger can't exist without a table, there is no need to drop triggers - fix abandoned trigger hist when error with sync triggers on sql-server log-based For Pro: - manage -> installed triggers screen should show last failed sym_trigger_hist attempt with any error message - display sync trigger error to user instead of missing trigger hist error - job monitor should detect an error only if it's the last run of sync triggers - manage -> jobs -> history should show exact start/end times instead of truncating to minute - manage -> jobs -> history should show most recent runs at top, descending by time | ||||
| Tags | sync-trigger | ||||
|
SymmetricDS: 3.15 99ee03bc 2024-01-22 20:51:39 Details Diff |
0006198: Record failed sync trigger attempts to database in trigger history and stats |
Affected Issues 0006198 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/StatisticService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/StatisticServiceSqlMap.java | Diff File | ||
| mod - 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 | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/statistic/IStatisticManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/statistic/JobStats.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/statistic/StatisticManager.java | Diff File | ||
| mod - symmetric-core/src/test/java/org/jumpmind/symmetric/statistic/MockStatisticManager.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseInfo.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/db2/Db2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-01-22 20:48 | elong | New Issue | |
| 2024-01-22 20:48 | elong | Status | new => assigned |
| 2024-01-22 20:48 | elong | Assigned To | => elong |
| 2024-01-22 20:48 | elong | Tag Attached: sync-trigger | |
| 2024-01-22 21:30 | elong | Status | assigned => resolved |
| 2024-01-22 21:30 | elong | Resolution | open => fixed |
| 2024-01-22 21:30 | elong | Fixed in Version | => 3.15.3 |
| 2024-02-05 18:58 | admin | Status | resolved => closed |
| 2024-02-15 20:28 | admin | Changeset attached | => SymmetricDS 3.15 99ee03bc |
| 2024-08-29 19:53 | elong | Relationship added | related to 0006571 |