What's New in v21.1.0-beta.4

April 19, 2021

Get future release notes emailed to you:

Downloads

Warning:
The CockroachDB executable for Windows is experimental and not suitable for production deployments. Windows 8 or higher is required.
Warning:

Beta releases are intended for testing and experimentation only. Beta releases are not recommended for production use, as they can lead to data corruption, cluster unavailability, performance issues, etc.

Docker image

icon/buttons/copy
$ docker pull cockroachdb/cockroach-unstable:v21.1.0-beta.4

General changes

  • Removed experimental feature UNIQUE WITHOUT INDEX from the documentation. #63499

SQL language changes

  • The pg_get_partkeydef builtin function is now implemented by always returning NULL. #63149
  • CockroachDB now collects execution stats for all statements when seen for the first time. To disable this behavior, set the sql.txn_stats.sample_rate cluster setting to 0, which will disable all execution stats collection. #63325
  • CockroachDB will now block the ability to set the initial PRIMARY REGION of a database if any multi-region fields on any zone configs in the database have been set. #63354
  • CockroachDB now introduces a pgcode when attempting to DROP REGION when the region being dropped is the PRIMARY REGION. #63354
  • Replaced the word "tuple" with its more user-friendly synonym "row" in vectorized stats outputs. #62956
  • Changed BACKUP of interleaved tables to require the include_deprecated_interleaves option as interleaved table backups will not be able to be restored in future versions of CockroachDB. #63501

Operational changes

  • RESTORE now cannot restore BACKUPs made by newer versions of CockroachDB. #62398

DB Console changes

The following statements now render correctly as events in the DB Console #63141: - ALTER DATABASE ADD REGION - ALTER DATABASE SET PRIMARY REGION - ALTER DATABASE ... SURVIVE ... FAILURE - ALTER DATABASE DROP REGION - CREATE TYPE - ALTER TYPE - DROP TYPE

Bug fixes

  • Fixed a bug present in earlier 21.1 versions where BACKUPs would produce an error when they should be able to backup the underlying data. #63095
  • Dropping a foreign key that was added in the same transaction no longer triggers an internal error. This bug has been present since at least version 20.1. #62879
  • Fixed a bug where an ALTER TABLE ... ADD COLUMN ... UNIQUE statement would cause an error if the table had a PARTITION ALL BY or REGIONAL BY ROW definition. #63189
  • Fixed a bug in earlier 21.1 versions where CREATE TABLE LIKE would copy a VIRTUAL column from the source table as a STORED column in the destination table. #63172
  • CockroachDB now returns an error when trying to perform a backup of a cluster that was taken on another tenant. #63223
  • Fixed a bug where index backfill data may have been missed by BACKUP in incremental backups. #63221
  • Fixed a bug where REGIONAL BY ROW zone configs were dropped before REGIONAL BY ROW changes are finalized. This caused a bug when the REGIONAL BY ROW transformation fail. #63274
  • Fixed a case where implicitly partitioned columns (e.g., from REGIONAL BY ROW tables and hash-sharded indexes) previously showed as implicit = false when using SHOW INDEXES or querying information_schema.pg_indexes. #63275
  • Fixed an error that could occur when performing an UPSERT on a REGIONAL BY ROW table with no secondary indexes or foreign keys. The error, 'missing "crdb_region" primary key column', has now been fixed. #63257
  • Fixed a bug where tables that were created by CockroachDB 19.x or older that included foreign key constraints and were backed up with the revision_history option would be malformed when restored by a CockroachDB 20.x cluster if the RESTORE used the AS OF SYSTEM TIME option. #63267
  • Fixed a bug in user-defined schemas where the dropping of any schema would prevent creation of schemas with the name of the database and would corrupt already existing schemas of that name. #63395
  • Fixed a bug in previous CockroachDB 21.1 releases where CockroachDB would sometimes return the output in an incorrect order if a query containing hash-aggregation was executed via the vectorized execution engine and spilled to temporary storage. #63408
  • Fixed a bug where incremental cluster backups may have missed data written to tables while they were OFFLINE. In practice this could have occurred if a RESTORE or IMPORT was running across incremental backups. #63304
  • CockroachDB now includes more anonymized data from SQL statements in telemetry updates and crash reports. #63482
  • Fixed a rare issue that caused replica divergence. If this occurred the divergence was reported by the replica consistency checker, typically within 24 hours of occurrence, and caused the nodes to terminate. #63473

Performance improvements

  • Improved performance of reverting IMPORT INTO jobs that IMPORT INTO empty tables. #63220

Miscellaneous improvements

  • Made the Kafka library used in changefeeds configurable using the kafka_sink_config option to enable latency versus throughput configurations. #63361
  • Connected the changefeed memory monitor to the parent SQL monitor to ensure that changefeeds do not try to use more memory than is available to the SQL server. #63409

Contributors

This release includes 50 merged PRs by 20 authors.

YesYes NoNo