hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Sung <ys...@pivotal.io>
Subject HAWQ runaway detector cancels all queries when set runaway_detector_activation_percent 100
Date Wed, 08 Mar 2017 04:40:25 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message