You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@griffin.apache.org by "chenchencc (Jira)" <ji...@apache.org> on 2020/01/10 04:50:00 UTC
[jira] [Updated] (GRIFFIN-321) visit service web page return 404
[ https://issues.apache.org/jira/browse/GRIFFIN-321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenchencc updated GRIFFIN-321:
-------------------------------
Summary: visit service web page return 404 (was: visit service web page return response body '{}')
> visit service web page return 404
> ---------------------------------
>
> 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 |http://localhost:18080/]
> port 18080 is my config port in application.properties
> {"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|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|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)