Ojas
02/14/2023, 5:53 AMKeith Swagler
02/14/2023, 2:35 PM--watchdog_level=-1
to disable limitsSam Lai
02/14/2023, 2:58 PMunified_log
queries should have the timestamp
greater-than-equal constraint specified to bound the search, e.g.
SELECT * FROM unified_log where process="sharingd" and category="AirDrop" and message like "Start transaction to%" and timestamp >= (SELECT unix_time-3600 FROM time);
to get the relevant log entries from the past hour (3600 seconds).
Note that I think there’s a memory leak with the unified_log
table, so even if your query succeeds, a subsequent query might get denylisted (as the watchdog doesn’t expect leaks after query execution). I’d do some testing first if you want to roll out a scheduled unified_log
query.