2012-05-03 21:54:20 MSG merovingian[21195]: monitoring dbfarm /export/scratch2/bscheers/databases/data/dbfarm/
2012-05-03 21:54:20 MSG merovingian[21195]: accepting connections on TCP socket 0.0.0.0:60000
2012-05-03 21:54:20 MSG merovingian[21195]: accepting connections on UNIX domain socket /tmp/.s.monetdb.60000
2012-05-03 21:54:20 MSG discovery[21195]: listening for UDP messages on 0.0.0.0:60000
2012-05-03 21:54:20 MSG control[21195]: accepting connections on UNIX domain socket /tmp/.s.merovingian.60000
2012-05-03 21:54:20 MSG discovery[21195]: new neighbour napels.ins.cwi.nl (napels.ins.cwi.nl)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/node3db/lightcurve3 (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/sjoert (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/trap (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/bugs (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/gsm (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/grb2 (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/node1db/lightcurve1 (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/bell (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/tradb (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/flarestar (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/sinterklaas (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/sipfull (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/grb (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/testing (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/node2db/lightcurve2 (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/sip (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/sip2full (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/test (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/simlofar (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/simlsst (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: new database mapi:monetdb://napels.ins.cwi.nl:60000/fast (ttl=660s)
2012-05-03 21:54:21 MSG discovery[21195]: registered neighbour napels.ins.cwi.nl:60000
2012-05-03 21:54:30 MSG control[21195]: (local): served status list
2012-05-03 21:54:48 MSG merovingian[21195]: starting database 'bell', up min/avg/max: 27s/49m/2h, crash average: 0.00 0.10 0.03 (5-4=1)
2012-05-03 21:54:48 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:54:48 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:54:48 MSG bell[21211]: arguments: /export/scratch2/bscheers/databases/MonetDB-Apr2012/bin/mserver5 --set gdk_dbfarm=/export/scratch2/bscheers/databases/data/dbfarm --dbname=bell --set merovingian_uri=mapi:monetdb://napels.ins.cwi.nl:60000/bell --set mapi_open=false --set mapi_port=0 --set mapi_usock=/export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock --set monet_vault_key=/export/scratch2/bscheers/databases/data/dbfarm/bell/.vaultkey --set gdk_nr_threads=8 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2012-05-03 21:54:48 MSG bell[21211]: # MonetDB 5 server v11.9.1 "Apr2012"
2012-05-03 21:54:48 MSG bell[21211]: # Serving database 'bell', using 8 threads
2012-05-03 21:54:48 MSG bell[21211]: # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
2012-05-03 21:54:48 MSG bell[21211]: # Found 15.629 GiB available main-memory.
2012-05-03 21:54:48 MSG bell[21211]: # Copyright (c) 1993-July 2008 CWI.
2012-05-03 21:54:48 MSG bell[21211]: # Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
2012-05-03 21:54:48 MSG bell[21211]: # Visit http://www.monetdb.org/ for further information
2012-05-03 21:54:48 MSG bell[21211]: # Listening for UNIX domain connection requests on mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock
2012-05-03 21:54:48 MSG bell[21211]: # MonetDB/GIS module loaded
2012-05-03 21:54:48 MSG bell[21211]: # MonetDB/SQL module loaded
2012-05-03 21:54:48 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:54:48 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:54:48 MSG bell[21211]: Running database upgrade commands:
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val TINYINT) returns TINYINT external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val SMALLINT) returns SMALLINT external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val INTEGER) returns INTEGER external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val BIGINT) returns BIGINT external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val REAL) returns REAL external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate median(val DOUBLE) returns DOUBLE external name "aggr"."median";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 TINYINT, e2 TINYINT) returns TINYINT external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 SMALLINT, e2 SMALLINT) returns SMALLINT external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 INTEGER, e2 INTEGER) returns INTEGER external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 BIGINT, e2 BIGINT) returns BIGINT external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 REAL, e2 REAL) returns REAL external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: create aggregate corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE external name "aggr"."corr";
2012-05-03 21:54:48 MSG bell[21211]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('median', 'corr') and f.type = 3 and f.schema_id = s.id and s.name = 'sys');
2012-05-03 21:54:48 MSG bell[21211]: 
2012-05-03 21:55:00 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:55:00 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:55:00 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:55:00 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:55:00 MSG bell[21211]: Running database upgrade commands:
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val TINYINT) returns TINYINT external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val SMALLINT) returns SMALLINT external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val INTEGER) returns INTEGER external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val BIGINT) returns BIGINT external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val REAL) returns REAL external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate median(val DOUBLE) returns DOUBLE external name "aggr"."median";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 TINYINT, e2 TINYINT) returns TINYINT external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 SMALLINT, e2 SMALLINT) returns SMALLINT external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 INTEGER, e2 INTEGER) returns INTEGER external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 BIGINT, e2 BIGINT) returns BIGINT external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 REAL, e2 REAL) returns REAL external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: create aggregate corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE external name "aggr"."corr";
2012-05-03 21:55:00 MSG bell[21211]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('median', 'corr') and f.type = 3 and f.schema_id = s.id and s.name = 'sys');
2012-05-03 21:55:00 MSG bell[21211]: 
2012-05-03 21:55:00 ERR bell[21211]: !ParseException:SQLparser:CREATE AGGREGATE: name 'median' (tinyint(8)) already in use
2012-05-03 21:55:48 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:55:48 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:55:48 MSG merovingian[21195]: proxying client (local) for database 'bell' to mapi:monetdb:///export/scratch2/bscheers/databases/data/dbfarm/bell/.mapi.sock?database=bell
2012-05-03 21:55:48 MSG merovingian[21195]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2012-05-03 21:55:48 MSG bell[21211]: Running database upgrade commands:
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val TINYINT) returns TINYINT external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val SMALLINT) returns SMALLINT external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val INTEGER) returns INTEGER external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val BIGINT) returns BIGINT external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val REAL) returns REAL external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate median(val DOUBLE) returns DOUBLE external name "aggr"."median";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 TINYINT, e2 TINYINT) returns TINYINT external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 SMALLINT, e2 SMALLINT) returns SMALLINT external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 INTEGER, e2 INTEGER) returns INTEGER external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 BIGINT, e2 BIGINT) returns BIGINT external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 REAL, e2 REAL) returns REAL external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: create aggregate corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE external name "aggr"."corr";
2012-05-03 21:55:48 MSG bell[21211]: insert into sys.systemfunctions (select f.id from sys.functions f, sys.schemas s where f.name in ('median', 'corr') and f.type = 3 and f.schema_id = s.id and s.name = 'sys');
2012-05-03 21:55:48 MSG bell[21211]: 
2012-05-03 21:55:48 ERR bell[21211]: !ParseException:SQLparser:CREATE AGGREGATE: name 'median' (tinyint(8)) already in use