jokob-sk
commented
1 year ago Hi there,
Can you please enable LOG_LEVEL=debug and post the pialert.log file after a crash?
The SQL query to execute explicitly checks for nulls (notice AND cur_Name IS NOT NULL below), so unsure why this would be happening without additional logs:
UPDATE Devices
SET dev_NAME = (SELECT cur_Name FROM CurrentScan
WHERE cur_MAC = dev_MAC)
WHERE (dev_Name in ("(unknown)", "(name not found)", "" )
OR dev_Name IS NULL)
AND EXISTS (SELECT 1 FROM CurrentScan
WHERE cur_MAC = dev_MAC
AND cur_Name IS NOT NULL
AND cur_Name IS NOT 'null'
AND cur_Name <> '') Thanks in advance, j
ftrueck
I navigate through pi.alert and all of a sudden the web is not reacting anymore. When I check the status of the docker container then I see a stacktrace from network scan. In the following I attach the Log when the crash happened.
Traceback (most recent call last): File "/usr/lib/python3.9/runpy.py", line 197, in _run_module_as_main return _run_code(code, main_globals, None, File "/usr/lib/python3.9/runpy.py", line 87, in _run_code exec(code, run_globals) File "/home/pi/pialert/pialert/main.py", line 179, in
sys.exit(main())
File "/home/pi/pialert/pialert/main.py", line 136, in main process_scan(db) File "/home/pi/pialert/pialert/networkscan.py", line 41, in process_scan update_devices_data_from_scan (db) File "/home/pi/pialert/pialert/device.py", line 193, in update_devices_data_from_scan sql.execute ("""UPDATE Devices sqlite3.IntegrityError: NOT NULL constraint failed: Devices.dev_Name 23:19:49 [Notification] included sections: ['new_devices', 'down_devices', 'events'] 23:19:49 [Notification] New Devices sections done. 23:19:49 [Notification] Down Devices sections done. 23:19:49 [Notification] Events sections done. 23:19:49 [Notification] No changes to report 23:19:49 [Notification] Notifications changes: 0 23:19:49 [MAIN] Process: Wait 23:19:54 [MAIN] waiting to start next loop 23:19:59 [MAIN] waiting to start next loop 23:20:05 [MAIN] waiting to start next loop 23:20:10 [MAIN] waiting to start next loop 23:20:15 [MAIN] waiting to start next loop 23:20:20 [MAIN] waiting to start next loop 23:20:25 [MAIN] waiting to start next loop 23:20:30 [MAIN] waiting to start next loop 23:20:35 [MAIN] waiting to start next loop 23:20:40 [MAIN] waiting to start next loop 23:20:45 [MAIN] waiting to start next loop 23:20:50 [Notification] Check if something to report 23:20:50 [Notification] Open text Template 23:20:50 [Notification] Open html Template 23:20:50 [Notification] Using template/back/report_template.html 23:20:50 [Notification] included sections: ['new_devices', 'down_devices', 'events'] 23:20:50 [Notification] New Devices sections done. 23:20:50 [Notification] Down Devices sections done. 23:20:50 [Notification] Events sections done. 23:20:50 [Notification] No changes to report 23:20:50 [Notification] Notifications changes: 0 23:20:50 [MAIN] Process: Wait 23:20:55 [MAIN] waiting to start next loop 23:21:00 [MAIN] waiting to start next loop 23:21:05 [MAIN] waiting to start next loop 23:21:10 [MAIN] waiting to start next loop 23:21:15 [MAIN] waiting to start next loop 23:21:20 [MAIN] waiting to start next loop 23:21:26 [MAIN] waiting to start next loop 23:21:31 [MAIN] waiting to start next loop 23:21:36 [MAIN] waiting to start next loop 23:21:41 [MAIN] waiting to start next loop 23:21:46 [API] Updating table_devices.json file in /front/api 23:21:46 [MAIN] waiting to start next loop 23:21:51 [Plugins] --------------------------------------------- 23:21:51 [Plugins] display_name: Arp-Scan (Network scan) 23:21:51 [Plugins] Executing: python3 /home/pi/pialert/front/plugins/arp_scan/script.py userSubnets={subnets} 23:22:44 [Plugins] SUCCESS, received 49 entries 23:22:45 [API] Updating table_plugins_events.json file in /front/api 23:22:46 [API] Updating table_plugins_history.json file in /front/api 23:22:46 [API] Updating table_plugins_objects.json file in /front/api 23:22:46 [Plugins] --------------------------------------------- 23:22:46 [Plugins] display_name: DHCP Leases (Device import) 23:22:46 [Plugins] Executing: python3 /home/pi/pialert/front/plugins/dhcp_leases/script.py paths={paths} 23:22:46 [Plugins] SUCCESS, received 41 entries 23:22:47 [API] Updating table_plugins_history.json file in /front/api 23:22:47 [Plugins] --------------------------------------------- 23:22:47 [Plugins] display_name: Internet check 23:22:47 [Plugins] Executing: python3 /home/pi/pialert/front/plugins/internet_ip/script.py prev_ip={prev_ip} DIG_GET_IP_ARG={DIG_GET_IP_ARG} 23:22:47 [Plugins] SUCCESS, received 1 entries 23:22:47 [API] Updating table_plugins_history.json file in /front/api 23:22:47 [Process Scan] Processing scan results 23:22:47 [Process Scan] Print Stats 23:22:47 [Scan Stats] Devices Detected.......: 92 23:22:47 [Scan Stats] New Devices............: 0 23:22:47 [Scan Stats] Down Alerts............: 0 23:22:47 [Scan Stats] New Down Alerts........: 0 23:22:47 [Scan Stats] New Connections........: 2 23:22:47 [Scan Stats] Disconnections.........: 0 23:22:47 [Scan Stats] IP Changes.............: 1 23:22:47 [Scan Stats] Scan Method Statistics: 23:22:47 DHCPLSS: 41 23:22:47 INTRNT: 1 23:22:47 arp-scan: 49 23:22:47 local_MAC: 1 23:22:47 [Process Scan] Stats end 23:22:47 [Process Scan] Sessions Events (connect / discconnect) 23:22:47 [Process Scan] Creating new devices 23:22:47 [Process Scan] Updating Devices Info