[jira] [Commented] (EAGLE-1030) Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC

2017-06-06 Thread Alexandre (JIRA) 

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

Alexandre commented on EAGLE-1030:
--

It's maybe not the best way to fix this issue but It seems that it works.
There is no more "Unknown column" in the logs.

> Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC
> ---
>
> Key: EAGLE-1030
> URL: https://issues.apache.org/jira/browse/EAGLE-1030
> Project: Eagle
>  Issue Type: Bug
>Affects Versions: v0.5.0
> Environment: Cent 0S 6.8
> MySQL Community Server (GPL) 5.7.18
> x86_64 for linux
> eagle 0.5
> hadoop 2.6.4
>Reporter: Alexandre
>
> Hi,
> I'm using JDBC for apache eagle and i have this exception in 
> "log/eagle-server.log": 
> ERROR [2017-06-02 08:02:45,403] org.apache.eagle.storage.jdbc.JdbcStorage: 
> Failed to query by: SELECT max(eaglejpa_process_process.currentTimeStamp), 
> eaglejpa_process_process.site FROM eaglejpa_process_process WHERE 
> (eaglejpa_process_process.timestamp>=? AND 
> eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
> ~[na:1.8.0_31]
> ! at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>  ~[na:1.8.0_31]
> ! at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>  ~[na:1.8.0_31]
> ! at java.lang.reflect.Constructor.newInstance(Constructor.java:408) 
> ~[na:1.8.0_31]
> ! at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.Util.getInstance(Util.java:360) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1535) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! ... 61 common frames omitted
> ! Causing: org.apache.torque.TorqueException: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at 
> org.apache.torque.util.ExceptionMapperImpl.toTorqueException(ExceptionMapperImpl.java:59)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1608) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1152) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:75)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! ... 59 common frames omitted
> ! Causing: java.io.IOException: Failed to query by: SELECT 
> max(eaglejpa_process_process.currentTimeStamp), eaglejpa_process_process.site 
> FROM eaglejpa_process_process WHERE (eaglejpa_process_process.timestamp>=? 
> AND eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:82)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:161) 
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at 
> org.apache.eagle.storage.operation.QueryStatement.execute(QueryStat

[jira] [Commented] (EAGLE-1030) Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC

2017-06-03 Thread Jayesh (JIRA) 

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

Jayesh commented on EAGLE-1030:
---

[~r7raul], is adding site in table eaglejpa_process_process, the right way to 
fix this issue ?

> Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC
> ---
>
> Key: EAGLE-1030
> URL: https://issues.apache.org/jira/browse/EAGLE-1030
> Project: Eagle
>  Issue Type: Bug
>Affects Versions: v0.5.0
> Environment: Cent 0S 6.8
> MySQL Community Server (GPL) 5.7.18
> x86_64 for linux
> eagle 0.5
> hadoop 2.6.4
>Reporter: Alexandre
>
> Hi,
> I'm using JDBC for apache eagle and i have this exception in 
> "log/eagle-server.log": 
> ERROR [2017-06-02 08:02:45,403] org.apache.eagle.storage.jdbc.JdbcStorage: 
> Failed to query by: SELECT max(eaglejpa_process_process.currentTimeStamp), 
> eaglejpa_process_process.site FROM eaglejpa_process_process WHERE 
> (eaglejpa_process_process.timestamp>=? AND 
> eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
> ~[na:1.8.0_31]
> ! at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>  ~[na:1.8.0_31]
> ! at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>  ~[na:1.8.0_31]
> ! at java.lang.reflect.Constructor.newInstance(Constructor.java:408) 
> ~[na:1.8.0_31]
> ! at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.Util.getInstance(Util.java:360) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1535) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! ... 61 common frames omitted
> ! Causing: org.apache.torque.TorqueException: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at 
> org.apache.torque.util.ExceptionMapperImpl.toTorqueException(ExceptionMapperImpl.java:59)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1608) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1152) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:75)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! ... 59 common frames omitted
> ! Causing: java.io.IOException: Failed to query by: SELECT 
> max(eaglejpa_process_process.currentTimeStamp), eaglejpa_process_process.site 
> FROM eaglejpa_process_process WHERE (eaglejpa_process_process.timestamp>=? 
> AND eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:82)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:161) 
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at 
> org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47)
>  [eagle-topolo

[jira] [Commented] (EAGLE-1030) Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC

2017-06-02 Thread JiJun Tang (JIRA) 

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

JiJun Tang commented on EAGLE-1030:
---

As a workaround, you can add column site in table eaglejpa_process_process.

> Unknown column 'eaglejpa_process_process.site' in 'field list' - using JDBC
> ---
>
> Key: EAGLE-1030
> URL: https://issues.apache.org/jira/browse/EAGLE-1030
> Project: Eagle
>  Issue Type: Bug
>Affects Versions: v0.5.0
> Environment: Cent 0S 6.8
> MySQL Community Server (GPL) 5.7.18
> x86_64 for linux
> eagle 0.5
> hadoop 2.6.4
>Reporter: Alexandre
>
> Hi,
> I'm using JDBC for apache eagle and i have this exception in 
> "log/eagle-server.log": 
> ERROR [2017-06-02 08:02:45,403] org.apache.eagle.storage.jdbc.JdbcStorage: 
> Failed to query by: SELECT max(eaglejpa_process_process.currentTimeStamp), 
> eaglejpa_process_process.site FROM eaglejpa_process_process WHERE 
> (eaglejpa_process_process.timestamp>=? AND 
> eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
> ~[na:1.8.0_31]
> ! at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>  ~[na:1.8.0_31]
> ! at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>  ~[na:1.8.0_31]
> ! at java.lang.reflect.Constructor.newInstance(Constructor.java:408) 
> ~[na:1.8.0_31]
> ! at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.Util.getInstance(Util.java:360) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1535) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! ... 61 common frames omitted
> ! Causing: org.apache.torque.TorqueException: 
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
> 'eaglejpa_process_process.site' in 'field list'
> ! at 
> org.apache.torque.util.ExceptionMapperImpl.toTorqueException(ExceptionMapperImpl.java:59)
>  ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1608) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at org.apache.torque.util.BasePeerImpl.doSelect(BasePeerImpl.java:1152) 
> ~[eagle-topology-0.5.0-SNAPSHOT-assembly.jar:na]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:75)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! ... 59 common frames omitted
> ! Causing: java.io.IOException: Failed to query by: SELECT 
> max(eaglejpa_process_process.currentTimeStamp), eaglejpa_process_process.site 
> FROM eaglejpa_process_process WHERE (eaglejpa_process_process.timestamp>=? 
> AND eaglejpa_process_process.timestamp GROUP BY eaglejpa_process_process.site LIMIT 10 Replacements: 
> [1493798565000,1496390565000,site1]
> ! at 
> org.apache.eagle.storage.jdbc.entity.impl.JdbcEntityReaderImpl.query(JdbcEntityReaderImpl.java:82)
>  ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at org.apache.eagle.storage.jdbc.JdbcStorage.query(JdbcStorage.java:161) 
> ~[eagle-storage-jdbc-0.5.0-SNAPSHOT.jar:0.5.0-SNAPSHOT]
> ! at 
> org.apache.eagle.storage.operation.QueryStatement.execute(QueryStatement.java:47)
>  [eagle-topology-0.5.0-SNA