Skip to content
Federico Ceratto edited this page Mar 3, 2020 · 7 revisions

Fastpath runbook

Manual deployment

ssh fastpath.ooni.nu
sudo apt-get update
apt-cache show fastpath | grep Ver | head -n5
sudo apt-get install fastpath

Log monitoring

sudo journalctl -f -u fastpath

Investigate missing msmts

SELECT report_id, input, test_start_time, probe_cc, probe_asn 
FROM measurement 
LEFT OUTER JOIN input ON input.input_no = measurement.input_no     
JOIN report ON report.report_no = measurement.report_no 
WHERE 
    NOT EXISTS ( 
        SELECT                                                    
        FROM                                           
            fastpath fp                                  
        WHERE                                            
            measurement_start_time > NOW() - interval '48 hours' 
            AND measurement_start_time <= NOW() 
            AND fp.report_id = report.report_id                      
            AND fp.test_name = report.test_name 
            AND fp.input = input.input) 
    AND measurement_start_time > NOW() - interval '48 hours' 
    AND measurement_start_time <= NOW() 
LIMIT 100; 
Clone this wiki locally