AIQUM 9.7 图形用户界面不可访问错误：身份验证失败
适用场景
Active IQ Unified Manager 9.7 （ AIQUM ）
问题描述
无法访问 AIQUM 9.7 图形用户界面 Error: Authentication Failed: Please verify Username and Password.
重新启动可解决问题描述问题，但此问题描述在客户环境中频繁出现。
在 ocumserver 日志中观察到错误
020-08-30 06:55:13,453 ERROR [oncommand] [opmTaskExecutor-2] [c.n.i.s.a.dao.NodeInventoryDao] fetchNodeInventoryStats for Nodes query: SELECT configSet.*, 0 AS eventSeverity FROM (select n.objId AS objid, n.name elementName,n.resourceKey elementResourceKey, 72 numberOfHours, COALESCE(sum(avgLatency*totalOps)/sum(totalOps),sum(avgLatency*totalOps)) latency, avg(totalOps) ops, avg(opmSysThroughput) throughput, avg (opmSysReadThroughput) readThroughput, avg(opmSysUtilization) AS nodeUtilization, (n.aggregateBytesTotal-n.aggregateBytesUsed) freeCapacity, n.aggregateBytesTotal totalCapacity, c.objId clusterId, c.name clusteRName, c.resourceKey clusterResourceKey, GROUP_CONCAT(DISTINCT tp.id ORDER BY tp.id) thresholdPolicyId, GROUP_CONCAT(DISTINCT tp.name ORDER BY tpm.policyId) thresholdPolicyName, cluster.fqdn AS clusterFqdn , avg(ext.cacheReadThroughput) as cacheReadThroughput , avg(cHRoomUsedPercent) usedHeadroom , avg(availableOps) availableOps FROM netapp_model_view.node n JOIN netapp_model_view.cluster c on c.objId=n.clusterId LEFT JOIN ocum.cluster cluster ON (c.objid = cluster.id) LEFT JOIN netapp_performance.summary_node sn ON (n.objId = sn.objId AND fromtime >= 1598472000000 AND fromtime < 1598734483371) LEFT JOIN opm.threshold_policy_mapping tpm ON (tpm.objectId=n.objId AND tpm.endTime is null) LEFT JOIN opm.threshold_policy tp ON (tp.id=tpm.policyId AND tp.elementType=9) LEFT JOIN netapp_performance.summary_extcacheobj ext ON (n.objId = ext.objId AND ext.fromtime >= 1598472000000 AND ext.fromtime < 1598734483371) LEFT JOIN netapp_performance.summary_opm_headroom_cpu sohc ON (n.objId = sohc.objId AND sohc.fromtime > 1598472000000 AND sohc.fromtime < 1598734483371) GROUP BY n.objId) configSet failed.Caused by: java.sql.SQLException: (conn=16) Can't change size of file (OS errno 28 - No space left on device)MySQL hostname.err 日志出错
2020-09-10T00:27:21.989954Z 1367 [ERROR] [MY-010907] [Server] Error writing file 'C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp\MLEE62.tmp' (errno: 28 - No space left on device)2020-09-10T00:27:21.990673Z 1367 [ERROR] [MY-011072] [Server] Binary logging not possible. Message: An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'ABORT_SERVER'. Hence aborting the server..00:27:21 UTC - mysqld got exception 0x80000003 ;Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Thread pointer: 0x2903019e6e0