-
Notifications
You must be signed in to change notification settings - Fork 1.6k
AssertionError at FilteredRecordCursorFactory.java #6762
Copy link
Copy link
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution
Description
To reproduce
SELECT
T1.event,
T1.origin,
CASE WHEN T1.event > 50 THEN 'High' ELSE 'Low' END
FROM telemetry T1
INNER JOIN telemetry T2 ON T1.created < T2.created
WHERE (cast(T1.origin as SYMBOL)) IS NULL AND NOW() = NOW()
ORDER BY (cast(T1.origin as SYMBOL)) NOT IN ('{}')
LIMIT NULL;
2026-02-09T13:46:03.161178Z C i.q.c.h.p.JsonQueryProcessorState [1093069874965] internal error [ex=java.lang.AssertionError
at io.questdb.griffin.engine.table.FilteredRecordCursorFactory.<init>(FilteredRecordCursorFactory.java:44)
at io.questdb.griffin.SqlCodeGenerator.generateJoins(SqlCodeGenerator.java:4194)
at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5344)
at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
at io.questdb.griffin.SqlCodeGenerator.generateSelectChoose(SqlCodeGenerator.java:5358)
at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5335)
at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
at io.questdb.griffin.SqlCodeGenerator.generateSelectVirtual(SqlCodeGenerator.java:5991)
at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5337)
at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
at io.questdb.griffin.SqlCodeGenerator.generateSubQuery(SqlCodeGenerator.java:6851)
at io.questdb.griffin.SqlCodeGenerator.generateSelectChoose(SqlCodeGenerator.java:5358)
at io.questdb.griffin.SqlCodeGenerator.generateSelect(SqlCodeGenerator.java:5335)
at io.questdb.griffin.SqlCodeGenerator.generateQuery0(SqlCodeGenerator.java:4839)
at io.questdb.griffin.SqlCodeGenerator.generateQuery(SqlCodeGenerator.java:4814)
at io.questdb.griffin.SqlCodeGenerator.generate(SqlCodeGenerator.java:682)
at io.questdb.griffin.SqlCompilerImpl.generateSelectOneShot(SqlCompilerImpl.java:4862)
at io.questdb.griffin.SqlCompilerImpl.generateSelectWithRetries(SqlCompilerImpl.java:545)
at io.questdb.griffin.SqlCompilerImpl.compileUsingModel(SqlCompilerImpl.java:3473)
at io.questdb.griffin.SqlCompilerImpl.compileInner(SqlCompilerImpl.java:2830)
at io.questdb.griffin.SqlCompilerImpl.compile(SqlCompilerImpl.java:414)
at io.questdb.cairo.pool.SqlCompilerPool$C.compile(SqlCompilerPool.java:145)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.compileAndExecuteQuery(JsonQueryProcessor.java:493)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.execute0(JsonQueryProcessor.java:219)
at io.questdb.cutlass.http.processors.JsonQueryProcessor.onRequestComplete(JsonQueryProcessor.java:309)
at io.questdb.cutlass.http.HttpConnectionContext.handleClientRecv(HttpConnectionContext.java:985)
at io.questdb.cutlass.http.HttpConnectionContext.handleClientOperation(HttpConnectionContext.java:323)
at io.questdb.cutlass.http.HttpServer.handleClientOperation(HttpServer.java:350)
at io.questdb.cutlass.http.HttpServer$1.lambda$$0(HttpServer.java:114)
at io.questdb.network.AbstractIODispatcher.processIOQueue(AbstractIODispatcher.java:224)
at io.questdb.cutlass.http.HttpServer$1.run(HttpServer.java:118)
at io.questdb.mp.Worker.run(Worker.java:152)
QuestDB version:
nightly
OS, in case of Docker specify Docker and the Host OS:
ubuntu
File System, in case of Docker specify Host File System:
ext4
Full Name:
Yuancheng Jiang
Affiliation:
National University of Singapore
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
- Yes, I have
Additional context
No response
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
BugIncorrect or unexpected behaviorIncorrect or unexpected behaviorSQLIssues or changes relating to SQL executionIssues or changes relating to SQL execution