Tao, Seems the issue is not with new query having same handle. But the other values seem to differ - esp. driverEndTime.
Couple of options for you not to see the exception any more : 1. Clear lens server persist state and restart. or 2. Remove the entry from DB corresponding to the problematic query handle. Can you raise a bug with the above exception to get it fixed properly? Thanks Amareshwari On Wed, Aug 3, 2016 at 9:42 AM, Tao Yan <t...@linkedin.com> wrote: > Hi Lens Developers, > > I run the example queries in the '20 minutes demo' page for several times, > and a query failed many time before it succeeded: > > lens-shell>query execute cube select product_id, store_sales from sales > where time_range_in(order_time, '2015-04-11-00', '2015-04-13-00') > > Then, I found the Lens server keeps printing the following error log: > 03 Aug 2016 03:59:04 [b9bd9e01-d2e9-448e-9045-d329fb86be34] [QueryPurger] > WARN org.apache.lens.server.query.LensServerDAO - Re insert happening in > purge: [Ljava.lang.StackTraceElement;@354862c > 03 Aug 2016 03:59:04 [b9bd9e01-d2e9-448e-9045-d329fb86be34] [QueryPurger] > WARN *org.apache.lens.server.query.QueryExecutionServiceImpl - Exception > while purging query 27be8f4d-9d9a-43da-9c10-710ef0734ab3* > java.sql.SQLException: Found different value pre-existing in DB while > trying to insert finished query.* Old =* FinishedLensQuery( > *handle=27be8f4d-9d9a-43da-9c10-710ef0734ab3*, userQuery=cube select > product_id, store_sales from sales where time_range_in(order_time, > '2015-04-11-00', '2015-04-13-00'), submitter=anonymous, > submissionTime=1470184239496, startTime=1470184243802, > endTime=1470184289999, result=null, status=FAILED, metadata=null, > rows=null, fileSize=null, errorMessage=Stage-0(MOVE):Stage-0: has failed! , > driverStartTime=1470184239666, driverEndTime=1470184289989, queryName=, > driverName=hive/hive1, selectedDriver=null) > *New =* FinishedLensQuery(*handle=27be8f4d-9d9a-43da-9c10-710ef0734ab3*, > userQuery=cube select product_id, store_sales from sales where > time_range_in(order_time, '2015-04-11-00', '2015-04-13-00'), > submitter=anonymous, submissionTime=1470184239496, startTime=1470184243802, > endTime=1470184608172, result=null, status=FAILED, metadata=null, > rows=null, fileSize=null, errorMessage=Error getting query status, > driverStartTime=1470184239666, driverEndTime=0, queryName=, > driverName=hive/hive1, selectedDriver=hive/hive1) > at > org.apache.lens.server.query.LensServerDAO.insertFinishedQuery(LensServerDAO.java:133) > ~[classes/:na] > at > org.apache.lens.server.query.QueryExecutionServiceImpl$QueryPurger.run(QueryExecutionServiceImpl.java:1007) > ~[classes/:na] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31] > > > It looks that the new query has the same handle as the old query. So, Lens > servers complains about it. It seems other queries are not impacted, but > this Warning messages are really annoying and impacting regular logs. > > Thanks, > -- > > *Tao Yan* > Software Engineer > Data Analytics Infrastructure Tools and Services > > > > 206.250.5345 > t...@linkedin.com > https://www.linkedin.com/in/taousc >