Release Notes for CockroachDB v1.1.6 and v2.0-beta.20180312

(Swati Kumar) #1

March 12, 2018

Happy Monday!

This week, we had both, a production release and a beta release - CockroachDB v1.1.6 and CockroachDB v2.0-beta.20180312. The production release includes bug fixes and stability improvements. The beta release includes:

Upgrade your version of CockroachDB here and let us know what you think!

The Cockroach Labs Team

CockroachDB v1.1.6

General Changes

Bug Fixes

  • Prevented disruptions in performance when gracefully shutting down a node. #23302
  • Fixed a zero QPS scenario when gracefully shutting down a node. #23306
  • Fixed a panic caused by empty COCKROACH_UPDATE_CHECK_URL or COCKROACH_USAGE_REPORT_URL environment variables. #23008
  • The conversion from INTERVAL to FLOAT now properly returns the number of seconds in the interval. #22893
  • Fixed a bug that caused queries of virtual tables with an explicit database name prefix (e.g. select * from mydb.crdb_internal.tables) to not get scrubbed properly in diagnostics reporting. #22815
  • A COMMIT reporting an error generated by a previous parallel statement (i.e., RETURNING NOTHING) no longer leaves the connection in an aborted transaction state. Instead, the transaction is considered completed and a ROLLBACK is not necessary. #22814
  • Fixed an issue with stale buffer data when using the binary format for ARRAY values. #22262
  • Fixed a bug that caused SQL connection errors during node startup. #22663
  • Fixed a bug that included decommissioned nodes in cluster stats aggregates. #22864


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

  • Xudong Zheng

CockroachDB v2.0-beta.20180312

Build Changes

  • Binaries are now built with Go 1.10 by default. #23311

General Changes

  • Logging data is now flushed to files every second to aid troubleshooting and monitoring. Synchronization to disk is performed separately every 30 seconds. #23231
  • Disabling diagnostics reporting also disables new version notification checks. #23007
  • Removed the diagnostics.reporting.report_metrics cluster setting, which is duplicative with the COCKROACH_SKIP_ENABLING_DIAGNOSTIC_REPORTING environment variable. #23007
  • All internal error messages are now logged when logging is set to a high enough verbosity. #23127

SQL Language Changes

  • Improved handling of large DELETE statements. They are now either allowed to complete or exited with an error message indicating that the transaction is too large to complete. #23289
  • The pg_catalog virtual tables, as well as the special casts ::regproc and ::regclass, can now only be queried by clients that set a current database. #23148

Command-Line Changes

  • When a node spends more than 30 seconds waiting for an init command or to join a cluster, a help message now gets prints to stdout. #23181

Admin UI Changes

  • Added a new debug page that allows users to create a "custom" graph displaying any combination of metrics. #23227
  • In the geographical map on the homepage of the Admin UI enterprise version, node components now link to Note Details page. #23283
  • Removed the Keys Written per Second per Store graph. #23303
  • Added the Lead Transferee field to the Range Debug page. #23241

Bug Fixes

  • Fixed a correctness bug where some ORDER BY queries would not return the correct results. #23541
  • The Admin UI no longer hangs after a node's network configuration has changed. #23348
  • The binary format for JSONB values is now supported. #23215
  • A node now waits in an unready state for the length of time specified by the server.shutdown.drain_wait cluster setting before draining. This helps ensure that load balancers won't send client traffic to a node about to be drained. #23319
  • Fixed a panic when using UPSERT ... RETURNING with UNION. #23317
  • Prevented disruptions in performance when gracefully shutting down a node. #23300
  • Hardened the cluster version upgrade mechanism. Rapid upgrades through more than two versions could sometimes fail recoverably. #23287
  • Fixed a deadlock when tables are rapidly created or dropped. #23288
  • Fixed a small memory leak in IMPORT CSV. #23259
  • Prevented a panic in DistSQL under certain error conditions. #23201
  • Added a readiness endpoint (/health?ready=1) for better integration with load balancers. #23247
  • Fixed a zero QPS scenario when gracefully shutting down a node. #23246
  • Secondary log files (e.g., the SQL execution log) are now periodically flushed to disk, in addition to the flush that occurs naturally when single log files are full (--log-file-max-size) and when the process terminates gracefully. Log file rotation is also now properly active for these files. #23231
  • Previously, the ranges column in the node status command output only included ranges whose raft leader was on the node in question. It now includes the count of all ranges on the node, regardless of where the raft leader is. #23180
  • Fixed a panic caused by empty COCKROACH_UPDATE_CHECK_URL or COCKROACH_USAGE_REPORT_URL environment variables. [#23008][#23008]
  • Prevented stale reads caused by the system clock moving backwards while the cockroach process is not running. #23122
  • Corrected the handling of cases where a replica fails to retrieve the last processed timestamp of a queue. #23127
  • Fixed a bug where the liveness status would not always display correctly on the single-node page in the Admin UI. #23193
  • Fixed a bug that showed incorrect descriptions on the Jobs page in the Admin UI. #23256

Doc Updates


This release includes 44 merged PRs by 21 authors.