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

server crashed could not find ordered index while creating a table #6574

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

server crashed could not find ordered index while creating a table #6574

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

Comments

@monetdb-team
Copy link

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

Date: 2018-04-11 00:53:41 +0200
From: Anton Kravchenko <<kravchenko.anton86>>
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @njnes

Last updated: 2018-06-20 11:02:08 +0200

Comment 26355

Date: 2018-04-11 00:53:41 +0200
From: Anton Kravchenko <<kravchenko.anton86>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
Build Identifier:

crash when creating a table from query with ordered index

Reproducible: Always

Steps to Reproduce:

create table t1(v0 int, v1 char(1));
insert into t1 values (1,'a'),(2,'b'),(3,'c');
create ordered index index_t1_v1 on t1(v1);

create table t2(v1 char(1));
insert into t2 values ('a');

create temp table t3 as
(select t1.v0 from t1
where
exists(select * from t2 where t2.v1=t1.v1))
with data on commit preserve rows;

Actual Results:

2018-04-10 15:38:49 ERR db1[31908]: could not find t1.%index_t1_v1
2018-04-10 15:38:49 ERR db1[31908]: t1.v0
2018-04-10 15:38:49 ERR db1[31908]: t1.v1
2018-04-10 15:38:49 ERR db1[31908]: t1.%TID%
2018-04-10 15:38:49 ERR db1[31908]: t1.v0
2018-04-10 15:38:49 ERR db1[31908]: t1.v1
2018-04-10 15:38:49 ERR db1[31908]: t1.%TID%
2018-04-10 15:38:49 ERR db1[31908]: mserver5: /home/akravchenko/MonetDB-Mar2018/MonetDB-11.29.3/sql/backends/monet5/rel_bin.c:576: exp_bin: Assertion `s' failed.
2018-04-10 15:38:52 MSG merovingian[26313]: database 'db1' (31908) has crashed (dumped core)

Expected Results:

It works as expected when no table is created:
select t1.v0 from t1
where
exists(select * from t2 where t2.v1=t1.v1);

MonetDB 5 server v11.29.3 "Mar2018" (64-bit, 128-bit integers)
Copyright (c) 1993 - July 2008 CWI
Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Found 31.3GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.32 2012-11-30 (compiled with 8.32)
openssl: OpenSSL 1.0.2k 26 Jan 2017 (compiled with OpenSSL 1.0.2l 25 May 2017)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: akravchenko@cent7-1 (x86_64-pc-linux-gnu)
Compilation: gcc -std=gnu99 -g
Linking : /usr/bin/ld -m elf_x86_64 -Wl,-Bsymbolic-functions

Comment 26358

Date: 2018-04-11 16:20:15 +0200
From: MonetDB Mercurial Repository <>

Changeset 885e050fdec6 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

fixes for bugs 6572, 6573 and 6574
also fix select -2*50 cast problem, fix type of function in rewriter.

6572/6574 fixed in dead code optimizer

6573 fixed problem in 'IN' handling with constants

Comment 26363

Date: 2018-04-12 10:12:55 +0200
From: MonetDB Mercurial Repository <>

Changeset 780897b729df 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=780897b729df

Changeset description:

Added tests for bugs 6574 and 6576
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