What's New in v19.1.0-beta.20190225

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

February 25, 2019

Since our initial launch, Cockroach Labs has used semantic versioning in our release cycle guidelines. Two years, one major release, and n-patch fixes later, we're making the switch to Calendar Versioning. This means subscribers to our release notes will see quite the jump in today's version numbering, from last week's 2.1.5 to today's 19.1 beta. You can read more about the switch here.

Get future release notes emailed to you:


This release has a deadlock bug that may result in nodes getting stuck in certain situations. This bug will be fixed in next week's beta. In the meantime, restart stuck nodes to recover.

Docker image

$ docker pull cockroachdb/cockroach-unstable:v19.1.0-beta.20190225

General changes

  • Records for completed jobs are cleaned up automatically after two weeks. #34725
  • SHOW JOBS now returns only running and recently finished jobs. Older jobs can still be inspected via the crdb_internal.jobs table. #34829

Enterprise edition changes

  • nodelocal:// storage paths for BACKUP, RESTORE, and IMPORT may include a node-ID in the Host part of the URI. It is not currently used (any node can get sent work and will look in its local IO directory) but will likely be required in the future. #34797
  • CHANGEFEEDs targeting cloud sinks now partition files into date folders. #34813
  • The new kv.rangefeed.concurrent_catchup_iterators cluster setting limits the number of rangefeed catchup iterators a store will allow concurrently before queueing. #34890
  • The CHANGEFEED experimental_avro format now supports SQL columns of type DATE, TIME, UUID, INET, and JSONB. #34918

SQL language changes

  • Virtual tables in pg_catalog and information_schema now support COMMENT ON like regular tables. #33697

Bug fixes

  • Fixed a bug that could cause a Raft log to grow very large, which in turn could prevent replication changes. #34502
  • Prevented down nodes from obstructing log truncation on ranges they are a member of. This problem could cause replication to fail due to an overly large Raft log. #34712
  • Fixed a panic when subtracting an array containing null from a JSON datum. #34757
  • Fixed a panic during some UNION ALL operations with projections, filters, or renders directly on top of the UNION ALL. #34762
  • Fixed a panic when the subquery in UPDATE SET (a,b) = (...subquery...) returns no rows. #34804
  • Fixed a rare panic ("close of closed channel") when shutting down a server. #34823
  • Fixed a deadlock during IMPORT and RESTORE that caused all writes on a node to be stopped. #34830
  • Fixed a panic during planning of certain complex join queries. #34843
  • Fixed a panic when CREATE STATISTICS is run on clusters containing nodes with different versions of CockroachDB. #34842
  • Fixed a bug where servers would endlessly try to refresh table statistics on dropped tables. #34884
  • CockroachDB now only lists tables in pg_catalog.pg_tables, for compatibility with PostgreSQL. #34857
  • Fixed a panic when using EXPLAIN ANALYZE with certain mutation queries. #34991

Performance improvements

  • Subqueries used with EXISTS or as a scalar value now avoid fetching more rows than needed to decide the outcome. #34801

Doc updates


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

  • Jaewan Park
YesYes NoNo