Re: [Observium] Event log showing 'changed' entries every 5 minutes
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Adam. Sent from my iPhone
On 4 Oct 2021, at 15:15, Adam Armstrong adama@observium.org wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Sent from my iPhone
On 4 Oct 2021, at 15:13, Richard Kuhns via observium observium@observium.org wrote:
Hello,
We're running Observerium Professional 21.10.11636.
Every 5 minutes the same 'changed' entries show up in the event log (screenshot below). The device in question is a Cisco ASR9K. Browsing to the device's page it looks like the changes below aren't actually be applied (no serial number listed, hardware is generic).
How can I go about fixing this?
Thanks in advance!
-- Richard Kuhns rjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Digging through the output, I found one section (INSERT INTO ports) that generated a number of
Incorrect integer value: ' '
for several rows, which I don't think is part of this problem. However, the script terminated with:
SQL[UPDATE `snmp_errors` set `error_count` ='311356',`updated` ='1633358368' WHERE `error_id` = '1695'] SQL RUNTIME[0.00367284s]
Fatal error: Uncaught ValueError: max(): Argument #1 ($value) must contain at least one element in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php:23 Stack trace: #0 /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php(23): max(Array) #1 /usr/local/www/observium/includes/include-dir-mib.inc.php(46): include('/usr/local/www/...') #2 /usr/local/www/observium/includes/polling/graphs.inc.php(16): include('/usr/local/www/...') #3 /usr/local/www/observium/includes/polling/functions.inc.php(334): include('/usr/local/www/...') #4 /usr/local/www/observium/poller.php(171): poll_device(Array, Array) #5 {main} thrown in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php on line 23
which doesn't look good.
On 10/4/21 10:18 AM, Adam Armstrong via observium wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Adam. Sent from my iPhone
On 4 Oct 2021, at 15:15, Adam Armstrong adama@observium.org wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Sent from my iPhone
On 4 Oct 2021, at 15:13, Richard Kuhns via observium observium@observium.org wrote:
Hello,
We're running Observerium Professional 21.10.11636.
Every 5 minutes the same 'changed' entries show up in the event log (screenshot below). The device in question is a Cisco ASR9K. Browsing to the device's page it looks like the changes below aren't actually be applied (no serial number listed, hardware is generic).
How can I go about fixing this?
Thanks in advance!
-- Richard Kuhnsrjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
Php8?
You can try moving the file out of the way. The graphs are the last thing polled I think, so it’s dying at the end before it actually inserts the changes to the device data (but it inserts the eventlog much earlier!)
/usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php
Adam.
Sent from my iPhone
On 4 Oct 2021, at 15:53, Richard Kuhns via observium observium@observium.org wrote:
Digging through the output, I found one section (INSERT INTO ports) that generated a number of
Incorrect integer value: ' '
for several rows, which I don't think is part of this problem. However, the script terminated with:
SQL[UPDATE `snmp_errors` set `error_count` ='311356',`updated` ='1633358368' WHERE `error_id` = '1695'] SQL RUNTIME[0.00367284s]
Fatal error: Uncaught ValueError: max(): Argument #1 ($value) must contain at least one element in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php:23 Stack trace: #0 /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php(23): max(Array) #1 /usr/local/www/observium/includes/include-dir-mib.inc.php(46): include('/usr/local/www/...') #2 /usr/local/www/observium/includes/polling/graphs.inc.php(16): include('/usr/local/www/...') #3 /usr/local/www/observium/includes/polling/functions.inc.php(334): include('/usr/local/www/...') #4 /usr/local/www/observium/poller.php(171): poll_device(Array, Array) #5 {main} thrown in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php on line 23
which doesn't look good.
On 10/4/21 10:18 AM, Adam Armstrong via observium wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Adam. Sent from my iPhone
On 4 Oct 2021, at 15:15, Adam Armstrong adama@observium.org wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Sent from my iPhone
On 4 Oct 2021, at 15:13, Richard Kuhns via observium observium@observium.org wrote:
Hello,
We're running Observerium Professional 21.10.11636.
Every 5 minutes the same 'changed' entries show up in the event log (screenshot below). The device in question is a Cisco ASR9K. Browsing to the device's page it looks like the changes below aren't actually be applied (no serial number listed, hardware is generic).
How can I go about fixing this?
Thanks in advance!
-- Richard Kuhns rjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
-- Richard Kuhns rjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Yes, PHP8 I'm afraid.
Moving cisco-subscriber-session-mib.inc.php took care of that problem, thanks. I'm guessing the following is another php8 issue; the debug run of poller.php now ends with
o Poller Time 43.93 secs o Memory usage 40MB (peak: 40MB) o MySQL Usage Insert[6/0.029s] Update[707/2.427s] Delete[2/0.009s] Cell[30/0.007s] Row[57/0.025s] Rows[172/0.086s] Col[6/0.01s] Connect[1/0s](2.593s 5.902%)
Fatal error: Uncaught TypeError: implode(): Argument #1 ($pieces) must be of type array, string given in /usr/local/www/observium/poller.php:247 Stack trace: #0 /usr/local/www/observium/poller.php(247): implode(' ', NULL) #1 {main} thrown in /usr/local/www/observium/poller.php on line 247
It doesn't look like that will cause any problem with the data collection, though.
Thanks!
On 10/4/21 11:10 AM, Adam Armstrong via observium wrote:
Php8?
You can try moving the file out of the way. The graphs are the last thing polled I think, so it’s dying at the end before it actually inserts the changes to the device data (but it inserts the eventlog much earlier!)
/usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php
Adam.
Sent from my iPhone
On 4 Oct 2021, at 15:53, Richard Kuhns via observium observium@observium.org wrote:
Digging through the output, I found one section (INSERT INTO ports) that generated a number of
Incorrect integer value: ' '
for several rows, which I don't think is part of this problem. However, the script terminated with:
SQL[UPDATE `snmp_errors` set `error_count` ='311356',`updated` ='1633358368' WHERE `error_id` = '1695'] SQL RUNTIME[0.00367284s]
Fatal error: Uncaught ValueError: max(): Argument #1 ($value) must contain at least one element in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php:23 Stack trace: #0 /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php(23): max(Array) #1 /usr/local/www/observium/includes/include-dir-mib.inc.php(46): include('/usr/local/www/...') #2 /usr/local/www/observium/includes/polling/graphs.inc.php(16): include('/usr/local/www/...') #3 /usr/local/www/observium/includes/polling/functions.inc.php(334): include('/usr/local/www/...') #4 /usr/local/www/observium/poller.php(171): poll_device(Array, Array) #5 {main} thrown in /usr/local/www/observium/includes/polling/graphs/cisco-subscriber-session-mib.inc.php on line 23
which doesn't look good.
On 10/4/21 10:18 AM, Adam Armstrong via observium wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Adam. Sent from my iPhone
On 4 Oct 2021, at 15:15, Adam Armstrong adama@observium.org wrote:
Looks like a failed sql query, a debugged poll on this device would probably show why:
./poller.php -h <device_id> -d -r
Sent from my iPhone
On 4 Oct 2021, at 15:13, Richard Kuhns via observium observium@observium.org wrote:
Hello,
We're running Observerium Professional 21.10.11636.
Every 5 minutes the same 'changed' entries show up in the event log (screenshot below). The device in question is a Cisco ASR9K. Browsing to the device's page it looks like the changes below aren't actually be applied (no serial number listed, hardware is generic).
How can I go about fixing this?
Thanks in advance!
-- Richard Kuhnsrjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
observium mailing list observium@observium.org https://link.edgepilot.com/s/052b68c7/4TZZDVp5rEKVo1FsBh04Jw?u=http://postma...
-- Richard Kuhnsrjk@wintek.com Systems Administrator Wintek Powered by Tipmont
Main: 765-742-8428 Direct: 765-269-8541 _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Richard Kuhns -
Richard Kuhns