Problems with creation and deletion

Hi

I have a test that creates a database and create some tables.

First bug or wierd thing i got was:

DROP DATABASE test;
pq: invalid foreign key: missing table=64 index=1: descriptor not found

I created multiple table on test start and removed them afterwards (Not removing the database). I did this multiple time to try out my schema. And after a while I can remove the database (one specific table). When i look in the UI and look at the table schema it’s just empty. Like it was removed but not correctly.

when i try to remove the faulty table I also get:

DROP table issues;
pq: invalid foreign key: missing table=64 index=1: descriptor not found

So then I started to create a new database with tables at the beginning of the test and then remove the database.

This led to:

root@:26257/> set database=aam_test;
SET
root@:26257/aam_test> show tables;
pq: no database with ID 183 found
I use the same Database name when I create a new.

Everything worked in the beginning fine. But after a while it started to get wierd.

I use

Build Tag: v1.0-rc.2
Build Time: 2017/05/05 13:55:11
Distribution: CCL
Platform: linux amd64
Go Version: go1.8.1
C Compiler: gcc 6.3.0
Build SHA-1: 1700211837c3e519bf093f8cda26fe2afb028ff3
Build Type: release

created issue https://github.com/cockroachdb/cockroach/issues/15786 to track this.