View Issue Details

IDProjectCategoryView StatusLast Update
0005508SymmetricDSBugpublic2022-11-30 19:34
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.8.12 
Target Version3.12.20Fixed in Version3.12.20 
Summary0005508: Multiple active trigger history for same table
DescriptionWhen routing encounters a trigger hist ID that does not exist, it creates a new trigger history for it, even if there is a newer, existing trigger history (for the same trigger, table, catalog, and schema).

2022-10-04 14:00:54,155 WARN [server] [DataService] [server-router-reader-1] Could not find a trigger history row for the table sym_node for data_id 272. Generating a new trigger history row.

Multiple active trigger histories can create problems for replication, such as sending a table multiple times during the initial load.
Steps To Reproduce1. stop routing
2. run heartbeat job
3. delete from sym_trigger_hist
4. restart


related to 0002944 closedchenson Attempt to recover if sym_trigger_hist is deleted. If the table and trigger can be found then recreate the row. 
related to 0005509 closedelong Multiple active trigger history for same table 


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 ff240432

2022-10-04 19:58:15


Details Diff
0005508: Multiple active trigger history for same table Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File

Issue History

Date Modified Username Field Change
2022-10-04 19:53 elong New Issue
2022-10-04 19:53 elong Status new => assigned
2022-10-04 19:53 elong Assigned To => elong
2022-10-04 19:53 elong Tag Attached: trigger
2022-10-04 19:54 elong Relationship added related to 0002944
2022-10-04 20:00 admin Changeset attached => SymmetricDS 3.12 ff240432
2022-10-04 20:00 elong Status assigned => resolved
2022-10-04 20:00 elong Resolution open => fixed
2022-10-04 20:00 elong Fixed in Version => 3.12.20
2022-10-04 20:02 elong Issue cloned: 0005509
2022-10-04 20:02 elong Relationship added related to 0005509
2022-11-30 19:34 admin Status resolved => closed