View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006741 | SymmetricDS | Bug | public | 2025-02-28 16:30 | 2025-03-11 20:35 |
| Reporter | pbelov | Assigned To | pbelov | ||
| Priority | low | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.14 | Fixed in Version | 3.15.14 | ||
| Summary | 0006741: Change log level to WARN in DefaultDatabaseWriter.logFailureDetails | ||||
| Description | The DefaultDatabaseWriter.logFailureDetails logs batch errors as INFO level messages. This change sets log level to WARN in logFailureDetails, to help this message break through filters, which might eliminate INFO messages. Example for the Compare & Repair job: 2025-02-28 09:51:13,298 INFO [Sybase] [DefaultDatabaseWriter] [sybase-dataloader-49994] Failed to process insert event in batch SQL08_Trigger--9999 on channel 'default'. Failed sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values ({ts '2018-10-10 11:20:23.563'},'BrandL01','234824','2370',null,'4442',null,null,null,'1742371')'234824' Failed raw sql was: insert into jcdc.dbo.disability (add_dt, add_user, disability_id, disab_cat_cd, disab_cat_other_desc, disab_sub_cat_cd, disab_sub_cat_other_desc, last_mod_dt, last_mod_user, stud_id) values (?,?,?,?,?,?,?,?,?,?) Failed sql parameters: [{ts '2018-10-10 11:20:23.563'}, 'BrandL01', '234824', '2370', null, '4442', null, null, null, '1742371', '234824'] Failed sql parameters types: [TIMESTAMP, VARCHAR, BIGINT, BIGINT, VARCHAR, BIGINT, VARCHAR, TIMESTAMP, VARCHAR, BIGINT] Failed sql state and code: ZZZZZ (584) Failed row data was: "2018-10-10 11:20:23.563","BrandL01","234824","2370",,"4442",,,,"1742371" StackTraceKey [SqlException:1962199873] 2025-02-28 09:51:13,399 ERROR [Sybase] [ManageIncomingBatchListener] [sybase-dataloader-49994] Failed to load batch SQL08_Trigger--9999 StackTraceKey [SqlException:1962199873] | ||||
| Tags | load only | ||||
|
SymmetricDS: 3.15 e345771f 2025-02-28 18:29:05 Committer: GitHub Details Diff |
0006741 Set log level to WARN in logFailureDetails Set log level to WARN in logFailureDetails, to help this message break through filters, which eliminate INFO messages. |
Affected Issues 0006741 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-02-28 16:30 | pbelov | New Issue | |
| 2025-02-28 16:30 | pbelov | Status | new => assigned |
| 2025-02-28 16:30 | pbelov | Assigned To | => pbelov |
| 2025-02-28 16:30 | pbelov | Tag Attached: load only | |
| 2025-02-28 18:30 | pbelov | Status | assigned => resolved |
| 2025-02-28 18:30 | pbelov | Resolution | open => fixed |
| 2025-02-28 18:30 | pbelov | Fixed in Version | => 3.15.14 |
| 2025-02-28 18:30 | pbelov | Summary | Change log level to ERROR in DefaultDatabaseWriter.logFailureDetails => Change log level to WARN in DefaultDatabaseWriter.logFailureDetails |
| 2025-02-28 18:30 | pbelov | Description Updated | View Revisions |
| 2025-02-28 18:30 | pbelov | Note Added: 0002652 | |
| 2025-02-28 19:00 | pbelov | Changeset attached | => SymmetricDS 3.15 e345771f |
| 2025-03-11 20:35 | pbelov | Status | resolved => closed |
| 2025-03-11 20:35 | pbelov | Note Added: 0002665 |