View Issue Details

IDProjectCategoryView StatusLast Update
0006482SymmetricDSBugpublic2024-08-01 14:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.8Fixed in Version3.15.8 
Summary0006482: Could not find trigger history causes error of wrong number of columns data validation in wrong column
DescriptionWhen a trigger history can't be found, it attempts to lookup a trigger history with the same number of columns. During routing, the default router does not select the row data or pk data, which prevents verification of the number of columns, so it's possible to get an error like:

[DataService] Could not find trigger history 377 for table mytable for data_id 175848. Using trigger hist 1206 instead.
[DataExtractorService] The batch server01-10670 appears corrupt in staging, so removing it. (The extracted row for table mytable had 14 columns but expected 17. Corrupted row for data ID 175848

Issue 0006174 contained the logic to match the number of columns, and issue 0006442 prevented the null pointer when using a default router without row/pk data available. This issue will cause it to look up the original data so it can get a column count.
Tagsrouting

Relationships

related to 0006483 closedelong Could not find trigger history causes error of wrong number of columns data validation in wrong column 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 2734cc67

2024-06-10 17:07:44

admin

Details Diff
0006482: Could not find trigger history causes error of wrong number of
columns data validation in wrong column
Affected Issues
0006482
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

SymmetricDS: 3.16 8793bcd5

2024-06-10 17:07:44

admin

Details Diff
0006482: Could not find trigger history causes error of wrong number of
columns data validation in wrong column
Affected Issues
0006482
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2024-06-10 16:58 elong New Issue
2024-06-10 16:58 elong Status new => assigned
2024-06-10 16:58 elong Assigned To => elong
2024-06-10 16:58 elong Tag Attached: routing
2024-06-10 17:05 elong Issue cloned: 0006483
2024-06-10 17:05 elong Relationship added related to 0006483
2024-06-10 17:11 elong Status assigned => resolved
2024-06-10 17:11 elong Resolution open => fixed
2024-06-10 17:11 elong Fixed in Version => 3.15.8
2024-06-10 17:20 elong Project SymmetricDS Pro => SymmetricDS
2024-06-10 18:00 admin Changeset attached => SymmetricDS 3.15 2734cc67
2024-08-01 14:00 admin Changeset attached => SymmetricDS 3.16 8793bcd5
2024-08-16 17:45 admin Status resolved => closed