Re: calcite multi-threading problem

[xiaobo]

can you share the solution for the problem, we are using the following 
libraries, and it seems janino 3.1.6  is only dependent by calcite-core.


&nbsp;&nbsp;&nbsp; <properties&gt;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<project.build.sourceEncoding&gt;UTF-8</project.build.sourceEncoding&gt;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<maven.compiler.encoding&gt;UTF-8</maven.compiler.encoding&gt;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<java.version&gt;9</java.version&gt;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<maven.compiler.source&gt;9</maven.compiler.source&gt;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<maven.compiler.target&gt;9</maven.compiler.target&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 
<log4j2.version&gt;2.17.1</log4j2.version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; 
<drools.version&gt;7.64.0.Final</drools.version&gt;
&nbsp;&nbsp; </properties&gt;



<groupId&gt;org.apache.calcite</groupId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<artifactId&gt;calcite-core</artifactId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<version&gt;1.29.0</version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; </dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<groupId&gt;org.apache.calcite.avatica</groupId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<artifactId&gt;avatica-core</artifactId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<version&gt;1.20.0</version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; </dependency&gt;




&nbsp;&nbsp;&nbsp; <dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<groupId&gt;org.drools</groupId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<artifactId&gt;drools-core</artifactId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<version&gt;${drools.version}</version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; </dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<groupId&gt;org.drools</groupId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<artifactId&gt;drools-compiler</artifactId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<version&gt;${drools.version}</version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; </dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; <dependency&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<groupId&gt;org.drools</groupId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<artifactId&gt;drools-decisiontables</artifactId&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 
<version&gt;${drools.version}</version&gt;
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; </dependency&gt;








------------------&nbsp;Original&nbsp;------------------
From: &nbsp;"xiong duan";<nobigo...@gmail.com&gt;;
Send time:&nbsp;Saturday, Feb 12, 2022 8:43 AM
To:&nbsp;"dev"<dev@calcite.apache.org&gt;; 

Subject: &nbsp;Re: calcite multi-threading problem



Yes, It is a dependency issue. I have met the same problem. +1 for Dmitry.

Dmitry Sysolyatin <dm.sysolya...@gmail.com&gt; 于2022年2月11日周五 21:18写道：

&gt; Actually, I had the same problem with spark. Spark 3.2.1 uses the old
&gt; version of janino, calcite 1.29 uses the new version of janino and they are
&gt; not compatible.
&gt; If I downgrade janino version to version which spark uses I got an error
&gt; not method found exception
&gt; If I upgrade the janino version to the version which calcite uses I get the
&gt; same error but with another method.
&gt;
&gt; As a result, I built a separate calcite jar package where I shaded janino
&gt; dependency
&gt;
&gt;
&gt;
&gt; On Fri, Feb 11, 2022 at 2:39 PM stanilovsky evgeny <
&gt; estanilovs...@gridgain.com&gt; wrote:
&gt;
&gt; &gt; for example on a current calcite branch:
&gt; &gt; grep janino gradle.properties
&gt; &gt; janino.version=3.1.6
&gt; &gt;
&gt; &gt;
&gt; &gt; &gt; yes, we use drools in the same project,&amp;nbsp; and drools 
uses janino
&gt; &gt; &gt; too, is there a version list of janino which calcite supports?
&gt; &gt; &gt;
&gt; &gt; &gt;
&gt; &gt; &gt;
&gt; &gt; &gt;
&gt; &gt; &gt; ---Original---
&gt; &gt; &gt; From: "Dmitry Sysolyatin"<dm.sysolya...@gmail.com&amp;gt;
&gt; &gt; &gt; Date: Fri, Feb 11, 2022 18:30 PM
&gt; &gt; &gt; To: "dev"<dev@calcite.apache.org&amp;gt;;
&gt; &gt; &gt; Subject: Re: calcite multi-threading problem
&gt; &gt; &gt;
&gt; &gt; &gt;
&gt; &gt; &gt; Hi!
&gt; &gt; &gt;
&gt; &gt;
&gt; 
It&amp;nbsp;looks&amp;nbsp;like&amp;nbsp;a&amp;nbsp;dependency&amp;nbsp;issue,&amp;nbsp;not&amp;nbsp;like&amp;nbsp;a&amp;nbsp;multi-threading&amp;nbsp;issue.&amp;nbsp;Most
&gt; &gt; &gt;
&gt; &gt;
&gt; 
likely&amp;nbsp;you&amp;nbsp;have&amp;nbsp;some&amp;nbsp;dependency&amp;nbsp;that&amp;nbsp;use&amp;nbsp;another&amp;nbsp;version&amp;nbsp;of&amp;nbsp;janino&amp;nbsp;but
&gt; &gt; &gt; calcite&amp;nbsp;requires&amp;nbsp;another&amp;nbsp;one
&gt; &gt; &gt;
&gt; &gt; &gt;
&gt; &gt;
&gt; 
On&amp;nbsp;Fri,&amp;nbsp;Feb&amp;nbsp;11,&amp;nbsp;2022&amp;nbsp;at&amp;nbsp;12:18&amp;nbsp;PM&amp;nbsp;xiaobo&amp;nbsp;<guxiaobo1...@qq.com.invalid
&gt; &gt; &amp;gt;&amp;nbsp;wrote:
&gt; &gt; &gt;
&gt; &gt; &gt; &amp;gt;&amp;nbsp;Hi,
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt;
&gt; &gt;
&gt; 
&amp;gt;&amp;nbsp;we&amp;nbsp;open&amp;nbsp;a&amp;nbsp;calcite&amp;nbsp;connection&amp;nbsp;with&amp;nbsp;ReflectiveSchema&amp;nbsp;in&amp;nbsp;one&amp;nbsp;thread,&amp;nbsp;and
&gt; &gt; &gt;
&gt; &gt;
&gt; 
&amp;gt;&amp;nbsp;execute&amp;nbsp;sqls&amp;nbsp;in&amp;nbsp;other&amp;nbsp;&amp;nbsp;threads&amp;nbsp;against&amp;nbsp;the&amp;nbsp;connection,&amp;nbsp;but&amp;nbsp;failed&amp;nbsp;with
&gt; &gt; &gt; &amp;gt;&amp;nbsp;this&amp;nbsp;error
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; 
&amp;gt;&amp;nbsp;com.google.common.util.concurrent.ExecutionError:
&gt; &gt; &gt; &amp;gt;&amp;nbsp;java.lang.NoSuchMethodError:
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt;
&gt; &gt;
&gt; 
&amp;gt;&amp;nbsp;org.codehaus.commons.compiler.CompilerFactoryFactory.getDefaultCompilerFactory(Ljava/lang/ClassLoader;)
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; 
&amp;gt;&amp;nbsp;Lorg/codehaus/commons/compiler/ICompilerFactory;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt; &amp;gt;
&gt; &gt; &gt;
&gt; &gt;
&gt; 
&amp;gt;&amp;nbsp;do&amp;nbsp;we&amp;nbsp;miss&amp;nbsp;anything&amp;nbsp;regarding&amp;nbsp;to&amp;nbsp;multi-threading&amp;nbsp;with&amp;nbsp;calcite?
&gt; &gt;
&gt;