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:1.9.2.12) 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 http://monetdb.cwi.nl/ 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://127.0.0.1:50000/
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 niels@cwi.nl 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 niels@cwi.nl 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.