-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
False
-
-
False
-
Moderate
In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
3.0.7.Final (also tested on 2.7.4.Final, same result)
What is the connector configuration?
(edited for brevity)
{
"connector.class": "io.debezium.connector.mysql.MySqlConnector",
"snapshot.locking.mode": "none",
"transforms": "unwrap",
"signal.enabled.channels": "source,kafka",
"heartbeat.action.query": "UPDATE streamkap.streamkap_heartbeat SET text = 'updated_heartbeat1', last_update = CURRENT_TIMESTAMP WHERE id = 1;",
"transforms.unwrap.drop.tombstones": "true",
"signal.data.collection": "streamkap.streamkap_signal",
"transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState",
"database.user": "****",
"signal.kafka.bootstrap.servers": "****:9092",
"signal.kafka.topic": "source_67a0.streamkap_signal",
"heartbeat.interval.ms": "1000",
"transforms.unwrap.field.name.adjustment.mode": "avro",
"transforms.unwrap.add.fields.prefix": "_streamkap_",
"database.password": "****",
"name": "source_67a0",
"snapshot.mode": "schema_only",
"connect.timeout.ms": "10000",
"transforms.unwrap.delete.handling.mode": "rewrite",
"schema.history.internal.store.only.captured.databases.ddl": "false",
"schema.history.internal.store.only.captured.tables.ddl": "false",
"topic.prefix": "source_67a0",
"database.server.id": "1738593595",
"read.only": "false",
"database.port": "3306",
"database.connectionTimeZone": "SERVER",
"database.hostname": "****",
"table.include.list": "ecommerce.Customers,streamkap.streamkap_signal,streamkap.streamkap_heartbeat"
}
What is the captured database version and mode of deployment?
AWS RDS MySQL, 8.0.28
What behavior do you expect?
The action query to update an entry in the configured heartbeat table on the configured interval.
What behavior do you see?
Action query is only executed when one of the other capture tables has a change event e.g. insert into ecommerce.Customers.
Do you see the same behaviour using the latest released Debezium version?
Not tested.
Do you have the connector logs, ideally from start till finish?
Yes.
