[
https://issues.apache.org/jira/browse/GRIFFIN-219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16711374#comment-16711374
]
Saket Bihari commented on GRIFFIN-219:
--------------------------------------
Any update on this? We have manually created this RULE table in quartz database
using the following syntax:
The problem was with "OUT" attribute !!!
CREATE TABLE RULE (ID BIGINT NOT NULL, CREATEDDATE BIGINT, DETAILS
VARCHAR(1024), DQTYPE VARCHAR(255), DSLTYPE VARCHAR(255), INDATAFRAMENAME
VARCHAR(255), MODIFIEDDATE DATETIME, `OUT` VARCHAR(255), OUTDATAFRAMENAME
VARCHAR(255), RULE VARCHAR(8192), evaluate_rule_id BIGINT, PRIMARY KEY (ID))...
But then when we restarted the Griffin service (in that time all other tables
were present in quartz database created in time of last service start time),
we're getting the following error:
[EL Fine]: sql: 2018-12-05
11:57:10.308--ServerSession(1324843695)--Connection(1077072774)--ALTER TABLE
JOBINSTANCEBEAN ADD CONSTRAINT FK_JOBINSTANCEBEAN_job_id FOREIGN KEY (job_id)
REFERENCES job (ID)
[EL Fine]: sql: 2018-12-05 11:57:10.364--ServerSession(1324843695)--SELECT 1
[EL Warning]: 2018-12-05 11:57:10.366--ServerSession(1324843695)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Can't create table
'quartz.#sql-4bd_1df' (errno: 121)
Error Code: 1005
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: 2018-12-05
11:57:10.369--ServerSession(1324843695)--Connection(1439632660)--ALTER TABLE
JOBDATASEGMENT ADD CONSTRAINT FK_JOBDATASEGMENT_segment_range_id FOREIGN KEY
(segment_range_id) REFERENCES SEGMENTRANGE (ID)
[EL Fine]: sql: 2018-12-05 11:57:10.427--ServerSession(1324843695)--SELECT 1
[EL Warning]: 2018-12-05 11:57:10.429--ServerSession(1324843695)--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Can't create table
'quartz.#sql-4bd_1df' (errno: 121)
Error Code: 1005
Any idea how to resolve this issue? It would be really helpful if anyone could
enlighten here...
> Griffin 0.3.1 Application Startup getting Failed due to mysql driver
> --------------------------------------------------------------------
>
> Key: GRIFFIN-219
> URL: https://issues.apache.org/jira/browse/GRIFFIN-219
> Project: Griffin (Incubating)
> Issue Type: Bug
> Affects Versions: 0.3.0-incubating
> Environment: CentOS 7.5
> Reporter: Saket Bihari
> Assignee: Kevin Yao
> Priority: Major
>
> Please find the details below:
> Executing: java -jar service-0.3.0-incubating.jar
> Getting Error:
> ------------------------
> Exception encountered during context initialization - cancelling refresh
> attempt: org.springframework.beans.factory.UnsatisfiedDependencyException:
> Error creating bean with name 'eclipseLinkJpaConfig' defined in URL
> [jar:file:/root/griffin-0.3.0-incubating/service/target/service-0.3.0-incubating.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
> 2018-12-04 08:40:01.007 INFO 67767 --- [ main]
> utoConfigurationReportLoggingInitializer :
> Error starting ApplicationContext. To display the auto-configuration report
> re-run your application with 'debug' enabled.
> 2018-12-04 08:40:01.010 ERROR 67767 --- [ main] o.s.b.SpringApplication :
> Application startup failed
> application.properties file:
> ------------------------------
> # jpa
> spring.datasource.url =
> jdbc:mysql://xxxxxxx.cloudapp.azure.com:3306/quartz?autoReconnect=true&useSSL=false
> spring.datasource.username = username
> spring.datasource.password = password123
> spring.jpa.generate-ddl=true
> spring.datasource.driverClassName = com.mysql.jdbc.Driver
> spring.jpa.show-sql = true
> # hive metastore
> hive.metastore.uris = thrift://xxxxxx.cloudapp.azure.com:9083
> hive.metastore.dbname = default
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
