How to know current shard id?

1

My database is set 24h duration for the default shard.

What influxdb query to use to know the current active shard id for given database ?

Is it safe enough to assume it is largest ‘id’ value from the queue below ?

SELECT “database”,id,retentionPolicy,seriesCreate,writeReq FROM “_internal”…“shard” WHERE time>now()-10s AND “database”=‘telegraf’ AND retentionPolicy=‘default’ AND writeReq>0
name: shard
time database id retentionPolicy seriesCreate writeReq

1528307460000000000 telegraf 820 default 206266 1530131
1528307460000000000 telegraf 945 default 281520 2556952
1528307460000000000 telegraf 949 default 168335 2229729

2

If you use the query SHOW SHARDS you will see a list of all shards and corresponding ids, and you will be able to identify the current active shard more easily than using the method above.

3

oh, right !

Thanks alot :smile:

1 Like
4

But any influx api? which lets me know the current shard id, which I will use for backup query from inside my application code???

5

Hi, you might not have noticed but you replied to a 2 year old thread. Probably best to open your own thread with the issue you’re having.