Exception: Inner join yielded no results

[elsajmayer]

I have a chart with multiple Queries. One of them that has an Inner join, sometimes is causes exception:

sunnylabs.query.QuerySyntaxException: Query syntax error: Inner join yielded no results

My query looks like

1. ( 
2.   max( 
3.     ts("metric1", tag1="${tag1}" and tag2="${tag2}" and tag3="${tag3}" and tag4="${tag4}"), 
4.     tag3 
5.   ) * 0 
6. ) 
7.   [+] 
8.   highpass(1, max( 
9.     ts("metric2", tag2="${tag2}"), 
10.     tag3 
11.   ) / 1000) 

My problem is not the exception. I know the reason that is being produced. My problem, is that the rest queries are not running.

My temporary solution was to replace the [+] with simple +. This caused the query to run slower (it either shows instantly, either doesn't).

Is there any way to keep [+] but let other queries run too?

[elsajmayer]

Hi Michael,

This should not be happening - I've filed a ticket with our engineering team to get this addressed. We apologize for the inconvenience!

-Vasily

[elsajmayer]

Hello Vasily,

I need more and more join's into my queries.

Is there any approach to ignore null results in joined queries?

[elsajmayer]

Hi Michael,

We have a fix for this bug in our pipeline so it's going to be addressed in one of the upcoming releases - we apologize for the inconvenience!

-Vasily

[elsajmayer]

Thanks Vasily, I appreciate it!