[
https://issues.apache.org/jira/browse/LENS-597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Puneet Gupta updated LENS-597:
------------------------------
Fix Version/s: (was: 2.6)
> Lens server logs flooded with SQLException
> ------------------------------------------
>
> Key: LENS-597
> URL: https://issues.apache.org/jira/browse/LENS-597
> Project: Apache Lens
> Issue Type: Bug
> Components: server
> 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)
