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
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

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.
@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