View Issue Details

IDProjectCategoryView StatusLast Update
0004107SymmetricDSBugpublic2019-10-27 16:08
Reporterjinpengfei Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.10.4 
Summary0004107: Support LOB data types like TEXT on Informix
Description2019-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]
Tagsdialect: informix

Relationships

related to 0004087 new Informix LOB support 

Activities

jinpengfei

2019-10-10 09:22

reporter   ~0001613

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.

Issue History

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