HAWQ runaway detector cancels all queries when set runaway_detector_activation_percent 100

[Stanley Sung]

after set runaway_detector_activation_percent to 100 (disable runaway
detector), all queries are cancelled.

Note that query used 64MB, available 81856MB and red zone is "-16MB".

red zone calculation bug?



ERROR:  Canceling query because of high VMEM usage. Used: 64MB, available
81856MB, red zone: -16MB (runaway_cleaner.c:152)  (seg9
sclmsdn02apd-hdp.sdc.vzwcorp.com:40000 pid=646507) (dispatcher.c:1801)
CONTEXT:  SQL statement "
                                             create table bp_full.nodes as
                                             select i
                                             from (
                                             select i from bp_full.g
                                                            union all
                                             select j as i from bp_full.g
                                             ) foo
                                             group by 1
                                             distributed by (i);


-- 
Regards,
--
Stanley Sung | Pivotal Data Engineering
+1-443-515-0205
http://www.pivotal.io
http://bcert.me/sfqygvsl