if you run this R code (with MonetDB.R), you will automatically load a series of brazilian census bureau data sets onto your computer. after all tables have been downloaded and imported, the R script will run a very simple CREATE TABLE command that will cause mserver to shut down when it should not.
library(downloader)
setwd( "C:/My Directory/CENSO/" )
after mserver.exe crashes, even if i re-load mserver.exe manually and then connect to it with mclient.exe, and run this block of code:
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;
the exact same crash occurs, so this is a new mserver.exe bug not a MonetDB.R bug.
should i file a bug report?
thanks!!!
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
# 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 <DIR> .
09/06/2013 04:34 PM <DIR> ..
09/27/2013 12:27 PM <DIR> MonetDB5
0 File(s) 0 bytes
3 Dir(s) 451,568,218,112 bytes free
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>