Active IQ Unified Manager Discussions

OnCommand Unified Manager 9.5P1 Cannot open connection

Chelydridae
2,362 Views

We are running OCUM 9.5P1 on CentOS and all of a sudden we get the following errors after login:

==TIME==
2020-08-20 08:06:44,042
==MESSAGE==
Cannot open connection

==DETAILS==
No details are available.
==CORRECTIVE ACTION==
No suggested corrective action is available.
==LOCATION==
Location is not specified.
==BROWSER INFO==
App Name: Netscape
App Version: 5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36
App Codename: Mozilla
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36
Platform: Win32
Cookie Enabled: true

 

==TIME==
2020-08-20 08:06:43,838

==MESSAGE==
StatementCallback; SQL [SELECT count(distinct source_id) FROM ocum.event, ocum.eventtypevalue v WHERE impactArea='PERFORMANCE' AND state in ('NEW', 'ACKNOWLEDGED') AND v.impactLevel=2 AND source_resourcetype='cluster' AND v.id=event.value_id AND iscontinuous=1]; (conn=10) unexpected end of stream, read 0 bytes from 4 (socket was closed by server); nested exception is java.sql.SQLNonTransientConnectionException: (conn=10) unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

==DETAILS==
No details are available.

==CORRECTIVE ACTION==
No suggested corrective action is available.

==LOCATION==
Location is not specified.

==BROWSER INFO==
<same as above>

 

It seems like a problem with the MySQL-DB ...

any suggestions where to look further and how to proceed are welcome.

 

Thank you all

2 REPLIES 2

AlexDawson
2,269 Views

Hi there! I agree that it does look like a problem talking to the MySQL DB - because this is essentially troubleshooting a Linux system, the best option is probably to open a support case and work with our specialist support teams in troubleshooting this.

 

How to open a support case

Chelydridae
2,235 Views

Finally I found a older backup and was able to restore that.

OCUM seems to work fine again.

 

Thx anyway for your suggestion.

 

best regards

Public