Operational Defect Database
BugZero found this defect 1308 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 10889338
KB4042885 - FIX: Divide-by-zero error when a parallel query is forced to run in serial mode in SQL Server 2017 - Microsoft Support
Last update date:
7/20/2023
Affected products:
SQL Server 2017 on Windows (all editions)
Affected releases:
build lower than 14.0.3006.16
Fixed releases:
14.0.3006.16
Description:
Symptoms
Assume that you have many concurrent parallel queries that are running on a busy system in SQL Server 2017. When you execute a parallel query, you may notice that the parallel query is forced to run in serial mode because of the lack of parallel worker threads. In this situation, a memory grant usage-warning feature may cause the divide-by-zero error.
Resolution
This issue is fixed in the following cumulative update for SQL Server: Cumulative Update 1 for SQL Server 2017
