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 <ajdamico@gmail.com>
Date: 11/22/17 12:13 (GMT+01:00)
To: Communication channel for MonetDB users <users-list@monetdb.org>
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