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)
