I ran valgrind –tool=callgrind on mserver5 while executing TPCH Q1 (in SQL) on a scale factor 100 database on a dual-processor, x86_64 linux server.  The program failed due to an assertion in DELTAproject, namely assert(tres) on line 3614 in sql.mx.  Without valgrind, the query completes correctly when mserver5 is run from a similar command line.  What appears below is the valgrind program output.

 

Steve Morgan

 

==1800== Callgrind, a call-graph generating cache profiler

==1800== Copyright (C) 2002-2011, and GNU GPL'd, by Josef Weidendorfer et al.

==1800== Using Valgrind-3.7.0 and LibVEX; rerun with -h for copyright info

==1800== Command: /usr/local/bin/mserver5 --dbpath=/home/ubuntu/monet/dbfarm/tpch --set merovingian_uri=mapi:monetdb://SM-MoDB3:50000/tpch --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/ubuntu/monet/dbfarm/tpch/.mapi.sock --set monet_vault_key=/home/ubuntu/monet/dbfarm/tpch/.vaultkey --set gdk_nr_threads=32 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes

==1800==

==1800== For interactive control, run 'callgrind_control -h'.

# MonetDB 5 server v11.15.3 "Feb2013-SP1"

# Serving database 'tpch', using 32 threads

# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked

# Found 188.887 GiB available main-memory.

# Copyright (c) 1993-July 2008 CWI.

# Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved

# Visit http://www.monetdb.org/ for further information

# Listening for UNIX domain connection requests on mapi:monetdb:///home/ubuntu/monet/dbfarm/tpch/.mapi.sock

# MonetDB/GIS module loaded

# MonetDB/JAQL module loaded

# MonetDB/SQL module loaded

#GDKmalloc(116404584) fails, try to free up space [memory in use=4416764392,virtual memory in use=31869532648]

#GDKmalloc(116404584) result [mem=3251134360,vm=15052332952]

#GDKmallocmax: recovery ok. Continuing..

#GDKmmap(1600192512) fails, try to free up space [memory in use=8024487008,virtual memory in use=26927363168]

#GDKmmap(1600192512) result [mem=5046231544,vm=20698587640]

#GDKmmap: recovery ok. Continuing..

#GDKmmap(1600192512) fails, try to free up space [memory in use=5046232200,virtual memory in use=20898866312]

#GDKmmap(1600192512) fails, try to free up space [memory in use=5046232200,virtual memory in use=22499058824]

#GDKmmap(1600192512) result [mem=4897637384,vm=22350464008]

mserver5: ../../../../MonetDB/sql/backends/monet5/sql.mx:3614: DELTAproject: Assertion `tres' failed.

#GDKmmap(1600192512) result [mem=5097655904,vm=22550482528]

#GDKmmap(1600192512) result [mem=5097655904,vm=22550482528]

==1800==

==1800== Events    : Ir

==1800== Collected : 142458949886

==1800==

==1800== I   refs:      142,458,949,886

./out: line 1:  1800 Killed                  valgrind --tool=callgrind /usr/local/bin/mserver5 --dbpath=/home/ubuntu/monet/dbfarm/tpch --set merovingian_uri=mapi:monetdb://SM-MoDB3:50000/tpch --set mapi_open=false --set mapi_port=0 --set mapi_usock=/home/ubuntu/monet/dbfarm/tpch/.mapi.sock --set monet_vault_key=/home/ubuntu/monet/dbfarm/tpch/.vaultkey --set gdk_nr_threads=32 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes