> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Technical Advisory 90146

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

Publication date: December 20, 2022

## Description

In CockroachDB <InternalLink version="releases" path="v22.1">v22.1.6</InternalLink> to <InternalLink version="releases" path="v22.1">v22.1.9</InternalLink>, changefeeds using the [`initial_scan='only'`](https://www.cockroachlabs.com/docs/v22.1/create-changefeed#initial-scan) 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'`](https://www.cockroachlabs.com/docs/v22.1/create-changefeed#options) encounters a schema change. The changefeed may not emit any changes that occurred prior to the schema change being emitted.

## Statement

This is resolved in CockroachDB by a fix that ensures all events correctly flush out of all buffers prior to the changefeed exiting.

The fix has been applied to maintenance releases of CockroachDB <InternalLink version="releases" path="v22.1">v22.1.10</InternalLink> and later.

## Mitigation

Users of CockroachDB <InternalLink version="releases" path="v22.1">v22.1.6</InternalLink> to <InternalLink version="releases" path="v22.1">v22.1.9</InternalLink> are encouraged to upgrade to <InternalLink version="releases" path="v22.1">v22.1.10</InternalLink> or a later version.

## Impact

Data expected to be emitted by changefeeds may not be complete.

Please reach out to the [support team](https://support.cockroachlabs.com/) if more information or assistance is needed.
