I have a benchmark which begins by creating a table if it doesn’t exist and then truncates it. After some number of runs truncate ended up hanging. So used cockroach sql to drop the table manually. Now the database seems to be in an inconsistent state:
root@:24442/yabf> CREATE TABLE object (type STRING, id STRING, st_apply_metadata BYTES, value BYTES, PRIMARY KEY(type, id));
pq: relation "object" already exists
root@:24442/yabf> SHOW TABLES;
+-------+
| Table |
+-------+
+-------+
(0 rows)
root@:24442/> drop database yabf;
pq: table "object" is being dropped
Curious if anyone has thoughts on what might be the root cause or links to the best way to debug issues like this.