[LENS-783] QueryPurger purging queries twice on hive server restart.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.4
• Assignee: Rajat Khandelwal
• Reporter: Rajat Khandelwal
• Created: 21/Sep/15 12:19
• Updated: 12/Feb/16 08:55
• Resolved: 28/Sep/15 12:03

Description

logs:

21 Sep 2015 11:32:07 [d226e92b-86dc-4bab-8581-839551f1b42b] [QueryPurger] WARN  org.apache.lens.server.query.QueryExecutionServiceImpl - Exception while purging query
java.sql.SQLException: Found different value pre-existing in DB while trying to insert finished query. Old = FinishedLensQuery(handle=d226e92b-86dc-4bab-8581-839551f1b42b, userQuery=some_user_query, submitter=user.name, submissionTime=1442820769519, startTime=1442820785396, endTime=1442821435109, result=null, status=FAILED, metadata=null, rows=null, fileSize=null, errorMessage=Error getting query status, driverStartTime=1442820769586, driverEndTime=0, metadataClass=null, queryName=week 38 invalid clicks dod, selectedDriver=null)
New = FinishedLensQuery(handle=d226e92b-86dc-4bab-8581-839551f1b42b, userQuery=some_user_query, submitter=user.name, submissionTime=1442820769519, startTime=1442820785396, endTime=1442821435109, result=null, status=FAILED, metadata=null, rows=null, fileSize=null, errorMessage=Error getting query status, driverStartTime=1442820769586, driverEndTime=0, metadataClass=null, queryName=week 38 invalid clicks dod, selectedDriver=org.apache.lens.driver.hive.HiveDriver@344e4f01)
        at org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:133) ~[classes/:na]