Date: 2013-09-30 15:00:08 +0200
From: Anthony Damico <>
To: SQL devs <>
Version: 11.15.15 (Feb2013-SP4)
CC: ajdamico, @hannesmuehleisen

Duplicates: #3376
Last updated: 2013-09-30 16:49:38 +0200

Comment 19220

Date: 2013-09-30 15:00:08 +0200
From: Anthony Damico <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:23.0) Gecko/20100101 Firefox/23.0
Build Identifier:

this appears to be related (but i'm not 100% sure)

http://bugs.monetdb.org/show_bug.cgi?id=3376

sql>create table c10_dom_pre_fpc as (SELECT * FROM ac_dom) UNION ALL (SELECT * F
ROM al_dom) UNION ALL (SELECT * FROM am_dom) UNION ALL (SELECT * FROM ap_dom) UN
ION ALL (SELECT * FROM ba_dom) UNION ALL (SELECT * FROM ce_dom) UNION ALL (SELEC
T * FROM df_dom) UNION ALL (SELECT * FROM es_dom) UNION ALL (SELECT * FROM go_do
m) UNION ALL (SELECT * FROM ma_dom) UNION ALL (SELECT * FROM mg_dom) UNION ALL (
SELECT * FROM ms_dom) UNION ALL (SELECT * FROM mt_dom) UNION ALL (SELECT * FROM
pa_dom) UNION ALL (SELECT * FROM pb_dom) UNION ALL (SELECT * FROM pe_dom) UNION
ALL (SELECT * FROM pi_dom) UNION ALL (SELECT * FROM pr_dom) UNION ALL (SELECT *
FROM rj_dom) UNION ALL (SELECT * FROM rn_dom) UNION ALL (SELECT * FROM ro_dom) U
NION ALL (SELECT * FROM rr_dom) UNION ALL (SELECT * FROM rs_dom) UNION ALL (SELE
CT * FROM sc_dom) UNION ALL (SELECT * FROM se_dom) UNION ALL (SELECT * FROM sp1_
dom) UNION ALL (SELECT * FROM sp2_rm_dom) UNION ALL (SELECT * FROM to_dom ) WITH
DATA;
GDK reported error.
HEAPextend: failed to extend to 755914244096 for 02\65\26501.tail: MT_mremap() f

Reproducible: Always

Steps to Reproduce:

install the latest instance of R and also monetdb SP-4

open up R and set your working directory with something like this:

setwd( "C:/My Directory/CENSO/" )

then run these three lines and let the program run for a few hours.

install.packages( c( "MonetDB.R" , "RCurl" , "downloader" ) )
library(downloader)
source_url( "https://raw.github.com/ajdamico/usgsd/master/Censo%20Demografico/download%20and%20import.R" , prompt = FALSE , echo = TRUE )

the program will crash at this line--

https://github.com/ajdamico/usgsd/blob/master/Censo%20Demografico/download%20and%20import.RL298

when it crashes, you can re-open the mserver with "censo_demografico.bat" and connect to it with mclient censo_demografico -p 50011

that should let you investigate and re-run the command that is actually breaking:

create table c10_dom_pre_fpc as (SELECT * FROM ac_dom) UNION ALL (SELECT * FROM al_dom) UNION ALL (SELECT * FROM am_dom) UNION ALL (SELECT * FROM ap_dom) UNION ALL (SELECT * FROM ba_dom) UNION ALL (SELECT * FROM ce_dom) UNION ALL (SELECT * FROM df_dom) UNION ALL (SELECT * FROM es_dom) UNION ALL (SELECT * FROM go_dom) UNION ALL (SELECT * FROM ma_dom) UNION ALL (SELECT * FROM mg_dom) UNION ALL (SELECT * FROM ms_dom) UNION ALL (SELECT * FROM mt_dom) UNION ALL (SELECT * FROM pa_dom) UNION ALL (SELECT * FROM pb_dom) UNION ALL (SELECT * FROM pe_dom) UNION ALL (SELECT * FROM pi_dom) UNION ALL (SELECT * FROM pr_dom) UNION ALL (SELECT * FROM rj_dom) UNION ALL (SELECT * FROM rn_dom) UNION ALL (SELECT * FROM ro_dom) UNION ALL (SELECT * FROM rr_dom) UNION ALL (SELECT * FROM rs_dom) UNION ALL (SELECT * FROM sc_dom) UNION ALL (SELECT * FROM se_dom) UNION ALL (SELECT * FROM sp1_dom) UNION ALL (SELECT * FROM sp2_rm_dom) UNION ALL (SELECT * FROM to_dom ) WITH DATA;

Actual Results:

in mserver----

MonetDB 5 server v11.15.15 "Feb2013-SP4"
Serving database 'censo_demografico', using 8 threads
Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
Found 7.860 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:50011/
MonetDB/JAQL module loaded
MonetDB/SQL module loaded

= .....\gdk\gdk_posix.c:800: MT_mremap(bat\02\65\26501.tail,468c50000,1889785
61024,755914244096): GDKextend() failed

in mclient----

C:\Windows\System32>cd ..

C:\Windows>cd ..

C:>cd "Program Files"

C:\Program Files>cd MonetDB

C:\Program Files\MonetDB>mclient censo_demografico -p 50011
'mclient' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MonetDB>mclient
'mclient' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MonetDB>ls
'ls' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\MonetDB>dir
Volume in drive C has no label.
Volume Serial Number is 882E-FD8A

Directory of C:\Program Files\MonetDB

09/06/2013 04:34 PM

C:\Program Files\MonetDB>cd MonetDB5

C:\Program Files\MonetDB\MonetDB5>mclient censo_demografico -p 50011
user(win32):monetdb
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Feb2013-SP4)
Database: MonetDB v11.15.15 (Feb2013-SP4), 'censo_demografico'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>create table c10_dom_pre_fpc as (SELECT * FROM ac_dom) UNION ALL (SELECT * F
ROM al_dom) UNION ALL (SELECT * FROM am_dom) UNION ALL (SELECT * FROM ap_dom) UN
ION ALL (SELECT * FROM ba_dom) UNION ALL (SELECT * FROM ce_dom) UNION ALL (SELEC
T * FROM df_dom) UNION ALL (SELECT * FROM es_dom) UNION ALL (SELECT * FROM go_do
m) UNION ALL (SELECT * FROM ma_dom) UNION ALL (SELECT * FROM mg_dom) UNION ALL (
SELECT * FROM ms_dom) UNION ALL (SELECT * FROM mt_dom) UNION ALL (SELECT * FROM
pa_dom) UNION ALL (SELECT * FROM pb_dom) UNION ALL (SELECT * FROM pe_dom) UNION
ALL (SELECT * FROM pi_dom) UNION ALL (SELECT * FROM pr_dom) UNION ALL (SELECT *
FROM rj_dom) UNION ALL (SELECT * FROM rn_dom) UNION ALL (SELECT * FROM ro_dom) U
NION ALL (SELECT * FROM rr_dom) UNION ALL (SELECT * FROM rs_dom) UNION ALL (SELE
CT * FROM sc_dom) UNION ALL (SELECT * FROM se_dom) UNION ALL (SELECT * FROM sp1_
dom) UNION ALL (SELECT * FROM sp2_rm_dom) UNION ALL (SELECT * FROM to_dom ) WITH
DATA;
GDK reported error.
HEAPextend: failed to extend to 755914244096 for 02\65\26501.tail: MT_mremap() f
ailed
sql>
sql>

Expected Results:

a table :)

Comment 19224

Date: 2013-09-30 16:49:38 +0200
From: @hannesmuehleisen

*** This bug has been marked as a duplicate of bug #3376 ***