Cockroach Labs supports the current stable release and two releases prior. Therefore, this version will no longer be supported after the Spring 2020 release.

September 17, 2018

Get future release notes emailed to you:


Backward-incompatible changes

  • CHANGEFEEDs created with previous betas and alphas will not work with this version. #29559
  • The experimental, non-recommended kv.allocator.stat_based_rebalancing.enabled and kv.allocator.stat_rebalance_threshold cluster settings have been replaced by an improved approach to load-based rebalancing that can be controlled via the new kv.allocator.load_based_rebalancing cluster setting. By default, leases will be rebalanced within a cluster to achieve better QPS balance. #29663

SQL language changes

  • Renamed the EXPERIMENTAL_OPT session setting to OPTIMIZER. The default value is ON, as before. #29530
  • Special characters, such as newlines, are now formatted using octal, instead of hex, for compatibility with PostgreSQL. #29593

Command-line changes

  • All cockroach client sub-commands (except for cockroach workload) now support the --url flag. #29621
  • Removed --log-backtrace-at and --verbosity flags, which were documented as being only useful by CockroachDB developers yet never actually used by CockroachDB developers. #30092

Admin UI changes

  • Long table rows now wrap, when necessary. #29551
  • Diagnostics requests are now proxied through Cockroach Labs to prevent exposing user IP addresses. #29194
  • Added attributes to the login form to allow LastPass to properly recognize it. #29561
  • Custom and regular charts now have the same width. #30083
  • Improved the UX of the Custom Chart page, and added the ability to configure multiple independent charts. #30118
  • Improved the design and accessibility of tooltips. #30115
  • Various improvements to the Statements pages. #30115
    • Simplified and cleaned-up the appearance.
    • Added statement retries.
    • Right-aligned all numeric stats.
    • Added more tooltips, including for the By Gateway Node table on the Statement Details page.
    • Improved tooltips by adding a legend detailing the parts of the bar chart.
    • Highlighted summary rows.
    • Improved table headers.
    • Reordered tables to highlight the most useful data.
    • Widened bar charts.
    • Summarized SET statements.
    • When a statement fingerprint has sometimes failed, used the optimizer, or been distributed, the number of matching executions is now shown.

Bug fixes

  • Fixed a bug that would allow the cluster summary text in the Admin UI to overflow its space. #29548
  • Corrected the behavior of INSERT INTO t DEFAULT VALUES when there are active schema changes. #29496
  • Fixed a race condition in IMPORT with a column that was a collated string. #29386
  • Fixed crash caused by certain kinds of UPSERT ... RETURNING statements on tables with active schema changes. #29543
  • CHANGEFEEDs now error when a watched table backfills (instead of undefined behavior). #29559
  • Fixed a panic that occurs when verbose logging is enabled. #29534
  • Fixed a panic caused by inserting values of the wrong type into columns depended on by computed columns. #29598
  • Fixed an issue where, under severe load, clients were sometimes receiving retryable errors with a non-retryable error code. #29614
  • The cockroach gen haproxy command now recognizes nodes that specify the HTTP port number using --http-addr instead of --http-port. #29536
  • Fixed a panic in SQL execution. #29669
  • Fixed a panic caused by malformed UTF-8 SQL strings. #29668
  • Corrected the Postgres oid type returned for collated string columns. #29674
  • Enterprise CHANGEFEEDs now correctly skip the initial scan when started with the cursor= option. #29613
  • Hash functions with NULL input now return NULL. #29974
  • Prevented a very rare premature failure in CHANGEFEEDs caused by a race condition with range splits. #30009
  • Fixed a crash when SELECT MIN(NULL) was run with the SQL optimizer enabled. #30014
  • Fixed a rare crash with the message retryable error for the wrong txn. #30046
  • Fixed a bug where certain queries, like merge joins, would appear to run out of memory due to incorrect memory accounting and fail. #30087
  • The string_agg() function can now accept a NULL as a delimiter. #30076

Performance improvements

  • Range replicas are now automatically rebalanced throughout the cluster to even out the amount of QPS being handled by each node. #29663
  • Prevented allocation when checking RPC connection health. #30055

Doc updates


This release includes 87 merged PRs by 23 authors. We would like to thank the following contributors from the CockroachDB community:

  • Sankt Petersbug (first-time contributor)

Yes No