Closed
Description
Describe the bug
After completion of the longevity test, we issued the drop materialized view command, which got stuck for more then 20 minutes and counting.
╰─> psql "postgres://dev:dev@rls-apse1-eks-a.risingwave-cloud.xyz:4566/dev?options=--tenant%3Drwc-3-longevity-20221128-044939"
dev=> \dm;
List of relations
Schema | Name | Type | Owner
--------+-------------+-------------------+-------
public | nexmark_q1 | materialized view | dev
public | nexmark_q10 | materialized view | dev
public | nexmark_q14 | materialized view | dev
public | nexmark_q2 | materialized view | dev
public | nexmark_q3 | materialized view | dev
(5 rows)
dev=> drop materialized view nexmark_q1;
job link: https://buildkite.com/risingwave-test/longevity-test/builds/179
To Reproduce
- run the longevity build
- After completion try to delete materialized view.
Expected behavior
Drop materialized view should be completed in a few seconds.
Additional context
you can use same setup for debugging.
psql "postgres://dev:dev@rls-apse1-eks-a.risingwave-cloud.xyz:4566/dev?options=--tenant%3Drwc-3-longevity-20221128-044939"