Applies ToSQL Server 2017 Developer Linux SQL Server 2017 Enterprise on Linux SQL Server 2017 Enterprise Core on Windows SQL Server 2017 Standard on Linux

Symptoms

When you use Always On Availability Groups in Microsoft SQL Server on Linux, a database that belongs to an availability group may be marked as SUSPECT. Additionally, error messages that resemble the following are logged in the SQL Server error log:

Error: 883, Severity: 16, State: 1.

Could not create the Write Page Recorder table: wpr_bucket_table for database WritePageRecorder2::CreateWPRBucketTable.

Error: 926, Severity: 14, State: 1.

Database database_name cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Resolution

This problem is fixed in the following update for SQL Server:

Cumulative Update 8 for SQL Server 2017

About SQL Server builds

Each new build for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

The latest build for SQL Server 2017

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the standard terminology Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.