【 使用环境 】测试环境
【 OB or 其他组件 】OMS
【 使用版本 】4.1.1
【问题描述】迁移pg某个表时，字段类型为timestamp,提示乱码，解析时间失败，导致迁移失败
【复现路径】PG迁移数据至OCEANBASE
【问题现象及影响】
异常堆栈信息
903
java.lang.RuntimeException: java.lang.RuntimeException: unrecognized date format �R~�
904
at com.oceanbase.oms.dataflow.common.stream.StreamRecordBatchBuilder.next(StreamRecordBatchBuilder.java:89)
905
at com.oceanbase.oms.dataflow.common.stream.StreamRecordBatchBuilder.next(StreamRecordBatchBuilder.java:20)
906
at com.oceanbase.connector.framework.threadmanager.sourcetask.ConditionedSourceConnectorTask.pollQueryConditionWithRetry(ConditionedSourceConnectorTask.java:117)
907
at com.oceanbase.connector.framework.threadmanager.sourcetask.ConditionedSourceConnectorTask.run(ConditionedSourceConnectorTask.java:68)
908
at java.lang.Thread.run(Thread.java:853)
909
Caused by: java.lang.RuntimeException: unrecognized date format �R~�
910
at com.oceanbase.oms.record.value.fieldvalue.timespec.GeneralDate$ISODateFormatParser.parseGeneralDate(GeneralDate.java:216)
911
at com.oceanbase.oms.record.value.fieldvalue.timespec.GeneralDateTime.parse(GeneralDateTime.java:169)
912
at com.oceanbase.oms.record.value.fieldvalue.timespec.GeneralDateTime.parseDateTime(GeneralDateTime.java:227)
913
at com.oceanbase.oms.dataflow.jdbcclient.postgres.PostgresResultSetValueGetterCenter.getTimestampWithoutZoned(PostgresResultSetValueGetterCenter.java:71)
914
at com.oceanbase.oms.dataflow.jdbcclient.AbstractQueryClient.getValue(AbstractQueryClient.java:199)
915
at com.oceanbase.oms.dataflow.jdbcclient.AbstractQueryClient.lambda$queryDataBySlice$1(AbstractQueryClient.java:773)
916
at com.oceanbase.oms.dataflow.common.stream.StreamRecordFetcher.next(StreamRecordFetcher.java:75)
917
at com.oceanbase.oms.dataflow.common.stream.StreamRecordBatchBuilder.next(StreamRecordBatchBuilder.java:74)
918
... 4 common frames omitted
每次暂停，恢复都会跑一批数据然后失败
【附件】
日期数据
sys_mapper_table_1_202311081705.csv.zip (110.3 KB)