# Error: repetition operator missing expression

**URL:** <https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671>\
**Category:** Systems\
**Tags:** influxdb, grafana, flux\
**Created:** [September 22, 2022, 8:02am UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671 "2022-09-22T08:02:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![William](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/william/32/7913_2.png) [@William](https://community.influxdata.com/u/William)\
**Post date:** [September 22, 2022, 8:02am UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671/1 "2022-09-22T08:02:51Z")

</div>

the below works if 1 cpu is selected at a time, however if i select multiple the below error message occurs. have tried to resolve however little success…

using influxdb2 flux and grafana

from(bucket: “default”)  
|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r[“host”] =~ /${server}/)  
|\> filter(fn: (r) =\> r[“cpu”] =~ /${cpu}/) ← line with error  
|\> filter(fn: (r) =\> r[“\_measurement”] == “system\_cpu”)  
|\> filter(fn: (r) =\> r[“\_field”] == “usage\_system”)  
|\> map(fn: (r) =\> ({cpu: r.cpu, \_time: r.\_time, \_value: r.\_value \* 100.0}))  
|\> group(columns: [“cpu”])  
|\> last()  
|\> group()  
|\> highestMax(n: 1, groupColumns: [“cpu”])

invalid: compilation failed: error @6:36-6:59: regex parse error: {cpu0,cpu1,cpu2,cpu3} error: repetition operator missing expression

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [September 26, 2022, 9:28pm UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671/2 "2022-09-26T21:28:48Z")

</div>

Hello @William,  
Welcome!  
Can you try:

```auto
|> filter(fn: (r) => r[“cpu”] =~ r.cpu =~ /cpu[0-3]$/

```

Insead?

---

<div class="post-metadata">

**Author:** ![ArtForLife](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/artforlife/32/11644_2.png) [@ArtForLife](https://community.influxdata.com/u/ArtForLife)\
**Post date:** [December 14, 2022, 2:13pm UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671/3 "2022-12-14T14:13:04Z")

</div>

I’m trying to resolve query but getting error  
invalid: compilation failed: error at @5:40-5:154: regex parse error: {Australia,Canary Island,India,Ireland,Italy,Mexico,Netherland,Netherlands,Poland,Portugal,Spain,United Kingdom} error: repetition operator missing expression

when i run query on perticuler region then i’m getting result with proper data but when i was trying to run query on all region getting above error

even i try operator .\* still getting error  
can someone help me  
from(bucket: “Default”)  
|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r[“\_measurement”] == “HttpResponse”)  
|\> filter(fn: (r) =\> r[“\_field”] == “http\_response\_code”)  
|\> filter(fn: (r) =\> r[“Country”] =~ /${Territory}/ and r[“status\_code”] =~ /200/)  
|\> group(columns: [“status\_code”,“Territory”], mode:“by”)  
|\> keep(columns: [“\_time”, “\_value” , “Country”])  
|\> count()

---

<div class="post-metadata">

**Author:** ![afroytlog](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@afroytlog](https://community.influxdata.com/u/afroytlog)\
**Post date:** [March 24, 2023, 7:52am UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671/4 "2023-03-24T07:52:57Z")

</div>

@Anaisdg ,  
I also have this issue. Could you please take a look?  
Thanks

from(bucket: “data”)  
|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r[“\_measurement”] == “stats”)  
|\> filter(fn: (r) =\> r[“\_field”] == “long” or r[“\_field”] == “lat”)  
|\> filter(fn: (r) =\> r[“site\_id”] =~ r.site\_id =~ /${sid}/)  
|\> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)  
|\> yield(name: “mean”)

invalid: compilation failed: error @7:69-7:126: regex parse error: {46430,53847,53876,9058,13382,5737,4956,4911,1414,2733} error: repetition operator missing expression

---

<div class="post-metadata">

**Author:** ![gabrielmocan](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/gabrielmocan/32/13139_2.png) [@gabrielmocan](https://community.influxdata.com/u/gabrielmocan)\
**Post date:** [March 31, 2023, 8:27pm UTC](https://community.influxdata.com/t/error-repetition-operator-missing-expression/26671/5 "2023-03-31T20:27:47Z")

</div>

Hey everybody, I was running through the same issue but found the answer on [influxdb - How to create regular expresion from Grafana variables. Influx 2.0DB - Stack Overflow](https://stackoverflow.com/questions/71999186/how-to-create-regular-expresion-from-grafana-variables-influx-2-0db)

Basically, Grafana allows how to expand the variable in Flux query.

So the answer to @William original question would be like:

`|> filter(fn: (r) => r[“cpu”] =~ /${cpu:regex}/)`

Hope it helps.
