RE: DEBUG Fatal error: infodb: UNIQUE constraint failed: bandwidth_usage_rollups.interval_start

Here is the output

SQLite version 3.18.0 2017-03-28 18:48:43
Enter “.help” for usage hints.
sqlite> SELECT datetime(strftime(’%Y-%m-%dT%H:00:00’, created_at)) created, bu.satellite_id sat_id, bu.action act , SUM(bu.amount) amt
…> FROM bandwidth_usage bu, bandwidth_usage_rollups bur
…> WHERE datetime(created_at) < datetime(CURRENT_TIMESTAMP)
…> AND bur.interval_start = created
…> AND bur.satellite_id = sat_id
…> AND bur.action = act
…> GROUP BY created, sat_id, act;
2019-07-24 15:00:00||1|2603300096
2019-07-24 15:00:00||2|1364762624
2019-07-24 15:00:00|�,B|3|768
sqlite>

2 posts were merged into an existing topic: DEBUG Fatal error: infodb: UNIQUE constraint failed: bandwidth_usage_rollups.interval_start