跳转到主内容

升级到4.9后、一个或多个数据库的SCSQL静修失败

Views:
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx<a>2009735624</a>
Last Updated:

适用场景

  • SnapCenter服务器(SC) 4.9/4.9P1
  • 适用于Microsoft SQL Server的SnapCenter插件(SCSQL) 4.9/4.9P1

问题描述

  • 将SCSQL升级到4.9或4.9P1之后、 即使 SCSQL-VDI超时错误-将数据库状态冻结为失败 SCSQL主机上的VDI超时增加、一个或多个数据库的暂停/取消暂停过程也会失败。
    • 在中出现错误 <installation_path>\Program Files\NetApp\SnapCenter\SnapCenter Plug-in for Microsoft SQL Server\log\SmSql_<id>.log

DEBUG SmSql_1231046 PID=[7908] TID=[199] Database [DB_Name] Quiesce is done... Waiting for UnQuiesce event...
DEBUG SmSql_1231046 PID=[7908] TID=[99] Calling SQLBackupRestoreVDI...
DEBUG SmSql_1231046 PID=[7908] TID=[99] Creating virtual device on : [host\instance]....
DEBUG SmSql_1231046 PID=[7908] TID=[99] Executing VDI Command on database [DB_Name]....
DEBUG SmSql_1231046 PID=[7908] TID=[146] Vdi timeout value - 1200000
DEBUG SmSql_1231046 PID=[7908] TID=[146] Connecting to SQL Server: [host\instance]
ERROR SmSql_1231046 PID=[7908] TID=[111] Quiesce could not complete for following databases within the timeout:
'DB_Name,DB_Name,DB_Name;'

  • 如果静噪/取消静噪过程失败、还可能会出现以下问题:
    • 在SC UI的"Monitor"选项卡中加载作业所用时间比正常情况要长。
    • SCSQL会锁定具有多个同时连接的受保护SQL数据库、从而导致与数据库连接的应用程序无响应。

 

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.