跳转到主内容

NetApp_Insight_2020.png 

由于磁盘 3 (数据磁盘)磁盘空间不足而导致 OnCommand Unified Manager 数据库损坏

Views:
4
Visibility:
Public
Votes:
0
Category:
oncommand-unified-manager
Specialty:
om
Last Updated:

适用于

适用于集群模式 ONTAP 的 OnCommand Unified Manager

问题

Unified Manager MySQL 服务无法启动。  由于 MySQL 不会启动所有其他服务,因此也无法启动。
 
在 MySQL error.log 中查看,您将看到记录的以下内容:
20XX-0X-18T04:11:30.978630Z 17096 [ERROR] Disk is full writing './unified-manager.~rec~' (Errcode: 16727840 - No space left on device). Waiting for someone to free space...

如果 MySQL 服务可能会在发生损坏后启动,您可能会在 MySQL error.log 文件中看到以下内容:
=====
20XX-0X -28T20:20:42.887959Z 17309 [ERROR] MYSQL_BIN_LOG::open failed to sync the index file.
20XX-0X -28T20:20:42.889354Z 17309 [ERROR] /usr/sbin/mysqld: Binary logging not possible. Message: Either disk is full or file system is read only while rotating the binlog. Aborting the server.
=====

如果 MySQL 服务能够启动, MySQL 将尝试自行恢复 / 修复,但由于已损坏,无法恢复。
=====
20XX-0X-28T20:20:44.383042Z 0 [Note] InnoDB: Starting crash recovery.
20XX-0X-28T20:20:44.399480Z 0 [Warning] InnoDB: Database page corruption or a failed file read of page [page id: space=23589, page number=2]. Trying to recover it from the doublewrite buffer.
20XX-0X-28T20:20:44.399563Z 0 [Note] InnoDB: Recovered page [page id: space=23589, page number=2] from the doublewrite buffer.
20XX-0X-28T20:20:44.399602Z 0 [Warning] InnoDB: Database page corruption or a failed file read of page [page id: space=23589, page number=3]. Trying to recover it from the doublewrite buffer.
20XX-0X-28T20:20:44.405526Z 0 [Warning] InnoDB: 16384 bytes should have been written. Only 8192 bytes written. Retrying for the remaining bytes.
20XX-0X-28T20:20:44.408596Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
 =====


您也可以通过检查磁盘 3/ 数据磁盘上的可用空间量进行确认。

=>
注意:从 Unified Manager 7.2 及更高版本开始,一旦磁盘容量达到大约 85% , Unified Manager 将向已配置的电子邮件地址发送警报。  此警报旨在为管理员提供足够的时间来扩展磁盘,以及在发生损坏之前扩展磁盘 3 分区。
=>
注意:从 Unified Manager 7.3 及更高版本开始,只有 Unified Manager 的 OVA 版本会在磁盘空间达到 95% 的已用空间时停止采集服务。  此操作旨在减少写入数据库的信息量。请注意,停止采集服务不会停止对 MySQL 数据库的所有写入,因为 OCIE 服务器服务和 MySQL 服务仍在运行。 

 

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