Network overview

Good morning :stuck_out_tongue_closed_eyes:

Can you tell me why the devices are not displayed in the browser?
I am grateful for your efforts :slight_smile:


pihole version
Core
Version is v5.18.3-541-g16af216 (Latest: null)
Branch is development
Hash is 16af216b (Latest: 16af216b)
Web
Version is v5.21-986-gcd916b1 (Latest: null)
Branch is development
Hash is cd916b17 (Latest: cd916b17)
FTL
Version is vDev-148e558 (Latest: null)
Branch is development
Hash is 148e558f (Latest: 148e558f)

rpi4-20231108
**Operating System: Debian GNU/Linux 12 (bookworm) **
-Kernel: Linux 6.1.0-26-arm64
-Architecture: arm64

Best regards b4sh

Do you see any error messages in the browser Console (devtools)?

Please check this post, answering to a similar issue:

1 Like

2024-10-26 11:00:01.046 ERROR export_queries_to_disk(): Failed to export queries: database is locked

ERROR export_queries_to_disk(disk.INSERT OR IGNORE INTO disk.domain_by_id SELECT * FROM domain_by_id): Cannot export subtable: database is locked

2024-10-26 10:00:01.030 ERROR export_queries_to_disk(disk.INSERT OR IGNORE INTO disk.client_by_id SELECT * FROM client_by_id): Cannot export subtable: database is locked

2024-10-26 10:00:01.030 ERROR export_queries_to_disk(disk.INSERT OR IGNORE INTO disk.forward_by_id SELECT * FROM forward_by_id): Cannot export subtable: database is locked

2024-10-26 10:00:01.030 ERROR export_queries_to_disk(disk.INSERT OR IGNORE INTO disk.addinfo_by_id SELECT * FROM addinfo_by_id): Cannot export subtable: database is locked

2024-10-26 10:00:01.030 ERROR export_queries_to_disk(disk.UPDATE disk.sqlite_sequence SET seq = (SELECT seq FROM sqlite_sequence WHERE disk.sqlite_sequence.name = sqlite_sequence.name)): Cannot export subtable: database is locked

2024-10-26 10:00:01.031 ERROR ERROR: SQL query "INSERT OR REPLACE INTO disk.ftl (id, value) VALUES ( 1, 1729929592.487122 );" failed: database is locked (SQLITE_BUSY)

2024-10-26 10:00:01.031 ERROR export_queries_to_disk(): Cannot update timestamp: database is locked

2024-10-26 10:00:01.031 ERROR ERROR: SQL query "UPDATE disk.counters SET value = value + 31279 WHERE id = 0;" failed: database is locked (SQLITE_BUSY)

2024-10-26 10:00:01.031 ERROR export_queries_to_disk(): Cannot update total queries counter: database is locked

2024-10-26 10:00:01.031 ERROR ERROR: SQL query "UPDATE disk.counters SET value = value + 4651 WHERE id = 1;" failed: database is locked (SQLITE_BUSY)

2024-10-26 10:00:01.031 ERROR export_queries_to_disk(): Cannot update blocked queries counter: database is locked

2024-10-26 10:00:02.035 ERROR ERROR: SQL query "DELETE FROM query_storage WHERE id IN (SELECT id FROM query_storage WHERE timestamp <= 1727337601 LIMIT (SELECT COUNT(*)/100 FROM query_storage));" failed: database is locked (SQLITE_BUSY)

2024-10-26 10:00:02.035 WARNING Database busy in delete_old_queries_in_DB()!

2024-10-26 10:00:03.040 ERROR ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1722067202;" failed: database is locked (SQLITE_BUSY)

pihole-FTL --config debug.arp true

problem solved :wink:,

pihole checkout ftl tweak/network-table-error-handling

THX

Core
Version is v5.18.3-547-g250fbd2 (Latest: null)
Branch is development
Hash is 250fbd21 (Latest: 250fbd21)
Web
Version is v5.21-992-g45b1784 (Latest: null)
Branch is development
Hash is 45b1784a (Latest: 45b1784a)
FTL
Version is vDev-5cd13c3 (Latest: null)
Branch is tweak/network-table-error-handling
Hash is 5cd13c30 (Latest: 5cd13c30)

The branch has been merged into development.

Please run

pihole checkout ftl development

to get back on track and receive future updates. The branch we used here for testing will not receive any further updates.

Thanks for helping confirming the fix!

1 Like

Donation is on the way :sunglasses:

Best regards b4sh

1 Like