Active IQ Unified Manager MySQL service periodically crashes, requiring the application to be restarted
Applies to
- Active IQ Unified Manager 9.7P1
- Windows Server 2019
Issue
- MySQL server service associated with Active IQ Unified Manager will abruptly stop after 24 hours, requiring a restart of the application.
- Errors in the MySQL error log file contain an entry below around the time of the application crash.
Example 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...Example 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
Example 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"