You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2017/09/22 21:37:01 UTC

[jira] [Commented] (AMBARI-15279) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4' doesn't exist

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

Shawn Weeks commented on AMBARI-15279:
--------------------------------------

And 2.5.2.0 as included in HDP 2.6.2. I'm also seeing a very similar error on the Pig View.

> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4' doesn't exist
> ----------------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-15279
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15279
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server, ambari-views
>    Affects Versions: 2.2.0
>            Reporter: DIPAYAN BHOWMICK
>            Assignee: DIPAYAN BHOWMICK
>             Fix For: 2.2.2
>
>         Attachments: AMBARI-15279.patch
>
>
> *PROBLEM:*
> Trying to run a query from Ambari Hive View generates "S020 Data storage error" in Ambari server log
> And the end of the stack trace is:
> {noformat}
> ...
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4' doesn't exist 
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) 
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) 
> at com.mysql.jdbc.Util.getInstance(Util.java:386) 
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) 
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) 
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) 
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) 
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) 
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834) 
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) 
> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313) 
> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) 
> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007) 
> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642) 
> ... 115 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)