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 crash when trying to delete a table has been added to a merge table with "cascade" at the end #4044

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

Comments

@monetdb-team
Copy link

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

Date: 2016-07-29 23:44:53 +0200
From: desparanto
To: SQL devs <>
Version: 11.23.7 (Jun2016-SP1)
CC: @njnes

Last updated: 2016-10-13 10:03:41 +0200

Comment 22267

Date: 2016-07-29 23:44:53 +0200
From: desparanto

User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0.1 Waterfox/47.0.1
Build Identifier:

when I do the following set of statements the server window closes and the client exits.
sql>create table joe1 (id int);
operation successful (72.127ms)

sql>create table joe2 (id int);
operation successful (57.130ms)

sql>create merge table joe3 (id int);
operation successful (93.939ms)

sql>alter table joe3 add table joe1;
operation successful (51.210ms)

sql>alter table joe3 add table joe2;
operation successful (41.280ms)

sql>drop table joe1 cascade;

Connection terminated during read line
Press any key to continue . . .

Reproducible: Always

Steps to Reproduce:

create table joe1 (id int);

create table joe2 (id int);

create merge table joe3 (id int);

alter table joe3 add table joe1;

alter table joe3 add table joe2;

drop table joe1 cascade;

Actual Results:

server window closes and client exits with:

Connection terminated during read line
Press any key to continue . . .

Expected Results:

some error maybe that says dropping a table that is part of a merge table is bad - or maybe give an option to drop the table and not the merge table.

MonetDB 5 server v11.23.3 "Jun2016" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 9.9GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.37 2015-04-28
openssl: OpenSSL 1.0.2d 9 Jul 2015
libxml2: 2.9.2
Compiled by: monet@LAB03 (x86_64-pc-winnt)
Compilation: cl -GF -W3 -WX -MD -nologo -Ox -Zi -Oi
Linking : cl -GF -W3 -WX -MD -nologo -Ox -Zi -Oi

Comment 22291

Date: 2016-08-11 18:39:27 +0200
From: @njnes

this bug was fixed in the jun2016 version

Comment 22295

Date: 2016-08-12 21:12:32 +0200
From: desparanto

Perhapse there are two Jun2016 versions? I was using a version labled Jun2016. The original post had :
"MonetDB 5 server v11.23.3 "Jun2016" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved"

In it which indicates the version.

Comment 24487

Date: 2016-10-13 10:03:41 +0200
From: @sjoerdmullender

Jun2016-SP2 has been released.

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