We had many devices not set to the correct location due to
https://jira.observium.org/browse/OBS-2767
Updated to r9505 and after doing so we reset the geo location via
web interface (device properties -> Geolocation -> Reset GEO
location)
On any device that this was done to it seems like they do not exist
to the poller any longer, none have been polled since the above
action was taken. I based this info from the Per Device stats in the
Pollerlog section (all of the devices that had their geo location
reset were last polled 5+ hours ago, everything else that was not
touched are being polled as expected every 5 minutes)
I see these errors in the db.log file, they appear to have shown up
when the Reset GEO location operation was done on each device:
[2018/10/24 14:48:43 -0400] index.php(4115):
Failed dbQuery (#1064 - You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version
for the right syntax to use near 'WHERE `location_id` = ?' at
line 1), Query: UPDATE `devices_locations` set WHERE
`location_id` = ?
[2018/10/24 14:49:44 -0400] index.php(9439): Failed
dbQuery (#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE `location_id` = ?' at line 1),
Query: UPDATE `devices_locations` set WHERE `location_id` = ?
[2018/10/24 14:50:23 -0400] index.php(9439): Failed
dbQuery (#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE `location_id` = ?' at line 1),
Query: UPDATE `devices_locations` set WHERE `location_id` = ?
[2018/10/24 14:50:57 -0400] index.php(44932): Failed
dbQuery (#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE `location_id` = ?' at line 1),
Query: UPDATE `devices_locations` set WHERE `location_id` = ?
[2018/10/24 14:51:28 -0400] index.php(25685): Failed
dbQuery (#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE `location_id` = ?' at line 1),
Query: UPDATE `devices_locations` set WHERE `location_id` = ?
[2018/10/24 14:52:29 -0400] index.php(25888): Failed
dbQuery (#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE `location_id` = ?' at line 1),
Query: UPDATE `devices_locations` set WHERE `location_id` = ?
Observium system info:
Observium 18.10.9505 (24th October 2018)
OS Linux 3.10.0-862.3.3.el7.x86_64 [amd64] (CentOS 7)
Apache 2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.0.31
PHP 7.0.31 (OPcache: ENABLED)
Python 2.7.5
MySQL 5.5.56-MariaDB (extension: mysqli 5.5.56-MariaDB)
SNMP NET-SNMP 5.7.2
RRDtool 1.6.0
Fping 3.10 (IPv4 only)