[GEODE-7728] org.apache.geode.InternalGemFireError: ERROR: Assertion failed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0, 1.13.0
• Component/s: querying
• Labels: GeodeCommons
• Assignee: Ernest Burghardt
• Reporter: Juan Ramos
• Created: 22/Jan/20 00:46
• Updated: 30/Mar/20 23:34
• Resolved: 05/Feb/20 12:22

Description

When trying to run a simple equi-join query (both fields are indexed) with additional filters on a single region, the execution fails with the following exception:

org.apache.geode.InternalGemFireError: ERROR: Assertion failed: '  '
	at org.apache.geode.cache.query.internal.Support.assertionFailed(Support.java:76)
	at org.apache.geode.cache.query.internal.Support.Assert(Support.java:65)
	at org.apache.geode.cache.query.internal.Support.Assert(Support.java:46)
	at org.apache.geode.cache.query.internal.AbstractGroupOrRangeJunction.filterEvaluate(AbstractGroupOrRangeJunction.java:150)
	at org.apache.geode.cache.query.internal.CompiledJunction.filterEvaluate(CompiledJunction.java:190)
	at org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:538)
	at org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:53)
	at org.apache.geode.cache.query.internal.DefaultQuery.executeUsingContext(DefaultQuery.java:432)
	at org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:267)
	at org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:199)

The problem seems to be that, in order to optimise the execution for a more general form of join queries, we fail to find the "optimal" filter on which to operate and, thus, the exception is thrown.
The problem is not reproducible whenever one of the fields used for the comparison is not indexed, or when both indexes are passed to the query engine using the HINT keyword.

Issue Links

• links to: GitHub Pull Request #4639