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.org> On Behalf Of Jacek Dabrowski via observium
Sent: 04 September 2019 16:24
To: observium@observium.org
Cc: 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.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