my personal laptop has 8gb of ram and 250gb of hard disk space, but i got the same error on our server (which has 64gb of ram) so that seems hard to believe..  i also did not hit this issue in Feb2013-SP3, so i believe the latest version introduced some sort of problem :(  what other diagnostics can i run for you?  should i submit a bug report?


On Sun, Sep 29, 2013 at 3:21 PM, Sjoerd Mullender <sjoerd@monetdb.org> wrote:
It looks like you are running out of memory.  What are the specs of your
system?

On 2013-09-29 19:54, Anthony Damico wrote:
> 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/" )
> source_url(
> "https://raw.github.com/ajdamico/usgsd/master/Censo%20Demografico/download%20and%20import.R"
> , prompt = FALSE , echo = TRUE )
>
> 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
> # Visit http://www.monetdb.org/ for further information
> # Listening for connection requests on mapi:monetdb://127.0.0.1:50011/
> <http://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    <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>
>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>


--
Sjoerd Mullender


_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list