Bug report

During a discussion about a good change event id, we found out thet the rs_id in null in the metada.

chat: https://debezium.zulipchat.com/#narrow/stream/348250-community-oracle/topic/Unique.20id.20for.20debezium.20messages

There is an example of the issue in zulip

What Debezium connector do you use and what version?

Using oracle connector with Debezium 2.1.2.Final

What is the connector configuration?

debezium.source.connector.class=io.debezium.connector.oracle.OracleConnector
debezium.source.table.include.list= .... *(6 tables)
debezium.source.schema.history.internal.store.only.captured.tables.ddl=true
debezium.source.schema.history.internal=io.debezium.storage.file.history.FileSchemaHistory
debezium.source.schema.history.internal.file.filename=data/schema.dat
debezium.source.database.history.store.only.captured.tables.ddl=true
debezium.source.database.history=io.debezium.relational.history.FileDatabaseHistory
debezium.source.database.history.file.filename=data/history.dat
debezium.source.offset.storage.file.filename=data/offsets.dat

debezium.source.log.mining.buffer.infinispan.cache.transactions=<local-cache name="transactions"><persistence passivation="false"><file-store read-only="false" preload="true" shared="false"><data path="./data"/><index path="./data"/></file-store></persistence></local-cache>
debezium.source.log.mining.buffer.infinispan.cache.processed_transactions=<local-cache name="processed-transactions"><persistence passivation="false"><file-store read-only="false" preload="true" shared="false"><data path="./data"/><index path="./data"/></file-store></persistence></local-cache>
debezium.source.log.mining.buffer.infinispan.cache.schema_changes=<local-cache name="schema-changes"><persistence passivation="false"><file-store read-only="false" preload="true" shared="false"><data path="./data"/><index path="./data"/></file-store></persistence></local-cache>
debezium.source.log.mining.buffer.infinispan.cache.events=<local-cache name="events"><persistence passivation="false"><file-store read-only="false" preload="true" shared="false"><data path="./data"/><index path="./data"/></file-store></persistence></local-cache>

debezium.source.snapshot.locking.mode=none
debezium.source.log.mining.strategy=online_catalog
debezium.source.decimal.handling.mode=double

1. When metadata is true, db transaction data will be sent as well
   debezium.source.provide.transaction.metadata=true
   debezium.source.value.converter.schemas.enable=false

quarkus.log.console.json=false
quarkus.log.level=info

1. Database connection params
   debezium.source.database.url= ...

• debezium.source.database.user=...
• debezium.source.database.password=...
• debezium.source.database.dbname=...
• debezium.source.database.pdb.name=..
• debezium.source.database.server.name=...

• debezium.source.snapshot.mode=initial

• debezium.source.log.mining.transaction.retention.hours=1
• debezium.source.log.mining.archive.log.hours=1

• debezium.source.snapshot.fetch.size=325000
• debezium.source.max.batch.size=325000
• debezium.source.max.queue.size=650000

• debezium.source.log.mining.buffer.type=infinispan_embedded

• debezium.source.log.mining.sleep.time.max.ms=15000

1. Nats configuration

• debezium.sink.type=nats-jetstream
• debezium.sink.nats-jetstream.url=nats://nats:4222
• debezium.source.topic.prefix=...

1. Initial snapshot select overrides
   ....

   What is the captured database version and mode of depoyment?

io.debezium.connector.oracle.OracleConnection - Database Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
2023-04-12 16:58:25 Version 19.3.0.0.0

Running in a docker container

What behaviour do you expect?

rs_id should be populated

What behaviour do you see?

rs_id is null

Do you see the same behaviour using the latest relesead Debezium version?

Checked with Debezium 2.2.0.Alpha3. Issue is present.