Ilya Shishkov created IGNITE-24751:
--------------------------------------

             Summary: Add warning when query pool was exhausted
                 Key: IGNITE-24751
                 URL: https://issues.apache.org/jira/browse/IGNITE-24751
             Project: Ignite
          Issue Type: Sub-task
            Reporter: Ilya Shishkov
         Attachments: QueryPoolExhaustingTest.patch

When {{QueryBlockingTaskExecutor}} of Calcite engine is used, query pool size 
must be larger than any UDF nesting, otherwise query hanging will occur, eg.:
# Query executor size is 2
# Execute SQL containing first UDF
# First UDF inside calls another one UDF
# Second UDF calls any SQL query and hangs

Reproducer:  [^QueryPoolExhaustingTest.patch] 

It seems, that we need:
# Add detailed warning about deadlock and print information, how kill 
problematic query
# Add documentation about proper query thread pool size configuring



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to