[ASTERIXDB-1110] Cannot drop a dataverse when there was an exception regarding an index operation

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: *DB - AsterixDB, TX - Transactions
• Assignee: Ildar Absalyamov
• Reporter: Taewoo Kim
• Created: 24/Sep/15 00:32
• Updated: 05/Dec/15 02:41
• Resolved: 20/Nov/15 01:02

Description

Cannot drop a dataverse after an exception is thrown from an index.

#1. Copy and paste the following code in the web interface. Execute the code. It will throw an exception at this moment.
drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type FooType as open {
a: int64
}

create dataset OpenFoo(FooType) primary key a;

create index btree_idx on OpenFoo(b:double) type btree enforced;

insert into dataset test.OpenFoo (

{"a":7, "b":3.14}

);

for $o in dataset OpenFoo return $o;

delete $o from dataset OpenFoo where $o.a = 7;

for $o in dataset OpenFoo return $o;

insert into dataset OpenFoo (

{"a":7, "b":3.14}

);

#2. Now, try to delete the dataverse by issuing the following command. It will throw this exception - Cannot remove index while it is open. [HyracksDataException]

drop dataverse test;

Issue Links

• is broken by: ASTERIXDB-1109 Index entries are not deleted on an open-type secondary index