May 20, 2019
This page lists additions and changes in v19.1.1 since v19.1.0.
- For a comprehensive summary of features in v19.1, see the v19.1 GA release notes.
- To upgrade to v19.1, see Upgrade to CockroachDB v19.1
Warning:
Cockroach Labs has discovered a bug relating to incremental backups, for CockroachDB v19.1.0 - v19.1.11. 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.
For more information, including other affected versions, see Technical Advisory 63162.
Get future release notes emailed to you:
Downloads
Docker image
$ docker pull cockroachdb/cockroach:v19.1.1
Enterprise edition changes
CHANGEFEEDs now accept akey_in_valueoption; this is automatically used for cloud storage sinks, making the primary key of deleted rows recoverable. #37328
SQL language changes
EXPLAIN (DISTSQL) CREATE STATISTICSnow shows the DistSQL plan used by theCREATE STATISTICSjob. #37237- Added missing columns to
information_schema.columns. #37283
Bug fixes
- Prevented panics when adding comments to database objects at high verbosity. #37325
- Fixed panics when trying to run certain
SHOWcommands via the pgwire prepare path. #37325 - Fixed a regression in 19.1 that prevented empty arrays from being accepted over pgwire. #37398
- While a cluster is unavailable (e.g., during a network partition), memory and goroutines used for authenticating connections no longer leak when the client closes said connections. #36177
- Fixed a possible panic while recovering from a WAL on which a sync operation failed. #37109
- Fixed an error which could occur when a zigzag join was performed against a table with dropped columns. #37245
- Fixed incorrect query plans/results when non-validated FK constraints are not satisfied by the data. #37253
CHANGEFEEDs now retry instead of causing errors in more situations. #37092- Fixed a bug where
CHANGEFEEDjob progress would regress when the job was restarted. #37091 - The
changefeed.max_behind_nanosmetric now has fewer false positives of changefeeds falling behind. #37048 - Corrected the names of some columns for tables created with
CREATE TABLE <name> AS <query>. #37238 - Fixed a bug causing unvalidated check constraints to disappear from the output of
SHOW CONSTRAINTSand to not be referenced inALTER TABLEafter upgrading to 19.1. #37462
Performance improvements
- Improved the performance of some queries containing predicates with constant functions, since these functions are now evaluated earlier during query optimization. #37234
- Improved the performance of some queries by teaching the optimizer to always prefer constrained scans over unconstrained scans. #37235
Doc updates
- Updated the Kubernetes tutorials for running CockroachDB on GKE to specify a reasonable machine type. Also updated the Helm-specific instructions for maintenance tasks (adding/removing nodes, upgrading a cluster).#4813 #4805
- Fixed the code sample in Build a PHP App with CockroachDB to not create new connections for each query. #4804.
Contributors
This release includes 28 merged PRs by 14 authors.
Was this helpful?
