Date: 2014-01-15 15:18:35 +0100
From: Christian Braun <>
To: SQL devs <>
Version: 11.17.9 (Jan2014)

Last updated: 2014-02-20 15:02:34 +0100

Comment 19451

Date: 2014-01-15 15:18:35 +0100
From: Christian Braun <>

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:26.0) Gecko/20100101 Firefox/26.0
Build Identifier:

After upgrading from 'MonetDB 5 server v11.15.19 "Feb2013-SP6"' to the release candidate, the database does not start anymore:

2014-01-15 15:13:44 MSG control[14903]: (local): served status list
2014-01-15 15:13:44 MSG merovingian[14903]: starting database 'db', up min/avg/max: 0s/3d/1w, crash average: 0.00 0.10 0.27 (70-60=10)
2014-01-15 15:13:45 MSG db[16499]: arguments: /usr/bin/mserver5 --dbpath=/var/monetdb/dbfarm/db --set merovingian_uri=mapi:monetdb://etna:50000/db --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb/dbfarm/db/.mapi.sock --set monet_vault_key=/var/monetdb/dbfarm/db/.vaultkey --set gdk_nr_threads=8 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2014-01-15 15:13:46 MSG merovingian[14903]: sending process 16499 (database 'db') the TERM signal
2014-01-15 15:13:46 MSG db[16499]: MonetDB 5 server v11.17.1 "Jan2014"
2014-01-15 15:13:46 MSG db[16499]: Serving database 'db', using 8 threads
2014-01-15 15:13:46 MSG db[16499]: Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
2014-01-15 15:13:46 MSG db[16499]: Found 47.263 GiB available main-memory.
2014-01-15 15:13:46 MSG db[16499]: Copyright (c) 1993-July 2008 CWI.
2014-01-15 15:13:46 MSG db[16499]: Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved
2014-01-15 15:13:46 MSG db[16499]: Visit http://www.monetdb.org/ for further information
2014-01-15 15:13:46 MSG db[16499]: !SyntaxException:parseError:include sysmon;
2014-01-15 15:13:46 MSG db[16499]: !SyntaxException:parseError:^MALException:malInclude:could not open file: querylog
2014-01-15 15:13:46 MSG db[16499]: !SyntaxException:parseError:include sysmon;
2014-01-15 15:13:46 MSG db[16499]: !SyntaxException:parseError: ^';' expected
2014-01-15 15:13:46 MSG merovingian[14903]: database 'db' (16499) has exited with exit status 0
2014-01-15 15:13:46 MSG merovingian[14903]: database 'db' has shut down
2014-01-15 15:13:46 ERR control[14903]: (local): failed to fork mserver: database 'db' started up, but failed to open up a communication channel

Reproducible: Always

Comment 19452

Date: 2014-01-15 15:42:36 +0100
From: @sjoerdmullender

It's not just an upgraded database that doesn't work. Also a new one doesn't work.

The problem turns out to be a missing file from the Debian/Ubuntu packages. The file /usr/lib/monetdb5/querylog.mal is missing.

You could try copying the file from the sources (e.g., http://dev.monetdb.org/hg/MonetDB/file/0193a77a33c5/monetdb5/modules/mal/querylog.mal then click on "raw" in the left margin) and install it in the location mentioned.

Comment 19453

Date: 2014-01-15 15:44:39 +0100
From: MonetDB Mercurial Repository <>

Changeset 4d42c99421c6 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Add missing file in Debian/Ubuntu packages.
This fixes bug #3419.

Comment 19454

Date: 2014-01-15 15:45:18 +0100
From: @sjoerdmullender

File is now packaged.

Comment 19455

Date: 2014-01-15 18:07:10 +0100
From: Christian Braun <>

Thanks. The error messages are gone. I can create and start a new database. But my existing database does not start. In the log i have:

2014-01-15 17:36:45 MSG merovingian[19494]: starting database 'db', up min/avg/max: 0s/3d/1w, crash average: 0.00 0.00 0.20 (77-67=10)
2014-01-15 17:36:45 MSG db[20059]: arguments: /usr/bin/mserver5 --dbpath=/var/monetdb/dbfarm/db --set merovingian_uri=mapi:monetdb://etna:50000/db --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb/dbfarm/db/.mapi.sock --set monet_vault_key=/var/monetdb/dbfarm/db/.vaultkey --set gdk_nr_threads=8 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes

The mserver just hangs and uses 100% cpu on one core with no disk activity. It is doing that for 30 minutes now. Is there anything else i can try to start the database?

Comment 19599

Date: 2014-02-20 15:02:34 +0100
From: @sjoerdmullender

Jan2014 has been released.