I tried it out, but it sill fails with the same error:
root@turris:~# /usr/bin/python3 /usr/libexec/pakon-light/archive.py && /usr/libexec/pakon-light/backup_sqlite.sh /var/lib/pakon.db /srv/pakon/pakon.db.xz
INFO:root:moved 232506 flows from live to archive
Traceback (most recent call last):
File "/usr/libexec/pakon-light/archive.py", line 131, in <module>
c.execute('DELETE FROM live.traffic WHERE start < ? AND flow_id IS NULL', (start,))
sqlite3.OperationalError: database is locked
Output of ps | grep pakon shows:
root@turris:~# ps | grep pakon
2293 root 14692 S python3 /usr/libexec/pakon-light/pakon-monitor.py
2307 root 10268 S python3 /usr/libexec/pakon-light/pakon-handler.py
2344 root 78940 S {Suricata-Main} /usr/bin/suricata -c /etc/suricata-pakon/suricata.yaml --pidfile /var/run/suricata/suricata.pid --af-packet=br-lan
12470 root 1116 S grep pakon
My pakon.db grew to 350M after ~2days. Let me know if you need any more information from me to track this down. Thanks!