Does not start IM and database

[David Jimenez]

Good morning community

I have a small serious problem, I hope for your valuable help.

A few moments ago my Windows Server 2012 R2 automatically restarted. When trying to lift the IM, I throw these probe in stop:

I check my MYSQL 56 database that is running, but it is paused

can you support me please? I will thank you very much.

Regards.

[Gene Howard]

Contact your dba to get you database back up and running and the restart the primary hub robot service.

The probes are all down because your data_engine can not connect to the database  because  it is paused

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------

[David Kim]

Troubleshoot the problem starting the MySQL Server then restart the primary hub robot

The following documents may help:

https://dev.mysql.com/doc/refman/5.6/en/starting-server-troubleshooting.html
https://dev.mysql.com/doc/refman/5.6/en/windows-start-command-line.html

[David Jimenez]

Thanks for your comments.

@Kab Lyo Kim, check the links you provided me, no difference was found in the files that are in production.

@Gene Howard, he tried to lift the service by forcing it from services and yet I don't get up.

It is concluded that for the amount of data that handles 50GB approx, it will be allowed to lift on its own. Which restarts the server and after approximately 3 hours I raise the Mysql service, the main hub is restarted and all the probes are changed to green.

As a reference is the time it takes to make monthly backups with the configuration on the data_engine probe of 15 days raw data and 180 days historic data

I hope this is a normal database condition with the IM.

I remain attentive to your observations.

regards

[Gene Howard]

I am glad to hear you have it working.
there is no normal for the amount of data.
this will be unique to each client.
You can check the below KB article to make sure old data is being deleted.

How does data_engine maintenance and retention work?

https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=3704

How to troubleshoot data retention and Database growth
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=9547

CA UIM - Nimsoft SLM Database Growth - NAS_TRANSACTION_LOG table
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=102927

Verifying that data_engine is deleting old raw and historic data properly from the database
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34940

------------------------------
Gene Howard
Principal Support Engineer
Broadcom
------------------------------