| title | titleSuffix | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.custom | ms.topic |
|---|---|---|---|---|---|---|---|---|---|---|
SQL Server 2019 Big Data Clusters platform release notes |
SQL Server 2019 Big Data Clusters |
This article describes the latest updates and known issues for SQL Server Big Data Clusters. |
WilliamDAssafMSFT |
wiassaf |
hudequei, randolphwest |
10/22/2023 |
sql |
big-data-cluster |
linux-related-content |
release-notes |
[!INCLUDESQL Server 2019]
[!INCLUDEbig-data-clusters-banner-retirement]
The following release notes apply to [!INCLUDEssbigdataclusters-ver15]. This article is broken into sections for each release describing the CU changes. The article also lists known issues for the most recent releases of [!INCLUDEssbigdataclusters-ver15].
[!INCLUDEssbigdataclusters-ver15] is a fully containerized solution orchestrated by Kubernetes. Starting with [!INCLUDEsssql19-md] CU12, each release of SQL Server Big Data Clusters is tested against a fixed configuration of components. The configuration is evaluated with each release and adjustments are made to stay in-line with the ecosystem as Kubernetes continues to evolve.
Important
Kubernetes is a fast paced ecosystem. It is key to keep your platform updated in order to be secure, and to be on a tested configuration for SQL Server Big Data Clusters.
Warning
On [!INCLUDEsssql19-md] Cumulative Update 15, the upgrade order is critical. Upgrade your big data cluster to CU15 before upgrading the Kubernetes cluster to version 1.21. If the Kubernetes cluster is upgraded to version 1.21 before BDC is upgraded to CU14 or CU15 then the cluster will end up in error state and the BDC upgrade will not succeed. In this case, reverting back to Kubernetes version 1.20 will fix the problem.
The following table contains the tested configuration matrix for each release of SQL Server 2019 Big Data Clusters:
| Release | Container OS | Kubernetes API | Runtime | Data Storage | Log Storage |
|---|---|---|---|---|---|
| CU23 | Ubuntu 20.04 LTS | 1.25.4 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU22 | Ubuntu 20.04 LTS | 1.25.4 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU21 | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU20 | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU19 | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU18 GDR | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU18 | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU17 | Ubuntu 20.04 LTS | 1.23.1 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU16 GDR | Ubuntu 20.04 LTS | 1.21 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU16 | Ubuntu 20.04 LTS | 1.21 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU15 | Ubuntu 20.04 LTS | 1.21 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU14 | Ubuntu 20.04 LTS | 1.21 | containerd 1.4.6 CRI-O 1.20.4 |
Block only | Block only |
| CU13 | Ubuntu 20.04 LTS | 1.20 | containerd 1.4.6 CRI-O 1.20.0 |
Block only | Block only |
| CU12 | Ubuntu 20.04 LTS | 1.20 | containerd 1.4.3 docker 20.10.2 CRI-O 1.20.0 |
Block only | Block only |
Restrictions:
- SQL Server 2019 Big Data Clusters is supported as a workload. Microsoft provides support for the software components on the containers installed and configured by SQL Server 2019 Big Data Clusters only. The support team doesn't support Kubernetes itself, and other containers that might influence SQL Server 2019 Big Data Clusters behavior. For Kubernetes support, contact your certified Kubernetes distribution provider.
- SQL Server 2019 Big Data Clusters requires block storage for all persisted volumes. Management operation on top of the persisted volumes created and used by a big data cluster is a capability that depends on the storage provider including, for example, operations to expand persistent volumes (PVs). Reference your specific CSI storage provider documentation or the partner reference architecture and white papers.
- The open-source components included by SQL Server 2019 Big Data Clusters are fixed for that particular release and must not be updated or modified.
- Container images are provided "as-is". Composability features of Kubernetes aren't supported. Changing the set of container images in a SQL Server 2019 Big Data Cluster release, or to customize the containers, isn't supported.
Reference architecture and white papers for [!INCLUDEbig-data-clusters-nover] can be found on the following pages:
The following table lists the release history for [!INCLUDEssbigdataclusters-ver15]. For more information, see SQL Server 2019 Big Data Clusters cumulative updates history.
| Release 1 | [!INCLUDEssbigdataclusters-ver15] version | [!INCLUDE azure-data-cli-azdata] version 2 | Release date | Details |
|---|---|---|---|---|
| CU23 | 15.0.4335.1 | 20.3.12 | Jun 15 2023 | Libraries are same as CU19. |
| CU22 | 15.0.4322.2 | 20.3.12 | Jun 15 2023 | Libraries are same as CU19. |
| CU21 | 15.0.4316.3 | 20.3.12 | Jun 15 2023 | Tested configurations, libraries are same as CU19. |
| CU20 | 15.0.4312.2 | 20.3.12 | Apr 14 2023 | Tested configurations, libraries are same as CU19. |
| CU19 | 15.0.4298.1 | 20.3.12 | Feb 16 2023 | |
| CU18 GDR KB 5021124 | 15.0.4280.7 | 20.3.12 | Feb 14 2023 | |
| CU18 | 15.0.4261.1 | 20.3.12 | Sep 28 2022 | |
| CU17 | 15.0.4249.2 | 20.3.12 | Aug 11 2022 | |
| CU16 GDR KB 5014356 | 15.0.4236.7 | 20.3.12 | Jun 14 2022 | |
| CU16 | 15.0.4223.1 | 20.3.11 | May 2 2022 | |
| CU15 | 15.0.4198.2 | 20.3.10 | Jan 27 2022 | |
| CU14 | 15.0.4188.2 | 20.3.9 | Nov 22 2021 | |
| CU13 | 15.0.4178.15 | 20.3.8 | Sep 9 2021 | |
| CU12 | 15.0.4153.13 | 20.3.7 | Aug 4 2021 | |
| CU11 | 15.0.4138.2 | 20.3.5 | Jun 10 2021 | |
| CU10 | 15.0.4123.1 | 20.3.2 | Apr 6 2021 | |
| CU9 | 15.0.4102.2 | 20.3.0 | Feb 11 2021 | |
| CU8-GDR | 15.0.4083.2 | 20.2.6 | Jan 12 2021 | |
| CU8 | 15.0.4073.23 | 20.2.2 | Oct 19 2020 | |
| CU6 | 15.0.4053.23 | 20.0.1 | Aug 4 2020 | |
| CU5 | 15.0.4043.16 | 20.0.0 | June 22 2020 | |
| CU4 | 15.0.4033.1 | 15.0.4033 | March 31 2020 | |
| CU3 | 15.0.4023.6 | 15.0.4023 | March 12 2020 | |
| CU2 | 15.0.4013.40 | 15.0.4013 | Feb 13 2020 | |
| CU1 | 15.0.4003.23 | 15.0.4003 | Jan 7 2020 | |
| GDR1 | 15.0.2070.34 | 15.0.2070 | Nov 4 2019 |
1 CU7 isn't available for [!INCLUDEssbigdataclusters-ver15].
2 [!INCLUDE azure-data-cli-azdata] version reflects the version of the tool at the time of the CU release. azdata can also release independently of the server release, therefore you might get newer versions when you install the latest packages. Newer versions are compatible with previously released CUs.
To install updates, see [How to upgrade [!INCLUDEbig-data-clusters-nover]](deployment-upgrade.md).
For known issues and resolves issues, see SQL Server 2019 Big Data Clusters platform known issues.
For more information about [!INCLUDEssbigdataclusters-ver15], see [Introducing [!INCLUDEbig-data-clusters-nover]](big-data-cluster-overview.md).