You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@griffin.apache.org by "osmondy.yang (Jira)" <ji...@apache.org> on 2022/09/07 11:49:00 UTC
[jira] [Commented] (GRIFFIN-354) Table 'quartz.DATACONNECTOR' doesn't exist
[ https://issues.apache.org/jira/browse/GRIFFIN-354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17601272#comment-17601272 ]
osmondy.yang commented on GRIFFIN-354:
--------------------------------------
sql 执行该SQL会遇到字段太长的错误， 将 `CONFIG VARCHAR ( 20480 )` 改为 `CONFIG TEXT` 即可
> Table 'quartz.DATACONNECTOR' doesn't exist
> ------------------------------------------
>
> Key: GRIFFIN-354
> URL: https://issues.apache.org/jira/browse/GRIFFIN-354
> Project: Griffin
> Issue Type: Bug
> Components: Measure Module
> Affects Versions: 0.6.0
> Reporter: Kingsley
> Priority: Major
> Labels: 0.6.0
> Attachments: error_info.md
>
>
> when i {color:#FF0000}create a measure{color}, the log dispaly the below {color:#FF0000}error information{color}:
>
>
> 2020-12-29 21:44:38.992 ERROR 2997 --- [http-nio-8080-exec-6] o.a.c.c.C.[.[.[.[dispatcherServlet] [175] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'quartz.DATACONNECTOR' doesn't exist
> Error Code: 1146
> Call: INSERT INTO DATACONNECTOR (ID, CONFIG, CREATEDDATE, DATAFRAMENAME, DATATIMEZONE, DATAUNIT, MODIFIEDDATE, NAME, TYPE, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> bind => [5, \{"database":"default","table.name":"demo_src"}, 1609249478939, null, , 1day, null, source1609250030772, HIVE, 1.2]
> Query: InsertObjectQuery(DataConnector\{name=source1609250030772type=HIVE, version='1.2', config={"database":"default","table.name":"demo_src"}})] with root cause
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'quartz.DATACONNECTOR' doesn't exist
>
>
> But I can't find the table name in the init_quartz_mysql_innodb.sql
> It's confusing
--
This message was sent by Atlassian Jira
(v8.20.10#820010)