pfSense-pkg-Status_Traffic_Totals (vnstat) - Error: Unable to parse database

[mfld]

Since one of the recent snapshots, vnstat database seems corrupted. Seen on 3 / 3 test boxes.

in CLI it has some clues:

vnstat

                      rx      /      tx      /     total    /   estimated
 enc0:
Error: Failed to get interface id from database (1): no such column: enc0
Error: Failed to fetch month data.
 pflog0:
Error: Failed to get interface id from database (1): no such column: pflog0
Error: Failed to fetch month data.
 pfsync0:
Error: Failed to get interface id from database (1): no such column: pfsync0
Error: Failed to fetch month data.
 WG0 (tun_wg0):
Error: Failed to get interface id from database (1): no such column: tun_wg0
Error: Failed to fetch month data.
 WAN (vtnet0):
Error: Failed to get interface id from database (1): no such column: vtnet0
Error: Failed to fetch month data.

23.01 is not effected. 2.7.0.a is.

db wipe via "Reset Graphing Data" button and service restart did not resolve.

Currently on 2.7.0.a.20230310.0600

[jimp]

Looks like it was from a recent sqlite change:

https://github.com/vergoh/vnstat/issues/243

https://redmine.pfsense.org/issues/14096