Skip to main content
NetApp Stage KB

Active IQ Unified Manager MySQL serviceĀ  periodically crashes, requiring the application to be restarted

Views:
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
OM
Last Updated:

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"

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.
28ae3cc4-1078-4bda-a5a9-9aa1f720a625