Hi,

I am trying to execute a rather complex aggregation query (referencing a nested VIEW hierarchy) on a star schema.

The server reports this exception: Error: MALException:algebra.join:GDK reported error. ERROR: HEAPextend: failed to extend to 115574952 for 76\7667tail

The memory used by the mserver5.exe process after running the query the first time is about 780K. Running the query the second time even crashes the instance.

The server (Release 5.14.2) runs on a 3,5GB Dual Core machine with Win XP 32bit.

This is the last memory debug info after starting the server:

#GDKmemchk (memcur=8910680,memmax=3061052579) (vmcur=58720256,vmmax=1610612736)

What I am noticing is that after having executed the query the first time two comparably big files (the above reported 76\7667tail and a tail file) with 94MB each are generated in the bat folder. All the other files there are in the lower KB range.

Is there a limit on the view nesting hierarchy (other than memory limitations)?

Can I tune the accepted memory limits somehow? It seems that MonetDB does not use all available memory.

Kind regards,

TB.