Hi keliang, we regular successfully load TPCH SF-100 on 16 GB systems. Do you use a pre-build version of MonetDB or did you compile it yourself? Is your MonetDB 64- or 32-bit (check what `mserver5 --version` says) How much free disk space is on the partition where your dbfarm is located? What are the actual values of XXX & XXXX in the error messages you get? Do your tables have constraints (primary-/foreign-keys, etc.) defined prior to loading data? Stefan ----- Original Message -----
Hello, I'm trying to load SF100 data into MonetDB but it crashed. My server:
64bit openSUSE 11.3 mem: 47GB swap: 1GB disk: 1.2T monetDB: 11.15.3
I use DBgen to generate my data. when I'm in a client I execute a script, after a few minutes, the monetDB was crashed.
get some error msg like this: HEAPextend failed to extend to XXX for XXXX
my script file : COPY records into from nation.tbl using ...; COPY records into from region.tbl using ...; COPY records into from customer.tbl using ...; COPY records into from part.tbl using ...; COPY records into from ...; COPY records into from ...; COPY records into from ...;
Does anybody know what's reason for this error ? and how can i overcome this error? Any help would be most welcome:)
Thx, keliang
_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |