Dear All,

I'm using Observium 20.1.10233 (stable) Enterprise version.

Observium sometime error on database when access from web

Image1.jpeg

At that time the graph stop add new data.

there's a notification in console like picture below, so I need to restart the database service.

image2.png

Access server and try to see HTOP

image3.png

Then check the log

image4.png

After restart database service, the graph starts to add new data again.

Then, I upgraded the server RAM from 12 GB to 24 GB on 9 November 2020 at night.

This server uses ramdisk configuration on SSD.

After the server booted up the graph didn't add new data until today 11 November 2020 at 00:00 the graph started to add new data again.

But, all previous data graphs on all devices before 11 November 2020 are missing.

Here's the screenshot for the missing data for example on one device after upgrade.

image5.png

Here's the HTOP from the observium server after upgrade

image6.png

I've restore to date 8 and 7 November but the all graph show "Draw Graph Error"

image7.jpeg & image8.jpeg

When check the rrd folder from the server restore, It just only show a few device folder.

I assume that folder still hold on ramdisk, but if I see log for ramdisk it sync every 2-5 minutes to hardisk.

Please tell me step-by-step how to troubleshoot & recover it.

Demikian yang dapat kami sampaikan, terimakasih.

Regards,

Aulia Rahman