AIQUM MySQL服务频繁崩溃
适用场景
- ActiveIQ Unified Manager (AIQUM) 9.6及更高版本
- MySQL
问题描述
- AIQUM图形用户界面不可访问/无响应
- 重新启动会暂时解决问题描述问题
- 发现MySQL服务处于未运行状态
- MySQL
error.log：[ERROR] [MY-010934] [Server] Out of memory (Needed 27240544 bytes)
[ERROR] [MY-010934] [Server] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
..
..
[ERROR] [MY-013190] [InnoDB] [FATAL] Some (1659055039) threads are still active Unable to allocate memory of size 16488.
[ERROR] [MY-013183] [InnoDB] Assertion failure: memory.cc:305:ib::fatal triggered thread 8312 - 频繁崩溃可能最终导致InnoDB损坏：
[ERROR] [MY-013190] [InnoDB] [FATAL] Some (1659055039) threads are still activeUnable to allocate memory of size 16488.
[ERROR] [MY-013183] [InnoDB] Assertion failure: memory.cc:305:ib::fatal triggered thread 8312
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/8.0/...-recovery.html
InnoDB: about forcing recovery.
mysqld got exception 0x16 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x26d9e459070
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...