You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Rajat Khandelwal (JIRA)" <ji...@apache.org> on 2015/07/24 12:42:05 UTC
[jira] [Updated] (LENS-597) Lens server logs flooded with
SQLException
[ https://issues.apache.org/jira/browse/LENS-597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajat Khandelwal updated LENS-597:
----------------------------------
Fix Version/s: 2.3
> Lens server logs flooded with SQLException
> ------------------------------------------
>
> Key: LENS-597
> URL: https://issues.apache.org/jira/browse/LENS-597
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Angad Singh
> Assignee: Rajat Khandelwal
> Fix For: 2.3
>
>
> {noformat}
> 10 Jun 2015 06:40:47,016 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
> java.sql.SQLException: Table 'lens.finished_queries' doesn't exist Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [f9fa2af5-d8d4-4aef-b106-718f444cb914, cube select apps_owned from user j where source = 'raf', anonymous, 0, 1433134606782, null, FAILED, null, 0, Driver :org.apache.lens.driver.hive.HiveDriver Cause :Could not find the table containing column: source, 0, 0, null, , 1433134605618]
> at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
> at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:787)
> at java.lang.Thread.run(Thread.java:745)
> 10 Jun 2015 06:40:47,017 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
> java.sql.SQLException: Table 'lens.finished_queries' doesn't exist Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [f9fa2af5-d8d4-4aef-b106-718f444cb914, cube select apps_owned from user j where source = 'raf', anonymous, 0, 1433134606782, null, FAILED, null, 0, Driver :org.apache.lens.driver.hive.HiveDriver Cause :Could not find the table containing column: source, 0, 0, null, , 1433134605618]
> at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
> at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:787)
> at java.lang.Thread.run(Thread.java:745)
> 10 Jun 2015 06:40:47,018 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
> java.sql.SQLException: Table 'lens.finished_queries' doesn't exist Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [f9fa2af5-d8d4-4aef-b106-718f444cb914, cube select apps_owned from user j where source = 'raf', anonymous, 0, 1433134606782, null, FAILED, null, 0, Driver :org.apache.lens.driver.hive.HiveDriver Cause :Could not find the table containing column: source, 0, 0, null, , 1433134605618]
> at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
> at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:787)
> at java.lang.Thread.run(Thread.java:745)
> 10 Jun 2015 06:40:47,018 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
> java.sql.SQLException: Table 'lens.finished_queries' doesn't exist Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [f9fa2af5-d8d4-4aef-b106-718f444cb914, cube select apps_owned from user j where source = 'raf', anonymous, 0, 1433134606782, null, FAILED, null, 0, Driver :org.apache.lens.driver.hive.HiveDriver Cause :Could not find the table containing column: source, 0, 0, null, , 1433134605618]
> at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
> at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:787)
> at java.lang.Thread.run(Thread.java:745)
> 10 Jun 2015 06:40:47,019 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
> java.sql.SQLException: Table 'lens.finished_queries' doesn't exist Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [f9fa2af5-d8d4-4aef-b106-718f444cb914, cube select apps_owned from user j where source = 'raf', anonymous, 0, 1433134606782, null, FAILED, null, 0, Driver :org.apache.lens.driver.hive.HiveDriver Cause :Could not find the table containing column: source, 0, 0, null, , 1433134605618]
> at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
> at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:456)
> at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:126)
> at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:787)
> at java.lang.Thread.run(Thread.java:745)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)