Allocating "only" about 2.8 GB does not ring alarms that the plan night be degenerated - assuming your data is not tiny.
Could you share:OS, full query, data sizes, free disk space at time of failure, mserver5 process size at time of failure?
Thanks,Stefan
-------- Original message --------From: Anthony Damico Date: 11/22/17 12:13 (GMT+01:00) To: Communication channel for MonetDB users Subject: algebra.join heapextend crash
hi, i'm using monetdblite-r 0.5.0 on a confidential dataset. my syntax worked on monetdblite 0.3.1 on the same machine
ftruncate: Invalid argument
Error in .local(conn, statement, ...) :
Unable to execute statement 'CREATE TABLE ccaed123_b_svcmon_xwalk AS
( SELECT
a.enrolid ,
a.yr ,
a.dataty...'.
Server says 'MALException:algebra.join:GDK reported error. !ERROR: GDKextendf: c
!ERROR: HEAPextend: failed to extend to 2890530816 for 02\57\25766.tail: GDKmre
map() failed '.
it's a local drive, the hard disk isn't close to full and the machine has 700gb of ram, but the
table it's trying to create might be bigger than that. dunno if related to https://www.monetdb.org/bugzilla/show_bug.cgi?id=3791
thanks
