[ 
https://issues.apache.org/jira/browse/GRIFFIN-321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

chenchencc updated GRIFFIN-321:
-------------------------------
    Description: 
visit service web page return response body '{}'

but don't have error log

 

*result:*

curl http://localhost:18080
{"timestamp":1578630628235,"status":404,"error":"Not Found","message":"No 
message available","path":"/api/v1/login"}

 

*run log:*

*java -jar $GRIFFIN_HOME/griffin-service.jar*

SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in 
[jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/lib/slf4j-log4j12-1.7.22.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in 
[jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/lib/log4j-slf4j-impl-2.7.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]
_________________ _________________________________________ __
__ ____/___ __ \____ _/___ ____/___ ____/____ _/___ | / /
_ / __ __ /_/ / __ / __ /_ __ /_ __ / __ |/ /
/ /_/ / _ _, _/ __/ / _ __/ _ __/ __/ / _ /| /
\____/ /_/ |_| /___/ /_/ /_/ /___/ /_/ |_/ version: 0.5.0

2020-01-10 12:25:07.659 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication : 
Starting GriffinWebApplication v0.5.0 on bgnode17 with PID 175689 
(/opt/data-quality/soft/griffin/griffin-service.jar started by chenchao1 in 
/opt/data-quality/soft/griffin)
2020-01-10 12:25:07.671 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication : 
No active profile set, falling back to default profiles: default
2020-01-10 12:25:07.757 INFO 175689 --- [ main] 
ationConfigEmbeddedWebApplicationContext : Refreshing 
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@7c53a9eb:
 startup date [Fri Jan 10 12:25:07 CST 2020]; root of context hierarchy
2020-01-10 12:25:09.289 INFO 175689 --- [ main] 
o.s.b.f.s.DefaultListableBeanFactory : Overriding bean definition for bean 
'dataSource' with a different definition: replacing [Root bean: class [null]; 
scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; 
autowireCandidate=true; primary=false; 
factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Dbcp;
 factoryMethodName=dataSource; initMethodName=null; 
destroyMethodName=(inferred); defined in class path resource 
[org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Dbcp.class]]
 with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; 
autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; 
factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari;
 factoryMethodName=dataSource; initMethodName=null; 
destroyMethodName=(inferred); defined in class path resource 
[org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
2020-01-10 12:25:09.290 INFO 175689 --- [ main] 
o.s.b.f.s.DefaultListableBeanFactory : Overriding bean definition for bean 
'dataSource' with a different definition: replacing [Root bean: class [null]; 
scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; 
autowireCandidate=true; primary=false; 
factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari;
 factoryMethodName=dataSource; initMethodName=null; 
destroyMethodName=(inferred); defined in class path resource 
[org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
 with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; 
autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; 
factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Tomcat;
 factoryMethodName=dataSource; initMethodName=null; 
destroyMethodName=(inferred); defined in class path resource 
[org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]]
2020-01-10 12:25:10.046 INFO 175689 --- [ main] 
f.a.AutowiredAnnotationBeanPostProcessor : JSR-330 'javax.inject.Inject' 
annotation found and supported for autowiring
2020-01-10 12:25:10.269 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.boot.autoconfigure.validation.ValidationAutoConfiguration' 
of type [class 
org.springframework.boot.autoconfigure.validation.ValidationAutoConfiguration] 
is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:10.293 WARN 175689 --- [ main] 
o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator 
has been chosen, EL interpolation will not be supported
2020-01-10 12:25:10.466 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 'validator' of type [class 
org.springframework.validation.beanvalidation.LocalValidatorFactoryBean] is not 
eligible for getting processed by all BeanPostProcessors (for example: not 
eligible for auto-proxying)
2020-01-10 12:25:10.558 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration'
 of type [class 
org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$a95fb55]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:10.651 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.cache.annotation.ProxyCachingConfiguration' of type [class 
org.springframework.cache.annotation.ProxyCachingConfiguration$$EnhancerBySpringCGLIB$$53a83173]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:10.719 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration' of type 
[class 
org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration$$EnhancerBySpringCGLIB$$481bf617]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:10.735 WARN 175689 --- [ main] 
o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator 
has been chosen, EL interpolation will not be supported
2020-01-10 12:25:10.752 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'spring.cache-org.springframework.boot.autoconfigure.cache.CacheProperties' of 
type [class org.springframework.boot.autoconfigure.cache.CacheProperties] is 
not eligible for getting processed by all BeanPostProcessors (for example: not 
eligible for auto-proxying)
2020-01-10 12:25:10.766 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 'cacheManagerCustomizers' of 
type [class 
org.springframework.boot.autoconfigure.cache.CacheManagerCustomizers] is not 
eligible for getting processed by all BeanPostProcessors (for example: not 
eligible for auto-proxying)
2020-01-10 12:25:10.773 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.boot.autoconfigure.cache.GuavaCacheConfiguration' of type 
[class 
org.springframework.boot.autoconfigure.cache.GuavaCacheConfiguration$$EnhancerBySpringCGLIB$$9fb92eb4]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:10.788 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 'cacheManager' of type [class 
org.springframework.cache.guava.GuavaCacheManager] is not eligible for getting 
processed by all BeanPostProcessors (for example: not eligible for 
auto-proxying)
2020-01-10 12:25:10.789 INFO 175689 --- [ main] 
trationDelegate$BeanPostProcessorChecker : Bean 
'cacheAutoConfigurationValidator' of type [class 
org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration$CacheManagerValidator]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
2020-01-10 12:25:11.284 INFO 175689 --- [ main] 
s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 
18080 (http)
Jan 10, 2020 12:25:11 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Tomcat
Jan 10, 2020 12:25:11 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/8.5.11
Jan 10, 2020 12:25:11 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring embedded WebApplicationContext
2020-01-10 12:25:11.521 INFO 175689 --- [ost-startStop-1] o.s.w.c.ContextLoader 
: Root WebApplicationContext: initialization completed in 3768 ms
2020-01-10 12:25:16.954 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.ServletRegistrationBean : Mapping servlet: 'dispatcherServlet' to [/]
2020-01-10 12:25:16.965 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' 
to: [/*]
2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' to: 
[/*]
2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' 
to: [/*]
2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: 
[/*]
2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'simpleFilter' to: [/*]
2020-01-10 12:25:18.156 INFO 175689 --- [ main] 
j.LocalContainerEntityManagerFactoryBean : Building JPA container 
EntityManagerFactory for persistence unit 'default'
2020-01-10 12:25:18.908 INFO 175689 --- [ main] 
j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory 
for persistence unit 'default'
[EL Info]: 2020-01-10 12:25:19.103--ServerSession(1297189682)--EclipseLink, 
version: Eclipse Persistence Services - 2.6.0.v20150309-bf26070
[EL Info]: connection: 2020-01-10 
12:25:19.201--ServerSession(1297189682)--/file:/opt/data-quality/soft/griffin/griffin-service.jar_default
 login successful
[EL Fine]: sql: 2020-01-10 
12:25:19.294--ServerSession(1297189682)--Connection(1760670079)--ALTER TABLE 
RULE ADD `out` VARCHAR(255) 
[EL Fine]: sql: 2020-01-10 12:25:19.309--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.31--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Duplicate column name 'out'
Error Code: 1060
Call: ALTER TABLE RULE ADD `out` VARCHAR(255) 
Query: DataModifyQuery(sql="ALTER TABLE RULE ADD `out` VARCHAR(255) ")
[EL Fine]: sql: 2020-01-10 
12:25:19.341--ServerSession(1297189682)--Connection(1550228904)--ALTER TABLE 
JOBDATASEGMENT ADD CONSTRAINT FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY 
(segment_range_id) REFERENCES SEGMENTRANGE (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.478--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.479--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE JOBDATASEGMENT ADD CONSTRAINT 
FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY (segment_range_id) REFERENCES 
SEGMENTRANGE (ID)
Query: DataModifyQuery(sql="ALTER TABLE JOBDATASEGMENT ADD CONSTRAINT 
FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY (segment_range_id) REFERENCES 
SEGMENTRANGE (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.48--ServerSession(1297189682)--Connection(684822005)--ALTER TABLE 
JOBINSTANCEBEAN ADD CONSTRAINT FK_JOBINSTANCEBEAN_job_id FOREIGN KEY (job_id) 
REFERENCES job (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.579--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.58--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE JOBINSTANCEBEAN ADD CONSTRAINT FK_JOBINSTANCEBEAN_job_id 
FOREIGN KEY (job_id) REFERENCES job (ID)
Query: DataModifyQuery(sql="ALTER TABLE JOBINSTANCEBEAN ADD CONSTRAINT 
FK_JOBINSTANCEBEAN_job_id FOREIGN KEY (job_id) REFERENCES job (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.581--ServerSession(1297189682)--Connection(1439632660)--ALTER TABLE 
RULE ADD CONSTRAINT FK_RULE_evaluate_rule_id FOREIGN KEY (evaluate_rule_id) 
REFERENCES EVALUATERULE (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.605--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.606--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE RULE ADD CONSTRAINT FK_RULE_evaluate_rule_id FOREIGN KEY 
(evaluate_rule_id) REFERENCES EVALUATERULE (ID)
Query: DataModifyQuery(sql="ALTER TABLE RULE ADD CONSTRAINT 
FK_RULE_evaluate_rule_id FOREIGN KEY (evaluate_rule_id) REFERENCES EVALUATERULE 
(ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.606--ServerSession(1297189682)--Connection(665698670)--ALTER TABLE 
SEGMENTPREDICATE ADD CONSTRAINT FK_SEGMENTPREDICATE_data_connector_id FOREIGN 
KEY (data_connector_id) REFERENCES DATACONNECTOR (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.677--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.678--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE SEGMENTPREDICATE ADD CONSTRAINT 
FK_SEGMENTPREDICATE_data_connector_id FOREIGN KEY (data_connector_id) 
REFERENCES DATACONNECTOR (ID)
Query: DataModifyQuery(sql="ALTER TABLE SEGMENTPREDICATE ADD CONSTRAINT 
FK_SEGMENTPREDICATE_data_connector_id FOREIGN KEY (data_connector_id) 
REFERENCES DATACONNECTOR (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.678--ServerSession(1297189682)--Connection(638169719)--ALTER TABLE 
GRIFFINMEASURE ADD CONSTRAINT FK_GRIFFINMEASURE_ID FOREIGN KEY (ID) REFERENCES 
MEASURE (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.686--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.686--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE GRIFFINMEASURE ADD CONSTRAINT FK_GRIFFINMEASURE_ID FOREIGN 
KEY (ID) REFERENCES MEASURE (ID)
Query: DataModifyQuery(sql="ALTER TABLE GRIFFINMEASURE ADD CONSTRAINT 
FK_GRIFFINMEASURE_ID FOREIGN KEY (ID) REFERENCES MEASURE (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.687--ServerSession(1297189682)--Connection(1446922577)--ALTER TABLE 
DATASOURCE ADD CONSTRAINT FK_DATASOURCE_measure_id FOREIGN KEY (measure_id) 
REFERENCES MEASURE (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.814--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.815--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE DATASOURCE ADD CONSTRAINT FK_DATASOURCE_measure_id FOREIGN 
KEY (measure_id) REFERENCES MEASURE (ID)
Query: DataModifyQuery(sql="ALTER TABLE DATASOURCE ADD CONSTRAINT 
FK_DATASOURCE_measure_id FOREIGN KEY (measure_id) REFERENCES MEASURE (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.815--ServerSession(1297189682)--Connection(722951168)--ALTER TABLE 
DATACONNECTOR ADD CONSTRAINT FK_DATACONNECTOR_data_source_id FOREIGN KEY 
(data_source_id) REFERENCES DATASOURCE (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.826--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.827--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE DATACONNECTOR ADD CONSTRAINT FK_DATACONNECTOR_data_source_id 
FOREIGN KEY (data_source_id) REFERENCES DATASOURCE (ID)
Query: DataModifyQuery(sql="ALTER TABLE DATACONNECTOR ADD CONSTRAINT 
FK_DATACONNECTOR_data_source_id FOREIGN KEY (data_source_id) REFERENCES 
DATASOURCE (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.827--ServerSession(1297189682)--Connection(451460284)--ALTER TABLE 
STREAMINGPREPROCESS ADD CONSTRAINT FK_STREAMINGPREPROCESS_pre_process_id 
FOREIGN KEY (pre_process_id) REFERENCES DATACONNECTOR (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.895--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.895--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE STREAMINGPREPROCESS ADD CONSTRAINT 
FK_STREAMINGPREPROCESS_pre_process_id FOREIGN KEY (pre_process_id) REFERENCES 
DATACONNECTOR (ID)
Query: DataModifyQuery(sql="ALTER TABLE STREAMINGPREPROCESS ADD CONSTRAINT 
FK_STREAMINGPREPROCESS_pre_process_id FOREIGN KEY (pre_process_id) REFERENCES 
DATACONNECTOR (ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.896--ServerSession(1297189682)--Connection(2101153819)--ALTER TABLE 
EXTERNALMEASURE ADD CONSTRAINT FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY 
(VIRTUALJOB_ID) REFERENCES job (ID)
[EL Fine]: sql: 2020-01-10 12:25:19.93--ServerSession(1297189682)--SELECT 1
[EL Warning]: 2020-01-10 12:25:19.931--ServerSession(1297189682)--Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
Can't write; duplicate key in table '#sql-131ca_7e06e0'
Error Code: 1022
Call: ALTER TABLE EXTERNALMEASURE ADD CONSTRAINT 
FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY (VIRTUALJOB_ID) REFERENCES job (ID)
Query: DataModifyQuery(sql="ALTER TABLE EXTERNALMEASURE ADD CONSTRAINT 
FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY (VIRTUALJOB_ID) REFERENCES job 
(ID)")
[EL Fine]: sql: 2020-01-10 
12:25:19.934--ServerSession(1297189682)--Connection(2024415090)--SELECT * FROM 
SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
[EL Fine]: sql: 2020-01-10 
12:25:19.938--ServerSession(1297189682)--Connection(1661210650)--SELECT * FROM 
SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
2020-01-10 12:25:21.698 INFO 175689 --- [ main] o.a.g.c.c.PropertiesConfig : 
external.config.location : /opt/data-quality/soft/griffin/conf
2020-01-10 12:25:21.698 INFO 175689 --- [ main] o.a.g.c.c.PropertiesConfig : 
external.env.location : /opt/data-quality/soft/griffin/env
2020-01-10 12:25:21.716 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
absolute path:/opt/data-quality/soft/griffin/env
2020-01-10 12:25:21.716 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
external location '/opt/data-quality/soft/griffin/env' does not exist.Read 
fromdefault path.
2020-01-10 12:25:21.819 INFO 175689 --- [ main] o.a.g.c.c.EnvConfig : {
 "spark" : {
 "log.level" : "WARN"
 },
 "sinks" : [ {
 "type" : "CONSOLE",
 "config" : {
 "max.log.lines" : 10
 }
 }, {
 "type" : "HDFS",
 "config" : {
 "path" : "hdfs:///user/chenchao1/griffin/persist",
 "max.persist.lines" : 10000,
 "max.lines.per.file" : 10000
 }
 }, {
 "type" : "ELASTICSEARCH",
 "config" : {
 "method" : "post",
 "api" : "http://bgnode8:9200/griffin/accuracy";,
 "connection.timeout" : "1m",
 "retry" : 10
 }
 } ],
 "griffin.checkpoint" : [ ]
}
2020-01-10 12:25:21.819 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
absolute path:/opt/data-quality/soft/griffin/env
2020-01-10 12:25:21.819 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
external location '/opt/data-quality/soft/griffin/env' does not exist.Read 
fromdefault path.
2020-01-10 12:25:21.823 INFO 175689 --- [ main] o.a.g.c.c.EnvConfig : {
 "spark" : {
 "log.level" : "WARN",
 "checkpoint.dir" : "hdfs:///user/chenchao1/griffin/checkpoint/${JOB_NAME}",
 "init.clear" : true,
 "batch.interval" : "1m",
 "process.interval" : "5m",
 "config" : {
 "spark.default.parallelism" : 4,
 "spark.task.maxFailures" : 5,
 "spark.streaming.kafkaMaxRatePerPartition" : 1000,
 "spark.streaming.concurrentJobs" : 4,
 "spark.yarn.maxAppAttempts" : 5,
 "spark.yarn.am.attemptFailuresValidityInterval" : "1h",
 "spark.yarn.max.executor.failures" : 120,
 "spark.yarn.executor.failuresValidityInterval" : "1h",
 "spark.hadoop.fs.hdfs.impl.disable.cache" : true
 }
 },
 "sinks" : [ {
 "type" : "CONSOLE",
 "config" : {
 "max.log.lines" : 100
 }
 }, {
 "type" : "HDFS",
 "config" : {
 "path" : "hdfs:///user/chenchao1/griffin/persist",
 "max.persist.lines" : 10000,
 "max.lines.per.file" : 10000
 }
 }, {
 "type" : "ELASTICSEARCH",
 "config" : {
 "method" : "post",
 "api" : "http://bgnode8:9200/griffin/accuracy";
 }
 } ],
 "griffin.checkpoint" : [ {
 "type" : "zk",
 "config" : {
 "hosts" : "bgnode6:2181",
 "namespace" : "griffin/infocache",
 "lock.path" : "lock",
 "mode" : "persist",
 "init.clear" : true,
 "close.clear" : false
 }
 } ]
}
2020-01-10 12:25:21.825 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
absolute path:/opt/data-quality/soft/griffin/conf
2020-01-10 12:25:21.826 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
external location '/opt/data-quality/soft/griffin/conf' does not exist.Read 
fromdefault path.
2020-01-10 12:25:21.844 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
absolute path:/opt/data-quality/soft/griffin/conf
2020-01-10 12:25:21.844 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
external location '/opt/data-quality/soft/griffin/conf' does not exist.Read 
fromdefault path.
2020-01-10 12:25:21.845 INFO 175689 --- [ main] o.s.b.f.c.PropertiesFactoryBean 
: Loading properties file from class path resource [quartz.properties]
2020-01-10 12:25:21.846 INFO 175689 --- [ main] o.a.g.c.u.PropertiesUtil : Read 
properties successfully from /quartz.properties.
2020-01-10 12:25:21.961 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
Using default implementation for ThreadExecutor
2020-01-10 12:25:21.981 INFO 175689 --- [ main] o.q.c.SchedulerSignalerImpl : 
Initialized Scheduler Signaller of type: class 
org.quartz.core.SchedulerSignalerImpl
2020-01-10 12:25:21.981 INFO 175689 --- [ main] o.q.c.QuartzScheduler : Quartz 
Scheduler v.2.2.2 created.
2020-01-10 12:25:21.987 INFO 175689 --- [ main] o.s.s.q.LocalDataSourceJobStore 
: Using db table-based data access locking (synchronization).
2020-01-10 12:25:21.991 INFO 175689 --- [ main] o.s.s.q.LocalDataSourceJobStore 
: JobStoreCMT initialized.
2020-01-10 12:25:21.993 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
Scheduler meta-data: Quartz Scheduler (v2.2.2) 'schedulerFactoryBean' with 
instanceId 'bgnode171578630321964'
 Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
 NOT STARTED.
 Currently in standby mode.
 Number of jobs executed: 0
 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 5 threads.
 Using job-store 
'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which 
supports persistence. and is clustered.

2020-01-10 12:25:21.993 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
Quartz scheduler 'schedulerFactoryBean' initialized from an externally provided 
properties instance.
2020-01-10 12:25:21.994 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
Quartz scheduler version: 2.2.2
2020-01-10 12:25:21.994 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
JobFactory set to: 
org.apache.griffin.core.job.factory.AutowiringSpringBeanJobFactory@35229f85
2020-01-10 12:25:22.536 INFO 175689 --- [ main] o.a.g.c.j.LivyTaskSubmitHelper 
: Livy uri : http://bgnode10:8998/batches
2020-01-10 12:25:22.925 WARN 175689 --- [ main] o.a.h.u.NativeCodeLoader : 
Unable to load native-hadoop library for your platform... using builtin-java 
classes where applicable
2020-01-10 12:25:23.164 INFO 175689 --- [ main] o.a.h.h.c.HiveConf : Found 
configuration file 
jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/classes!/hive-site.xml
2020-01-10 12:25:23.476 INFO 175689 --- [ main] h.metastore : Trying to connect 
to metastore with URI thrift://bgnode3:9083
2020-01-10 12:25:23.504 INFO 175689 --- [ main] h.metastore : Opened a 
connection to metastore, current connections: 1
2020-01-10 12:25:23.558 INFO 175689 --- [ main] h.metastore : Connected to 
metastore.
2020-01-10 12:25:24.651 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerAdapter : Looking for @ControllerAdvice: 
org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@7c53a9eb:
 startup date [Fri Jan 10 12:25:07 CST 2020]; root of context hierarchy
2020-01-10 12:25:24.773 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/version],methods=[GET]}" onto public java.lang.String 
org.apache.griffin.core.info.GriffinInfoController.greeting()
2020-01-10 12:25:24.775 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metrics],methods=[GET]}" onto public 
java.util.Map<java.lang.String, 
java.util.List<org.apache.griffin.core.metric.model.Metric>> 
org.apache.griffin.core.metric.MetricController.getAllMetrics()
2020-01-10 12:25:24.777 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metrics/values],methods=[GET]}" onto public 
java.util.List<org.apache.griffin.core.metric.model.MetricValue> 
org.apache.griffin.core.metric.MetricController.getMetricValues(java.lang.String,int,int,long)
2020-01-10 12:25:24.777 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metrics/values],methods=[POST]}" onto public 
org.springframework.http.ResponseEntity<?> 
org.apache.griffin.core.metric.MetricController.addMetricValues(java.util.List<org.apache.griffin.core.metric.model.MetricValue>)
2020-01-10 12:25:24.778 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metrics/values],methods=[DELETE]}" onto public 
org.springframework.http.ResponseEntity<?> 
org.apache.griffin.core.metric.MetricController.deleteMetricValues(java.lang.String)
2020-01-10 12:25:24.786 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/{id}],methods=[PUT]}" onto public 
org.apache.griffin.core.job.entity.AbstractJob 
org.apache.griffin.core.job.JobController.onActions(java.lang.Long,java.lang.String)
 throws java.lang.Exception
2020-01-10 12:25:24.786 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs],methods=[DELETE]}" onto public void 
org.apache.griffin.core.job.JobController.deleteJob(java.lang.String) throws 
org.quartz.SchedulerException
2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/{id}],methods=[DELETE]}" onto public void 
org.apache.griffin.core.job.JobController.deleteJob(java.lang.Long) throws 
org.quartz.SchedulerException
2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs],methods=[POST]}" onto public 
org.apache.griffin.core.job.entity.AbstractJob 
org.apache.griffin.core.job.JobController.addJob(org.apache.griffin.core.job.entity.AbstractJob)
 throws java.lang.Exception
2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs],methods=[GET]}" onto public 
java.util.List<org.apache.griffin.core.job.entity.AbstractJob> 
org.apache.griffin.core.job.JobController.getJobs(java.lang.String)
2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/instances/{instanceId}],methods=[GET]}" onto public 
org.apache.griffin.core.job.entity.JobInstanceBean 
org.apache.griffin.core.job.JobController.findInstanceByInstanceId(java.lang.Long)
2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/download],methods=[GET]}" onto public 
org.springframework.http.ResponseEntity<org.springframework.core.io.Resource> 
org.apache.griffin.core.job.JobController.download(java.lang.String,long) 
throws java.lang.Exception
2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/trigger/{id}],methods=[POST]}" onto public void 
org.apache.griffin.core.job.JobController.triggerJob(java.lang.Long) throws 
org.quartz.SchedulerException
2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "\{[/api/v1/jobs/config]}" 
onto public org.apache.griffin.core.job.entity.AbstractJob 
org.apache.griffin.core.job.JobController.getJobConfig(java.lang.Long)
2020-01-10 12:25:24.789 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/instances],methods=[GET]}" onto public 
java.util.List<org.apache.griffin.core.job.entity.JobInstanceBean> 
org.apache.griffin.core.job.JobController.findInstancesOfJob(java.lang.Long,int,int)
2020-01-10 12:25:24.789 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/jobs/health],methods=[GET]}" onto public 
org.apache.griffin.core.job.entity.JobHealth 
org.apache.griffin.core.job.JobController.getHealthInfo()
2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/org],methods=[GET]}" onto public java.util.List<java.lang.String> 
org.apache.griffin.core.measure.MeasureOrgController.getOrgs()
2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/org/{org}],methods=[GET]}" onto public 
java.util.List<java.lang.String> 
org.apache.griffin.core.measure.MeasureOrgController.getMetricNameListByOrg(java.lang.String)
2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/org/measure/names],methods=[GET]}" onto public 
java.util.Map<java.lang.String, java.util.List<java.lang.String>> 
org.apache.griffin.core.measure.MeasureOrgController.getMeasureNamesGroupByOrg()
2020-01-10 12:25:24.793 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures],methods=[GET]}" onto public java.util.List<? extends 
org.apache.griffin.core.measure.entity.Measure> 
org.apache.griffin.core.measure.MeasureController.getAllAliveMeasures(java.lang.String)
2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures/{id}],methods=[GET]}" onto public 
org.apache.griffin.core.measure.entity.Measure 
org.apache.griffin.core.measure.MeasureController.getMeasureById(long)
2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures/owner/{owner}],methods=[GET]}" onto public 
java.util.List<org.apache.griffin.core.measure.entity.Measure> 
org.apache.griffin.core.measure.MeasureController.getAliveMeasuresByOwner(java.lang.String)
2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures],methods=[POST]}" onto public 
org.apache.griffin.core.measure.entity.Measure 
org.apache.griffin.core.measure.MeasureController.createMeasure(org.apache.griffin.core.measure.entity.Measure)
2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures],methods=[PUT]}" onto public 
org.apache.griffin.core.measure.entity.Measure 
org.apache.griffin.core.measure.MeasureController.updateMeasure(org.apache.griffin.core.measure.entity.Measure)
2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures/{id}],methods=[DELETE]}" onto public void 
org.apache.griffin.core.measure.MeasureController.deleteMeasureById(java.lang.Long)
 throws org.quartz.SchedulerException
2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/measures],methods=[DELETE]}" onto public void 
org.apache.griffin.core.measure.MeasureController.deleteMeasures() throws 
org.quartz.SchedulerException
2020-01-10 12:25:24.797 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/dbs],methods=[GET]}" onto public 
java.lang.Iterable<java.lang.String> 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllDatabases()
2020-01-10 12:25:24.797 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/dbs/tables/names],methods=[GET]}" onto public 
java.util.Map<java.lang.String, java.util.List<java.lang.String>> 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTableNames()
2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/tables/names],methods=[GET]}" onto public 
java.lang.Iterable<java.lang.String> 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTableNames(java.lang.String)
2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/dbs/tables],methods=[GET]}" onto public 
java.util.Map<java.lang.String, 
java.util.List<org.apache.hadoop.hive.metastore.api.Table>> 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTables()
2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/tables],methods=[GET]}" onto public 
java.util.List<org.apache.hadoop.hive.metastore.api.Table> 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTables(java.lang.String)
2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/hive/table],methods=[GET]}" onto public 
org.apache.hadoop.hive.metastore.api.Table 
org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getTable(java.lang.String,java.lang.String)
2020-01-10 12:25:24.800 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/subject],methods=[GET]}" onto public 
java.lang.Iterable<java.lang.String> 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjects()
2020-01-10 12:25:24.800 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/versions],methods=[GET]}" onto public 
java.lang.Iterable<java.lang.Integer> 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectVersions(java.lang.String)
2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/subjectSchema],methods=[GET]}" onto public 
io.confluent.kafka.schemaregistry.client.rest.entities.Schema 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectSchema(java.lang.String,java.lang.String)
2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/config],methods=[GET]}" onto public 
io.confluent.kafka.schemaregistry.client.rest.entities.Config 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getTopLevelConfig()
2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/config/{subject}],methods=[GET]}" onto public 
io.confluent.kafka.schemaregistry.client.rest.entities.Config 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectLevelConfig(java.lang.String)
2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/metadata/kafka/schema/{id}],methods=[GET]}" onto public 
io.confluent.kafka.schemaregistry.client.rest.entities.SchemaString 
org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSchemaString(java.lang.Integer)
2020-01-10 12:25:24.802 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/api/v1/login/authenticate],methods=[POST]}" onto public 
org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, 
java.lang.Object>> 
org.apache.griffin.core.login.LoginController.login(java.util.Map<java.lang.String,
 java.lang.String>)
2020-01-10 12:25:24.806 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
"\{[/error],produces=[text/html]}" onto public 
org.springframework.web.servlet.ModelAndView 
org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
2020-01-10 12:25:24.806 INFO 175689 --- [ main] 
s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "\{[/error]}" onto public 
org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, 
java.lang.Object>> 
org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
2020-01-10 12:25:24.881 INFO 175689 --- [ main] 
o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/webjars/**] onto handler 
of type [class 
org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2020-01-10 12:25:24.882 INFO 175689 --- [ main] 
o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/**] onto handler of type 
[class org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2020-01-10 12:25:24.916 INFO 175689 --- [ main] 
.m.m.a.ExceptionHandlerExceptionResolver : Detected @ExceptionHandler methods 
in griffinExceptionHandler
2020-01-10 12:25:24.973 INFO 175689 --- [ main] 
o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/**/favicon.ico] onto 
handler of type [class 
org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
2020-01-10 12:25:30.749 INFO 175689 --- [ main] 
o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on 
startup
2020-01-10 12:25:30.766 INFO 175689 --- [ main] 
o.s.c.s.DefaultLifecycleProcessor : Starting beans in phase 2147483647
2020-01-10 12:25:30.766 INFO 175689 --- [ main] o.s.s.q.SchedulerFactoryBean : 
Starting Quartz Scheduler now
2020-01-10 12:25:30.797 INFO 175689 --- [ main] o.s.s.q.LocalDataSourceJobStore 
: ClusterManager: detected 1 failed or restarted instances.
2020-01-10 12:25:30.797 INFO 175689 --- [ main] o.s.s.q.LocalDataSourceJobStore 
: ClusterManager: Scanning for instance "bgnode171578629416141"'s failed 
in-progress jobs.
2020-01-10 12:25:30.805 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
Scheduler schedulerFactoryBean_$_bgnode171578630321964 started.
2020-01-10 12:25:30.822 INFO 175689 --- [ main] 
s.a.ScheduledAnnotationBeanPostProcessor : No 
TaskScheduler/ScheduledExecutorService bean found for scheduled processing
Jan 10, 2020 12:25:30 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-nio-18080"]
Jan 10, 2020 12:25:30 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [http-nio-18080]
2020-01-10 12:25:30.867 INFO 175689 --- [pool-5-thread-1] 
o.a.g.c.m.h.HiveMetaStoreService : Evict hive cache
Jan 10, 2020 12:25:30 PM org.apache.tomcat.util.net.NioSelectorPool 
getSharedSelector
INFO: Using a shared selector for servlet write/read
[EL Fine]: sql: 2020-01-10 
12:25:30.912--ServerSession(1297189682)--Connection(1612698511)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:25:30.927--ServerSession(1297189682)--Connection(724612497)--SELECT ID, 
APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (expire_timestamp <= 
?)
 bind => [1 parameter bound]
2020-01-10 12:25:30.937 INFO 175689 --- [ main] 
s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 18080 
(http)
2020-01-10 12:25:30.946 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication : 
Started GriffinWebApplication in 24.21 seconds (JVM running for 25.473)
[EL Fine]: sql: 2020-01-10 
12:25:30.953--ClientSession(1542130237)--Connection(1977196780)--DELETE FROM 
JOBINSTANCEBEAN WHERE ((expire_timestamp <= ?) AND (DELETED = ?))
 bind => [2 parameters bound]
2020-01-10 12:25:30.969 INFO 175689 --- [pool-5-thread-1] 
o.a.g.c.j.JobServiceImpl : Delete 0 expired job instances.
Jan 10, 2020 12:25:41 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'dispatcherServlet'
2020-01-10 12:25:41.807 INFO 175689 --- [io-18080-exec-1] 
o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': 
initialization started
2020-01-10 12:25:41.830 INFO 175689 --- [io-18080-exec-1] 
o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': 
initialization completed in 22 ms
[EL Fine]: sql: 2020-01-10 
12:26:30.925--ServerSession(1297189682)--Connection(1594280335)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:27:30.931--ServerSession(1297189682)--Connection(30748468)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:28:30.94--ServerSession(1297189682)--Connection(1622492767)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:29:30.943--ServerSession(1297189682)--Connection(996509770)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:30:30.953--ServerSession(1297189682)--Connection(1743023688)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:31:30.959--ServerSession(1297189682)--Connection(1527486180)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:32:30.964--ServerSession(1297189682)--Connection(2094953605)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:33:30.967--ServerSession(1297189682)--Connection(881639974)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:34:30.97--ServerSession(1297189682)--Connection(551023431)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:35:30.974--ServerSession(1297189682)--Connection(676620878)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:36:30.977--ServerSession(1297189682)--Connection(791671173)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:37:30.98--ServerSession(1297189682)--Connection(615593200)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:38:30.983--ServerSession(1297189682)--Connection(1615983339)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:39:30.988--ServerSession(1297189682)--Connection(262053999)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
2020-01-10 12:40:30.836 INFO 175689 --- [pool-5-thread-1] 
o.a.g.c.m.h.HiveMetaStoreService : Evict hive cache
[EL Fine]: sql: 2020-01-10 
12:40:30.992--ServerSession(1297189682)--Connection(1848136440)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:41:30.995--ServerSession(1297189682)--Connection(231460473)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:42:30.998--ServerSession(1297189682)--Connection(629102840)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:43:31.0--ServerSession(1297189682)--Connection(829875009)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:44:31.003--ServerSession(1297189682)--Connection(1393122270)--SELECT 
DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
MODIFIEDDATE, predicate_job_deleted, predicate_group_name, predicate_job_name, 
SESSIONID, STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:45:31.006--ServerSession(1297189682)--Connection(563197612)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:46:31.01--ServerSession(1297189682)--Connection(282988792)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]
[EL Fine]: sql: 2020-01-10 
12:47:31.013--ServerSession(1297189682)--Connection(915872014)--SELECT DISTINCT 
ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
(?,?,?,?,?,?))
 bind => [6 parameters bound]

  was:
visit service web page return response body '{}'

but don't have error log


> visit service web page return response body '{}'
> ------------------------------------------------
>
>                 Key: GRIFFIN-321
>                 URL: https://issues.apache.org/jira/browse/GRIFFIN-321
>             Project: Griffin
>          Issue Type: Bug
>    Affects Versions: 0.4.0
>            Reporter: chenchencc
>            Priority: Major
>
> visit service web page return response body '{}'
> but don't have error log
>  
> *result:*
> curl http://localhost:18080
> {"timestamp":1578630628235,"status":404,"error":"Not Found","message":"No 
> message available","path":"/api/v1/login"}
>  
> *run log:*
> *java -jar $GRIFFIN_HOME/griffin-service.jar*
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in 
> [jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/lib/slf4j-log4j12-1.7.22.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in 
> [jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/lib/log4j-slf4j-impl-2.7.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]
> _________________ _________________________________________ __
> __ ____/___ __ \____ _/___ ____/___ ____/____ _/___ | / /
> _ / __ __ /_/ / __ / __ /_ __ /_ __ / __ |/ /
> / /_/ / _ _, _/ __/ / _ __/ _ __/ __/ / _ /| /
> \____/ /_/ |_| /___/ /_/ /_/ /___/ /_/ |_/ version: 0.5.0
> 2020-01-10 12:25:07.659 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication 
> : Starting GriffinWebApplication v0.5.0 on bgnode17 with PID 175689 
> (/opt/data-quality/soft/griffin/griffin-service.jar started by chenchao1 in 
> /opt/data-quality/soft/griffin)
> 2020-01-10 12:25:07.671 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication 
> : No active profile set, falling back to default profiles: default
> 2020-01-10 12:25:07.757 INFO 175689 --- [ main] 
> ationConfigEmbeddedWebApplicationContext : Refreshing 
> org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@7c53a9eb:
>  startup date [Fri Jan 10 12:25:07 CST 2020]; root of context hierarchy
> 2020-01-10 12:25:09.289 INFO 175689 --- [ main] 
> o.s.b.f.s.DefaultListableBeanFactory : Overriding bean definition for bean 
> 'dataSource' with a different definition: replacing [Root bean: class [null]; 
> scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; 
> autowireCandidate=true; primary=false; 
> factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Dbcp;
>  factoryMethodName=dataSource; initMethodName=null; 
> destroyMethodName=(inferred); defined in class path resource 
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Dbcp.class]]
>  with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; 
> autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; 
> factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari;
>  factoryMethodName=dataSource; initMethodName=null; 
> destroyMethodName=(inferred); defined in class path resource 
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
> 2020-01-10 12:25:09.290 INFO 175689 --- [ main] 
> o.s.b.f.s.DefaultListableBeanFactory : Overriding bean definition for bean 
> 'dataSource' with a different definition: replacing [Root bean: class [null]; 
> scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; 
> autowireCandidate=true; primary=false; 
> factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari;
>  factoryMethodName=dataSource; initMethodName=null; 
> destroyMethodName=(inferred); defined in class path resource 
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
>  with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; 
> autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; 
> factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Tomcat;
>  factoryMethodName=dataSource; initMethodName=null; 
> destroyMethodName=(inferred); defined in class path resource 
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]]
> 2020-01-10 12:25:10.046 INFO 175689 --- [ main] 
> f.a.AutowiredAnnotationBeanPostProcessor : JSR-330 'javax.inject.Inject' 
> annotation found and supported for autowiring
> 2020-01-10 12:25:10.269 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'org.springframework.boot.autoconfigure.validation.ValidationAutoConfiguration'
>  of type [class 
> org.springframework.boot.autoconfigure.validation.ValidationAutoConfiguration]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:10.293 WARN 175689 --- [ main] 
> o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator 
> has been chosen, EL interpolation will not be supported
> 2020-01-10 12:25:10.466 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 'validator' of type [class 
> org.springframework.validation.beanvalidation.LocalValidatorFactoryBean] is 
> not eligible for getting processed by all BeanPostProcessors (for example: 
> not eligible for auto-proxying)
> 2020-01-10 12:25:10.558 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration'
>  of type [class 
> org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$a95fb55]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:10.651 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'org.springframework.cache.annotation.ProxyCachingConfiguration' of type 
> [class 
> org.springframework.cache.annotation.ProxyCachingConfiguration$$EnhancerBySpringCGLIB$$53a83173]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:10.719 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration' of type 
> [class 
> org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration$$EnhancerBySpringCGLIB$$481bf617]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:10.735 WARN 175689 --- [ main] 
> o.h.v.m.ParameterMessageInterpolator : HV000184: ParameterMessageInterpolator 
> has been chosen, EL interpolation will not be supported
> 2020-01-10 12:25:10.752 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'spring.cache-org.springframework.boot.autoconfigure.cache.CacheProperties' 
> of type [class org.springframework.boot.autoconfigure.cache.CacheProperties] 
> is not eligible for getting processed by all BeanPostProcessors (for example: 
> not eligible for auto-proxying)
> 2020-01-10 12:25:10.766 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 'cacheManagerCustomizers' of 
> type [class 
> org.springframework.boot.autoconfigure.cache.CacheManagerCustomizers] is not 
> eligible for getting processed by all BeanPostProcessors (for example: not 
> eligible for auto-proxying)
> 2020-01-10 12:25:10.773 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'org.springframework.boot.autoconfigure.cache.GuavaCacheConfiguration' of 
> type [class 
> org.springframework.boot.autoconfigure.cache.GuavaCacheConfiguration$$EnhancerBySpringCGLIB$$9fb92eb4]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:10.788 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 'cacheManager' of type [class 
> org.springframework.cache.guava.GuavaCacheManager] is not eligible for 
> getting processed by all BeanPostProcessors (for example: not eligible for 
> auto-proxying)
> 2020-01-10 12:25:10.789 INFO 175689 --- [ main] 
> trationDelegate$BeanPostProcessorChecker : Bean 
> 'cacheAutoConfigurationValidator' of type [class 
> org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration$CacheManagerValidator]
>  is not eligible for getting processed by all BeanPostProcessors (for 
> example: not eligible for auto-proxying)
> 2020-01-10 12:25:11.284 INFO 175689 --- [ main] 
> s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat initialized with port(s): 
> 18080 (http)
> Jan 10, 2020 12:25:11 PM org.apache.catalina.core.StandardService 
> startInternal
> INFO: Starting service Tomcat
> Jan 10, 2020 12:25:11 PM org.apache.catalina.core.StandardEngine startInternal
> INFO: Starting Servlet Engine: Apache Tomcat/8.5.11
> Jan 10, 2020 12:25:11 PM org.apache.catalina.core.ApplicationContext log
> INFO: Initializing Spring embedded WebApplicationContext
> 2020-01-10 12:25:11.521 INFO 175689 --- [ost-startStop-1] 
> o.s.w.c.ContextLoader : Root WebApplicationContext: initialization completed 
> in 3768 ms
> 2020-01-10 12:25:16.954 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.ServletRegistrationBean : Mapping servlet: 'dispatcherServlet' to 
> [/]
> 2020-01-10 12:25:16.965 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'characterEncodingFilter' 
> to: [/*]
> 2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'hiddenHttpMethodFilter' 
> to: [/*]
> 2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'httpPutFormContentFilter' 
> to: [/*]
> 2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'requestContextFilter' to: 
> [/*]
> 2020-01-10 12:25:16.966 INFO 175689 --- [ost-startStop-1] 
> o.s.b.w.s.FilterRegistrationBean : Mapping filter: 'simpleFilter' to: [/*]
> 2020-01-10 12:25:18.156 INFO 175689 --- [ main] 
> j.LocalContainerEntityManagerFactoryBean : Building JPA container 
> EntityManagerFactory for persistence unit 'default'
> 2020-01-10 12:25:18.908 INFO 175689 --- [ main] 
> j.LocalContainerEntityManagerFactoryBean : Initialized JPA 
> EntityManagerFactory for persistence unit 'default'
> [EL Info]: 2020-01-10 12:25:19.103--ServerSession(1297189682)--EclipseLink, 
> version: Eclipse Persistence Services - 2.6.0.v20150309-bf26070
> [EL Info]: connection: 2020-01-10 
> 12:25:19.201--ServerSession(1297189682)--/file:/opt/data-quality/soft/griffin/griffin-service.jar_default
>  login successful
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.294--ServerSession(1297189682)--Connection(1760670079)--ALTER TABLE 
> RULE ADD `out` VARCHAR(255) 
> [EL Fine]: sql: 2020-01-10 12:25:19.309--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.31--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column 
> name 'out'
> Error Code: 1060
> Call: ALTER TABLE RULE ADD `out` VARCHAR(255) 
> Query: DataModifyQuery(sql="ALTER TABLE RULE ADD `out` VARCHAR(255) ")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.341--ServerSession(1297189682)--Connection(1550228904)--ALTER TABLE 
> JOBDATASEGMENT ADD CONSTRAINT FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY 
> (segment_range_id) REFERENCES SEGMENTRANGE (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.478--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.479--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE JOBDATASEGMENT ADD CONSTRAINT 
> FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY (segment_range_id) REFERENCES 
> SEGMENTRANGE (ID)
> Query: DataModifyQuery(sql="ALTER TABLE JOBDATASEGMENT ADD CONSTRAINT 
> FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY (segment_range_id) REFERENCES 
> SEGMENTRANGE (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.48--ServerSession(1297189682)--Connection(684822005)--ALTER TABLE 
> JOBINSTANCEBEAN ADD CONSTRAINT FK_JOBINSTANCEBEAN_job_id FOREIGN KEY (job_id) 
> REFERENCES job (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.579--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.58--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE JOBINSTANCEBEAN ADD CONSTRAINT FK_JOBINSTANCEBEAN_job_id 
> FOREIGN KEY (job_id) REFERENCES job (ID)
> Query: DataModifyQuery(sql="ALTER TABLE JOBINSTANCEBEAN ADD CONSTRAINT 
> FK_JOBINSTANCEBEAN_job_id FOREIGN KEY (job_id) REFERENCES job (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.581--ServerSession(1297189682)--Connection(1439632660)--ALTER TABLE 
> RULE ADD CONSTRAINT FK_RULE_evaluate_rule_id FOREIGN KEY (evaluate_rule_id) 
> REFERENCES EVALUATERULE (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.605--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.606--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE RULE ADD CONSTRAINT FK_RULE_evaluate_rule_id FOREIGN KEY 
> (evaluate_rule_id) REFERENCES EVALUATERULE (ID)
> Query: DataModifyQuery(sql="ALTER TABLE RULE ADD CONSTRAINT 
> FK_RULE_evaluate_rule_id FOREIGN KEY (evaluate_rule_id) REFERENCES 
> EVALUATERULE (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.606--ServerSession(1297189682)--Connection(665698670)--ALTER TABLE 
> SEGMENTPREDICATE ADD CONSTRAINT FK_SEGMENTPREDICATE_data_connector_id FOREIGN 
> KEY (data_connector_id) REFERENCES DATACONNECTOR (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.677--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.678--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE SEGMENTPREDICATE ADD CONSTRAINT 
> FK_SEGMENTPREDICATE_data_connector_id FOREIGN KEY (data_connector_id) 
> REFERENCES DATACONNECTOR (ID)
> Query: DataModifyQuery(sql="ALTER TABLE SEGMENTPREDICATE ADD CONSTRAINT 
> FK_SEGMENTPREDICATE_data_connector_id FOREIGN KEY (data_connector_id) 
> REFERENCES DATACONNECTOR (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.678--ServerSession(1297189682)--Connection(638169719)--ALTER TABLE 
> GRIFFINMEASURE ADD CONSTRAINT FK_GRIFFINMEASURE_ID FOREIGN KEY (ID) 
> REFERENCES MEASURE (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.686--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.686--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE GRIFFINMEASURE ADD CONSTRAINT FK_GRIFFINMEASURE_ID FOREIGN 
> KEY (ID) REFERENCES MEASURE (ID)
> Query: DataModifyQuery(sql="ALTER TABLE GRIFFINMEASURE ADD CONSTRAINT 
> FK_GRIFFINMEASURE_ID FOREIGN KEY (ID) REFERENCES MEASURE (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.687--ServerSession(1297189682)--Connection(1446922577)--ALTER TABLE 
> DATASOURCE ADD CONSTRAINT FK_DATASOURCE_measure_id FOREIGN KEY (measure_id) 
> REFERENCES MEASURE (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.814--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.815--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE DATASOURCE ADD CONSTRAINT FK_DATASOURCE_measure_id FOREIGN 
> KEY (measure_id) REFERENCES MEASURE (ID)
> Query: DataModifyQuery(sql="ALTER TABLE DATASOURCE ADD CONSTRAINT 
> FK_DATASOURCE_measure_id FOREIGN KEY (measure_id) REFERENCES MEASURE (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.815--ServerSession(1297189682)--Connection(722951168)--ALTER TABLE 
> DATACONNECTOR ADD CONSTRAINT FK_DATACONNECTOR_data_source_id FOREIGN KEY 
> (data_source_id) REFERENCES DATASOURCE (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.826--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.827--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE DATACONNECTOR ADD CONSTRAINT 
> FK_DATACONNECTOR_data_source_id FOREIGN KEY (data_source_id) REFERENCES 
> DATASOURCE (ID)
> Query: DataModifyQuery(sql="ALTER TABLE DATACONNECTOR ADD CONSTRAINT 
> FK_DATACONNECTOR_data_source_id FOREIGN KEY (data_source_id) REFERENCES 
> DATASOURCE (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.827--ServerSession(1297189682)--Connection(451460284)--ALTER TABLE 
> STREAMINGPREPROCESS ADD CONSTRAINT FK_STREAMINGPREPROCESS_pre_process_id 
> FOREIGN KEY (pre_process_id) REFERENCES DATACONNECTOR (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.895--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.895--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE STREAMINGPREPROCESS ADD CONSTRAINT 
> FK_STREAMINGPREPROCESS_pre_process_id FOREIGN KEY (pre_process_id) REFERENCES 
> DATACONNECTOR (ID)
> Query: DataModifyQuery(sql="ALTER TABLE STREAMINGPREPROCESS ADD CONSTRAINT 
> FK_STREAMINGPREPROCESS_pre_process_id FOREIGN KEY (pre_process_id) REFERENCES 
> DATACONNECTOR (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.896--ServerSession(1297189682)--Connection(2101153819)--ALTER TABLE 
> EXTERNALMEASURE ADD CONSTRAINT FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY 
> (VIRTUALJOB_ID) REFERENCES job (ID)
> [EL Fine]: sql: 2020-01-10 12:25:19.93--ServerSession(1297189682)--SELECT 1
> [EL Warning]: 2020-01-10 12:25:19.931--ServerSession(1297189682)--Exception 
> [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: 
> Can't write; duplicate key in table '#sql-131ca_7e06e0'
> Error Code: 1022
> Call: ALTER TABLE EXTERNALMEASURE ADD CONSTRAINT 
> FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY (VIRTUALJOB_ID) REFERENCES job 
> (ID)
> Query: DataModifyQuery(sql="ALTER TABLE EXTERNALMEASURE ADD CONSTRAINT 
> FK_EXTERNALMEASURE_VIRTUALJOB_ID FOREIGN KEY (VIRTUALJOB_ID) REFERENCES job 
> (ID)")
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.934--ServerSession(1297189682)--Connection(2024415090)--SELECT * 
> FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
> [EL Fine]: sql: 2020-01-10 
> 12:25:19.938--ServerSession(1297189682)--Connection(1661210650)--SELECT * 
> FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
> 2020-01-10 12:25:21.698 INFO 175689 --- [ main] o.a.g.c.c.PropertiesConfig : 
> external.config.location : /opt/data-quality/soft/griffin/conf
> 2020-01-10 12:25:21.698 INFO 175689 --- [ main] o.a.g.c.c.PropertiesConfig : 
> external.env.location : /opt/data-quality/soft/griffin/env
> 2020-01-10 12:25:21.716 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
> absolute path:/opt/data-quality/soft/griffin/env
> 2020-01-10 12:25:21.716 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
> external location '/opt/data-quality/soft/griffin/env' does not exist.Read 
> fromdefault path.
> 2020-01-10 12:25:21.819 INFO 175689 --- [ main] o.a.g.c.c.EnvConfig : {
>  "spark" : {
>  "log.level" : "WARN"
>  },
>  "sinks" : [ {
>  "type" : "CONSOLE",
>  "config" : {
>  "max.log.lines" : 10
>  }
>  }, {
>  "type" : "HDFS",
>  "config" : {
>  "path" : "hdfs:///user/chenchao1/griffin/persist",
>  "max.persist.lines" : 10000,
>  "max.lines.per.file" : 10000
>  }
>  }, {
>  "type" : "ELASTICSEARCH",
>  "config" : {
>  "method" : "post",
>  "api" : "http://bgnode8:9200/griffin/accuracy";,
>  "connection.timeout" : "1m",
>  "retry" : 10
>  }
>  } ],
>  "griffin.checkpoint" : [ ]
> }
> 2020-01-10 12:25:21.819 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
> absolute path:/opt/data-quality/soft/griffin/env
> 2020-01-10 12:25:21.819 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
> external location '/opt/data-quality/soft/griffin/env' does not exist.Read 
> fromdefault path.
> 2020-01-10 12:25:21.823 INFO 175689 --- [ main] o.a.g.c.c.EnvConfig : {
>  "spark" : {
>  "log.level" : "WARN",
>  "checkpoint.dir" : "hdfs:///user/chenchao1/griffin/checkpoint/${JOB_NAME}",
>  "init.clear" : true,
>  "batch.interval" : "1m",
>  "process.interval" : "5m",
>  "config" : {
>  "spark.default.parallelism" : 4,
>  "spark.task.maxFailures" : 5,
>  "spark.streaming.kafkaMaxRatePerPartition" : 1000,
>  "spark.streaming.concurrentJobs" : 4,
>  "spark.yarn.maxAppAttempts" : 5,
>  "spark.yarn.am.attemptFailuresValidityInterval" : "1h",
>  "spark.yarn.max.executor.failures" : 120,
>  "spark.yarn.executor.failuresValidityInterval" : "1h",
>  "spark.hadoop.fs.hdfs.impl.disable.cache" : true
>  }
>  },
>  "sinks" : [ {
>  "type" : "CONSOLE",
>  "config" : {
>  "max.log.lines" : 100
>  }
>  }, {
>  "type" : "HDFS",
>  "config" : {
>  "path" : "hdfs:///user/chenchao1/griffin/persist",
>  "max.persist.lines" : 10000,
>  "max.lines.per.file" : 10000
>  }
>  }, {
>  "type" : "ELASTICSEARCH",
>  "config" : {
>  "method" : "post",
>  "api" : "http://bgnode8:9200/griffin/accuracy";
>  }
>  } ],
>  "griffin.checkpoint" : [ {
>  "type" : "zk",
>  "config" : {
>  "hosts" : "bgnode6:2181",
>  "namespace" : "griffin/infocache",
>  "lock.path" : "lock",
>  "mode" : "persist",
>  "init.clear" : true,
>  "close.clear" : false
>  }
>  } ]
> }
> 2020-01-10 12:25:21.825 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
> absolute path:/opt/data-quality/soft/griffin/conf
> 2020-01-10 12:25:21.826 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
> external location '/opt/data-quality/soft/griffin/conf' does not exist.Read 
> fromdefault path.
> 2020-01-10 12:25:21.844 INFO 175689 --- [ main] o.a.g.c.u.FileUtil : File 
> absolute path:/opt/data-quality/soft/griffin/conf
> 2020-01-10 12:25:21.844 WARN 175689 --- [ main] o.a.g.c.u.FileUtil : The 
> external location '/opt/data-quality/soft/griffin/conf' does not exist.Read 
> fromdefault path.
> 2020-01-10 12:25:21.845 INFO 175689 --- [ main] 
> o.s.b.f.c.PropertiesFactoryBean : Loading properties file from class path 
> resource [quartz.properties]
> 2020-01-10 12:25:21.846 INFO 175689 --- [ main] o.a.g.c.u.PropertiesUtil : 
> Read properties successfully from /quartz.properties.
> 2020-01-10 12:25:21.961 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
> Using default implementation for ThreadExecutor
> 2020-01-10 12:25:21.981 INFO 175689 --- [ main] o.q.c.SchedulerSignalerImpl : 
> Initialized Scheduler Signaller of type: class 
> org.quartz.core.SchedulerSignalerImpl
> 2020-01-10 12:25:21.981 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
> Quartz Scheduler v.2.2.2 created.
> 2020-01-10 12:25:21.987 INFO 175689 --- [ main] 
> o.s.s.q.LocalDataSourceJobStore : Using db table-based data access locking 
> (synchronization).
> 2020-01-10 12:25:21.991 INFO 175689 --- [ main] 
> o.s.s.q.LocalDataSourceJobStore : JobStoreCMT initialized.
> 2020-01-10 12:25:21.993 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
> Scheduler meta-data: Quartz Scheduler (v2.2.2) 'schedulerFactoryBean' with 
> instanceId 'bgnode171578630321964'
>  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
>  NOT STARTED.
>  Currently in standby mode.
>  Number of jobs executed: 0
>  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 5 threads.
>  Using job-store 
> 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which 
> supports persistence. and is clustered.
> 2020-01-10 12:25:21.993 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
> Quartz scheduler 'schedulerFactoryBean' initialized from an externally 
> provided properties instance.
> 2020-01-10 12:25:21.994 INFO 175689 --- [ main] o.q.i.StdSchedulerFactory : 
> Quartz scheduler version: 2.2.2
> 2020-01-10 12:25:21.994 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
> JobFactory set to: 
> org.apache.griffin.core.job.factory.AutowiringSpringBeanJobFactory@35229f85
> 2020-01-10 12:25:22.536 INFO 175689 --- [ main] 
> o.a.g.c.j.LivyTaskSubmitHelper : Livy uri : http://bgnode10:8998/batches
> 2020-01-10 12:25:22.925 WARN 175689 --- [ main] o.a.h.u.NativeCodeLoader : 
> Unable to load native-hadoop library for your platform... using builtin-java 
> classes where applicable
> 2020-01-10 12:25:23.164 INFO 175689 --- [ main] o.a.h.h.c.HiveConf : Found 
> configuration file 
> jar:file:/opt/data-quality/soft/griffin/griffin-service.jar!/BOOT-INF/classes!/hive-site.xml
> 2020-01-10 12:25:23.476 INFO 175689 --- [ main] h.metastore : Trying to 
> connect to metastore with URI thrift://bgnode3:9083
> 2020-01-10 12:25:23.504 INFO 175689 --- [ main] h.metastore : Opened a 
> connection to metastore, current connections: 1
> 2020-01-10 12:25:23.558 INFO 175689 --- [ main] h.metastore : Connected to 
> metastore.
> 2020-01-10 12:25:24.651 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerAdapter : Looking for @ControllerAdvice: 
> org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext@7c53a9eb:
>  startup date [Fri Jan 10 12:25:07 CST 2020]; root of context hierarchy
> 2020-01-10 12:25:24.773 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/version],methods=[GET]}" onto public java.lang.String 
> org.apache.griffin.core.info.GriffinInfoController.greeting()
> 2020-01-10 12:25:24.775 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metrics],methods=[GET]}" onto public 
> java.util.Map<java.lang.String, 
> java.util.List<org.apache.griffin.core.metric.model.Metric>> 
> org.apache.griffin.core.metric.MetricController.getAllMetrics()
> 2020-01-10 12:25:24.777 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metrics/values],methods=[GET]}" onto public 
> java.util.List<org.apache.griffin.core.metric.model.MetricValue> 
> org.apache.griffin.core.metric.MetricController.getMetricValues(java.lang.String,int,int,long)
> 2020-01-10 12:25:24.777 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metrics/values],methods=[POST]}" onto public 
> org.springframework.http.ResponseEntity<?> 
> org.apache.griffin.core.metric.MetricController.addMetricValues(java.util.List<org.apache.griffin.core.metric.model.MetricValue>)
> 2020-01-10 12:25:24.778 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metrics/values],methods=[DELETE]}" onto public 
> org.springframework.http.ResponseEntity<?> 
> org.apache.griffin.core.metric.MetricController.deleteMetricValues(java.lang.String)
> 2020-01-10 12:25:24.786 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/{id}],methods=[PUT]}" onto public 
> org.apache.griffin.core.job.entity.AbstractJob 
> org.apache.griffin.core.job.JobController.onActions(java.lang.Long,java.lang.String)
>  throws java.lang.Exception
> 2020-01-10 12:25:24.786 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs],methods=[DELETE]}" onto public void 
> org.apache.griffin.core.job.JobController.deleteJob(java.lang.String) throws 
> org.quartz.SchedulerException
> 2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/{id}],methods=[DELETE]}" onto public void 
> org.apache.griffin.core.job.JobController.deleteJob(java.lang.Long) throws 
> org.quartz.SchedulerException
> 2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs],methods=[POST]}" onto public 
> org.apache.griffin.core.job.entity.AbstractJob 
> org.apache.griffin.core.job.JobController.addJob(org.apache.griffin.core.job.entity.AbstractJob)
>  throws java.lang.Exception
> 2020-01-10 12:25:24.787 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs],methods=[GET]}" onto public 
> java.util.List<org.apache.griffin.core.job.entity.AbstractJob> 
> org.apache.griffin.core.job.JobController.getJobs(java.lang.String)
> 2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/instances/{instanceId}],methods=[GET]}" onto public 
> org.apache.griffin.core.job.entity.JobInstanceBean 
> org.apache.griffin.core.job.JobController.findInstanceByInstanceId(java.lang.Long)
> 2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/download],methods=[GET]}" onto public 
> org.springframework.http.ResponseEntity<org.springframework.core.io.Resource> 
> org.apache.griffin.core.job.JobController.download(java.lang.String,long) 
> throws java.lang.Exception
> 2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/trigger/{id}],methods=[POST]}" onto public void 
> org.apache.griffin.core.job.JobController.triggerJob(java.lang.Long) throws 
> org.quartz.SchedulerException
> 2020-01-10 12:25:24.788 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "\{[/api/v1/jobs/config]}" 
> onto public org.apache.griffin.core.job.entity.AbstractJob 
> org.apache.griffin.core.job.JobController.getJobConfig(java.lang.Long)
> 2020-01-10 12:25:24.789 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/instances],methods=[GET]}" onto public 
> java.util.List<org.apache.griffin.core.job.entity.JobInstanceBean> 
> org.apache.griffin.core.job.JobController.findInstancesOfJob(java.lang.Long,int,int)
> 2020-01-10 12:25:24.789 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/jobs/health],methods=[GET]}" onto public 
> org.apache.griffin.core.job.entity.JobHealth 
> org.apache.griffin.core.job.JobController.getHealthInfo()
> 2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/org],methods=[GET]}" onto public java.util.List<java.lang.String> 
> org.apache.griffin.core.measure.MeasureOrgController.getOrgs()
> 2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/org/{org}],methods=[GET]}" onto public 
> java.util.List<java.lang.String> 
> org.apache.griffin.core.measure.MeasureOrgController.getMetricNameListByOrg(java.lang.String)
> 2020-01-10 12:25:24.791 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/org/measure/names],methods=[GET]}" onto public 
> java.util.Map<java.lang.String, java.util.List<java.lang.String>> 
> org.apache.griffin.core.measure.MeasureOrgController.getMeasureNamesGroupByOrg()
> 2020-01-10 12:25:24.793 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures],methods=[GET]}" onto public java.util.List<? extends 
> org.apache.griffin.core.measure.entity.Measure> 
> org.apache.griffin.core.measure.MeasureController.getAllAliveMeasures(java.lang.String)
> 2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures/{id}],methods=[GET]}" onto public 
> org.apache.griffin.core.measure.entity.Measure 
> org.apache.griffin.core.measure.MeasureController.getMeasureById(long)
> 2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures/owner/{owner}],methods=[GET]}" onto public 
> java.util.List<org.apache.griffin.core.measure.entity.Measure> 
> org.apache.griffin.core.measure.MeasureController.getAliveMeasuresByOwner(java.lang.String)
> 2020-01-10 12:25:24.794 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures],methods=[POST]}" onto public 
> org.apache.griffin.core.measure.entity.Measure 
> org.apache.griffin.core.measure.MeasureController.createMeasure(org.apache.griffin.core.measure.entity.Measure)
> 2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures],methods=[PUT]}" onto public 
> org.apache.griffin.core.measure.entity.Measure 
> org.apache.griffin.core.measure.MeasureController.updateMeasure(org.apache.griffin.core.measure.entity.Measure)
> 2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures/{id}],methods=[DELETE]}" onto public void 
> org.apache.griffin.core.measure.MeasureController.deleteMeasureById(java.lang.Long)
>  throws org.quartz.SchedulerException
> 2020-01-10 12:25:24.795 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/measures],methods=[DELETE]}" onto public void 
> org.apache.griffin.core.measure.MeasureController.deleteMeasures() throws 
> org.quartz.SchedulerException
> 2020-01-10 12:25:24.797 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/dbs],methods=[GET]}" onto public 
> java.lang.Iterable<java.lang.String> 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllDatabases()
> 2020-01-10 12:25:24.797 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/dbs/tables/names],methods=[GET]}" onto public 
> java.util.Map<java.lang.String, java.util.List<java.lang.String>> 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTableNames()
> 2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/tables/names],methods=[GET]}" onto public 
> java.lang.Iterable<java.lang.String> 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTableNames(java.lang.String)
> 2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/dbs/tables],methods=[GET]}" onto public 
> java.util.Map<java.lang.String, 
> java.util.List<org.apache.hadoop.hive.metastore.api.Table>> 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTables()
> 2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/tables],methods=[GET]}" onto public 
> java.util.List<org.apache.hadoop.hive.metastore.api.Table> 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getAllTables(java.lang.String)
> 2020-01-10 12:25:24.798 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/hive/table],methods=[GET]}" onto public 
> org.apache.hadoop.hive.metastore.api.Table 
> org.apache.griffin.core.metastore.hive.HiveMetaStoreController.getTable(java.lang.String,java.lang.String)
> 2020-01-10 12:25:24.800 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/subject],methods=[GET]}" onto public 
> java.lang.Iterable<java.lang.String> 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjects()
> 2020-01-10 12:25:24.800 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/versions],methods=[GET]}" onto public 
> java.lang.Iterable<java.lang.Integer> 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectVersions(java.lang.String)
> 2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/subjectSchema],methods=[GET]}" onto public 
> io.confluent.kafka.schemaregistry.client.rest.entities.Schema 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectSchema(java.lang.String,java.lang.String)
> 2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/config],methods=[GET]}" onto public 
> io.confluent.kafka.schemaregistry.client.rest.entities.Config 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getTopLevelConfig()
> 2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/config/{subject}],methods=[GET]}" onto public 
> io.confluent.kafka.schemaregistry.client.rest.entities.Config 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSubjectLevelConfig(java.lang.String)
> 2020-01-10 12:25:24.801 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/metadata/kafka/schema/{id}],methods=[GET]}" onto public 
> io.confluent.kafka.schemaregistry.client.rest.entities.SchemaString 
> org.apache.griffin.core.metastore.kafka.KafkaSchemaController.getSchemaString(java.lang.Integer)
> 2020-01-10 12:25:24.802 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/api/v1/login/authenticate],methods=[POST]}" onto public 
> org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, 
> java.lang.Object>> 
> org.apache.griffin.core.login.LoginController.login(java.util.Map<java.lang.String,
>  java.lang.String>)
> 2020-01-10 12:25:24.806 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped 
> "\{[/error],produces=[text/html]}" onto public 
> org.springframework.web.servlet.ModelAndView 
> org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
> 2020-01-10 12:25:24.806 INFO 175689 --- [ main] 
> s.w.s.m.m.a.RequestMappingHandlerMapping : Mapped "\{[/error]}" onto public 
> org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, 
> java.lang.Object>> 
> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest)
> 2020-01-10 12:25:24.881 INFO 175689 --- [ main] 
> o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/webjars/**] onto 
> handler of type [class 
> org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
> 2020-01-10 12:25:24.882 INFO 175689 --- [ main] 
> o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/**] onto handler of 
> type [class 
> org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
> 2020-01-10 12:25:24.916 INFO 175689 --- [ main] 
> .m.m.a.ExceptionHandlerExceptionResolver : Detected @ExceptionHandler methods 
> in griffinExceptionHandler
> 2020-01-10 12:25:24.973 INFO 175689 --- [ main] 
> o.s.w.s.h.SimpleUrlHandlerMapping : Mapped URL path [/**/favicon.ico] onto 
> handler of type [class 
> org.springframework.web.servlet.resource.ResourceHttpRequestHandler]
> 2020-01-10 12:25:30.749 INFO 175689 --- [ main] 
> o.s.j.e.a.AnnotationMBeanExporter : Registering beans for JMX exposure on 
> startup
> 2020-01-10 12:25:30.766 INFO 175689 --- [ main] 
> o.s.c.s.DefaultLifecycleProcessor : Starting beans in phase 2147483647
> 2020-01-10 12:25:30.766 INFO 175689 --- [ main] o.s.s.q.SchedulerFactoryBean 
> : Starting Quartz Scheduler now
> 2020-01-10 12:25:30.797 INFO 175689 --- [ main] 
> o.s.s.q.LocalDataSourceJobStore : ClusterManager: detected 1 failed or 
> restarted instances.
> 2020-01-10 12:25:30.797 INFO 175689 --- [ main] 
> o.s.s.q.LocalDataSourceJobStore : ClusterManager: Scanning for instance 
> "bgnode171578629416141"'s failed in-progress jobs.
> 2020-01-10 12:25:30.805 INFO 175689 --- [ main] o.q.c.QuartzScheduler : 
> Scheduler schedulerFactoryBean_$_bgnode171578630321964 started.
> 2020-01-10 12:25:30.822 INFO 175689 --- [ main] 
> s.a.ScheduledAnnotationBeanPostProcessor : No 
> TaskScheduler/ScheduledExecutorService bean found for scheduled processing
> Jan 10, 2020 12:25:30 PM org.apache.coyote.AbstractProtocol init
> INFO: Initializing ProtocolHandler ["http-nio-18080"]
> Jan 10, 2020 12:25:30 PM org.apache.coyote.AbstractProtocol start
> INFO: Starting ProtocolHandler [http-nio-18080]
> 2020-01-10 12:25:30.867 INFO 175689 --- [pool-5-thread-1] 
> o.a.g.c.m.h.HiveMetaStoreService : Evict hive cache
> Jan 10, 2020 12:25:30 PM org.apache.tomcat.util.net.NioSelectorPool 
> getSharedSelector
> INFO: Using a shared selector for servlet write/read
> [EL Fine]: sql: 2020-01-10 
> 12:25:30.912--ServerSession(1297189682)--Connection(1612698511)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:25:30.927--ServerSession(1297189682)--Connection(724612497)--SELECT ID, 
> APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
> predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
> STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (expire_timestamp 
> <= ?)
>  bind => [1 parameter bound]
> 2020-01-10 12:25:30.937 INFO 175689 --- [ main] 
> s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 18080 
> (http)
> 2020-01-10 12:25:30.946 INFO 175689 --- [ main] o.a.g.c.GriffinWebApplication 
> : Started GriffinWebApplication in 24.21 seconds (JVM running for 25.473)
> [EL Fine]: sql: 2020-01-10 
> 12:25:30.953--ClientSession(1542130237)--Connection(1977196780)--DELETE FROM 
> JOBINSTANCEBEAN WHERE ((expire_timestamp <= ?) AND (DELETED = ?))
>  bind => [2 parameters bound]
> 2020-01-10 12:25:30.969 INFO 175689 --- [pool-5-thread-1] 
> o.a.g.c.j.JobServiceImpl : Delete 0 expired job instances.
> Jan 10, 2020 12:25:41 PM org.apache.catalina.core.ApplicationContext log
> INFO: Initializing Spring FrameworkServlet 'dispatcherServlet'
> 2020-01-10 12:25:41.807 INFO 175689 --- [io-18080-exec-1] 
> o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': 
> initialization started
> 2020-01-10 12:25:41.830 INFO 175689 --- [io-18080-exec-1] 
> o.s.w.s.DispatcherServlet : FrameworkServlet 'dispatcherServlet': 
> initialization completed in 22 ms
> [EL Fine]: sql: 2020-01-10 
> 12:26:30.925--ServerSession(1297189682)--Connection(1594280335)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:27:30.931--ServerSession(1297189682)--Connection(30748468)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:28:30.94--ServerSession(1297189682)--Connection(1622492767)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:29:30.943--ServerSession(1297189682)--Connection(996509770)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:30:30.953--ServerSession(1297189682)--Connection(1743023688)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:31:30.959--ServerSession(1297189682)--Connection(1527486180)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:32:30.964--ServerSession(1297189682)--Connection(2094953605)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:33:30.967--ServerSession(1297189682)--Connection(881639974)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:34:30.97--ServerSession(1297189682)--Connection(551023431)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:35:30.974--ServerSession(1297189682)--Connection(676620878)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:36:30.977--ServerSession(1297189682)--Connection(791671173)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:37:30.98--ServerSession(1297189682)--Connection(615593200)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:38:30.983--ServerSession(1297189682)--Connection(1615983339)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:39:30.988--ServerSession(1297189682)--Connection(262053999)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> 2020-01-10 12:40:30.836 INFO 175689 --- [pool-5-thread-1] 
> o.a.g.c.m.h.HiveMetaStoreService : Evict hive cache
> [EL Fine]: sql: 2020-01-10 
> 12:40:30.992--ServerSession(1297189682)--Connection(1848136440)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:41:30.995--ServerSession(1297189682)--Connection(231460473)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:42:30.998--ServerSession(1297189682)--Connection(629102840)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:43:31.0--ServerSession(1297189682)--Connection(829875009)--SELECT DISTINCT 
> ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, MODIFIEDDATE, 
> predicate_job_deleted, predicate_group_name, predicate_job_name, SESSIONID, 
> STATE, timestamp, TYPE, job_id FROM JOBINSTANCEBEAN WHERE (STATE IN 
> (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:44:31.003--ServerSession(1297189682)--Connection(1393122270)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:45:31.006--ServerSession(1297189682)--Connection(563197612)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:46:31.01--ServerSession(1297189682)--Connection(282988792)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]
> [EL Fine]: sql: 2020-01-10 
> 12:47:31.013--ServerSession(1297189682)--Connection(915872014)--SELECT 
> DISTINCT ID, APPID, APPURI, CREATEDDATE, DELETED, expire_timestamp, 
> MODIFIEDDATE, predicate_job_deleted, predicate_group_name, 
> predicate_job_name, SESSIONID, STATE, timestamp, TYPE, job_id FROM 
> JOBINSTANCEBEAN WHERE (STATE IN (?,?,?,?,?,?))
>  bind => [6 parameters bound]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to