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 sequence crashes mserver5 #2730

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

select * from sequence crashes mserver5 #2730

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


Copy link

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

Date: 2010-11-22 23:22:49 +0100
From: @yzchang
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: @njnes

Last updated: 2011-03-28 17:31:37 +0200

Comment 15215

Date: 2010-11-22 23:22:49 +0100
From: @yzchang

User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-GB; rv: Gecko/20101026 Firefox/3.6.12
Build Identifier:

start an mserver session and create a sequence, say 'seq1', and in the same mserver5 session execute the query "select * from seq1" instantly crashes mserver5. The following are output of my console:

===== client terminal =====
$ mclient -lsql -t
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v5.22.2, 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create sequence seq1 as integer start with 0 increment by 1 maxvalue 10;
operation successful
Timer 4.418 msec
sql>select * from seq1;
MAPI = monetdb@localhost:50000
ACTION= read_line
QUERY = select * from seq1;
ERROR = !Connection terminated
Timer 4.453 msec

===== client terminal =====
$ mserver5
MonetDB server v5.22.2, based on kernel v1.40.2
Not released
Serving database 'demo', using 4 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
Found 7.750 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved
Visit for further information
warning: please don't forget to set your vault key!
(see /export/scratch0/zhang/monet-install/candidate/debug/etc/monetdb5.conf)
Listening for connection requests on mapi:monetdb://
MonetDB/SQL module v2.40.2 loaded
MonetDB/GIS module v0.20.2 loaded

Segmentation fault

Reproducible: Always

Comment 15225

Date: 2010-11-24 20:59:03 +0100
From: @njnes

Changeset decb8b46e1ec made by Niels Nes in the MonetDB repo, refers to this bug.

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

Changeset description:

fix bug #2730
sequences should only be added to the stack with multi statements (ie serial's/alters)

Comment 15226

Date: 2010-11-24 21:03:04 +0100
From: @njnes

Changeset 25384da1c126 made by Niels Nes in the MonetDB repo, refers to this bug.

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

Changeset description:

fix bug #2730

Comment 15642

Date: 2011-03-28 17:31:37 +0200
From: @sjoerdmullender

The Mar2011 version has been released.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant