You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Arshad Matin (JIRA)" <ji...@apache.org> on 2015/02/12 12:30:11 UTC
[jira] [Created] (LENS-309) Exception while purging query :
integrity constraint violation, unique constraint or index violation
Arshad Matin created LENS-309:
---------------------------------
Summary: Exception while purging query : integrity constraint violation, unique constraint or index violation
Key: LENS-309
URL: https://issues.apache.org/jira/browse/LENS-309
Project: Apache Lens
Issue Type: Bug
Reporter: Arshad Matin
{noformat}
11 Feb 2015 10:07:28,755 [QueryPurger] WARN org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
java.lang.Exception: java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_CT_10068 table: FINISHED_QUERIES Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [7ceb47c8-711a-4ff2-9768-aa7b589c244c, CREATE TEMPORARY FUNCTION sleep AS 'hive.udf.SampleUdf', test, 1423648952200, 1423649193356, null, SUCCESSFUL, null, 0, null, 1423648952187, 1423648952207, null, , 1423648947496]
at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:132)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:768)
at java.lang.Thread.run(Thread.java:701)
Caused by: java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_CT_10068 table: FINISHED_QUERIES Query: insert into finished_queries (handle, userquery,submitter,starttime,endtime,result,status,metadata,rows,errormessage,driverstarttime,driverendtime, metadataclass, queryname, submissiontime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: [7ceb47c8-711a-4ff2-9768-aa7b589c244c, CREATE TEMPORARY FUNCTION sleep AS 'hive.udf.SampleUdf', test, 1423648952200, 1423649193356, null, SUCCESSFUL, null, 0, null, 1423648952187, 1423648952207, null, , 1423648947496]
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:127)
... 2 more
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)