Active IQ Unified Manager MySQL 服务定期崩溃，需要重新启动应用程序。
适用场景
- ActiveIQ Unified Manager 9.7P1
- Windows Server 2019
问题描述
- 与 Active IQ Unified Manager 关联的 MySQL 服务器服务将在 24 小时后突然停止，需要重新启动应用程序。
- MySQL错误日志文件中的错误在应用程序崩溃前后包含以下条目。
示例 1
020-07-24T03:03:47.874111Z 43 [Warning] [MY-012152] [InnoDB] Open files 306 exceeds the limit 300
03:51:33 UTC - mysqld got exception 0xc0000005 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x2d08048c510
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...示例 2
2021-04-17T12:34:06.xxxxxxx xxxxxx [Note] Unknown error 1158
2021-04-17T12:34:14.xxxxxxx xxxxxx [Note] Unknown error 1156
2021-04-17T12:34:14.xxxxxxx xxxxxx [Note] Unknown error 1156
2021-04-17T12:34:36.xxxxxxx xxxxxx [Note] Unknown error 1156
2021-04-17T12:34:36.xxxxxxx xxxxxx [Note] Unknown error 1043
2021-04-17T12:34:55.xxxxxxx xxxxxx [Note] Unknown error 1158
示例 3.
2021-08-05T02:56:31.437637Z 12382 [ERROR] [MY-010934] [Server] Out of memory (Needed 2391524 bytes) 2021-08-05T02:56:31.440225Z 12382 [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"