I am getting error that max-series-per-database
is reached (“error”:“partial write: max-series-per-database limit exceeded: (1000000) dropped=2"), meanwhile show series exact cardinality
shows that there are just around 510 000 entries, also counting series gave same results.
What am I missing?
MarcV
June 28, 2019, 10:36am
2
Hi @andrejska welcome to the community ,
I am sorry for the delayed answer , but this post reminded me of your question.
Do you have multiple retention policies in your database ?
Hi all.
‘SHOW SERIES (EXACT) CARDINALITY ON database’ returns only the series count of the default ‘autogen’ retention policy.
And the series in other retention policies on the same database are not counted.
The series count in other retention policies only can be retrieved by the ‘measurement’ base.
(e.g. SHOW SERIES EXACT CARDINALITY ON database FROM database.rp1.mesure1)
Is there any way to get the whole series count on a database with multiple retention policies ?
@MarcV sorry for delayed answer,
Yes, I do have two retention policies
itooo
July 16, 2019, 4:31pm
4
@andrejska I guess we ran into a similar problem, I don’t have a clear answer for you but there certainly are clues here: Max-series-per-database VS show series cardinality VS show tag values -> Index not cleaned?
Can you observe the same behavior on your setup ?