You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "XiaoboGu (Jira)" <ji...@apache.org> on 2022/03/02 13:13:00 UTC
[jira] [Commented] (CALCITE-5028) Janino throws NoSuchMethodError in a multi-threaded application
[ https://issues.apache.org/jira/browse/CALCITE-5028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17500144#comment-17500144 ]
XiaoboGu commented on CALCITE-5028:
-----------------------------------
Here is content of our pom.xml:
<project
xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.2.1.RELEASE</version>
<relativePath/>
</parent>
<groupId>com.xsmartware</groupId>
<artifactId>pbcm-svr</artifactId>
<version>0.0.2</version>
<name>pbcm-svr</name>
<description>Server app for ssml. </description>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
<java.version>9</java.version>
<maven.compiler.source>9</maven.compiler.source>
<maven.compiler.target>9</maven.compiler.target>
<log4j2.version>2.17.1</log4j2.version>
<drools.version>7.64.0.Final</drools.version>
</properties>
<dependencies>
<dependency>
<groupId>com.xsmartware</groupId>
<artifactId>net-common</artifactId>
<version>0.0.2</version>
</dependency>
<dependency>
<groupId>com.xsmartware</groupId>
<artifactId>pbcm-sdk</artifactId>
<version>0.0.2</version>
</dependency>
<dependency>
<groupId>org.apache.calcite</groupId>
<artifactId>json-adapter</artifactId>
<version>0.0.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<exclusions>
<exclusion>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.apache.shiro</groupId>
<artifactId>shiro-spring-boot-web-starter</artifactId>
<version>1.4.0</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.1</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-core</artifactId>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-api</artifactId>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-web</artifactId>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-slf4j-impl</artifactId>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
</dependency>
<dependency>
<groupId>org.dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>2.1.3</version>
</dependency>
<dependency>
<groupId>jaxen</groupId>
<artifactId>jaxen</artifactId>
</dependency>
<dependency>
<groupId>org.drools</groupId>
<artifactId>drools-core</artifactId>
<version>${drools.version}</version>
</dependency>
<dependency>
<groupId>org.drools</groupId>
<artifactId>drools-compiler</artifactId>
<version>${drools.version}</version>
</dependency>
<dependency>
<groupId>org.drools</groupId>
<artifactId>drools-decisiontables</artifactId>
<version>${drools.version}</version>
</dependency>
<dependency>
<groupId>org.apache.calcite</groupId>
<artifactId>calcite-core</artifactId>
<version>1.29.0</version>
</dependency>
<dependency>
<groupId>org.apache.calcite.avatica</groupId>
<artifactId>avatica-core</artifactId>
<version>1.20.0</version>
</dependency>
<!--
<dependency>
<groupId>org.codehaus.janino</groupId>
<artifactId>janino</artifactId>
<version>3.1.4</version>
</dependency>
<dependency>
<groupId>org.codehaus.janino</groupId>
<artifactId>commons-compiler</artifactId>
<version>3.1.4</version>
</dependency>
-->
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
> Janino throws NoSuchMethodError in a multi-threaded application
> ---------------------------------------------------------------
>
> Key: CALCITE-5028
> URL: https://issues.apache.org/jira/browse/CALCITE-5028
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.29.0
> Reporter: XiaoboGu
> Priority: Blocker
>
> we have the Java.lang.NoSuchMethodError problem when using the default 3.1.6 version of Janino in a multi-threaded application, which works well with janino 3.1.4.
> com.xsmartware.pbcm.sdk.PBCMException: Calcite ERROR:java.lang.NoSuchMethodError: org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
> at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:61) ~[classes/:?]
> at com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:24) ~[classes/:?]
> at com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:1) ~[classes/:?]
> at com.xsmartware.pbcm.thread.PBCMBaseThread.run(PBCMBaseThread.java:38) [classes/:?]
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
> at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
> at java.lang.Thread.run(Thread.java:834) [?:?]
> Caused by: com.google.common.util.concurrent.ExecutionError: java.lang.NoSuchMethodError: org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
> at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2053) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache.get(LocalCache.java:3966) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3989) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4950) ~[guava-31.0.1-jre.jar:?]
> at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.revise(JaninoRelMetadataProvider.java:187) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMetadataQueryBase.revise(RelMetadataQueryBase.java:118) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:604) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMdCollation.project(RelMdCollation.java:291) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.lambda$create$0(LogicalProject.java:125) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:244) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:124) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:114) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:178) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.project_(RelBuilder.java:2025) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:1797) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.projectNamed(RelBuilder.java:2088) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.createAggImpl(SqlToRelConverter.java:3248) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertAgg(SqlToRelConverter.java:3151) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:702) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:664) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3548) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:589) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:259) ~[calcite-core-1.29.0.jar:1.29.0]
> at com.xsmartware.common.calcite.CalciteDatabase.parseSql(CalciteDatabase.java:120) ~[classes/:?]
> at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:104) ~[classes/:?]
> at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:139) ~[classes/:?]
> at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:39) ~[classes/:?]
> ... 8 more
> Caused by: java.lang.NoSuchMethodError: org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)Lorg/codehaus/commons/compiler/ICompilerFactory;
> at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.compile(JaninoRelMetadataProvider.java:152) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.generateCompileAndInstantiate(JaninoRelMetadataProvider.java:136) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.lambda$static$0(JaninoRelMetadataProvider.java:70) ~[calcite-core-1.29.0.jar:1.29.0]
> at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3533) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2282) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2159) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2049) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache.get(LocalCache.java:3966) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3989) ~[guava-31.0.1-jre.jar:?]
> at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4950) ~[guava-31.0.1-jre.jar:?]
> at org.apache.calcite.rel.metadata.JaninoRelMetadataProvider.revise(JaninoRelMetadataProvider.java:187) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMetadataQueryBase.revise(RelMetadataQueryBase.java:118) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMetadataQuery.collations(RelMetadataQuery.java:604) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.metadata.RelMdCollation.project(RelMdCollation.java:291) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.lambda$create$0(LogicalProject.java:125) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.plan.RelTraitSet.replaceIfs(RelTraitSet.java:244) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:124) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:114) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:178) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.project_(RelBuilder.java:2025) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:1797) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.tools.RelBuilder.projectNamed(RelBuilder.java:2088) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.createAggImpl(SqlToRelConverter.java:3248) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertAgg(SqlToRelConverter.java:3151) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:702) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:664) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3548) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:589) ~[calcite-core-1.29.0.jar:1.29.0]
> at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:259) ~[calcite-core-1.29.0.jar:1.29.0]
> at com.xsmartware.common.calcite.CalciteDatabase.parseSql(CalciteDatabase.java:120) ~[classes/:?]
> at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:104) ~[classes/:?]
> at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:139) ~[classes/:?]
> at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:39) ~[classes/:?]
> ... 8 more
>
>
> we checked the janino release note page
> [http://janino-compiler.github.io/janino/changelog.html]
> Fixed issue #141: Unable to find org.codehaus.commons.compiler.properties in java 11: ICompilerFactories were loaded through the current thread's "context class loader", which is a bad choice in some environments. Thus, the methods "getDefaultCompilerFactory()", "getAllCompilerFactories()" and "getCompilerFactory(className)" were duplicated and augmented with a "classLoader" parameter.
> It seems the getDefaultCompilerFactory method with a classloader parameter was removed intentionally, but calcite still needs it.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)