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
