[
https://issues.apache.org/jira/browse/LENS-309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajat Khandelwal reassigned LENS-309:
-------------------------------------
Assignee: Rajat Khandelwal
> 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
> Assignee: Rajat Khandelwal
>
> {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)
