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

select from a REMOTE TABLE referring local table crashes mserver5 #3754

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

select from a REMOTE TABLE referring local table crashes mserver5 #3754

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

Comments

@monetdb-team
Copy link

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

Date: 2015-07-07 18:12:35 +0200
From: @yzchang
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-04-23 16:31:18 +0200

Comment 20968

Date: 2015-07-07 18:12:35 +0200
From: @yzchang

[Version should be changed to Jul2015 when it's added to the list]

commands to run server and client:

$ mserver5 --dbpath=/tmp/test
$ mclient -d test

Run the following queries:
CREATE TABLE t1 (i int);
CREATE REMOTE TABLE rt (LIKE t1) ON 'mapi:monetdb://localhost:50000/test';
SELECT * FROM rt;

to observe mserver5 crash at the following line:

0x00007fffef39d646 in timestamp_delta (d=0x0, ts=0) at /ufs/zhang/monet/Jul2015/sql/storage/bat/bat_storage.c:21
21 while (d->next && d->wtime > ts)

Comment 21097

Date: 2015-08-05 12:32:50 +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 21099

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

fixed by adding for a valid table in the bat_storage.c bind and property functions

Comment 21186

Date: 2015-08-28 13:41:47 +0200
From: @sjoerdmullender

Jul2015 has been released.

Comment 26403

Date: 2018-04-23 16:31:18 +0200
From: MonetDB Mercurial Repository <>

Changeset a7b565049fd9 made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Signal to MAPI that the password is hashed

This should fix the test
sql/test/BugTracker-2015/local-remotetable-crash.Bug-3754 that was
broken.
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