You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
On Nov2019 release, whenever a SQL function defined in MAL is called, the server tests if the MAL definition exists. At your setting, the server attempted to call the SQL procedure listdir from the FITS module, but the MAL definition was not found. Please confirm if the fits.mal script is at lib/monetdb5 directory, as well as the lib_fits.so native library. The latter must be set also on the linker path if not installed at a regular path: LD_LIBRARY_PATH
$ mserver5 --dbpath=/tmp/test --set mapi_port=60000
MonetDB 5 server v11.35.3 (Nov2019)
...
loading sql script: 72_fits.sql
main thread:!ERROR:ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)
ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)Fatal error during initialization:
ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)
Then, when I try to install the fits lib, I got another error:
$ sudo apt install libmonetdb5-server-cfitsio
...
Unpacking libmonetdb5-server-cfitsio (11.35.3) ...
dpkg: error processing archive /var/cache/apt/archives/libmonetdb5-server-cfitsio_11.35.3_amd64.deb (--unpack):
trying to overwrite '/usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql', which is also in package monetdb5-sql 11.35.3
E: Sub-process /usr/bin/dpkg returned an error code (1)
I can workaround this by deleting the file:
$ sudo rm /usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql
Now I can start a database
It seems the file /usr/lib/x86_64-linux-gnu/monetdb5/fits.mal has accidentally been included in the monetdb5-server package. Remove the file from you installation and things should work again.
Note, the file does need to be present if you als install the package libmonetdb5-server-cfitsio.
In addition to the file mentioned in comment 4, the file /usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql needs to be removed as well.
On Fedora systems, the file /usr/lib64/monetdb/createdb/72_fits.sql should be removed.
As in comment 4, don't remove these files if you've actually also installed the MonetDB cfitsio package (libmonetdb5-server-cfitsio on Debian/Ubuntu, MonetDB-cfitsio on Fedora).
Date: 2019-12-02 08:30:47 +0100
From: wangkk
To: buildtools devs <>
Version: 11.35.3 (Nov2019)
CC: arnold.kuzniar, @PedroTadim, @yzchang
Last updated: 2020-02-16 22:42:03 +0100
Comment 27435
Date: 2019-12-02 08:30:47 +0100
From: wangkk
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36
Build Identifier:
After I run
shell> monetdbd create /path/to/mydbfarm
shell> monetdbd start /path/to/mydbfarm
shell> monetdb create voc
shell> monetdb release voc
shell> mclient -u monetdb -d voc
It outputs the following:
monetdbd: internal error while starting mserver 'database 'voc' has crashed after starting, manual intervention needed, check monetdbd's logfile (merovingian.log) for details'
Reproducible: Always
Steps to Reproduce:
shell> monetdbd create /path/to/mydbfarm
shell> monetdbd start /path/to/mydbfarm
shell> monetdb create voc
shell> monetdb release voc
shell> mclient -u monetdb -d voc
Actual Results:
In logs:
external name fits.listdir not bound (sys.listdir) Fatal error during initialization:
Comment 27436
Date: 2019-12-02 08:31:14 +0100
From: wangkk
Created attachment 638
logs
Comment 27437
Date: 2019-12-02 09:09:48 +0100
From: @PedroTadim
Hello Wang,
On Nov2019 release, whenever a SQL function defined in MAL is called, the server tests if the MAL definition exists. At your setting, the server attempted to call the SQL procedure listdir from the FITS module, but the MAL definition was not found. Please confirm if the fits.mal script is at lib/monetdb5 directory, as well as the lib_fits.so native library. The latter must be set also on the linker path if not installed at a regular path: LD_LIBRARY_PATH
Comment 27439
Date: 2019-12-02 11:47:09 +0100
From: @yzchang
I can confirm this error. At least, our Debian installer is broken.
I installed MonetDB on a Ubuntu Bionis following the instructions here: https://www.monetdb.org/downloads/deb/
Then when I try to start a fresh database, I got:
$ mserver5 --dbpath=/tmp/test --set mapi_port=60000
MonetDB 5 server v11.35.3 (Nov2019)
...
loading sql script: 72_fits.sql
main thread:!ERROR:ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)
ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)Fatal error during initialization:
ParseException:SQLparser:3F000!CREATE PROCEDURE: external name fits.listdir not bound (sys.listdir)
Then, when I try to install the fits lib, I got another error:
$ sudo apt install libmonetdb5-server-cfitsio
...
Unpacking libmonetdb5-server-cfitsio (11.35.3) ...
dpkg: error processing archive /var/cache/apt/archives/libmonetdb5-server-cfitsio_11.35.3_amd64.deb (--unpack):
trying to overwrite '/usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql', which is also in package monetdb5-sql 11.35.3
E: Sub-process /usr/bin/dpkg returned an error code (1)
I can workaround this by deleting the file:
$ sudo rm /usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql
Now I can start a database
Comment 27440
Date: 2019-12-03 09:58:19 +0100
From: @sjoerdmullender
It seems the file /usr/lib/x86_64-linux-gnu/monetdb5/fits.mal has accidentally been included in the monetdb5-server package. Remove the file from you installation and things should work again.
Note, the file does need to be present if you als install the package libmonetdb5-server-cfitsio.
Comment 27441
Date: 2019-12-03 10:04:48 +0100
From: MonetDB Mercurial Repository <>
Changeset 302e85949ac8 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=302e85949ac8
Changeset description:
Comment 27468
Date: 2019-12-09 22:42:58 +0100
From: @sjoerdmullender
In addition to the file mentioned in comment 4, the file /usr/lib/x86_64-linux-gnu/monetdb5/createdb/72_fits.sql needs to be removed as well.
On Fedora systems, the file /usr/lib64/monetdb/createdb/72_fits.sql should be removed.
As in comment 4, don't remove these files if you've actually also installed the MonetDB cfitsio package (libmonetdb5-server-cfitsio on Debian/Ubuntu, MonetDB-cfitsio on Fedora).
Comment 27556
Date: 2020-02-16 22:42:03 +0100
From: @sjoerdmullender
*** Bug #6820 has been marked as a duplicate of this bug. ***
The text was updated successfully, but these errors were encountered: