Skip to content

Autoseeding sometimes fails but succeeds on retry; other times it fails repeatedly with no response #957

@chuansao258

Description

@chuansao258

The image downloaded from the official website for SQL Server 2017 CU32.

errorlog:
026-03-17 16:49:25.41 spid61s Error: 18210, Severity: 16, State: 1.
2026-03-17 16:49:25.41 spid61s BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device '{C70CC0DC-9573-4A37-8C97-2A2CFCA6F2E1}'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2026-03-17 16:49:25.42 spid61s Error: 3203, Severity: 16, State: 1.
2026-03-17 16:49:25.42 spid61s Read on "/var/opt/mssql/data/data/xxxx.mdf" failed: 87(The parameter is incorrect.)
2026-03-17 16:49:25.42 spid61s Error: 3202, Severity: 16, State: 1.
2026-03-17 16:49:25.42 spid61s Write on "{C70CC0DC-9573-4A37-8C97-2A2CFCA6F2E1}" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
2026-03-17 16:49:25.42 spid61s Error: 3271, Severity: 16, State: 1.
2026-03-17 16:49:25.42 spid61s A nonrecoverable I/O error occurred on file "{C70CC0DC-9573-4A37-8C97-2A2CFCA6F2E1}:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

When querying sys.dm_hadr_physical_seeding_stats, there are many failed records, and sometimes the seeding eventually succeeds. However, in some cases, the query returns empty records(remote_id,state is null) directly, and restarting the primary database resolves the issue and allows seeding to succeed again.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions