What's New in v2.0-beta.20180326

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

March 26, 2018

Get future release notes emailed to you:


General Changes

  • A CockroachDB process now flushes its logs upon receiving SIGHUP instead of SIGUSR1 as it did earlier. This is aimed to simplify the automation of process monitoring, test, and backup tools. #23783
  • Information about zone config usage is now included in diagnostic reports. #23750

Enterprise Edition Changes

SQL Language Changes

  • SQL features introduced in CockroachDB v2.0 cannot be used in clusters that are not upgraded fully to v2.0. #24013
  • Added an escape option to the encode() and decode() built-in functions. #23781
  • Introduced a series of PostgreSQL-compatible, privilege-related built-in functions. #23839
  • Added the pg_language table to the pg_catalog virtual schema. #23839
  • Added the anyarray type to the pg_type virtual schema. #23836
  • Retryable errors on schema change operations are now less likely to be returned to clients; more operations are retried internally. #24050

Command-Line Changes

  • Client commands now report a warning if the connection URL is specified by the --url as well as some other command-line flag. If you use the --url flag, other flags can fill in pieces missing from the URL.
  • Added per-node heap profiles to the debug zip command output. #23858

Admin UI Changes

  • More debug pages are now locked down by the server.remote_debugging.mode cluster setting. #24022
  • The Network Diagnostics report no longer crashes when the latencies are very small or on a single node cluster. #23868
  • Fixed the flicker in the Node Map as data is being reloaded. #23757
  • Fixed the text overflowing past the table cell boundaries on the Jobs page. #23748
  • Updated the labels for the Snapshots graph on the Replication dashboard to be more specific. #23742
  • Fixed a bug where graphs would not display on clusters with large numbers of nodes. #24045
  • Decommissioned nodes no longer appear in the node selection dropdown on the Metrics page. #23800
  • Fixed a condition where a persistent trailing dip could appear in graphs for longer time periods. #23874

Bug Fixes

  • Redacted string values in debug API responses. #24070
  • Old replicas are now garbage collected in a more timely fashion after a node has been offline for a long time (this bug only exists in recent v2.0 alpha/beta releases, not in v1.1). #24066
  • Fixed a bug where some inverted index queries could return incorrect results. #23968
  • Fixed the behavior of the @> operator with arrays and scalars. #23969
  • Inverted indexes can no longer be hinted for inappropriate queries. #23989
  • Enforced minimum privileges for the admin role. #23935
  • A panic is now avoided if the SQL audit log directory does not exist when the node is started. #23928
  • Supported Postgres syntax for USING GIN. #23910
  • Fixed a bug where INSERT/DELETE/UPDATE/UPSERT may lose updates if run using WITH or the [ ... ] syntax. #23895
  • Made sure that all built-in functions have a unique Postgres OID for compatibility. #23880
  • Fixed an error message generated by the experimental SCRUB feature. #23845
  • Fixed a bug where CREATE VIEW after ALTER TABLE ADD COLUMN would fail to register the dependency on the newly added column. #23845
  • Fixed crashes or incorrect results when combining an OUTER JOIN with a VALUES clause that contains only NULL values on a column (or other subqueries which result in a NULL column). #23838
  • Fixed rare nil pointer exception in rebalance target selection. #23807
  • The cockroach zone set command will now automatically retry if it encounters an error while setting zone configurations. #23782
  • Fixed a bug where closing a connection in the middle of executing a query sometimes crashed the server. #23761
  • Fixed a bug where expressions could be mistakenly considered equal, despite their types being different. #23722
  • Fixed a bug where the RANGE COUNT metric on the Cluster Overview page of the Admin UI could significantly undercount the number of ranges. #23746
  • The client URL reported upon cockroach start now does not include the option application_name. #23894

Performance Improvements

  • Improved cluster performance during overload scenarios. #23884

Doc Updates


This release includes 64 merged PRs by 23 authors. We would like to thank the following contributors from the CockroachDB community, with special thanks to first-time contributors Bob Vawter.

YesYes NoNo