Hi all,

I have downloaded the latest version MonetDB-11.23.7 and built it from source. But I have encountered errors while entering a newly created database:

===========================================================
$ monetdbd start ~/monetdb_dbfarm2
$ monetdb create topk_synthetic
$ monetdb release topk_synthetic
$ mclient -dtopk_synthetic
CREATE FUNCTION: name 'md5' (clob) already in use
ParseException:SQLparser:CREATE FUNCTION: name 'md5' (clob) already in use
===========================================================

Logs are as follows:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2016-09-01 09:45:21 MSG merovingian[30268]: starting database 'topk_synthetic', up min/avg/max: 0s/0s/0s, crash average: 0.00 0.00 0.00 (0-0=0)
2016-09-01 09:45:22 MSG topk_synthetic[30287]: arguments: /usr/local/bin/mserver5 --dbpath=/home/zeroxwj/monetdb_dbfarm2/topk_synthetic --set merovingian_uri=mapi:monetdb://SourceCode:50000/topk_synthetic --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/zeroxwj/monetdb_dbfarm2/topk_synthetic/.mapi.sock --set monet_vault_key=/home/zeroxwj/monetdb_dbfarm2/topk_synthetic/.vaultkey --set gdk_nr_threads=8 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # MonetDB 5 server v11.23.7 "Jun2016-SP1"
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Serving database 'topk_synthetic', using 8 threads
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Found 15.625 GiB available main-memory.
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Copyright (c) 1993-July 2008 CWI.
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Copyright (c) August 2008-2016 MonetDB B.V., all rights reserved
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Visit http://www.monetdb.org/ for further information
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # Listening for UNIX domain connection requests on mapi:monetdb:///home/zeroxwj/monetdb_dbfarm2/topk_synthetic/.mapi.sock
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # MonetDB/SQL module loaded
2016-09-01 09:45:22 MSG merovingian[30268]: proxying client (local) for database 'topk_synthetic' to mapi:monetdb:///home/zeroxwj/monetdb_dbfarm2/topk_synthetic/.mapi.sock?database=topk_synthetic
2016-09-01 09:45:22 MSG merovingian[30268]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # SQL catalog created, loading sql scripts once
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 09_like.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 10_math.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 11_times.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 12_url.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 13_date.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 14_inet.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 15_querylog.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 16_tracelog.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 17_temporal.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 19_cluster.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 20_vacuum.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 21_dependency_functions.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 22_clients.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 23_skyserver.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 24_zorder.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 25_debug.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 26_sysmon.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 27_rejects.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 39_analytics.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 39_analytics_hge.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 40_json.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 40_json_hge.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 41_jsonstore.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 41_md5sum.sql
2016-09-01 09:45:22 MSG merovingian[30268]: proxying client localhost:54853 for database 'topk_synthetic' to mapi:monetdb:///home/zeroxwj/monetdb_dbfarm2/topk_synthetic/.mapi.sock?database=topk_synthetic
2016-09-01 09:45:22 MSG merovingian[30268]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # SQL catalog created, loading sql scripts once
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 09_like.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 10_math.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 11_times.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 12_url.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 13_date.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 14_inet.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 15_querylog.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 16_tracelog.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 17_temporal.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 19_cluster.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 20_vacuum.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 21_dependency_functions.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 22_clients.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 23_skyserver.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 24_zorder.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 25_debug.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 26_sysmon.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 27_rejects.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 39_analytics.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 39_analytics_hge.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 40_json.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 40_json_hge.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 41_jsonstore.sql
2016-09-01 09:45:22 MSG topk_synthetic[30287]: # loading sql script: 41_md5sum.sql
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

As far as I understand, those sql scripts (e.g., 09_like.sql) are for initialization purpose. What is the reason that it loads those scripts twice?

BTW, I can start an existing database successfully.

I have never encountered such errors before. Any suggestion would be helpful. Thanks.

Best regards,
Wenjian