[
https://issues.apache.org/jira/browse/KYLIN-5089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
曹勇 updated KYLIN-5089:
----------------------
Environment:
hadoop-3.2.2
hive-2.3.9
kylin-4.0.0
scala-2.12.14
spark-3.1.1-bin-hadoop3.2
zookeeper-3.7.0
> ERROR [pool-1-thread-1] cachesync.Broadcaster:152 : error running wiping
> when running $KYLIN_HOME/bin/system-cube.sh setup
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-5089
> URL: https://issues.apache.org/jira/browse/KYLIN-5089
> Project: Kylin
> Issue Type: Bug
> Components: Others
> Affects Versions: v4.0.0
> Environment: hadoop-3.2.2
> hive-2.3.9
> kylin-4.0.0
> scala-2.12.14
> spark-3.1.1-bin-hadoop3.2
> zookeeper-3.7.0
> Reporter: 曹勇
> Priority: Major
> Attachments: image-2021-09-15-15-14-58-935.png
>
>
> when I run `$KYLIN_HOME/bin/system-cube.sh setup`,the error happend:
> {code:java}
> Retrieving hadoop conf dir...
> Retrieving Spark dependency...
> Skip spark which not owned by kylin. SPARK_HOME is
> /home/hadoop/spark-3.1.1-bin-hadoop3.2 and KYLIN_HOME is
> /home/hadoop/kylin-4.0.0 .
> OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support
> was removed in 8.0
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/ext/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
> 2021-09-15 15:04:03,862 INFO [main] common.KylinConfig:117 : Loading
> kylin-defaults.properties from
> file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/kylin-defaults.properties
> 2021-09-15 15:04:03,875 INFO [main] common.KylinConfig:369 : Use
> KYLIN_HOME=/home/hadoop/kylin-4.0.0
> 2021-09-15 15:04:03,921 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.metadata.url.identifier : kylin_metadata
> 2021-09-15 15:04:03,923 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.log.spark-executor-properties-file :
> /home/hadoop/kylin-4.0.0/conf/spark-executor-log4j.properties
> 2021-09-15 15:04:03,924 INFO [main] common.KylinConfig:160 : Initialized a
> new KylinConfig from getInstanceFromEnv : 334203599
> Running org.apache.kylin.tool.metrics.systemcube.SCCreator -inputConfig
> /home/hadoop/kylin-4.0.0/SCSinkTools.json -output
> /home/hadoop/kylin-4.0.0/system_cube
> which: no hbase in
> (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hadoop/zookeeper-3.7.0/bin:/usr/local/firefox:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.302.b08-0.el7_9.x86_64/jre/bin:/home/hadoop/hadoop-3.2.2/bin:/home/hadoop/hadoop-3.2.2/sbin/:/home/hadoop/spark-3.1.1-bin-hadoop3.2/bin:/home/hadoop/spark-3.1.1-bin-hadoop3.2/sbin:/home/hadoop/hive-2.3.9/bin:/home/hadoop/scala-2.12.14/bin:/home/hadoop/.local/bin:/home/hadoop/bin)
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hive-2.3.9/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> SLF4J: Actual binding is of type
> [org.apache.logging.slf4j.Log4jLoggerFactory]Logging initialized using
> configuration in file:/home/hadoop/hive-2.3.9/conf/hive-log4j2.properties
> Async: true
> OK
> Time taken: 4.36 seconds
> which: no hbase in
> (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hadoop/zookeeper-3.7.0/bin:/usr/local/firefox:/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.302.b08-0.el7_9.x86_64/jre/bin:/home/hadoop/hadoop-3.2.2/bin:/home/hadoop/hadoop-3.2.2/sbin/:/home/hadoop/spark-3.1.1-bin-hadoop3.2/bin:/home/hadoop/spark-3.1.1-bin-hadoop3.2/sbin:/home/hadoop/hive-2.3.9/bin:/home/hadoop/scala-2.12.14/bin:/home/hadoop/.local/bin:/home/hadoop/bin)
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hive-2.3.9/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> SLF4J: Actual binding is of type
> [org.apache.logging.slf4j.Log4jLoggerFactory]Logging initialized using
> configuration in file:/home/hadoop/hive-2.3.9/conf/hive-log4j2.properties
> Async: true
> OK
> Time taken: 4.394 seconds
> OK
> Time taken: 0.464 seconds
> OK
> Time taken: 0.61 seconds
> OK
> Time taken: 0.179 seconds
> OK
> Time taken: 0.12 seconds
> OK
> Time taken: 0.172 seconds
> OK
> Time taken: 0.123 seconds
> OK
> Time taken: 0.157 seconds
> OK
> Time taken: 0.106 seconds
> OK
> Time taken: 0.159 seconds
> OK
> Time taken: 0.199 seconds
> Starting restoring /home/hadoop/kylin-4.0.0/system_cube
> Retrieving hive dependency...
> Retrieving hadoop conf dir...
> Retrieving Spark dependency...
> Skip spark which not owned by kylin. SPARK_HOME is
> /home/hadoop/spark-3.1.1-bin-hadoop3.2 and KYLIN_HOME is
> /home/hadoop/kylin-4.0.0 .
> OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support
> was removed in 8.0
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/ext/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
> 2021-09-15 15:04:57,446 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.metadata.url :
> /home/hadoop/kylin-4.0.0/system_cube
> 2021-09-15 15:04:57,448 INFO [main] common.KylinConfig:117 : Loading
> kylin-defaults.properties from
> file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/kylin-defaults.properties
> 2021-09-15 15:04:57,459 INFO [main] common.KylinConfig:369 : Use
> KYLIN_HOME=/home/hadoop/kylin-4.0.0
> 2021-09-15 15:04:57,503 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.metadata.url.identifier : kylin_metadata
> 2021-09-15 15:04:57,504 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.log.spark-executor-properties-file :
> /home/hadoop/kylin-4.0.0/conf/spark-executor-log4j.properties
> 2021-09-15 15:04:57,505 INFO [main] common.KylinConfig:160 : Initialized a
> new KylinConfig from getInstanceFromEnv : 212921632
> 2021-09-15 15:04:57,513 INFO [main] persistence.ResourceStore:90 : Using
> metadata url /home/hadoop/kylin-4.0.0/system_cube for resource store
> 2021-09-15 15:04:57,589 INFO [main] persistence.ResourceStore:90 : Using
> metadata url
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> for resource store
> 2021-09-15 15:04:57,599 INFO [main] persistence.JDBCConnectionManager:92 :
> Connecting to Jdbc with url:jdbc:mysql://10.110.147.229:3306/kylin by user
> hadoop
> 2021-09-15 15:04:57,875 INFO [main] persistence.JDBCConnectionManager:65 :
> Connected to MySQL 5.6.41-log
> 2021-09-15 15:04:57,889 INFO [main] persistence.JDBCResourceStore:115 :
> Table [kylin_metadata] already exists
> 2021-09-15 15:04:57,891 INFO [main] persistence.JDBCResourceStore:115 :
> Table [kylin_metadata_log] already exists
> 2021-09-15 15:04:57,895 INFO [main] persistence.ResourceParallelCopier:77 :
> Copy / from /home/hadoop/kylin-4.0.0/system_cube to
> org.apache.kylin.common.persistence.JDBCResourceStore@2b4bac49
> 2021-09-15 15:04:57,903 INFO [main] persistence.ResourceParallelCopier:136 :
> 22 resources (out of 23) to copy
> Progress: 0.0%, 0 resource, 0 error; copied 0.0 MB in 0.0 min, 0.0 KB/s
> Progress: 100.0%, 22 resource, 0 error; copied 0.1 MB in 0.0 min, 545.2 KB/s
> 2021-09-15 15:04:58,059 INFO [main] persistence.ResourceParallelCopier:92 :
> Done copy / from /home/hadoop/kylin-4.0.0/system_cube to
> org.apache.kylin.common.persistence.JDBCResourceStore@2b4bac49
> Metadata restored from /home/hadoop/kylin-4.0.0/system_cube
> Retrieving hive dependency...
> Retrieving hadoop conf dir...
> Retrieving Spark dependency...
> Skip spark which not owned by kylin. SPARK_HOME is
> /home/hadoop/spark-3.1.1-bin-hadoop3.2 and KYLIN_HOME is
> /home/hadoop/kylin-4.0.0 .
> OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support
> was removed in 8.0
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/kylin-4.0.0/ext/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in
> [jar:file:/home/hadoop/hadoop-3.2.2/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
> 2021-09-15 15:05:27,491 INFO [main] common.KylinConfig:117 : Loading
> kylin-defaults.properties from
> file:/home/hadoop/kylin-4.0.0/tool/kylin-tool-4.0.0.jar!/kylin-defaults.properties
> 2021-09-15 15:05:27,503 INFO [main] common.KylinConfig:369 : Use
> KYLIN_HOME=/home/hadoop/kylin-4.0.0
> 2021-09-15 15:05:27,545 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.metadata.url.identifier : kylin_metadata
> 2021-09-15 15:05:27,548 INFO [main] common.KylinConfigBase:263 : Kylin
> Config was updated with kylin.log.spark-executor-properties-file :
> /home/hadoop/kylin-4.0.0/conf/spark-executor-log4j.properties
> 2021-09-15 15:05:27,548 INFO [main] common.KylinConfig:160 : Initialized a
> new KylinConfig from getInstanceFromEnv : 140799417
> 2021-09-15 15:05:27,556 INFO [main] persistence.ResourceStore:90 : Using
> metadata url
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> for resource store
> 2021-09-15 15:05:27,567 INFO [main] persistence.JDBCConnectionManager:92 :
> Connecting to Jdbc with url:jdbc:mysql://10.110.147.229:3306/kylin by user
> hadoop
> 2021-09-15 15:05:27,887 INFO [main] persistence.JDBCConnectionManager:65 :
> Connected to MySQL 5.6.41-log
> 2021-09-15 15:05:27,902 INFO [main] persistence.JDBCResourceStore:115 :
> Table [kylin_metadata] already exists
> 2021-09-15 15:05:27,904 INFO [main] persistence.JDBCResourceStore:115 :
> Table [kylin_metadata_log] already exists
> 2021-09-15 15:05:27,908 INFO [main] cli.CubeSignatureRefresher:59 :
> Reloading Cube Metadata from store:
> kylin_metadata(key='/cube_desc')@kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:27,911 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.cube.CubeDescManager
> 2021-09-15 15:05:27,911 INFO [main] cube.CubeDescManager:91 : Initializing
> CubeDescManager with config
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:28,173 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.project.ProjectManager
> 2021-09-15 15:05:28,174 INFO [main] project.ProjectManager:81 : Initializing
> ProjectManager with metadata url
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:28,191 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.cachesync.Broadcaster
> 2021-09-15 15:05:28,196 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.model.DataModelManager
> 2021-09-15 15:05:28,199 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.TableMetadataManager
> 2021-09-15 15:05:28,290 INFO [main] model.RowKeyColDesc:99 : Implicitly
> convert encoding to time
> 2021-09-15 15:05:28,290 INFO [main] model.RowKeyColDesc:99 : Implicitly
> convert encoding to time
> 2021-09-15 15:05:28,290 INFO [main] model.RowKeyColDesc:95 : Implicitly
> convert encoding to date
> 2021-09-15 15:05:28,388 INFO [main] common.KylinConfig:526 : Close manager
> Broadcaster
> 2021-09-15 15:05:28,389 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.model.DataModelManager
> 2021-09-15 15:05:28,389 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.TableMetadataManager
> 2021-09-15 15:05:28,390 INFO [Thread-1] cachesync.Broadcaster:188 :
> AnnounceThreadPool shutdown.
> 2021-09-15 15:05:28,390 INFO [Thread-1] cachesync.Broadcaster:190 :
> AnnounceMainLoop shutdown.
> 2021-09-15 15:05:28,392 ERROR [pool-1-thread-1] cachesync.Broadcaster:152 :
> error running wiping
> java.lang.InterruptedException
> at
> java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014)
> at
> java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048)
> at
> java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492)
> at
> org.apache.kylin.metadata.cachesync.Broadcaster$1.run(Broadcaster.java:116)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at java.lang.Thread.run(Thread.java:748)
> 2021-09-15 15:05:28,399 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.cachesync.Broadcaster
> 2021-09-15 15:05:28,408 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.metadata.project.ProjectManager
> 2021-09-15 15:05:28,409 INFO [main] project.ProjectManager:81 : Initializing
> ProjectManager with metadata url
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:28,413 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.cube.CubeDescManager
> 2021-09-15 15:05:28,413 INFO [main] cube.CubeDescManager:91 : Initializing
> CubeDescManager with config
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:28,433 INFO [main] model.RowKeyColDesc:99 : Implicitly
> convert encoding to time
> 2021-09-15 15:05:28,433 INFO [main] model.RowKeyColDesc:99 : Implicitly
> convert encoding to time
> 2021-09-15 15:05:28,433 INFO [main] model.RowKeyColDesc:95 : Implicitly
> convert encoding to date
> 2021-09-15 15:05:28,438 INFO [main] common.KylinConfig:493 : Creating new
> manager instance of class org.apache.kylin.cube.CubeManager
> 2021-09-15 15:05:28,443 INFO [main] cube.CubeManager:122 : Initializing
> CubeManager with config
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:119 :
> =================================================================
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:120 : Run
> CubeSignatureRefresher completed;
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:123 :
> Following resources are updated successfully:
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:125 :
> /cube_desc/KYLIN_HIVE_METRICS_QUERY_EXECUTION_QA.json
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:125 :
> /cube_desc/KYLIN_HIVE_METRICS_QUERY_SPARK_JOB_QA.json
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:125 :
> /cube_desc/KYLIN_HIVE_METRICS_QUERY_SPARK_STAGE_QA.json
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:125 :
> /cube_desc/KYLIN_HIVE_METRICS_JOB_QA.json
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:125 :
> /cube_desc/KYLIN_HIVE_METRICS_JOB_EXCEPTION_QA.json
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:137 : No
> error or warning messages; The update succeeds.
> 2021-09-15 15:05:28,469 INFO [main] cli.CubeSignatureRefresher:140 :
> =================================================================
>
> {code}
> when I run *./bin/system-cube.sh build*, the log:
> {code:java}
> % Total % Received % Xferd Average Speed Time Time Time
> Current
> Dload Upload Total Spent Left Speed
> 100 735 100 687 100 48 92450 6459 --:--:-- --:--:-- --:--:-- 98142
> <!doctype html><html lang="zh"><head><title>HTTP Status 401 –
> 未经授权的</title><style type="text/css">body
> {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b
> {color:white;background-color:#525D76;} h1 {font-size:22px;} h2
> {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;}
> .line
> {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP
> Status 401 – 未经授权的</h1><hr class="line" /><p><b>Type</b> Status
> Report</p><p><b>消息</b> Unauthorized</p><p><b>描述</b>
> 因为当前请求缺少对目标资源对有效的认证信息，所以它不会实施。</p><hr class="line" /><h3>Apache
> Tomcat/7.0.100</h3></body></html>
> {code}
> Then I open the page of Dashboard,the error message:
> !image-2021-09-15-15-14-58-935.png|width=567,height=276!
> the kylin server log as follow:
> {code:java}
> ==========================[QUERY]===============================
> Query Id: cf016e6c-87a1-b0b1-6416-7d1102ade4ac
> SQL: select REALIZATION,count(*) from KYLIN.HIVE_METRICS_QUERY_EXECUTION_QA
> where PROJECT = ? and EXCEPTION = ? and KDAY_DATE >= ? and KDAY_DATE <= ?
> group by REALIZATION
> User: ADMIN
> Success: false
> Duration: 0.039
> Project: KYLIN_SYSTEM
> Realization Names: []
> Cuboid Ids: []
> Is Exactly Matched: []
> Total scan count: 0
> Total scan files: 0
> Total metadata time: 0ms
> Total spark scan time: 0ms
> Total scan bytes: -1
> Result row count: 0
> Storage cache used: false
> Is Query Push-Down: false
> Is Prepare: false
> Used Spark pool: null
> Trace URL: null
> Message: Error while preparing statement [select REALIZATION,count(*) from
> KYLIN.HIVE_METRICS_QUERY_EXECUTION_QA where PROJECT = ? and EXCEPTION = ? and
> KDAY_DATE >= ? and KDAY_DATE <= ? group by REALIZATION]
> ==========================[QUERY]===============================2021-09-15
> 15:14:06,841 ERROR [http-bio-7070-exec-8] controller.BasicController:65 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while preparing
> statement [select REALIZATION,count(*) from
> KYLIN.HIVE_METRICS_QUERY_EXECUTION_QA where PROJECT = ? and EXCEPTION = ? and
> KDAY_DATE >= ? and KDAY_DATE <= ? group by REALIZATION]
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:486)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:405)
> at
> org.apache.kylin.rest.controller.DashboardController.getChartData(DashboardController.java:118)
> at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
> at
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
> at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
> at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
> at
> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
> at
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
> at
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
> at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
> at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object
> 'KYLIN' not found
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
> at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
> at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:803)
> at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4706)
> at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:172)
> at
> org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2975)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2960)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3219)
> at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:569)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:264)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:230)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:796)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:655)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:618)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:221)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:203)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1334)
> at
> org.apache.kylin.rest.service.QueryService.access$800(QueryService.java:143)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1373)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1368)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:717)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:221)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:514)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:469)
> ... 77 more
> 2021-09-15 15:14:06,839 ERROR [http-bio-7070-exec-1]
> controller.BasicController:65 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while preparing
> statement [select KDAY_DATE,count(*) from
> KYLIN.HIVE_METRICS_QUERY_EXECUTION_QA where PROJECT = ? and EXCEPTION = ? and
> KDAY_DATE >= ? and KDAY_DATE <= ? group by KDAY_DATE]
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:486)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:405)
> at
> org.apache.kylin.rest.controller.DashboardController.getChartData(DashboardController.java:118)
> at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
> at
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
> at
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
> at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
> at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
> at
> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
> at
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
> at
> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
> at
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
> at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347)
> at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at
> com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
> at
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1195)
> at
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
> at
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:317)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object
> 'KYLIN' not found
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
> org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
> at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
> at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:803)
> at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4706)
> at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:172)
> at
> org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2975)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2960)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3219)
> at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
> at
> org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:569)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:264)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:230)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:796)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:655)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:618)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:221)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:203)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:192)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:89)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:175)
> at
> org.apache.kylin.rest.service.QueryService.createPreparedContext(QueryService.java:1334)
> at
> org.apache.kylin.rest.service.QueryService.access$800(QueryService.java:143)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1373)
> at
> org.apache.kylin.rest.service.QueryService$PreparedContextFactory.create(QueryService.java:1368)
> at
> org.apache.commons.pool2.BaseKeyedPooledObjectFactory.makeObject(BaseKeyedPooledObjectFactory.java:60)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.create(GenericKeyedObjectPool.java:1064)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:358)
> at
> org.apache.commons.pool2.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:281)
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:717)
> at
> org.apache.kylin.rest.service.QueryService.query(QueryService.java:221)
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:514)
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:469)
> ... 77 more
> 2021-09-15 15:14:08,729 INFO [FetcherRunner 1476111731-29]
> common.KylinConfig:493 : Creating new manager instance of class
> org.apache.kylin.job.execution.ExecutableManager
> 2021-09-15 15:14:08,730 INFO [FetcherRunner 1476111731-29]
> execution.ExecutableManager:92 : Using metadata url:
> kylin_metadata@jdbc,url=jdbc:mysql://10.110.147.229:3306/kylin,username=hadoop,password=hadoop1234,maxActive=10,maxIdle=10,driverClassName=com.mysql.cj.jdbc.Driver
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
