在维护环境时发现,event viewer log中有SQL server always on availability group的错误:
Always On Availability Groups transport has detected a missing log block for availability database "DB name". LSN of last applied log block is (...). Log scan will be restarted to fix the issue. This is an informational message only. No user action is required.
SQL的版本是2017,经过check是当前SQL版本的已知问题,同时受影响的还有SQL2016版本。
对此问题可用通过升级SQL server解决,具体升级到的版本如下:
SQL Server 2017: Cumulative Update 8
SQL Server 2016 SP2: Cumulative Update 2
SQL Server 2016 SP1: Cumulative Update 10
感谢阅读。