Page 1 of 1
No servers have checked in with data yet in fusion
Posted: Thu Jun 28, 2018 9:49 am
by amane
Hi,
Fusion is not working.
Getting below mentioned error.
"No servers have checked in with data yet.

"
Re: No servers have checked in with data yet in fusion
Posted: Thu Jun 28, 2018 11:13 am
by 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"?
Re: No servers have checked in with data yet in fusion
Posted: Fri Jun 29, 2018 7:19 am
by 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.
Re: No servers have checked in with data yet in fusion
Posted: Fri Jun 29, 2018 8:47 am
by 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?
Re: No servers have checked in with data yet in fusion
Posted: Fri Jun 29, 2018 8:55 am
by 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
Re: No servers have checked in with data yet in fusion
Posted: Fri Jun 29, 2018 9:02 am
by 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/
Re: No servers have checked in with data yet in fusion
Posted: Mon Jul 02, 2018 9:55 am
by amane
Thanks Scott
Issue resolved...
We will upgrade the fusion in our environment.
Re: No servers have checked in with data yet in fusion
Posted: Mon Jul 02, 2018 10:45 am
by scottwilkerson
amane wrote:Thanks Scott
Issue resolved...
We will upgrade the fusion in our environment.
Excellent, glad the issue is resolved.
Locking