跳转到主内容

iSCSI Linux 客户端 LUN 路径不是 ALUA 的最佳路径

Views:
40
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
san
Last Updated:

适用场景

  • ONTAP 9.x
  • Linux
  • Microsoft SQL Server

问题描述

  • 运行 multipath -ll 会为 MPIO 显示不正确的异步逻辑单元访问( ALUA ),性能不是最佳的
  • ONTAP 维护可能会导致停机以延长使用时间 敏感应用程序 / 数据库
示例
0123456789 NETAPP,LUN C-Mode
size=2.6T features='3 queue_if_no_path pg_init_retries 50' hwhandler='1 alua' wp=rw
|-+- policy='service-time 0' prio=50 status=active
| `- 33:0:0:0 sdc  active ready running
`-+- policy='service-time 0' prio=10 status=enabled
|- 35:0:0:0 sdb  active ready running
|- 36:0:0:0 sdd  active ready running
`- 34:0:0:0 sde active ready running
 
Error: 17053, Severity: 16, State: 1.
SQLServerLogMgr::LogWriter: Operating system error 1117(The request could not be performed because of an I/O device error.) encountered.
Write error during log flush.
Error: 9001, Severity: 21, State: 4.
The log for database 'msdb' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database.
Database msdb was shutdown due to error 9001 in routine 'XdesRMFull::CommitInternal'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
Error: 823, Severity: 24, State: 2.
The operating system returned error 1117(The request could not be performed because of an I/O device error.) to SQL Server during a read at offset x in file 'x:\sqlsystemdb\mssqlserverx\MSSQL\DATA\tempdb.mdf'.
Additional messages in the SQL Server error log and operating system error log may provide more detail. This is a sever system-level error condition that threatens database integrity and must be corrected immediately.
Complete a full database consistency check (DBCC CHECKDB).

 

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.