DROP INDEX crashes server with BATsubselect: invalid argument: b must have a dense head

[monetdb-team]

Date: 2014-02-21 13:48:04 +0100
From: @hannesmuehleisen
To: SQL devs <>
Version: 11.17.9 (Jan2014)
CC: ajdamico

Last updated: 2014-03-11 09:19:36 +0100

Comment 19629

Date: 2014-02-21 13:48:04 +0100
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.112 Safari/537.36
Build Identifier:

Dropping an index from a table crashes the server.

Reproducible: Always

Steps to Reproduce:

1. Create a fairly large table (confirmed with ~200000 entries) with a single integer column
2. Create an index on the table
3. Drop the index again

Actual Results:

!FATAL: 40000!COMMIT: transation commit failed (perhaps your disk is full?) exiting (kernel error: !ERROR: BATsubselect: invalid argument: b must have a dense head.

Expected Results:

No crash and index is gone.

Comment 19630

Date: 2014-02-21 13:48:46 +0100
From: @hannesmuehleisen

Created attachment 267
SQL script that provokes the issue

Attached file: crash.sql.bz2 (application/x-bzip, 359611 bytes)
Description: SQL script that provokes the issue

Comment 19631

Date: 2014-02-21 14:17:21 +0100
From: @sjoerdmullender

The logger uses BUNdelete. We can't have that in "headless" code.

Comment 19633

Date: 2014-02-21 16:21:58 +0100
From: MonetDB Mercurial Repository <>

Changeset ef0df6f6f964 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=ef0df6f6f964

Changeset description:

Revert back to using legacy functions in log_tend.
This fixes bug #3443.

Comment 19634

Date: 2014-02-21 17:06:11 +0100
From: @sjoerdmullender

Fixed, but we still need a test.

Comment 19696

Date: 2014-03-11 09:19:36 +0100
From: @sjoerdmullender

Jan2014-SP1 has been released.