You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
> drop database justtest
> create database justtest
> use justtest
Using database justtest
> show measurements
name: measurements
------------------
name
test.test.test.test2
I can show the measurements after recreating the database justtest.
Looks like the points are gone but the database metadata persists:
> drop database mydb
> create database mydb
> use mydb
Using database mydb
> show measurements
name: measurements
------------------
name
triangle
triangle-float
> select * from triangle
> select value from triangle
> show series
name: triangle
--------------
_key tagkey
triangle,tagkey=tagval tagval
name: triangle-float
--------------------
_key tagkey2
triangle-float,tagkey2=tagval1 tagval1
Bouncing the database between the drop and create database statements appears to alleviate the issue, pointing I think convincingly at the metadata store being the culprit.
> drop database mydb
> show databases
ERR: Get http://localhost:8086/query?db=&q=show+databases: dial tcp 127.0.0.1:8086: connection refused
> show databases
name: databases
---------------
name
> create database mydb
> use mydb
Using database mydb
> show series
> select value from triangle
ERR: measurement not found: "mydb"..triangle
scenario 1:
I have run below lines in the influx cli.
I can show the measurements after recreating the database
justtest
.scenario 2:
1 Insert a point with line protocol.
2 Select the results in influx cil.
3 Drop and create the database with the same name.
4 Insert a point without
value2
field.5 Select again.
We can still see the
value2
field.Any ideas about this?
Thanks in advance.
The text was updated successfully, but these errors were encountered: