You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@griffin.apache.org by "zhangxin3@ngarihealth.com" <zh...@ngarihealth.com> on 2020/10/28 08:33:01 UTC
Error: Table 'quartz.DATACONNECTOR' doesn't exist
when i submit
get the error
'''
2020-10-28 16:01:35.218 ERROR 872879 --- [http-nio-8080-exec-10] 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 => [12, {"database":"test","table.name":"hdfs_meta_data_sum1","where":""}, 1603872095196, null, , 1day, null, source1603869251654, HIVE, 1.2]
Query: InsertObjectQuery(DataConnector{name=source1603869251654type=HIVE, version='1.2', config={"database":"test","table.name":"hdfs_meta_data_sum1","where":""}})] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'quartz.DATACONNECTOR' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0_60]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar:5.1.47]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar:5.1.47]
'''
i can not find 'quartz.DATACONNECTOR ' in Init_quartz_mysql_innodb.sql
please help me.
姓 名：张 欣
邮 件：zhangxin3@ngarihealth.com
地 址：杭州市滨江区江南大道3688号潮人汇9楼
网 址：www.ngarihealth.com
Re: Error: Table 'quartz.DATACONNECTOR' doesn't exist
Posted by Kevin Yao <ah...@gmail.com>.
Hi Xin,
Can you tell us which version you're using? Can you provide more details?
Thanks,
Kevin
On Wed, Oct 28, 2020 at 10:36 PM William Guo <gu...@apache.org> wrote:
> I don't think we should have a dataconnector table for quartz?
> Could you share the full log?
>
>
>
> On Wed, Oct 28, 2020 at 10:26 PM zhangxin3@ngarihealth.com <
> zhangxin3@ngarihealth.com> wrote:
>
> > when i submit
> >
> >
> > get the error
> > '''
> > 2020-10-28 16:01:35.218 ERROR 872879 --- [http-nio-8080-exec-10]
> > 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 => [12, {"database":"test","table.name
> ":"hdfs_meta_data_sum1","where":""},
> > 1603872095196, null, , 1day, null, source1603869251654, HIVE, 1.2]
> > Query: InsertObjectQuery(DataConnector{name=source1603869251654type=HIVE,
> > version='1.2', config={"database":"test","table.name
> ":"hdfs_meta_data_sum1","where":""}})]
> > with root cause
> >
> > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> > 'quartz.DATACONNECTOR' doesn't exist
> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> > ~[?:1.8.0_60]
> > at
> >
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> > ~[?:1.8.0_60]
> > at
> >
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > ~[?:1.8.0_60]
> > at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
> > ~[?:1.8.0_60]
> > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> > at com.mysql.jdbc.Util.getInstance(Util.java:408)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
> > ~[mysql-connector-java-5.1.47.jar:5.1.47]
> >
> > '''
> > i can not find 'quartz.DATACONNECTOR ' in Init_quartz_mysql_innodb.sql
> > <
> https://github.com/apache/griffin/blob/master/service/src/main/resources/Init_quartz_mysql_innodb.sql
> >
> > please help me.
> > ------------------------------
> >
> > 姓 名：张 欣
> >
> > 邮 件：zhangxin3@ngarihealth.com
> >
> > 地 址：杭州市滨江区江南大道3688号潮人汇9楼
> >
> > 网 址：www.ngarihealth.com
> >
>
Re: Error: Table 'quartz.DATACONNECTOR' doesn't exist
Posted by William Guo <gu...@apache.org>.
I don't think we should have a dataconnector table for quartz?
Could you share the full log?
On Wed, Oct 28, 2020 at 10:26 PM zhangxin3@ngarihealth.com <
zhangxin3@ngarihealth.com> wrote:
> when i submit
>
>
> get the error
> '''
> 2020-10-28 16:01:35.218 ERROR 872879 --- [http-nio-8080-exec-10]
> 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 => [12, {"database":"test","table.name":"hdfs_meta_data_sum1","where":""},
> 1603872095196, null, , 1day, null, source1603869251654, HIVE, 1.2]
> Query: InsertObjectQuery(DataConnector{name=source1603869251654type=HIVE,
> version='1.2', config={"database":"test","table.name":"hdfs_meta_data_sum1","where":""}})]
> with root cause
>
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'quartz.DATACONNECTOR' doesn't exist
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[?:1.8.0_60]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> ~[?:1.8.0_60]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[?:1.8.0_60]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
> ~[?:1.8.0_60]
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
> at com.mysql.jdbc.Util.getInstance(Util.java:408)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
> ~[mysql-connector-java-5.1.47.jar:5.1.47]
>
> '''
> i can not find 'quartz.DATACONNECTOR ' in Init_quartz_mysql_innodb.sql
> <https://github.com/apache/griffin/blob/master/service/src/main/resources/Init_quartz_mysql_innodb.sql>
> please help me.
> ------------------------------
>
> 姓 名：张 欣
>
> 邮 件：zhangxin3@ngarihealth.com
>
> 地 址：杭州市滨江区江南大道3688号潮人汇9楼
>
> 网 址：www.ngarihealth.com
>