> DELETE FROM "collectd"
> select * from "collectd" limit 10
name: collectd
time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail
---- --------- ------------- ---- ------- -------------------- -------- --------------- -------- -------- --------
1516116110000000000 1 0 :25826 339244 616 db1 0 4822 2520 0
1516116120000000000 2 0 :25826 500645 900 db1 0 7110 5299 0
1516116130000000000 3 0 :25826 675326 1188 db1 0 9611 8305 0
1516116140000000000 4 0 :25826 852990 1571 db1 0 12092 11632 0
1516116150000000000 5 0 :25826 1034671 1892 db1 0 14673 14673 0
1516116160000000000 5 0 :25826 1202893 2233 db1 0 16997 14673 0
1516116170000000000 6 0 :25826 1385816 2647 db1 0 19485 17287 0
1516116180000000000 7 0 :25826 1553934 2993 db1 0 21811 19971 0
1516116190000000000 8 0 :25826 1726277 3343 db1 0 24250 23082 0
1516116200000000000 9 0 :25826 1906581 3720 db1 0 26745 26212 0
[@db1 ~]# rpm -qa | grep influ
influxdb-1.6.4-1.x86_64
[@db1 ~]# cat /etc/centos-release
CentOS Linux release 7.5.1804 (Core)
Can also not delete this from an empty retention policy of 1h that I created with DROP MEASUREMENT “collectd”
Should such basic things not work? Influx is already existing for quite some time.
Hi good news , such basic things work
> select * from "collectd"
name: collectd
time batchesTx batchesTxFail bind hostname
---- --------- ------------- ---- --------
1542465452733424131 '1' '0' ':25826' db1
1542465453685459505 '1' '0' ':25826' db1
1542465454165343006 '1' '0' ':25826' db1
1542466672229532812 '1' '0' ':25826' db1
1542466674966499994 '1' '0' ':25826' db2
1542466677192239925 '1' '0' ':25826' db3
> DELETE FROM "collectd"
> select * from "collectd" limit 10
>
Useful answer. So we should conclude from your and my test that influx sometimes works and sometimes does not work?