Graph data is stored in the rrds folder, you can copy this to a new install and ./device_add.php all of the devices, and it’ll pick up graphing data.

You can also transfer the MySQL database, this will keep any settings you’ve changed in the web UI, alerting, etc. This might not be the best idea, if you’re not sure what’s set in the database that might be causing issues.

Then config.php is things you’ve changed. I’d recommend not copying this, but reading through it and manually transferring settings you KNOW you need. Less is more.

Reinstall onto a clean server using the install script, then copy rrd folder across and ./device_add.php everything (you could shell script this pretty easily).

Adam.

From: observium <observium-bounces@observium.org> On Behalf Of Jacek Dabrowski via observium
Sent: 07 September 2019 12:13
To: observium@observium.org
Cc: Jacek.Dabrowski@selgros.pl; adama@memetic.org
Subject: Re: [Observium] DB Error

The tips didn't help. limiting processes helps so that the database does not scream. However, rrdtool does not work properly (no graphics) how can you transfer the whole configuration to the new server?

Pozdrawiam

Jacek Dąbrowski

From: observium <observium-bounces@observium.org> On Behalf Of Adam Armstrong via observium
Sent: Wednesday, September 4, 2019 6:13 PM
To: 'Observium' <observium@observium.org>
Cc: adama@memetic.org
Subject: Re: [Observium] DB Error

There are 28 snmpbulkwalk/snmpget processes on that screenshot, which suggests that there are at least 26 pollers running, which is probably causing the problem.

I also see a number of python processes, which suggests there are a lot of poller-wrappers running.

The system is at 100% load, which would explain the problems, because it’ll just spawn more and more processes.

Kill all of this off and it might go back to normal. If it doesn’t, you need to find out which devices are polling slowly, or why everything is polling slowly.

Have you changed the setting that limits poller-wrapper processes in the config?

Adam.

From: observium <observium-bounces@observium.org> On Behalf Of Jacek Dabrowski via observium
Sent: 04 September 2019 16:49
To: observium@observium.org
Cc: Jacek.Dabrowski@selgros.pl
Subject: Re: [Observium] DB Error

Discovery time is very big, top does not show that the server is heavily loaded

Pozdrawiam

Jacek Dąbrowski
Koordynator Administratorów IT


Transgourmet Polska Sp. z o.o.
Zamenhofa 133, 61-131, Poznań, Polska
tel.: +48 61 874 20 17
kom.: +48 604 069 933
E-mail: Jacek.Dabrowski@selgros.pl
www.selgros.pl
www.selgros24.pl
www.transgourmet.pl

Transgourmet Polska Sp. z o.o. jest zarejestrowana w Sądzie Rejonowym Poznań-Nowe Miasto i Wilda w Poznaniu, Wydział VIII Gospodarczy Krajowego Rejestru Sądowego pod nr KRS: 0000045597.
NIP: PL 781-10-11-998, REGON 630375413. Wysokość kapitału zakładowego: 310.000.000,00 złotych.
Zapraszamy do korzystania z aplikacji HELPDESK...

From: observium <observium-bounces@observium.org> On Behalf Of Greg Peterson via observium
Sent: Wednesday, September 4, 2019 5:20 PM
To: Observium <observium@observium.org>
Cc: Greg Peterson <gpeterson@nescmn.net>
Subject: Re: [Observium] DB Error

I was getting this message when I had devices that didn’t finish polling in five minutes (300s). you can check this by looking at  polling information/Per Device

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Jacek Dabrowski via observium
Sent: Monday, September 02, 2019 3:54 AM
To: observium@observium.org
Cc: Jacek.Dabrowski@selgros.pl
Subject: [Observium] DB Error

Hello,

Yesterday I turned off Observium after turning on the message DB Error 1040 appears, which I can do with it ???

Pozdrawiam

Jacek Dąbrowski