RisingWave Community - How to cancel a job causing OOMKill error in a cluster?

RisingWave Community

risingwave-community.slack.com

troubleshooting

How to cancel a job causing OOMKill error in a cluster?

André Falk is experiencing OOMKill error caused by trying to create a materialized view. The 'cancel jobs' command does not work. Is there any other way to cancel the job?

André Falk

Asked on Nov 29, 2023

Check metrics in Grafana to monitor cluster performance.
Set system parameter by psql: ALTER SYSTEM SET pause_on_next_bootstrap to true
Restart the meta node.
Drop the relevant materialized views.
Restart the meta node again to resume.

Nov 30, 2023Edited by