Software-update: CockroachDB 2.0.3

Het team achter CockroachDB heeft versie 2.0.3 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:

General Changes

• The new compactor.threshold_bytes and max_record_age cluster settings can be used to configure the compactor. #25458
• The new cluster.preserve_downgrade_option cluster setting makes it possible to preserve the option to downgrade after performing a rolling upgrade to v2.1. #25811

SQL Language Changes

• Prevented DROP TABLE from using too much CPU. #25852

Command-Line Changes

• The cockroach sql command no longer prompts for a password when a certificate is provided. #26232
• The cockroach quit command now prints warning messages to the standard error stream, not to standard output. #26163

Bug Fixes

• Prevented the internal gossip network from being partitioned by making it much less likely that nodes in the network could forget about each other. #25521
• Prevented spurious BudgetExceededErrors for some queries that read a lot of JSON data from disk. #25719
• Fixed a crash in some cases when using a GROUP BY with HAVING. #25654
• Fixed a crash caused by inserting data into a table with computed columns that reference other columns that weren't present in the INSERT statement. #25807
• UPSERT is now properly able to write NULL values to every column in tables containing more than one column family. #26181
• Fixed a bug where a long-running query running from one day to the next would not always produce the right value for current_date(). #26413
• Fixed a bug where cockroach quit would erroneously fail even though the node already successfully shut down. #26163
• Rows larger than 8192 bytes are now supported by the "copy from" protocol. #26641
• Trying to "copy from stdin" into a table that doesn't exist no longer drops the connection. #26641
• Previously, expired compactions could stay in the queue forever. Now, they are removed when they expire. #26659

Performance Improvements

• The performance impact of dropping a large table has been substantially reduced. #26615

Doc Updates

• Documented special syntax forms of built-in SQL functions and conditional and function-like operators, and updated the SQL operator order of precedence. #3192
• Added best practices on understanding and avoiding transaction contention and a related FAQ. #3156
• Improved the documentation of AS OF SYSTEM TIME. #3155
• Expanded the manual deployment guides to cover running a sample workload against a cluster. #3149
• Added FAQs on generating unique, slowly increasing sequential numbers and the differences between UUID, sequences, and unique_rowid(). #3104

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