View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004107 | SymmetricDS | Bug | public | 2019-10-09 03:31 | 2025-04-30 17:48 |
| Reporter | jinpengfei | Assigned To | |||
| Priority | low | ||||
| Status | confirmed | Resolution | open | ||
| Product Version | 3.10.4 | ||||
| Summary | 0004107: Support LOB data types like TEXT on Informix | ||||
| Description | 2019-10-09 11:22:54,869 ERROR [corp-000] [ManageIncomingBatchListener] [corp-000-dataloader-2] Failed to load batch 001-310 StackTraceKey [RuntimeException:210653200] 2019-10-09 11:22:54,873 ERROR [corp-000] [DataLoaderService] [qtp1237598030-12] Failed to process batch StackTraceKey [RuntimeException:210653200] 2019-10-09 11:22:54,874 INFO [corp-000] [DataLoaderService] [qtp1237598030-12] 1 data and 1 batches loaded during push request from store:001:001. There were 1 batches in error 2019-10-09 11:22:58,446 INFO [corp-000] [RouterService] [corp-000-job-8] Routed 1 data events in 26 ms 2019-10-09 11:22:58,454 INFO [corp-000] [DataGapFastDetector] [corp-000-job-8] Expired 1 data gap(s) between data_id 5854 and 5859 and between create_time 2019-10-09 11:02:10.0 and 2019-10-09 11:02:10.0 2019-10-09 11:23:04,760 INFO [corp-000] [IncomingBatchService] [corp-000-dataloader-3] Retrying batch 001-310 2019-10-09 11:23:04,764 INFO [corp-000] [DefaultDatabaseWriter] [corp-000-dataloader-3] Failed to process insert event in batch 001-310 on channel 'sessions'. Failed sql was: insert into `rdc_manager`.`sessions` (`session_id`, `expires`, `data`) values (?,?,?) Failed row data was: "CEGLAv8ltyjf_enTqVLrzs5tj0UV9ZKH","1570621055","{\"cookie\":{\"originalMaxAge\":1800000,\"expires\":\"2019-10-09T11:37:34.979Z\",\"httpOnly\":true,\"path\":\"/\"}}" StackTraceKey [RuntimeException:210653200] 2019-10-09 11:23:04,765 INFO [corp-000] [DefaultDatabaseWriter] [corp-000-dataloader-3] Failed to process insert event in batch 001-310 on channel 'sessions'. Failed row data was: "CEGLAv8ltyjf_enTqVLrzs5tj0UV9ZKH","1570621055","{\"cookie\":{\"originalMaxAge\":1800000,\"expires\":\"2019-10-09T11:37:34.979Z\",\"httpOnly\":true,\"path\":\"/\"}}" StackTraceKey [RuntimeException:210653200] 2019-10-09 11:23:04,768 ERROR [corp-000] [ManageIncomingBatchListener] [corp-000-dataloader-3] Failed to load batch 001-310 StackTraceKey [RuntimeException:210653200] 2019-10-09 11:23:04,775 ERROR [corp-000] [DataLoaderService] [qtp1237598030-19] Failed to process batch StackTraceKey [RuntimeException:210653200] | ||||
| Tags | dialect: informix | ||||
| related to | 0004087 | closed | Informix LOB support |
|
|
LOB data types like TEXT are not currently supported on Informix (documented under https://www.symmetricds.org/doc/3.10/html/user-guide.html#databases-compatibility). For unrecognized types, it tries to treat them like VARCHAR as a last attempt to try syncing them, which is why you get the strange error. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-10-09 03:31 | jinpengfei | New Issue | |
| 2019-10-10 09:22 | jinpengfei | Note Added: 0001613 | |
| 2019-10-27 16:07 | elong | Summary | 2019-10-09 19:22:35,065 ERROR [store-001] [AcknowledgeService] [store-001-push-default-3] The outgoing batch 000-310 failed: Odd => Support LOB data types like TEXT on Informix |
| 2019-10-27 16:07 | elong | Tag Attached: dialect: informix | |
| 2019-10-27 16:08 | elong | Relationship added | related to 0004087 |
| 2025-04-30 17:48 | cquamme | Priority | normal => low |
| 2025-04-30 17:48 | cquamme | Status | new => confirmed |