Publication date: December 20, 2022
In CockroachDB v22.1.6 to v22.1.9, changefeeds using the
initial_scan='only' option can complete with a
successful status even if not all messages have been emitted to the sink. This occurs consistently unless the table is very small.
The same issue may occur if a changefeed with
schema_change_policy='stop' encounters a schema change. The changefeed may not emit any changes that occurred prior to the schema change being emitted.
This is resolved in CockroachDB by #90241, which ensures all events correctly flush out of all buffers prior to the changefeed exiting.
The fix has been applied to maintenance releases of CockroachDB v22.1.10 and later.
This public issue is tracked by #90146.
Data expected to be emitted by changefeeds may not be complete.
Please reach out to the support team if more information or assistance is needed.