Bugs item #2261241, was opened at 2008-11-11 09:07 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2261241&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: MonetDB5 "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Thomas Neumann (tneumann) Assigned to: Niels Nes (nielsnes) Summary: bulkloading a large string table kills mserver Initial Comment: Bulkloading a large string table of the form (id,value) kills mserver. I attached a data generator that generates 21GB of input to illustrate the problem. How to reproduce: - g++ -odatagen -O2 datagen.cpp - ./datagen > test.sql - monetdb create foo - monetdb start foo - mclient -l sql -d foo test.sql results in: ERROR = Connection terminated and the server crashed (on Linux x86_64). Note that there seem to be two problems in one: The primary crash seems to be due to the "primary key" constraints in the table. Dropping it changes the behavior: The bulkload succeeds on a machine with 32GB of main memory, but effectively stops (i.e., swap excessively) on a machine with 2GB of main memory. Adding the primary key constrants after successful bulkloading without it crashes the server, too. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2261241&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
