You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Rajat Khandelwal (JIRA)" <ji...@apache.org> on 2015/02/12 13:00:18 UTC
[jira] [Assigned] (LENS-309) Exception while purging query :
integrity constraint violation, unique constraint or index violation
[ 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)