# Kafka Postgres Sink Connector Schema Schema{io.debezium.time.Date:INT32} does not correspond to a known timestamp type format **URL:** \ **Category:** Kafka Connect\ **Created:** [1 June 2023 18:49 UTC](https://forum.confluent.io/t/kafka-postgres-sink-connector-schema-schema-io-debezium-time-date-int32-does-not-correspond-to-a-known-timestamp-type-format/7997 "2023-06-01T18:49:59Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Abdugani](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@Abdugani](https://forum.confluent.io/u/Abdugani)\ **Post date:** [1 June 2023 18:49 UTC](https://forum.confluent.io/t/kafka-postgres-sink-connector-schema-schema-io-debezium-time-date-int32-does-not-correspond-to-a-known-timestamp-type-format/7997/1 "2023-06-01T18:49:59Z")
Hello! Need help, I have multiple columns with different time types. ```auto transforms=unwrap,FirstConverter,SecondConverter,ThirdConverter,FourthConverter,FifthConverter,SixthConverter,CreatedConverter,UpdatedConverter transforms.FirstConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.FirstConverter.format=yyyy-MM-dd transforms.FirstConverter.field=to_transit_leaving_date transforms.FirstConverter.target.type=Date transforms.SecondConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.SecondConverter.format=HH:mm:ss transforms.SecondConverter.field=to_transit_leaving_time transforms.SecondConverter.target.type=Time transforms.ThirdConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.ThirdConverter.format=yyyy-MM-dd transforms.ThirdConverter.field=leaving_date transforms.ThirdConverter.target.type=Date transforms.FourthConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.FourthConverter.format=HH:mm:ss transforms.FourthConverter.field=leaving_time transforms.FourthConverter.target.type=Time transforms.FifthConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.FifthConverter.format=yyyy-MM-dd transforms.FifthConverter.field=arriving_date transforms.FifthConverter.target.type=Date transforms.SixthConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.SixthConverter.format=HH:mm:ss transforms.SixthConverter.field=arriving_time transforms.SixthConverter.target.type=Time transforms.CreatedConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.CreatedConverter.format=yyyy-MM-dd HH:mm:ss transforms.CreatedConverter.field=created_at transforms.CreatedConverter.target.type=Timestamp transforms.UpdatedConverter.type=org.apache.kafka.connect.transforms.TimestampConverter$Value transforms.UpdatedConverter.format=yyyy-MM-dd HH:mm:ss transforms.UpdatedConverter.field=updated_at transforms.UpdatedConverter.target.type=Timestamp time.precision.mode=connect ``` I get an error on startup ```auto Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: [2023-06-01 23:39:35,061] ERROR WorkerSinkTask{id=labor_migration-bus_tickets-sink-01-0} Task threw an uncaught and unrecoverable exception (org.apache.kafka.connect.runtime.WorkerTask:186) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: org.apache.kafka.connect.errors.ConnectException: Tolerance exceeded in error handler Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.errors.RetryWithToleranceOperator.execAndHandleError(RetryWithToleranceOperator.java:178) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.errors.RetryWithToleranceOperator.execute(RetryWithToleranceOperator.java:104) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.TransformationChain.apply(TransformationChain.java:50) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerSinkTask.convertAndTransformRecord(WorkerSinkTask.java:513) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerSinkTask.convertMessages(WorkerSinkTask.java:468) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(WorkerSinkTask.java:324) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(WorkerSinkTask.java:228) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(WorkerSinkTask.java:200) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:184) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:234) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at java.base/java.lang.Thread.run(Thread.java:829) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: Caused by: org.apache.kafka.connect.errors.ConnectException: Schema Schema{io.debezium.time.Date:INT32} does not correspond to a known timestamp type format Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.transforms.TimestampConverter.timestampTypeFromSchema(TimestampConverter.java:413) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.transforms.TimestampConverter.applyValueWithSchema(TimestampConverter.java:375) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.transforms.TimestampConverter.applyWithSchema(TimestampConverter.java:362) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.transforms.TimestampConverter.apply(TimestampConverter.java:279) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.TransformationChain.lambda$apply$0(TransformationChain.java:50) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.errors.RetryWithToleranceOperator.execAndRetry(RetryWithToleranceOperator.java:128) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: at org.apache.kafka.connect.runtime.errors.RetryWithToleranceOperator.execAndHandleError(RetryWithToleranceOperator.java:162) Jun 01 23:39:35 pg-cdc-1 connect-standalone.sh[138069]: ... 14 more ``` what is the problem? ---
**Author:** ![OneCricketeer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/onecricketeer/32/1551_2.png) [@OneCricketeer](https://forum.confluent.io/u/OneCricketeer)\ **Post date:** [5 June 2023 17:41 UTC](https://forum.confluent.io/t/kafka-postgres-sink-connector-schema-schema-io-debezium-time-date-int32-does-not-correspond-to-a-known-timestamp-type-format/7997/2 "2023-06-05T17:41:20Z")
Have you tried a time config other than `time.precision.mode=connect`? ---
**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\ **Post date:** [5 July 2023 17:41 UTC](https://forum.confluent.io/t/kafka-postgres-sink-connector-schema-schema-io-debezium-time-date-int32-does-not-correspond-to-a-known-timestamp-type-format/7997/3 "2023-07-05T17:41:41Z")
Closed on 5 July 2023 17:41 UTC This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.