[
https://issues.apache.org/jira/browse/IGNITE-24376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Korotkov updated IGNITE-24376:
-------------------------------------
Description:
After the IGNITE-22991 (bump from the calcite 1.34 to 1.37) the
org.apache.commons:commons-text JAR is missing from the binary distribution.
Which causes the exception say for the "SELECT sum(fld) FROM Item" query
executed on the {*}client node{*}:
{code:java}
java.lang.NoClassDefFoundError:
org/apache/commons/text/similarity/LevenshteinDistance
{code}
{noformat}
[2025-02-03T13:02:52,932][WARN
][calciteQry-#117%isetest.perftests.sql_test.SqlSimpleTest.sum_indexed_test.range.10M.engine.calcite.ignite_version.ignite-2.17.0%][QueryTaskExecutorImpl]
Uncaught exception
org.apache.ignite.IgniteException: Unexpected exception
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:329)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.lambda$init$2(ExchangeServiceImpl.java:195)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:233)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:211)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:73)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[?:?]
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[?:?]
at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.lang.NoClassDefFoundError:
org/apache/commons/text/similarity/LevenshteinDistance
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
Caused by: java.lang.ClassNotFoundException:
org.apache.commons.text.similarity.LevenshteinDistance
at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
~[?:?]
at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
~[?:?]
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
~[?:?]
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
{noformat}
was:
After the IGNITE-22991 (bump from the calcite 1.34 to 1.37) the
org.apache.commons:commons-text JAR is missing from the binary distribution.
Which causes the following exceptions say for the query executed on the
{*}client node{*}: "SELECT sum(fld) FROM Item"
{noformat}
[2025-02-03T13:02:52,932][WARN
][calciteQry-#117%isetest.perftests.sql_test.SqlSimpleTest.sum_indexed_test.range.10M.engine.calcite.ignite_version.ignite-2.17.0%][QueryTaskExecutorImpl]
Uncaught exception
org.apache.ignite.IgniteException: Unexpected exception
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:329)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.lambda$init$2(ExchangeServiceImpl.java:195)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:233)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:211)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:73)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[?:?]
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[?:?]
at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.lang.NoClassDefFoundError:
org/apache/commons/text/similarity/LevenshteinDistance
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
Caused by: java.lang.ClassNotFoundException:
org.apache.commons.text.similarity.LevenshteinDistance
at
java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
~[?:?]
at
java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
~[?:?]
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
~[?:?]
at
org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
~[calcite-core-1.37.0.jar:1.37.0]
at SC.apply(Unknown Source) ~[?:?]
at
org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
~[ignite-calcite-2.17.0.jar:2.17.0]
at
org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
~[ignite-calcite-2.17.0.jar:2.17.0]
... 7 more
{noformat}
> Calcite. ClassNotFoundException in queries with SUM (missing commons-text JAR)
> ------------------------------------------------------------------------------
>
> Key: IGNITE-24376
> URL: https://issues.apache.org/jira/browse/IGNITE-24376
> Project: Ignite
> Issue Type: Bug
> Reporter: Sergey Korotkov
> Priority: Critical
> Labels: calcite, ignite-2, ise
>
> After the IGNITE-22991 (bump from the calcite 1.34 to 1.37) the
> org.apache.commons:commons-text JAR is missing from the binary distribution.
> Which causes the exception say for the "SELECT sum(fld) FROM Item" query
> executed on the {*}client node{*}:
> {code:java}
> java.lang.NoClassDefFoundError:
> org/apache/commons/text/similarity/LevenshteinDistance
> {code}
>
> {noformat}
> [2025-02-03T13:02:52,932][WARN
> ][calciteQry-#117%isetest.perftests.sql_test.SqlSimpleTest.sum_indexed_test.range.10M.engine.calcite.ignite_version.ignite-2.17.0%][QueryTaskExecutorImpl]
> Uncaught exception
> org.apache.ignite.IgniteException: Unexpected exception
> at
> org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:329)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.lambda$init$2(ExchangeServiceImpl.java:195)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:233)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.message.MessageServiceImpl.lambda$onMessage$0(MessageServiceImpl.java:211)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:73)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> [?:?]
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> [?:?]
> at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
> Caused by: java.lang.NoClassDefFoundError:
> org/apache/commons/text/similarity/LevenshteinDistance
> at
> org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
> ~[calcite-core-1.37.0.jar:1.37.0]
> at SC.apply(Unknown Source) ~[?:?]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> ... 7 more
> Caused by: java.lang.ClassNotFoundException:
> org.apache.commons.text.similarity.LevenshteinDistance
> at
> java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
> ~[?:?]
> at
> java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
> ~[?:?]
> at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
> ~[?:?]
> at
> org.apache.calcite.runtime.SqlFunctions.<clinit>(SqlFunctions.java:169)
> ~[calcite-core-1.37.0.jar:1.37.0]
> at SC.apply(Unknown Source) ~[?:?]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.exp.agg.AccumulatorsFactory$AccumulatorWrapperImpl.end(AccumulatorsFactory.java:333)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getOnReducer(HashAggregateNode.java:381)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode$Grouping.getRows(HashAggregateNode.java:291)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.flush(HashAggregateNode.java:196)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.HashAggregateNode.end(HashAggregateNode.java:166)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.pushUnordered(Inbox.java:324)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.push(Inbox.java:203)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.rel.Inbox.onBatchReceived(Inbox.java:177)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> at
> org.apache.ignite.internal.processors.query.calcite.exec.ExchangeServiceImpl.onMessage(ExchangeServiceImpl.java:324)
> ~[ignite-calcite-2.17.0.jar:2.17.0]
> ... 7 more
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)