And here comes the failed one (10.0.1.64)
[2020-03-23 14:51:00.052 15383] dbquery: "BEGIN TRANSACTION"
[2020-03-23 14:51:00.054 15383] dbquery: "END TRANSACTION"
[2020-03-23 14:51:00.066 15383] dbquery: "INSERT OR REPLACE INTO ftl (id, value) VALUES ( 1, 1584971448 );"
[2020-03-23 14:51:00.074 15383] dbquery: "UPDATE counters SET value = value + 12 WHERE id = 0;"
[2020-03-23 14:51:00.080 15383] dbquery: "UPDATE counters SET value = value + 0 WHERE id = 1;"
[2020-03-23 14:51:00.081 15383] Notice: Queries stored in FTL_db: 12 (took 31.2 ms, last SQLite ID 2179730)
[2020-03-23 14:51:00.082 15383] dbquery: "BEGIN TRANSACTION"
[2020-03-23 14:51:00.090 15383] dbquery: "SELECT id FROM network WHERE hwaddr = 'd4:38:9c:01:ac:6c';"
[2020-03-23 14:51:00.091 15383] dbquery: "UPDATE network SET lastQuery = MAX(lastQuery, 1584971170) WHERE id = 4;"
[2020-03-23 14:51:00.092 15383] dbquery: "UPDATE network SET numQueries = numQueries + 0 WHERE id = 4;"
[2020-03-23 14:51:00.092 15383] dbquery: "UPDATE network SET name = ? WHERE id = ?;" with arguments 1 = "sony-xz1-compact" and 2 = 4
[2020-03-23 14:51:00.092 15383] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen) VALUES(4,'10.0.1.190',(cast(strftime('%s', 'now') as int)));"
[2020-03-23 14:51:00.093 15383] dbquery: "SELECT id FROM network WHERE hwaddr = 'f0:9f:c2:1e:8f:e9';"
[2020-03-23 14:51:00.093 15383] dbquery: "UPDATE network SET lastQuery = MAX(lastQuery, 1584968871) WHERE id = 1;"
[2020-03-23 14:51:00.093 15383] dbquery: "UPDATE network SET numQueries = numQueries + 0 WHERE id = 1;"
[2020-03-23 14:51:00.093 15383] dbquery: "UPDATE network SET name = ? WHERE id = ?;" with arguments 1 = "usg" and 2 = 1
[2020-03-23 14:51:00.093 15383] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen) VALUES(1,'10.0.1.1',(cast(strftime('%s', 'now') as int)));"
[2020-03-23 14:51:00.094 15383] dbquery: "SELECT id FROM network WHERE hwaddr = '3c:97:0e:13:36:c0';"
[2020-03-23 14:51:00.094 15383] dbquery: "UPDATE network SET lastQuery = MAX(lastQuery, 1584971420) WHERE id = 2;"
[2020-03-23 14:51:00.094 15383] dbquery: "UPDATE network SET numQueries = numQueries + 4 WHERE id = 2;"
[2020-03-23 14:51:00.094 15383] dbquery: "UPDATE network SET name = ? WHERE id = ?;" with arguments 1 = "thinkpad-lan" and 2 = 2
[2020-03-23 14:51:00.094 15383] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen) VALUES(2,'10.0.1.136',(cast(strftime('%s', 'now') as int)));"
[2020-03-23 14:51:00.094 15383] Network table: Client 10.0.1.136 has zero queries (4241, 0)
[2020-03-23 14:51:00.094 15383] Network table: Client 10.0.1.2 has zero queries (88, 0)
[2020-03-23 14:51:00.094 15383] Network table: Client 127.0.0.1 has zero queries (372, 0)
[2020-03-23 14:51:00.094 15383] Network table: Client 10.0.1.1 has zero queries (73, 0)
[2020-03-23 14:51:00.094 15383] Network table: Client 10.0.1.215 has zero queries (23, 0)
[2020-03-23 14:51:00.095 15383] Network table: Client 10.0.1.64 known through ARP/neigh cache
[2020-03-23 14:51:00.095 15383] Network table: Client 10.0.1.182 has zero queries (33, 0)
[2020-03-23 14:51:00.095 15383] Network table: Client 10.0.1.190 has zero queries (1677, 0)
[2020-03-23 14:51:00.095 15383] Network table: Client 10.0.40.3 has zero queries (287, 0)
[2020-03-23 14:51:00.095 15383] Network table: 10.0.30.254 NOT known through ARP/neigh cache
[2020-03-23 14:51:00.095 15383] dbquery: "SELECT network_id FROM network_addresses WHERE ip = '10.0.30.254' AND lastSeen > (cast(strftime('%s', 'now') as int)-86400) ORDER BY lastSeen DESC;"
[2020-03-23 14:51:00.095 15383] APR: Identified device 10.0.30.254 using most recently used IP address
[2020-03-23 14:51:00.095 15383] dbquery: "UPDATE network SET lastQuery = MAX(lastQuery, 1584971448) WHERE id = 3;"
[2020-03-23 14:51:00.095 15383] dbquery: "UPDATE network SET numQueries = numQueries + 2 WHERE id = 3;"
[2020-03-23 14:51:00.095 15383] dbquery: "UPDATE network SET name = ? WHERE id = ?;" with arguments 1 = "chromecast-wohnzimmer" and 2 = 3
[2020-03-23 14:51:00.095 15383] dbquery: "INSERT OR REPLACE INTO network_addresses (network_id,ip,lastSeen) VALUES(3,'10.0.30.254',(cast(strftime('%s', 'now') as int)));"
[2020-03-23 14:51:00.096 15383] dbquery: "COMMIT"
[2020-03-23 14:51:00.101 15383] ARP table processing (3 entries from ARP, 1 from FTL's cache) took 19.1 ms
[2020-03-23 14:51:00.487 15383] 0 / 10 client host names resolved
[2020-03-23 14:51:00.487 15383] 0 / 1 upstream server host names resolved
Mo 23. Mär 14:50:52 CET 2020
10.0.1.190 dev eth0 lladdr d4:38:9c:01:ac:6c STALE
10.0.1.1 dev eth0 lladdr f0:9f:c2:1e:8f:e9 DELAY
0.0.0.0 dev lo lladdr 00:00:00:00:00:00 NOARP
10.0.1.64 dev eth0 FAILED
10.0.1.136 dev eth0 lladdr 3c:97:0e:13:36:c0 REACHABLE
ff02::1:ff42:dae4 dev eth0 lladdr 33:33:ff:42:da:e4 NOARP
ff02::2 dev eth0 lladdr 33:33:00:00:00:02 NOARP
ff02::16 dev eth0 lladdr 33:33:00:00:00:16 NOARP
::1 dev lo lladdr 00:00:00:00:00:00 NOARP
No false positive mock-device