All dashboards disappeared, that dashboard is not valid...

[rjjimenez]

Hi

We were adding dashlet in dashboads and we have received the following error:

Bad Dashboard
Unfortunately for you, that dashboard is not valid... Too bad. Dashboard ID: fnrkq5k7

Now when we look dashboards, all they are gone.

Attached the screenshot of the error, http nagios logs and also the result of the dashboard in database.

NagiosXI Entreprise 5.2.3

Best regards

[lmiltchev]

What dashlet were you adding to your dashboards? What is the user that you were logged in as while trying to view the dashboard - nagiosadmin, other user (admin, regular user, read-only user)? Do ALL users have issues with accessing the dashboard?

[rjjimenez]

Hi

We were logged with the nagiosadmin user and we were adding service graphics.

Only disappeared the nagiosadmin user dashboars, the others users dashboards work correctly.

Best Regards

[ssax]

First, take an XI backup:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf


You may have so much data in there that you're hitting the max byte limit of the DB field type, change the field type so that it will support at least 4GB by running this command:

Code: Select all

echo "alter table xi_usermeta modify keyvalue LONGTEXT;" | mysql -uroot -pnagiosxi nagiosxi

Now you should not experience the issue going forward.

You may need to delete what dashboards you currently have setup:

Code: Select all

echo "delete from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi

Let us know the results.

[vAJ]

Just had this happen to my Network Engineering director... I'm trying the fix now as well, will report back success or fail.

He's tearing up over our IM session right now. ;(

[vAJ]

Do they really lose all of that dashboard data?

I'm going to have some very unhappy people today...

[ssax]

The problem is that the data is serialized, let me see if I can come up with a workaround to losing the data.

[ssax]

Do you still have the broken dashboards, if so, please run this command and PM me the data:

Code: Select all

echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi

Thank you

[ssax]

Did that data that you PM'd contain the broken data? I'm unable to figure out what is wrong with it, the data unserializes properly and it doesn't look like it hit the byte limit. Have you deleted and tried to recreate to see if they show up?

[vAJ]

Man, I dropped the ball on this.

Are you suggesting that if we delete a given dashboard (which currently shows nothing) and recreate with the same name we potentially will get the dashboard contents back?