Thanks for this detailed report, we'll take it along in scrutinizing the code and improving documentation/error reporting. Shahbaz wrote:
Thanks Martin, Apparently the BATs stayed large because my server had crashed. I again tried to load a file into my server and it crashed again. The reason is probably that I am on a 32 bit machine (osx laptop) and I was trying to insert a file slightly over 5 gigs. One of the problems was that I wasn't getting any messages, I couldn't tell if the file was even being inserted.
Initially I tried loading my file using the following syntax: ./MapiClient -l sql -d demo -u monetdb -P monetdb -s "copy into sys.dash5 from 'data/dump.final' using delimiters '|'" This command just seems to hang there.
I then logged in using mjclient and just issued the command inside the quotes: "copy into ... using deli..." This ran for a while then I received the following message: Error: End of stream reached (Mserver still alive?)
When I checked my server, it had crashed, with the following message: ./mserver5 # MonetDB Server v5.0.0_beta2_1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for i686-apple-darwin8.8.1/32bit with 32bit OIDs dynamically linked # dbname:demo # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /Users/me/MonetDB/etc/monetdb5.conf)
include sql; ##GDKvmtrim(4294967295) MT_mmap_trim(4095 MB): rss = 0 MB ##GDKvmtrim(4294967295) MT_mmap_trim(4095 MB): rss = 0 MB ##GDKvmtrim(4294967295) MT_mmap_trim(4095 MB): rss = 0 MB gdk_utils.mx:1149: failed assertion `(oldsize & 2) == 0' Abort trap
Part of the problem is that I don't really see any messages saying what the server is doing. I try to follow the change in disk size (df -kh) but I saw that number decreasing very slowly and by very small amount.
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users