apex-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (APEXMALHAR-2382) User should not be required to create "dt_meta" table while using JdbcPOJOInsertOutputOperator
Date Tue, 10 Jan 2017 09:14:58 GMT

    [ https://issues.apache.org/jira/browse/APEXMALHAR-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15814423#comment-15814423
] 

ASF GitHub Bot commented on APEXMALHAR-2382:
--------------------------------------------

GitHub user Hitesh-Scorpio opened a pull request:

    https://github.com/apache/apex-malhar/pull/532

    APEXMALHAR-2382 code changes to create meta table

    @DT-Priyanka please review,

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/Hitesh-Scorpio/apex-malhar APEXMALHAR-2382_new_auto_create_meta_table

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/apex-malhar/pull/532.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #532
    
----
commit c1b53d90095c0bde2dc82fb344de36449dce3f61
Author: Hitesh-Scorpio <forhiteshjob@gmail.com>
Date:   2017-01-10T09:13:00Z

    APEXMALHAR-2382 code changes to create meta table

----


> User should not be required to create "dt_meta" table while using JdbcPOJOInsertOutputOperator
> ----------------------------------------------------------------------------------------------
>
>                 Key: APEXMALHAR-2382
>                 URL: https://issues.apache.org/jira/browse/APEXMALHAR-2382
>             Project: Apache Apex Malhar
>          Issue Type: Bug
>            Reporter: Hitesh Kapoor
>            Assignee: Hitesh Kapoor
>
> f the "dt_meta" does not exist in the database, error is thrown as:
> {code}
> 2016-10-28 06:33:22,327 ERROR com.datatorrent.stram.engine.StreamingContainer: Abandoning
deployment of operator OperatorDeployInfo[id=3,name=JdbcOutput,type=GENERIC,checkpoint={ffffffffffffffff,
0, 0},inputs=[OperatorDeployInfo.InputDeployInfo[portName=input,streamId=From Table to Table,sourceNodeId=1,sourcePortName=outputPort,locality=<null>,partitionMask=0,partitionKeys=<null>]],outputs=[]]
due to setup failure.
> java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'tmp.dt_meta' doesn't exist
> 	at com.datatorrent.lib.db.jdbc.JdbcTransactionalStore.getCommittedWindowIdHelper(JdbcTransactionalStore.java:240)
> 	at com.datatorrent.lib.db.jdbc.JdbcTransactionalStore.getCommittedWindowId(JdbcTransactionalStore.java:196)
> 	at com.datatorrent.lib.db.AbstractTransactionableStoreOutputOperator.setup(AbstractTransactionableStoreOutputOperator.java:97)
> 	at com.datatorrent.lib.db.jdbc.AbstractJdbcTransactionableOutputOperator.setup(AbstractJdbcTransactionableOutputOperator.java:95)
> 	at com.datatorrent.lib.db.jdbc.JdbcPOJOInsertOutputOperator.setup(JdbcPOJOInsertOutputOperator.java:60)
> 	at com.datatorrent.lib.db.jdbc.JdbcPOJOInsertOutputOperator.setup(JdbcPOJOInsertOutputOperator.java:48)
> 	at com.datatorrent.stram.engine.Node.setup(Node.java:188)
> 	at com.datatorrent.stram.engine.StreamingContainer.setupNode(StreamingContainer.java:1317)
> 	at com.datatorrent.stram.engine.StreamingContainer.access$100(StreamingContainer.java:129)
> 	at com.datatorrent.stram.engine.StreamingContainer$2.run(StreamingContainer.java:1396)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'tmp.dt_meta'
doesn't exist
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> 	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
> 	at com.mysql.jdbc.Util.getInstance(Util.java:378)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
> 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3361)
> 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3295)
> 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1852)
> 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1975)
> 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2476)
> 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1404)
> 	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1546)
> 	at com.datatorrent.lib.db.jdbc.JdbcTransactionalStore.getCommittedWindowIdHelper(JdbcTransactionalStore.java:229)
> 	... 9 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message