[influxdb] All series has disappear after RP

[d***@ext.privalia.com]

Hi,

I would like delete a TAG but how this not is possible I remove all series related

SHOW TAG VALUES FROM "uptime" WITH KEY = "pod_name" WHERE "pod_namespace" =~ /dperez/

name: uptime
key value
--- -----
pod_name AAAAAA
pod_name BBBBBB

DROP SERIES FROM "uptime" WHERE "pod_name" =~ /AAAAAA/

Also I create a policy retain for 1 hour

CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1 DEFAULT
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false
one_hour 1h0m0s 1h0m0s 1 true

But now all my queries are empty

select * from "cpu/limit" where namespace_name =~ /dperez/ limit 20

Why? DROP Series has a particular condition, I don't think this was the problem, but de new retention policy why delete all data even last 1 hour from all?

And the worst is that I wait time and time and mesuraments are empty of series.

What I did wrong?

Thank you

[Dani Perez Santos]

I add more information, I delete my new PR and activate the old and now I
see all data again. I don't understand nothing...

DROP RETENTION POLICY one_hour ON k8s
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false

ALTER RETENTION POLICY default ON k8s DEFAULT
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 true

select * from "cpu/limit" where namespace_name =~ /dfigueras/ limit 20

name: cpu/limit
time container_base_image container_name host_id hostname labels
namespace_id namespace_name nodename pod_id pod_name pod_namespace type
value
---- -------------------- -------------- ------- -------- ------
------------ -------------- -------- ------ -------- ------------- ----
-----
1496844000000000000
spdc1k8sregistry11/frontal-***@sha256:9f6223fbd68b116f1fc53b349fadd18be475f2f6bade1ca810b7e41b80d40bbf
frontal-php56 spdc1clu01kubew02 spdc1clu01kubew02
createdby:dan.figueras,k8s-app:frontal-php56,name:frontal-php56,owner:dfigueras,pod-template-hash:2518504934
100ca1c6-446f-11e7-82eb-0050568e7178 dfigueras spdc1clu01kubew02
44c6a239-4511-11e7-82eb-0050568e7178 frontal-php56-2518504934-mfd82
dfigueras pod_container 400
1496844000000000000 100ca1c6-446f-11e7-82eb-0050568e7178 dfigueras ns 1400
1496844000000000000 spdc1clu01kubew01 spdc1clu01kubew01
createdby:dan.figueras,k8s-app:mysql56,name:mysql56,owner:dfigueras,pod-template-hash:584599298
100ca1c6-446f-11e7-82eb-0050568e7178 dfigueras spdc1clu01kubew01
4db74218-4511-11e7-82eb-0050568e7178 mysql56-584599298-j234b dfigueras pod
1000

Any idea, why activate the new policy data disappears?

CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1 DEFAULT

Thank you

Hi,
I would like delete a TAG but how this not is possible I remove all series related

SHOW TAG VALUES FROM "uptime" WITH KEY = "pod_name" WHERE

"pod_namespace" =~ /dperez/
name: uptime
key value
--- -----
pod_name AAAAAA
pod_name BBBBBB

DROP SERIES FROM "uptime" WHERE "pod_name" =~ /AAAAAA/

Also I create a policy retain for 1 hour

CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1 DEFAULT
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false
one_hour 1h0m0s 1h0m0s 1 true
But now all my queries are empty
select * from "cpu/limit" where namespace_name =~ /dperez/ limit 20
Why? DROP Series has a particular condition, I don't think this was the
problem, but de new retention policy why delete all data even last 1 hour
from all?
And the worst is that I wait time and time and mesuraments are empty of series.
What I did wrong?
Thank you
--
Remember to include the version number!
---
You received this message because you are subscribed to a topic in the
Google Groups "InfluxData" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/influxdb/hXFZkGmlfGA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/
msgid/influxdb/781252c4-77f4-4443-9abd-7eb2428e9c02%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Dani Pérez

[Dani Perez Santos]

I did again... but same result

CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1 DEFAULT
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false
one_hour 1h0m0s 1h0m0s 1 true

select * from "cpu/limit" where namespace_name =~ /dfigueras/ limit 20
select * from one_hour."cpu/limit" where namespace_name =~ /dfigueras/

limit 20

select * from one_hour."cpu/limit" where namespace_name =~ /dfigueras/

limit 20
empty.....

Any idea? what's wrong?

I add more information, I delete my new PR and activate the old and now I
see all data again. I don't understand nothing...

DROP RETENTION POLICY one_hour ON k8s
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false

ALTER RETENTION POLICY default ON k8s DEFAULT
SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 true

select * from "cpu/limit" where namespace_name =~ /dfigueras/ limit 20

name: cpu/limit
time container_base_image container_name host_id hostname labels
namespace_id namespace_name nodename pod_id pod_name pod_namespace type
value
---- -------------------- -------------- ------- -------- ------
------------ -------------- -------- ------ -------- ------------- ----
-----
9f6223fbd68b116f1fc53b349fadd18be475f2f6bade1ca810b7e41b80d40bbf
frontal-php56 spdc1clu01kubew02 spdc1clu01kubew02
frontal-php56,owner:dfigueras,pod-template-hash:2518504934
100ca1c6-446f-11e7-82eb-0050568e7178 dfigueras spdc1clu01kubew02
44c6a239-4511-11e7-82eb-0050568e7178 frontal-php56-2518504934-mfd82
dfigueras pod_container 400
1496844000000000000 100ca1c6-446f-11e7-82eb-0050568e7178 dfigueras ns 1400
1496844000000000000 spdc1clu01kubew01 spdc1clu01kubew01
createdby:dan.figueras,k8s-app:mysql56,name:mysql56,
owner:dfigueras,pod-template-hash:584599298 100ca1c6-446f-11e7-82eb-0050568e7178
dfigueras spdc1clu01kubew01 4db74218-4511-11e7-82eb-0050568e7178
mysql56-584599298-j234b dfigueras pod 1000
Any idea, why activate the new policy data disappears?
CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1 DEFAULT
Thank you

Hi,
I would like delete a TAG but how this not is possible I remove all series related

SHOW TAG VALUES FROM "uptime" WITH KEY = "pod_name" WHERE

"pod_namespace" =~ /dperez/
name: uptime
key value
--- -----
pod_name AAAAAA
pod_name BBBBBB

DROP SERIES FROM "uptime" WHERE "pod_name" =~ /AAAAAA/

Also I create a policy retain for 1 hour

CREATE RETENTION POLICY one_hour ON k8s DURATION 1h REPLICATION 1

DEFAULT

SHOW RETENTION POLICIES ON "k8s"

name duration shardGroupDuration replicaN default
---- -------- ------------------ -------- -------
default 0s 168h0m0s 1 false
one_hour 1h0m0s 1h0m0s 1 true
But now all my queries are empty
select * from "cpu/limit" where namespace_name =~ /dperez/ limit 20
Why? DROP Series has a particular condition, I don't think this was the
problem, but de new retention policy why delete all data even last 1 hour
from all?
And the worst is that I wait time and time and mesuraments are empty of series.
What I did wrong?
Thank you
--
Remember to include the version number!
---
You received this message because you are subscribed to a topic in the
Google Groups "InfluxData" group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/influxdb/hXFZkGmlfGA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit https://groups.google.com/d/ms
gid/influxdb/781252c4-77f4-4443-9abd-7eb2428e9c02%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Dani Pérez

--
Dani Pérez