Software-update: CockroachDB 2.0.4

Het team achter CockroachDB heeft versie 2.0.4 uitgebracht. Dit is een opensourcedatabase die uitermate geschikt is voor cloudomgevingen en die verschillende opties voor het opvangen van problemen biedt, dankzij de verspreide opzet. Voor meer informatie verwijzen we naar deze pagina, waar de meest gestelde vragen worden beantwoord. De lijst met veranderingen ziet er als volgt uit:

SQL Language Changes

• CHECK constraints are now checked when updating a conflicting row in INSERT ... ON CONFLICT DO UPDATE statements. #26699
• An error is now returned to the user instead of panicking when trying to add a column with a UNIQUE constraint when that column's type is not indexable. #26728

Command-Line Changes

• CockroachDB now computes the correct number of replicas on down nodes. Therefore, when decommissioning nodes via the cockroach node decommission command, the --wait=all option no longer hangs indefinitely when there are down nodes. As a result, the --wait=live option is no longer necessary and has been deprecated. #27158

Bug Fixes

• Fixed a typo on Node Map screen of the Admin UI. #27129
• Fixed a rare crash on node decommissioning. #26717
• Joins across two interleaved tables no longer return incorrect results under certain circumstances when the equality columns aren't all part of the interleaved columns. #26832
• Successes of time series maintenance queue operations are no longer counted as errors in the Metrics dashboard of the Admin UI. #26820
• Prevented a situation in which ranges repeatedly fail to perform a split. #26944
• Fixed a crash that could occur when distributed LIMIT queries were run on a cluster with at least one unhealthy node. #26953
• Failed IMPORTs now begin to clean up partially imported data immediately and in a faster manner. #26986
• Alleviated a scenario in which a large number of uncommitted Raft commands could cause memory pressure at startup time. #27024
• The pg-specific syntax SET transaction_isolation now supports settings other than SNAPSHOT. This bug did not affect the standard SQL SET TRANSACTION ISOLATION LEVEL. #27047
• The DISTINCT ON clause is now reported properly in statement statistics. #27222
• Fixed a crash when trying to plan certain UNION ALL queries. #27233
• Commands are now abandoned earlier once a deadline has been reached. #27215
• Fixed a panic in IMPORT when creating a table using a sequence operation (e.g., nextval()) in a column's DEFAULT expression. #27294

Doc Updates

• Added a tutorial on benchmarking CockroachDB with TPC-C. #3281
• Added systemd configs and instructions to deployment tutorials. #3268
• Updated the Kubernetes tutorials to reflect that pods aren't "Ready" before init. #3291

Versienummer	2.0.4
Releasestatus	Final
Besturingssystemen	Windows 7, Linux, macOS, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016
Website	Cockroach Labs
Download	https://www.cockroachlabs.com/docs/releases/v2.0.4.html
Licentietype	Voorwaarden (GNU/BSD/etc.)