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"