[
https://issues.apache.org/jira/browse/GRIFFIN-179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16546034#comment-16546034
]
Kwang-in (Dennis) JUNG commented on GRIFFIN-179:
------------------------------------------------
[~Kevin Yao] some more question...
1.It shows error log when I click black image(button?) with 'system' written:
```
2018-07-17 14:02:55.750 ERROR 5021 --- [io-8080-exec-10]
o.a.g.c.m.MetricServiceImpl : Failed to get metric values named System.
Connection refused
```
Can you tell me what caused this problem?
2.I found some error message related with db setup when running service:
```
Internal Exception: java.sql.SQLException: Can't create table
`quartz`.`#sql-24f_2e` (errno: 121 "Duplicate key on write or update")
Error Code: 1005
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: 2018-07-17
14:06:16.821--ServerSession(302366050)--Connection(1131184547)--SELECT * FROM
SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
[EL Fine]: sql: 2018-07-17
14:06:16.826--ServerSession(302366050)--Connection(1533524862)--SELECT * FROM
SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
```
Do I have to do something with database?
3.Also, hive seems not connected though I started running `hiveserver2`
```
2018-07-17 14:06:21.324 INFO 5167 --- [ main] h.metastore : Trying to connect
to metastore with URI thrift://localhost:9083
2018-07-17 14:06:21.326 WARN 5167 --- [ main] h.metastore : Failed to connect
to the MetaStore Server...
2018-07-17 14:06:21.326 INFO 5167 --- [ main] h.metastore : Waiting 1 seconds
before next connection attempt.
2018-07-17 14:06:22.328 INFO 5167 --- [ main] h.metastore : Trying to connect
to metastore with URI thrift://localhost:9083
2018-07-17 14:06:22.330 WARN 5167 --- [ main] h.metastore : Failed to connect
to the MetaStore Server...
2018-07-17 14:06:22.330 INFO 5167 --- [ main] h.metastore : Waiting 1 seconds
before next connection attempt.
2018-07-17 14:06:23.349 ERROR 5167 --- [ main] o.a.g.c.m.h.HiveMetaStoreProxy :
Failed to connect hive metastore. Could not connect to meta store using any of
the URIs provided. Most recent failure:
org.apache.thrift.transport.TTransportException: java.net.ConnectException:
Connection refused (Connection refused)
at org.apache.thrift.transport.TSocket.open(TSocket.java:226)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:478)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:286)
```
Thanks.
> Deploy questions
> ----------------
>
> Key: GRIFFIN-179
> URL: https://issues.apache.org/jira/browse/GRIFFIN-179
> Project: Griffin (Incubating)
> Issue Type: Test
> Affects Versions: 0.2.0-incubating
> Reporter: Kwang-in (Dennis) JUNG
> Priority: Minor
>
> Hello,
> I'm starter of this project, and have some question of setting up.
> This is my application.properties...
> ```
> spring.datasource.url =
> jdbc:mysql://localhost:3306/quartz?autoReconnect=true&useSSL=false
> spring.datasource.username = griffin
> spring.datasource.password = 123456
> spring.jpa.generate-ddl=true
> spring.datasource.driver-class-name = com.mysql.jdbc.Driver
> ...
> ```
> ...and it shows problem...
>
> ```
> ...
> 2018-07-13 14:33:52.190 ERROR 6603 --- [ main] o.s.b.SpringApplication :
> Application startup failed
> org.springframework.beans.factory.UnsatisfiedDependencyException: Error
> creating bean with name 'eclipseLinkJpaConfig' defined in URL
> [jar:file:/Users/jung/workspace/etc/incubator-griffin/service/target/service-0.2.0-incubating-SNAPSHOT.jar!/BOOT-INF/classes!/org/apache/griffin/core/config/EclipseLinkJpaConfig.class]:
> Unsatisfied dependency expressed through constructor parameter 0; nested
> exception is org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'dataSource' defined in class path resource
> [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]:
> Bean instantiation via factory method failed; nested exception is
> org.springframework.beans.BeanInstantiationException: Failed to instantiate
> [org.apache.tomcat.jdbc.pool.DataSource]: Factory method 'dataSource' threw
> exception; nested exception is java.lang.IllegalStateException: Cannot load
> driver class: com.mysql.jdbc.Driver
> at
> org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:749)
> ~[spring-beans-4.3.6.RELEASE.jar!/:4.3.6.RELEASE]
> at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:189)
> ~[spring-beans-4.3.6.RELEASE.jar!/:4.3.6.RELEASE]
> ...
> ```
>
> As you see, I'm trying to work on with mysql.
> Could you give me some help?
>
> Thanks.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
