View Issue Details

IDProjectCategoryView StatusLast Update
0006850SymmetricDSImprovementpublic2025-04-26 01:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
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

There are no notes attached to this issue.

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