Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Insert after index creation crash #6781

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Insert after index creation crash #6781

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2019-11-04 09:25:16 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development

Last updated: 2020-01-02 18:04:04 +0100

Comment 27387

Date: 2019-11-04 09:25:16 +0100
From: @PedroTadim

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

This bug comes from a user into users-list, create a table, then two indexes on column, then an insert, causes the server to crash.

Reproducible: Always

Steps to Reproduce:

  1. Create table a(a int, b int, id bigserial);
  2. Create ordered index a_pk on a(id);
  3. Create index a_idx1 on a(a);
  4. Insert into a(a) values(1);

Actual Results:

SIGSEV

Expected Results:

Successful insert.

Comment 27388

Date: 2019-11-04 09:28:40 +0100
From: MonetDB Mercurial Repository <>

Changeset 6fc5137b678d made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=6fc5137b678d

Changeset description:

Added test for bug #6781

Comment 27392

Date: 2019-11-05 17:00:01 +0100
From: MonetDB Mercurial Repository <>

Changeset cd153742f6d4 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=cd153742f6d4

Changeset description:

Added fix for bug #6781, ie, don't attempt to insert/update on indexes without delta structures

Comment 27505

Date: 2020-01-02 18:04:04 +0100
From: MonetDB Mercurial Repository <>

Changeset 5a1607486f7c made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=5a1607486f7c

Changeset description:

Extend index-insert-crash.Bug-6781 test also with imprints index, which also has no delta structure.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant