some compute server purchases to watch out for

[williamstein]

In some rare instances the network usage purchase doesn't get closed promptly. There are 3 that have ever had this happen, all from the last two weeks (two are mine and one is Andrey Novoseltsev's). It might be that the network info will just take longer than expected to arrive from Google and these will clear in a few days. I'm creating this ticket to keep watch on this.

mc=# select count(*) from purchases where period_start <= now() - interval '1 week' and period_end is null;
-[ RECORD 1 ]
count | 3

smc=# select * from purchases where period_start <= now() - interval '1 week' and period_end is null;
-[ RECORD 1 ]------+----------------------------------------------------------------------------------------------------------------
id                 | 83316
time               | 2024-10-19 23:13:25.577569
account_id         | 25e2cae4...
cost               | 
invoice_id         | 
paid               | 
project_id         | 433cab19...
description        | {"type": "compute-server-network-usage", "amount": 0, "last_updated": 1729379605577, "compute_server_id": 2537}
tag                | 
notes              | 
pending            | 
cost_per_hour      | 
period_start       | 2024-10-19 23:13:25.577
period_end         | 
service            | compute-server-network-usage
day_statement_id   | 
month_statement_id | 
cost_so_far        | 0
-[ RECORD 2 ]------+----------------------------------------------------------------------------------------------------------------
id                 | 83318
time               | 2024-10-19 23:14:41.758676
account_id         | 25e2cae4-...
cost               | 
invoice_id         | 
paid               | 
project_id         | 433cab19-...
description        | {"type": "compute-server-network-usage", "amount": 0, "last_updated": 1729379681758, "compute_server_id": 1101}
tag                | 
notes              | 
pending            | 
cost_per_hour      | 
period_start       | 2024-10-19 23:14:41.758
period_end         | 
service            | compute-server-network-usage
day_statement_id   | 
month_statement_id | 
cost_so_far        | 0
...