[0.9.0] Can not recreate a measurement

[indrekj]

v0.9.0

Replicate:

#!/bin/sh

echo ">> Recreating the database"
curl -G http://localhost:8086/query --data-urlencode "q=DROP DATABASE foobar"
curl -G http://localhost:8086/query --data-urlencode "q=CREATE DATABASE foobar"

echo
echo ">> Creating a measurement"
curl -XPOST 'http://localhost:8086/write?db=foobar' -d 'cpu,host=serverB,region=us-west value=1.0'

echo
echo ">> Dropping the measurement"
curl -G http://localhost:8086/query --data-urlencode "db=foobar" --data-urlencode "q=DROP MEASUREMENT cpu"

echo
echo ">> Recreating the measurement"
curl -XPOST 'http://localhost:8086/write?db=foobar' -d 'cpu,host=serverA,region=us-west value=1.0'

echo
echo ">> Querying the measurement"
curl -G http://localhost:8086/query --data-urlencode "db=foobar" --data-urlencode "q=SELECT COUNT(value) FROM cpu"

Output:

>> Recreating the database
{"results":[{}]}{"results":[{}]}
>> Creating a measurement

>> Dropping the measurement
{"results":[{"error":"bucket not found"}]}
>> Recreating the measurement
write failed: database not open
>> Querying the measurement
{"results":[{"error":"unknown field or tag name in select clause: value"}]}%

[#2940 might be also related]

[jonaz]

I have the exact same issue with 0.9.0!

If i restart the server after i got "unknown field or tag name in select clause: value"
the measurement seems to be restored as is was before i ran DROP measurement

[beckettsean]

Thanks for the find! Here's a slightly easier to parse example using the CLI:

> CREATE DATABASE drop_test
> USE drop_test
Using database drop_test
> INSERT cpu,host=serverB,region=us-west value=1.0
> SELECT * FROM cpu
name: cpu
tags: host=serverB, region=us-west
time                value
----                -----
2015-06-12T21:46:13.375960817Z  1

> DROP MEASUREMENT cpu
> INSERT cpu,host=serverB,region=us-west value=1.0
> SELECT * FROM cpu
ERR: select statement must include at least one field or function call
> SHOW MEASUREMENTS
name: measurements
------------------
name
cpu

> SELECT value FROM cpu
ERR: unknown field or tag name in select clause: value
> 

[consense]

+1
very annoying for integration testing of our influxdb reliant code

[otoolep]

I'm working on the query code at the moment, I'll take a look at this.

[otoolep]

Should be fixed in 0.9.1 by #3002

[otoolep]

An effective workaround is to restart the system after dropping the measurement. Once this change goes in, the restart will no longer be required.

[otoolep]

All fixed.

[otoolep]

Thanks for the excellent bug report @indrekj

[KrishnaPG]

Getting the same error in latest version (0.9.3), after dropping a measurement and inserting later.

[beckettsean]

@KrishnaPG can you please provide the steps to reproduce the issue, both the writes and the queries? I am unable to reproduce this error on 0.9.3:

> CREATE DATABASE drop_test1
> USE drop_test1
Using database drop_test1
> INSERT cpu,host=serverB,region=us-west value=1.0
> SELECT * FROM cpu
name: cpu
---------
time                host    region  value
2015-08-31T18:31:58.221415617Z  serverB us-west 1

> DROP MEASUREMENT cpu
> INSERT cpu,host=serverB,region=us-west value=1.0
> SELECT * FROM cpu
name: cpu
---------
time                host    region  value
2015-08-31T18:32:10.046086765Z  serverB us-west 1