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.orgmailto:observium-bounces@observium.org> On Behalf Of Jacek Dabrowski via observium Sent: 04 September 2019 16:49 To: observium@observium.orgmailto:observium@observium.org Cc: Jacek.Dabrowski@selgros.plmailto:Jacek.Dabrowski@selgros.pl Subject: Re: [Observium] DB Error
Discovery time is very big, top does not show that the server is heavily loaded
[cid:image001.jpg@01D5657D.EFFA18C0]
[cid:image002.jpg@01D5657D.EFFA18C0]
Pozdrawiam
Jacek Dąbrowski Koordynator Administratorów IT
[cid:image003.png@01D5657D.EFFA18C0]http://transgourmet.pl/ 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.plmailto:Jacek.Dabrowski@selgros.pl www.selgros.plhttp://selgros.pl www.selgros24.plhttp://selgros24.pl www.transgourmet.plhttp://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 HELPDESKhttp://helpdesk-it... From: observium <observium-bounces@observium.orgmailto:observium-bounces@observium.org> On Behalf Of Greg Peterson via observium Sent: Wednesday, September 4, 2019 5:20 PM To: Observium <observium@observium.orgmailto:observium@observium.org> Cc: Greg Peterson <gpeterson@nescmn.netmailto: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.orgmailto:observium@observium.org Cc: Jacek.Dabrowski@selgros.plmailto: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 ???
[cid:image001.jpg@01D5617C.C2F25CC0]
Pozdrawiam
Jacek Dąbrowski