Stephen THis is because monetdb + valgrinds takes more memory. MonetDB fails to mmap a needed input. We agree a more gracefull exit would be better. NIels On Thu, Jun 06, 2013 at 10:19:19AM -0700, Stephen P. Morgan wrote:

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

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl