大网数据广告活动
数据库与应用安全

Disk space exhaustion causes SSAS crash

· 52CE 我爱测

This article describes a Microsoft SQL Server Analysis Services (SSAS) crash error that occurs when disk space is exhausted.

This article describes a Microsoft SQL Server Analysis Services (SSAS) crash error that occurs when disk space is exhausted on the system hosting the SSAS instance.

Original product version:   SQL Server
Original KB number:   4088924

Symptoms

Any release of SSAS crashes when it experiences an I/O error during the rollback of a failed processing job. When this problem occurs, the following error message may be logged in the Application log:

File system error: The following error occurred while writing to the file 'LazyWriter Stream': There is not enough space on the disk. .
File system error: The background thread running lazy writer encountered an I/O error.

More information

This problem may occur if the available disk space is exhausted. This problem can cause an emergency shutdown of the service. The shutdown resembles a crash, although it is internally initiated.

During the rollback operation, some I/O is required to wrap up the transaction. Disk exhaustion can cause I/O failure. This makes it impossible to roll back the transaction deterministically to a consistent state. The server should not continue serving any data while it is in an inconsistent state. In this situation, the only way to recover is to shut down the server and then force it to restart.

When the server restarts, a cleanup operation occurs before any data is made available for querying. This operation can safely enumerate through all the files in the data directory. The cleanup removes any files that are not confirmed as valid and part of the expected data.

Applies to

  • SQL Server 2017 on Windows (all editions)
  • SQL Server 2017 on Linux (all editions)
  • SQL Server 2016 Enterprise
  • SQL Server 2014 Enterprise
  • SQL Server 2012 Enterprise

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 08/03/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。