Sink connector 'sink-postgres' is configured with 'delete.enabled=false' and 'pk.mode=none'

Skip to first unread message

Natarajan Sundaramoorthy

May 6, 2021, 6:04:01 PM5/6/21
to Confluent Platform
Trying to load data from kafka to postgres and running into below error.

Can you please help? Does json which we move from kakfa to postgres should have schema in it?

org.apache.kafka.connect.errors.ConnectException: Sink connector 'sink-postgres' is configured with 'delete.enabled=false' and 'pk.mode=none' and therefore requires records with a non-null Struct value and non-null Struct schema, but found record at (topic='test',partition=0,offset=0,timestamp=1620338169130) with a null value and null value schema.
        at io.confluent.connect.jdbc.sink.RecordValidator.lambda$requiresValue$2(
        at io.confluent.connect.jdbc.sink.BufferedRecords.add(
        at io.confluent.connect.jdbc.sink.JdbcDbWriter.write(
        at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(
        at org.apache.kafka.connect.runtime.WorkerSinkTask.deliverMessages(
        at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(
        at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(
        at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(
        at org.apache.kafka.connect.runtime.WorkerTask.doRun(
        at java.util.concurrent.Executors$
        at java.util.concurrent.ThreadPoolExecutor.runWorker(
        at java.util.concurrent.ThreadPoolExecutor$

samprati sharma

May 6, 2021, 11:08:34 PM5/6/21
Hi Natarajan, 

From error, it is clear that you are publishing records with value as "null". Such records are called tombstone records. 

To handle such records so that connectors won't fail, you have to apply tombstone transformation.

Samprati Sharma 

You received this message because you are subscribed to the Google Groups "Confluent Platform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To view this discussion on the web visit
Reply all
Reply to author
0 new messages