When trying to delete some wrongly added points I did the following interaction in the influx client, I annotated the commands with comments.
This happened with influx v1.7.11
# inspect the last entries which hold some wrong points
select * from MeterDeliveryTariff0 limit 100;
precision rfc3339
select * from MeterDeliveryTariff0 limit 100;
select * from MeterDeliveryTariff0 order by time desc limit 100;
# try a delete query for 1 of the wrong points.
delete from MeterDeliveryTariff0 where time = 2021-12-30T14:45:59.343Z;
# Strange, this did not work
delete from MeterDeliveryTariff0 where time = "2021-12-30T14:45:59.343Z";
# Still does not work
precision u
# Try using unix timestamps
select * from MeterDeliveryTariff0 order by time desc limit 10;
delete from MeterDeliveryTariff0 where time = 1640875559343000;
# still doesn't work
select * from MeterDeliveryTariff0 order by time desc limit 10;
delete from MeterDeliveryTariff0 where time = 1640875559343000;
select * from MeterDeliveryTariff0 order by time desc limit 10;
# simply does not work
# maybe we need to give an interval?
delete from MeterDeliveryTariff0 where time > 1640843993488000 and time <1640875617459000;
select * from MeterDeliveryTariff0 order by time desc limit 10;
delete from MeterDeliveryTariff0 where time > 1640843993488000 and time < 1640875617459000;
select * from MeterDeliveryTariff0 order by time desc limit 10;
# still doesn't work
delete from MeterDeliveryTariff0 where time > 1640843993488000;
# shouldve delete just a few points, most importantly relatively *new* points which hold the wrong points
select * from MeterDeliveryTariff0 order by time desc limit 10;
# SHOCK, realise everything is gone, including points before! 1640843993488000
Is there any logical explanation of the witnessed behavior?
