Date: 2011-03-08 15:29:20 +0100
From: manuela <<m.sagona>>
To: SQL devs <>
Version: 11.1.1 (Mar2011) [obsolete]
CC: @njnes, steffen.hausmann

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

Comment 15543

Date: 2011-03-08 15:29:20 +0100
From: manuela <<m.sagona>>

User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/9.0.597.107 Safari/534.13
Build Identifier:

When you connect to monetdb with a new user on a new db and try to display the tables (you have already loaded in), the client response is "connection lost" unless you quit, login as monetdb, quit again and login again as the new user.

Reproducible: Always

Steps to Reproduce:

1. create a new user and a new db and load the data in
2. login with such credentials
3. display tables

Actual Results:

sql>\d
MAPI = (voc) /home/manuela/MyMonetDB/var/monetdb5/dbfarm/mapi_socket
ACTION= mapi_query
ERROR = !Connection lost
MAPI = (voc) /home/manuela/MyMonetDB/var/monetdb5/dbfarm/mapi_socket
ACTION= mapi_query
ERROR = !Connection lost

Expected Results:

sql>\d
TABLE voc.craftsmen
TABLE voc.impotenten
TABLE voc.invoices
TABLE voc.lastvoyages
TABLE voc.lastvoyages2
VIEW voc.onboard_people
TABLE voc.passengers
TABLE voc.seafarers
TABLE voc.soldiers
TABLE voc.total
VIEW voc.total_onboard
TABLE voc.voyages

Comment 15544

Date: 2011-03-08 17:03:09 +0100
From: @grobian

I've seen this happening, also on Stefan's laptop, but I can't reproduce it:

(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/monetdb status
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/monetdb create test
created database in maintenance mode: test
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/monetdb release test
taken database out of maintenance mode: test
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/mclient -dtest
Welcome to mclient, the MonetDB/SQL interactive terminal (Mar2011-hg)
Database: MonetDB v11.1.0, 'test'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>CREATE USER "voc" WITH PASSWORD 'voc' NAME 'VOC Explorer' SCHEMA "sys";
operation successful
sql>CREATE SCHEMA "voc" AUTHORIZATION "voc";
operation successful
sql>ALTER USER "voc" SET SCHEMA "voc";
operation successful
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/mclient -dtest -uvoc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Mar2011-hg)
Database: MonetDB v11.1.0, 'test'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\d
sql>
sql>\d
sql>
(volund:monetdb/Mar2011/hgrepo) fabian% wget "http://monetdb.cwi.nl/Assets/VOC/voc_dump.sql.bz2" -O - | bzcat | $INSTALL_DIR/bin/mclient -dtest -uvoc
...
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/mclient -dtest -uvoc
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Mar2011-hg)
Database: MonetDB v11.1.0, 'test'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>\d
TABLE voc.craftsmen
TABLE voc.impotenten
TABLE voc.invoices
TABLE voc.passengers
TABLE voc.seafarers
TABLE voc.soldiers
TABLE voc.total
TABLE voc.voyages
sql>\d
TABLE voc.craftsmen
TABLE voc.impotenten
TABLE voc.invoices
TABLE voc.passengers
TABLE voc.seafarers
TABLE voc.soldiers
TABLE voc.total
TABLE voc.voyages
(volund:monetdb/Mar2011/hgrepo) fabian% $INSTALL_DIR/bin/monetdb status
name state uptime health last crash
test running 3m 24s 100%, 0s -

Comment 15545

Date: 2011-03-08 17:05:13 +0100
From: @grobian

ah... one needs to stop (and start) the mserver, then it indeed fails on each and every query that is performed:

2011-03-08 17:04:15 MSG merovingian[9866]: database 'test' (10702) was killed by signal SIGSEGV

Comment 15546

Date: 2011-03-08 17:39:17 +0100
From: @grobian

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffe6321700 (LWP 11300)]
0x00007fffe7485755 in create_func (sql=0x7fffd8005468, qname=0x7fffd80e1288,
params=0x0, res=0x7fffd80e13d8, ext_name=0x7fffd80e1418, body=0x0,
is_func=1, is_aggr=0)
at /ufs/fabian/scratch/monetdb/Mar2011/hgrepo/sql/server/sql_psm.c:620
620 sql_func *f = sf->func;

this was introduced in commit 81293e2793a5

The sf was found to be NULL before, it's basically never set.

Niels, I've no idea what the intended use was here.

Comment 15549

Date: 2011-03-09 15:17:48 +0100
From: @grobian

*** Bug #2785 has been marked as a duplicate of this bug. ***

Comment 15555

Date: 2011-03-09 17:28:47 +0100
From: @njnes

Changeset 895515c4cf65 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=895515c4cf65

Changeset description:

fixed bug #2786
we need to instantiate functions in the proper schema context.

Comment 15556

Date: 2011-03-09 17:29:44 +0100
From: @njnes

fixed the bug, test needs to be added still.

Comment 15601

Date: 2011-03-17 10:39:37 +0100
From: @grobian

bug cannot be tested using Mtest

Comment 15645

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

The Mar2011 version has been released.