hi Lefteris, i have submitted this

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

i believe this bug is related, and has been submitted to bugzilla here already--

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


thanks!!!!


On Mon, Sep 30, 2013 at 8:48 AM, Lefteris <lsidir@gmail.com> wrote:
Hi,

yes if this is something that can be reproduced, then a bug report
would be helpful!

thank you,

lefteris

On Sun, Sep 29, 2013 at 10:44 PM, Anthony Damico <ajdamico@gmail.com> wrote:
> 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
>>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list