Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

the drop measurement reappears and the data is old #10263

Closed
EmptyRabbit opened this issue Sep 6, 2018 · 5 comments
Closed

the drop measurement reappears and the data is old #10263

EmptyRabbit opened this issue Sep 6, 2018 · 5 comments

Comments

@EmptyRabbit
Copy link

EmptyRabbit commented Sep 6, 2018

System info:
influxdb version:1.5.2
operating system:ubuntu
tools:iterm,pycharm
language:python3.6

Steps to reproduce:

1.use python-influxdb DataFrameClient.write_points write data to measurement 'TS121'
2. drop measurement TS121
3.use python-influxdb DataFrameClient.write_points write same data to measurement 'TS121' again
4.drop measurement TS121
5.use python-influxdb DataFrameClient.write_points write other data to measurement 'TS121' again
6.drop measurement TS121
7.select * from TS121 limit 1

Expected behavior:
after step 7
I expected nothing would be printed

Actual behavior:
after step 7
the screen show TS121 has data I wrote in step 1&3 not data in step 5
using DataFrameClient.query also could query the data in step 1&3

Additional info:
don't know much details.but drop other measurement is ok

@e-dard
Copy link
Contributor

e-dard commented Nov 19, 2018

Possibly a duplicate of #9694

@zeebo
Copy link
Contributor

zeebo commented Nov 20, 2018

I'd love to have some more details on this:

  1. Is this on a fresh database?
  2. What indexes are being used for your shards?
  3. Does the issue persist after a restart?
  4. Are you writing to the measurement the same time you're dropping it?
  5. Does the issue still happen on version 1.7.1?

To collect shard index types, you can either navigate to the shard folder and check if it has an index folder, or run this command:

influx -database <database> -execute 'show stats' | grep indexType | sort | uniq

@dgnorton dgnorton added the 1.x label Jan 7, 2019
@russorat
Copy link
Contributor

@e-dard can this be closed?

@stale
Copy link

stale bot commented Jul 23, 2019

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Jul 23, 2019
@e-dard
Copy link
Contributor

e-dard commented Jul 23, 2019

@EmptyRabbit I think I fixed this in #14266. It will be available in 1.8 or 1.7.9 (if there is a 1.7.9).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

6 participants