Environment

• YugabyteDB - All Versions

Issue

• A customer cancelled the DROP DATABASE query as it was running longer. As a result they were unable to create the same database. The following were the errors reported:

yugabyte=# create database test;
ERROR:  Already present: Keyspace 'test' already exists
yugabyte=# drop database test;
ERROR:  database "test" does not exist

Resolution

Overview

• When the initial  DROP DATABASE query was cancelled, it removed entries from the PostgreSQL catalog but not from the DocDB catalog.

Steps

1. Delete the database from the DocDB catalog using the below command

yb-admin --master_addresses $yb-masters delete_namespace ysql.test

      2. Create the database

yugabyte=# create database test;