What's New in v19.2.1

This version of CockroachDB is no longer supported. For more details, see the Release Support Policy.

November 25, 2019

This page lists additions and changes in v19.2.1 since v19.2.0.


A denial-of-service (DoS) vulnerability is present in CockroachDB v19.2.0 - v19.2.11 due to a bug in protobuf. This is resolved in CockroachDB v19.2.12 and later releases. When upgrading is not an option, users should audit their network configuration to verify that the CockroachDB HTTP port is not available to untrusted clients. We recommend blocking the HTTP port behind a firewall.

For more information, including other affected versions, see Technical Advisory 58932.


Cockroach Labs has discovered a bug relating to incremental backups, for CockroachDB v19.2.0 - v19.2.12. If a backup coincides with an in-progress index creation (backfill), RESTORE, or IMPORT, it is possible that a subsequent incremental backup will not include all of the indexed, restored or imported data.

Users are advised to upgrade to v20.1.15 or v20.2.8 or later, which includes resolutions.

For more information, including other affected versions, see Technical Advisory 63162.

Get future release notes emailed to you:


Docker image

$ docker pull cockroachdb/cockroach:v19.2.1

SQL language changes

Command-line changes

  • When restarting a node, CockroachDB now provides a hint to ensure that all cockroach start commands include the --join flag. #42325

Bug fixes

  • Reduced the likelihood of out-of-memory errors during histogram collection. #42370
  • Fixed an out-of-memory error that could occur when collecting statistics on tables with a string index column. #42380
  • Fixed some casts from OID to TEXT. #42257
  • OUTER HASH joins are now executed correctly via the vectorized engine when NULL values are present. #42438
  • Fixed a bug in the crdb_internal.encode_key() built-in function that could cause SHOW RANGE FOR ROW statements on tables with dropped indexes to return incorrect results or an error. #42461
  • Prevented memory leaks when counting rows during BACKUP. #42535

Performance improvements

  • The ./cockroach debug check-store command is now faster. #42150
  • Improved statistics estimation during query planning for columns with many NULL values. #42436


This release includes 12 merged PRs by 8 authors.

YesYes NoNo