# Cannot remove \_internal measurements / series **URL:** \ **Category:** Systems\ **Created:** [November 20, 2018, 9:45pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515 "2018-11-20T21:45:19Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![f1outsourcing](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@f1outsourcing](https://community.influxdata.com/u/f1outsourcing)\ **Post date:** [November 20, 2018, 9:45pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/1 "2018-11-20T21:45:19Z")
I recently enabled the store-database = “\_internal” in /etc/influxdb/influxdb.conf ``` > use _internal Using database _internal > show measurements name: measurements name ---- collectd cq database httpd queryExecutor runtime shard subscriber tsm1_cache tsm1_engine tsm1_filestore tsm1_wal write ``` So now I would like to delete these measurements from the “collections” database ``` > use "collections"."autogen" Using database collections Using retention policy autogen > select count(batchesTx) from "collectd" name: collectd time count ---- ----- 0 3109 > select * from collectd order by time desc limit 2 name: collectd time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail ---- --------- ------------- ---- ------- -------------------- -------- --------------- -------- -------- -------- 1516147190000000000 2732 0 :25826 868809792 1889925 db1 0 11669872 11668618 0 1516147180000000000 2731 0 :25826 868506024 1889332 db1 0 11665765 11664594 0 ``` Running the following delete statements ``` > drop series from "collectd" > select * from collectd order by time desc limit 2 name: collectd time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail ---- --------- ------------- ---- ------- -------------------- -------- --------------- -------- -------- -------- 1516147190000000000 2732 0 :25826 868809792 1889925 db1 0 11669872 11668618 0 1516147180000000000 2731 0 :25826 868506024 1889332 db1 0 11665765 11664594 0 > ``` No result, this one: ``` > delete from "collectd" > select * from collectd order by time desc limit 2 name: collectd time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail ---- --------- ------------- ---- ------- -------------------- -------- --------------- -------- -------- -------- 1516147190000000000 2732 0 :25826 868809792 1889925 db1 0 11669872 11668618 0 1516147180000000000 2731 0 :25826 868506024 1889332 db1 0 11665765 11664594 0 ``` No result, oow this one: ``` > drop measurement "collectd" > select * from collectd order by time desc limit 2 name: collectd time batchesTx batchesTxFail bind bytesRx droppedPointsInvalid hostname pointsParseFail pointsRx pointsTx readFail ---- --------- ------------- ---- ------- -------------------- -------- --------------- -------- -------- -------- 1516147190000000000 2732 0 :25826 868809792 1889925 db1 0 11669872 11668618 0 1516147180000000000 2731 0 :25826 868506024 1889332 db1 0 11665765 11664594 0 ``` None of the commands resulted in reporting an error, just reported nothing ---
**Author:** ![katy](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/katy/32/855_2.png) [@katy](https://community.influxdata.com/u/katy)\ **Post date:** [November 20, 2018, 10:39pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/2 "2018-11-20T22:39:41Z")
The issues with `DROP` and `DELETE` are known. You can view some of the GitHub issues [here](https://github.com/influxdata/influxdb/issues/10052) and [here](https://github.com/influxdata/influxdb/issues/9694) if you want to keep up-to-date or see what other people have done. ---
**Author:** ![f1outsourcing](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@f1outsourcing](https://community.influxdata.com/u/f1outsourcing)\ **Post date:** [November 27, 2018, 2:29pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/3 "2018-11-27T14:29:31Z")
FYI, upgraded to influxdb-1.7.1-1.x86\_64 still have this issue, while someone could with 1.7.1 in this post. > > > \### Bug report > > Cannot delete measurments. > I accidentally created a bunch of …MS SQL server measurements into my Telegraf db, and want to remove them. When i try to remove them with DROP MEASUREMENT "\" it doesnt actually seem to drop it... > > My mistake seems to have created over 1000 measurements, so i suspect the bug/issue is due to the number of measurements. > If i create a new test database i can drop measurements as expected. > > \_\_System info:\_\_ > Influx 1.5.1 running on Red Hat 4.8.5-11 > > > \_\_Steps to reproduce:\_\_ > > Create a lot of measurements - i did this by trying to use the MS SQL Server telegraf input. > > > 1. USE telegraf > 2. DROP MEASUREMENT "xa7\_sessions" > It doesnt matter what measurement i specify, i cannot remove it. There is no error > 3. SHOW MEASUREMENTS > Its still there! > > \_\_Expected behavior:\_\_ > Id expect the measurement to no longer be returned after running the DROP MEASUREMENT command. > > \_\_Actual behavior:\_\_ > SHOW MEASUREMENT continues to return the measurement..and will not die ;-( > > \_\_Additional info:\_\_ \[Include gist of relevant config, logs, etc.\] ---
**Author:** ![f1outsourcing](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@f1outsourcing](https://community.influxdata.com/u/f1outsourcing)\ **Post date:** [December 8, 2018, 11:06am UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/4 "2018-12-08T11:06:05Z")
When is this going to be resolved? It is quite a required function to be able to drop series and measurements don’t you think also? ---
**Author:** ![f1outsourcing](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@f1outsourcing](https://community.influxdata.com/u/f1outsourcing)\ **Post date:** [December 16, 2018, 12:21pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/5 "2018-12-16T12:21:34Z")
Still not working, enabling debug logging does not even show anything in logs. influxdb-1.7.2-1.x86\_64 ---
**Author:** ![f1outsourcing](https://avatars.discourse-cdn.com/v4/letter/f/a183cd/32.png) [@f1outsourcing](https://community.influxdata.com/u/f1outsourcing)\ **Post date:** [December 21, 2018, 1:54pm UTC](https://community.influxdata.com/t/cannot-remove-internal-measurements-series/7515/6 "2018-12-21T13:54:39Z")
this fixed it ``` find . -type d -name index -exec rm -Rf {} \; influx_inspect buildtsi -datadir data/ -waldir wal/ ```