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

Crash on remote table schema mismatch #3778

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

Crash on remote table schema mismatch #3778

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2015-07-28 16:01:22 +0200
From: @hannesmuehleisen
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2015-09-28 15:37:30 +0200

Comment 21063

Date: 2015-07-28 16:01:22 +0200
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36
Build Identifier:

Create a table on remote node, say
CREATE TABLE sometable_0(A BIGINT);
Insert some data
INSERT INTO SOMETABLE VALUES (42);
Add this table as a remote table on another node with a slightly wrong schema
CREATE REMOTE TABLE sometable_0 (A INTEGER) ON 'mapi:monetdb://.../...';
SELECT * FROM sometable_0;

Result: crash of remote node. Also, unhelpful error message on master node: "illegal input, not a JSON header (got '')"

Reproducible: Always

Actual Results:

Crash

Expected Results:

No crash, error should be thrown at remote table creation. Also, better error message on crash of remote node.

Comment 21064

Date: 2015-07-28 16:04:04 +0200
From: MonetDB Mercurial Repository <>

Changeset 317820b49de5 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Test case for Bug #3778

Comment 21096

Date: 2015-08-05 12:32:20 +0200
From: MonetDB Mercurial Repository <>

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

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

Changeset description:

added more defensive code to handle typos for the remote cases.
see bugs 3778 and 3754

Comment 21098

Date: 2015-08-05 12:33:00 +0200
From: @njnes

added a check for proper types in the mvc_bind* code.

Comment 21233

Date: 2015-08-28 13:43:10 +0200
From: @sjoerdmullender

Jul2015 has been released.

Comment 21290

Date: 2015-09-28 15:37:17 +0200
From: MonetDB Mercurial Repository <>

Changeset 56adbdf57769 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

renamed schemadiff.SQL.py to schemadiff.Bug-3778.SQL.py

Comment 21291

Date: 2015-09-28 15:37:23 +0200
From: MonetDB Mercurial Repository <>

Changeset f15a56550f53 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

added "canonical" stable output for tests schemadiff.Bug-3778 & copy_into.Bug-3813;

correct / expected output still needs to be approved / provided !

Comment 21293

Date: 2015-09-28 15:37:30 +0200
From: MonetDB Mercurial Repository <>

Changeset 0b830207930c made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

BugTracker-2015: activate "dormand(?)" / new tests schemadiff.Bug-3778 & copy_into.Bug-3813
@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants