No servers have checked in with data yet in fusion

[amane]

Hi,

Fusion is not working.

Getting below mentioned error.

"No servers have checked in with data yet. "

[scottwilkerson]

How long ago did you setup fusion?

Did you add multiple fused servers under the Servers menu?

If so, If you go to Servers -> System Status
What do you see under "Fused Server Status"?

[amane]

Hi Scott,

Around 4 months before Fusion was set in our environment.

Yes, we have added 7 fused servers and all were working before but now for all servers we are getting same error.

Please find attached snapshot for fused servers status. Status is ok for all fused status. I removed one fused server and added again but no luck.

[scottwilkerson]

Lets run the following on the server

Code: Select all

mysql -u root -pfusion -e "select * from polling_lock"

If this returns data, lets run this

Code: Select all

mysql -u root -pfusion -e "truncate polling_lock"

Also, what version of Fusion are you running?

[amane]

Hi Scott,

Please find the output below for given commands.

mysql -u root -pfusion -e "select * from polling_lock"
ERROR 1046 (3D000) at line 1: No database selected

mysql -u root -pfusion -e "truncate polling_lock"
ERROR 1046 (3D000) at line 1: No database selected

We are using Nagios Fusion 4.0.1

[scottwilkerson]

My apologies, I missed the database in the command

Lets run the following on the server

Code: Select all

mysql -u root -pfusion fusion -e "select * from polling_lock"

If this returns data, lets run this

Code: Select all

mysql -u root -pfusion fusion -e "truncate polling_lock"

And this was a bug that was fixed in 4.1.0 so an upgrade would help prevent this from happening again
https://www.nagios.com/downloads/nagios ... hange-log/

[amane]

Thanks Scott

Issue resolved...

We will upgrade the fusion in our environment.

[scottwilkerson]

Thanks Scott

Issue resolved...

We will upgrade the fusion in our environment.

Excellent, glad the issue is resolved.

Locking