View Issue Details

IDProjectCategoryView StatusLast Update
0006850SymmetricDSImprovementpublic2025-05-06 02:45
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.16.0 
Target Version3.16.2Fixed in Version3.16.2 
Summary0006850: Extract error should be recorded on outgoing batch
DescriptionAn extract error should be recorded on the outgoing batch, so any monitoring application will see it. If the batch is part of a load, the error should also be marked on the table reload status.
Steps To ReproduceExtract errors are rare, so this is hard to reproduce. An invalid "where" clause on the table during initial load will actually cause the load to cancel altogether, so you need a query that only fails during extract. I ran into it because the Postgres driver can't extract a money data type, but that is fixed in 0006847. One idea to get a failure is to set db.sql.query.timeout.seconds very low and have long running query.
Tagsextract

Activities

pbelov

2025-05-06 02:45

manager   ~0002892

Included in the 3.16.2 release

Related Changesets

SymmetricDS: 3.16 98f6f126

2025-04-26 00:46:57

elong


Committer: GitHub Details Diff
0006850: Extract error should be recorded on outgoing batch (0000261)

* 0006850: Extract error should be recorded on outgoing batch
Affected Issues
0006850
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/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File

Issue History

Date Modified Username Field Change
2025-04-25 13:11 elong New Issue
2025-04-25 13:11 elong Status new => assigned
2025-04-25 13:11 elong Assigned To => elong
2025-04-25 13:11 elong Tag Attached: extract
2025-04-25 13:13 elong Status assigned => resolved
2025-04-25 13:13 elong Resolution open => fixed
2025-04-25 13:13 elong Fixed in Version => 3.16.2
2025-04-26 01:00 elong Changeset attached => SymmetricDS 3.16 98f6f126
2025-05-06 02:45 pbelov Note Added: 0002892
2025-05-06 02:45 pbelov Status resolved => closed