由于错误"无法将日志文件.\ib_logfile101设置为大小"、无法访问AIQUM图形用户界面

适用场景

• ActiveIQ Unified Manager 9.6P1及更高版本
• Windows

问题描述

• 无法访问AIQUM图形用户界面(错误404)。
• MySQL和OIE服务已关闭、OCIEAU已启动。
• 部署文件dfM-app.war处于故障状态。
• 当我们尝试启动MySQL时、我们收到以下错误：

Windows could not start the MYSQL8 service On Local Computer. Error 1053•. The service did not respond to the Start or control request in a timely fashion.

• 从MySQL错误日志中、我们可以看到以下错误：

2023-10-25T09:16:57.692725Z 1 [Note] [MY-013575] [InnoDB] Creating log file .\ib_logfile101 2023-10-25T09:18:10.926777Z 1 [Note] [MY-012887] [InnoDB] Setting log file .\ib_logfile101 size to 189770 MB. Progress : 10% 2023-10-25T09:19:40.485390Z 1 [Note] [MY-012887] [InnoDB] Setting log file .\ib_logfile101 size to 189770 MB. Progress : 20% 2023-10-25T09:19:59.163682Z 1 [ERROR] [MY-012644] [InnoDB] Encountered a problem with file '.\ib_logfile101' 2023-10-25T09:19:59.167174Z 1 [ERROR] [MY-012645] [InnoDB] Disk is full. Try to clean the disk to free space. 2023-10-25T09:19:59.170650Z 1 [ERROR] [MY-012888] [InnoDB] Cannot set log file .\ib_logfile101 to size 189770 MB 2023-10-25T09:20:01.496534Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-10-25T09:20:01.544845Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2023-10-25T09:20:01.554295Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2023-10-25T09:20:01.560308Z 0 [ERROR] [MY-010119] [Server] Aborting

• 我们 尝试从MySQL数据 驱动器中清除数据、释放了大约50 GB的空间、并提供了大约90 GB的可用空间。
• 然后、我们会部署失败的部署文件、停止OCIEAU和OCIE服务并启动MySQL服务。服务失败、并出现与上述相同的错误。
• 然后、我们可以看到MySQL数据驱动器E：\快速填满、可能是由于.\ib_logfile101的文件恢复在后端进行、在达到可用的0 GB后、我们可以看到恢复终止、E驱动器返回到先前的状态。