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.

Sign up for GitHub

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

Jump to bottom

Series cannot be deleted #371

Closed
sontags opened this issue Mar 28, 2014 · 5 comments
Closed

Series cannot be deleted #371

sontags opened this issue Mar 28, 2014 · 5 comments
Milestone
0.5.2

Comments

@sontags
Copy link

sontags commented Mar 28, 2014

Tested with InfluxDB v0.5.0-rc.5 (git: d253d09) on RHEL6.4

There seems to be no way to delete series. Reproduce like so:

# PREPARE: 1) CREATE DB; 2) FEED DATA; 3) LIST SERIES
curl -X POST 'http://localhost:8086/db?u=root&p=root' -d '{"name": "s"}'
curl -X POST 'http://localhost:8086/db/s/series?u=root&p=root&time_precision=s' -d '[{"name": "response_times","columns": ["time", "value"],"points": [[1382819388, 234.3]]}]'
curl -X GET 'http://menetd:8086/db/s/series?u=root&p=root&q=list%20series%3B' 

# DROP DB: 1) DROP DB; 2) RECREATE DB; 3) LIST SERIES -> (SERIES ARE STILL THERE!)
curl -X DELETE 'http://localhost:8086/db/s?u=root&p=root'
curl -X POST 'http://localhost:8086/db?u=root&p=root' -d '{"name": "s"}'
curl -X GET 'http://menetd:8086/db/s/series?u=root&p=root&q=list%20series%3B' 

# DROP DB: 1) SELETE SERIES; 2) LIST SERIES -> (SERIES ARE STILL THERE!)
curl -X DELETE 'http://localhost:8086/db/s/series/response_times?u=root&p=root'
curl -X GET 'http://menetd:8086/db/s/series?u=root&p=root&q=list%20series%3B'
@jvshahid
Copy link
Contributor

Can you run curl with -v and paste the output here

@jvshahid
Copy link
Contributor

also, why are you hitting localhost and menetd, are these the same machine ?

@sontags
Copy link
Author

sontags commented Mar 28, 2014

@jvshahid Yes, menetd equals localhost, sorry...

# PREPARE: 1) CREATE DB; 2) FEED DATA; 3) LIST SERIES
curl -v -X POST 'http://localhost:8086/db?u=root&p=root' -d '{"name": "s"}'
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > POST /db?u=root&p=root HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    > Content-Length: 13
    > Content-Type: application/x-www-form-urlencoded
    >
    < HTTP/1.1 201 Created
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: text/plain
    < Date: Fri, 28 Mar 2014 15:30:59 GMT
    < Content-Length: 0
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
curl -v -X POST 'http://localhost:8086/db/s/series?u=root&p=root&time_precision=s' -d '[{"name": "response_times","columns": ["time", "value"],"points": [[1382819388, 234.3]]}]'
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > POST /db/s/series?u=root&p=root&time_precision=s HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    > Content-Length: 89
    > Content-Type: application/x-www-form-urlencoded
    >
    < HTTP/1.1 200 OK
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: text/plain
    < Date: Fri, 28 Mar 2014 15:31:45 GMT
    < Content-Length: 0
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
curl -v -X GET 'http://localhost:8086/db/s/series?u=root&p=root&q=list%20series%3B' 
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > GET /db/s/series?u=root&p=root&q=list%20series%3B HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    >
    < HTTP/1.1 200 OK
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: application/json
    < Date: Fri, 28 Mar 2014 15:32:32 GMT
    < Content-Length: 76
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
    [{"name":"response_times","columns":["time","sequence_number"],"points":[]}]

# DROP DB: 1) DROP DB; 2) RECREATE DB; 3) LIST SERIES -> (SERIES ARE STILL THERE!)
curl -v -X DELETE 'http://localhost:8086/db/s?u=root&p=root'
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > DELETE /db/s?u=root&p=root HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    >
    < HTTP/1.1 204 No Content
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: text/plain
    < Date: Fri, 28 Mar 2014 15:33:19 GMT
    < Content-Length: 0
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
curl -v -X POST 'http://localhost:8086/db?u=root&p=root' -d '{"name": "s"}'
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > POST /db?u=root&p=root HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    > Content-Length: 13
    > Content-Type: application/x-www-form-urlencoded
    >
    < HTTP/1.1 201 Created
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: text/plain
    < Date: Fri, 28 Mar 2014 15:33:49 GMT
    < Content-Length: 0
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
curl -v -X GET 'http://localhost:8086/db/s/series?u=root&p=root&q=list%20series%3B' 
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > GET /db/s/series?u=root&p=root&q=list%20series%3B HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    >
    < HTTP/1.1 200 OK
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: application/json
    < Date: Fri, 28 Mar 2014 15:34:15 GMT
    < Content-Length: 76
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
    [{"name":"response_times","columns":["time","sequence_number"],"points":[]}]

# DROP DB: 1) SELETE SERIES; 2) LIST SERIES -> (SERIES ARE STILL THERE!)
curl -v -X DELETE 'http://localhost:8086/db/s/series/response_times?u=root&p=root'
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > DELETE /db/s/series/response_times?u=root&p=root HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    >
    < HTTP/1.1 204 No Content
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: text/plain
    < Date: Fri, 28 Mar 2014 15:34:52 GMT
    < Content-Length: 0
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
curl -v -X GET 'http://localhost:8086/db/s/series?u=root&p=root&q=list%20series%3B' 
    * About to connect() to localhost port 8086 (#0)
    *   Trying 127.0.0.1... connected
    * Connected to localhost (127.0.0.1) port 8086 (#0)
    > GET /db/s/series?u=root&p=root&q=list%20series%3B HTTP/1.1
    > User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.14.3.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
    > Host: localhost:8086
    > Accept: */*
    >
    < HTTP/1.1 200 OK
    < Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept
    < Access-Control-Allow-Methods: GET, POST, PUT, DELETE
    < Access-Control-Allow-Origin: *
    < Access-Control-Max-Age: 2592000
    < Content-Type: application/json
    < Date: Fri, 28 Mar 2014 15:35:18 GMT
    < Content-Length: 76
    <
    * Connection #0 to host localhost left intact
    * Closing connection #0
    [{"name":"response_times","columns":["time","sequence_number"],"points":[]}]

@jvshahid
Copy link
Contributor

Thanks @sontags this definitely looks like a bug. Can you keep your data directory handy in case we need it. I'll try to reproduce this bug in the next few hours and get it fixed asap.

@jvshahid jvshahid added this to the 0.5.2 milestone Mar 28, 2014
@breml
Copy link

breml commented May 2, 2014

Tested with 0.5.10 and 0.5.12 I have the same problem while running InfluxDB as a Cluster with two nodes. The series does not get deleted. I used the steps mentioned above to reproduce.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
0.5.2
Development

No branches or pull requests
3 participants
@jvshahid @sontags @breml