You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Angad Singh (JIRA)" <ji...@apache.org> on 2015/06/10 08:37:00 UTC
[jira] [Created] (LENS-597) Lens server logs flooded with
SQLException
Angad Singh created LENS-597:
--------------------------------
Summary: 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
{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)