Skip to main content
NetApp Knowledge Base

iSCSI Linux client LUN paths not optimal for ALUA

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

Applies to

  • ONTAP 9.x
  • Linux
  • Microsoft SQL Server

Issue

  • Running multipath -ll displays incorrect asynchronous logical unit access (ALUA) for MPIO, performance not optimal
  • ONTAP Maintenance may result in outage for time to live sensitive applications/databases
Examples:
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).

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support