We had a power system upgrade in the server room to two UPS , I did not change anything and earlier the server has not been restarted for a long time, I am looking for other possible reasons but ping to devices and server performance is the same.
Pozdrawiam
Jacek Dąbrowski
From: observium observium-bounces@observium.org On Behalf Of Adam Armstrong via observium Sent: Wednesday, September 4, 2019 5:49 PM To: 'Observium' observium@observium.org Cc: adama@memetic.org Subject: Re: [Observium] DB Error
Why did you turn Observium off and back on again? What other things were you doing at the same time which required that?
There's not really anything about restarting a server which would cause what you're seeing, which is probably massive poller backlogs and huge numbers of poller processes.
Adam.
From: observium <observium-bounces@observium.orgmailto:observium-bounces@observium.org> On Behalf Of Jacek Dabrowski via observium Sent: 04 September 2019 16:24 To: observium@observium.orgmailto:observium@observium.org Cc: Jacek.Dabrowski@selgros.plmailto:Jacek.Dabrowski@selgros.pl Subject: Re: [Observium] DB Error
I have these times in my log:
[2019/09/04 15:21:30 +0000] poller.php(16243): /opt/observium/poller.php: p121-rt - 1 devices polled in 387.1 secs [2019/09/04 15:21:30 +0000] poller.php(19578): /opt/observium/poller.php: p112-sw-35-poe - 1 devices polled in 281.3 secs [2019/09/04 15:21:30 +0000] poller.php(19623): /opt/observium/poller.php: p126-sw-33-poe - 1 devices polled in 280.4 secs [2019/09/04 15:21:30 +0000] poller.php(16212): /opt/observium/poller.php: p117-sw-core-pt - 1 devices polled in 387.9 secs [2019/09/04 15:21:33 +0000] poller.php(19689): /opt/observium/poller.php: p124-sw-36 - 1 devices polled in 281.1 secs [2019/09/04 15:21:36 +0000] poller.php(16209): /opt/observium/poller.php: p113-sw-core-pt - 1 devices polled in 394.0 secs [2019/09/04 15:21:40 +0000] poller.php(16203): /opt/observium/poller.php: p101-rt-d - 1 devices polled in 397.6 secs [2019/09/04 15:21:41 +0000] poller.php(16200): /opt/observium/poller.php: p101-sw-05-rack5 - 1 devices polled in 398.4 secs [2019/09/04 15:21:41 +0000] poller.php(19877): /opt/observium/poller.php: p127-sw-37-poe - 1 devices polled in 282.0 secs [2019/09/04 15:21:42 +0000] poller.php(16194): /opt/observium/poller.php: p170-rt-2 - 1 devices polled in 400.0 secs [2019/09/04 15:21:43 +0000] poller.php(16196): /opt/observium/poller.php: p102-rt-b - 1 devices polled in 400.7 secs [2019/09/04 15:21:44 +0000] poller.php(19953): /opt/observium/poller.php: p123-sw-36 - 1 devices polled in 281.5 secs [2019/09/04 15:21:46 +0000] poller.php(22490): /opt/observium/poller.php: p116-etykiety2 - 1 devices polled in 182.6 secs [2019/09/04 15:21:47 +0000] poller.php(20083): /opt/observium/poller.php: p114-sw-34-kasyn - 1 devices polled in 280.1 secs [2019/09/04 15:21:47 +0000] poller.php(22543): /opt/observium/poller.php: p127-etykiety1 - 1 devices polled in 182.8 secs [2019/09/04 15:21:47 +0000] poller.php(16191): /opt/observium/poller.php: p102-rt - 1 devices polled in 405.2 secs [2019/09/04 15:21:49 +0000] poller.php(16185): /opt/observium/poller.php: p170-rt-1 - 1 devices polled in 406.4 secs [2019/09/04 15:21:51 +0000] poller.php(16179): /opt/observium/poller.php: p121-sw-core - 1 devices polled in 408.5 secs [2019/09/04 15:21:51 +0000] poller.php(21905): /opt/observium/poller.php: p124-dc1 - 1 devices polled in 210.1 secs [2019/09/04 15:21:56 +0000] poller.php(22638): /opt/observium/poller.php: p121-netbotz - 1 devices polled in 190.4 secs [2019/09/04 15:21:57 +0000] poller.php(22679): /opt/observium/poller.php: p128-netbotz - 1 devices polled in 189.8 secs [2019/09/04 15:21:57 +0000] poller.php(22672): /opt/observium/poller.php: p120-netbotz - 1 devices polled in 190.1 secs [2019/09/04 15:21:57 +0000] poller.php(22633): /opt/observium/poller.php: p101-ups-symetra - 1 devices polled in 190.7 secs [2019/09/04 15:21:58 +0000] poller.php(16175): /opt/observium/poller.php: p101-sw-09-rack2 - 1 devices polled in 415.6 secs [2019/09/04 15:21:58 +0000] poller.php(22564): /opt/observium/poller.php: p114-sts - 1 devices polled in 193.7 secs [2019/09/04 15:21:59 +0000] poller.php(22611): /opt/observium/poller.php: p101-rac-vela - 1 devices polled in 193.2 secs [2019/09/04 15:21:59 +0000] poller.php(22733): /opt/observium/poller.php: p117-netbotz - 1 devices polled in 190.1 secs [2019/09/04 15:21:59 +0000] poller.php(22731): /opt/observium/poller.php: p113-netbotz - 1 devices polled in 190.6 secs [2019/09/04 15:22:02 +0000] poller.php(22576): /opt/observium/poller.php: p113-sts - 1 devices polled in 196.7 secs [2019/09/04 15:22:02 +0000] poller.php(22545): /opt/observium/poller.php: p111-sts - 1 devices polled in 197.8 secs [2019/09/04 15:22:03 +0000] poller.php(16172): /opt/observium/poller.php: p122-rt - 1 devices polled in 420.7 secs [2019/09/04 15:22:04 +0000] poller.php(22886): /opt/observium/poller.php: p114-netbotz - 1 devices polled in 189.7 secs [2019/09/04 15:22:05 +0000] poller.php(22572): /opt/observium/poller.php: p112-sts - 1 devices polled in 199.8 secs [2019/09/04 15:22:05 +0000] poller.php(22927): /opt/observium/poller.php: p123-netbotz - 1 devices polled in 189.8 secs [2019/09/04 15:22:06 +0000] poller.php(22327): /opt/observium/poller.php: p111-dc1 - 1 devices polled in 207.9 secs [2019/09/04 15:22:06 +0000] poller.php(16168): /opt/observium/poller.php: p102-sw-core - 1 devices polled in 423.9 secs [2019/09/04 15:22:09 +0000] poller.php(22417): /opt/observium/poller.php: pl-sdc01 - 1 devices polled in 207.6 secs [2019/09/04 15:22:09 +0000] poller.php(22499): /opt/observium/poller.php: p101-wifi-guest - 1 devices polled in 205.6 secs [2019/09/04 15:22:09 +0000] poller.php(22404): /opt/observium/poller.php: p111-ms1 - 1 devices polled in 208.3 secs [2019/09/04 15:22:10 +0000] poller.php(22443): /opt/observium/poller.php: pl-sapp08 - 1 devices polled in 208.2 secs
Pozdrawiam
Jacek Dąbrowski 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
