citusdata / citusdata/citus

Cannot drop a database with a maintenance daemon without the citus extension

Open
#1,717 3 comments 3 reactions 0 assignees View on GitHub
bug warm-up
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

If another database has a maintenance daemon, it can only dropped from a database with the Citus extension.

```
$ psql template1 -c "CREATE DATABASE foo"
$ psql foo -c "CREATE EXTENSION citus"
$ psql template1 -c "DROP DATABASE foo"
ERROR: database "foo" is being accessed by other users
DETAIL: There is 1 other session using the database.
```

The reason is that the `StopMaintenanceDaemon` function is only called from the utility hook if the Citus extension exists: https://github.com/citusdata/citus/blob/master/src/backend/distributed/executor/multi_utility.c#L464

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.