原 GreenPlum报错ERROR: Canceling query because of high VMEM usage.
现象
查询报错:ERROR: Canceling query because of high VMEM usage.
ERROR: Canceling query because of high VMEM usage. Used: 16368MB, available 1900MB, red zone: 17110MB (runaway_cleaner.c:202) (seg14 slice2 192.100.26.106:6002 pid=899) (runaway_cleaner.c:202) CONTEXT: SQL statement "refresh materialized view mv_ygz with data" PL/pgSQL function refresh_mv_ygz() line 3 at SQL statement
可能原因
1、在会话级别配置optimizer为off。若数据量很小,但查询SQL复杂,若启用optimizer,则往往会报这个错,所以,此时可以在SQL级别禁用该参数。
1 2 3 4 | set optimizer=off; -- 若是物化视图报错,则可以手动刷新1次物化视图 select refresh_mv_ygz(); |