Re: if i run these commands in R, mserver dies.. any ideas how to fix? thanks

DB looks corrupted. I would recreate it and see whether that fixes the issue. 

> On 21 Sep 2015, at 18:01, Anthony Damico  wrote:
> 
> # MonetDB 5 server v11.21.3 "Jul2015"
> # Serving database 'marketscan', using 4 threads
> # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked
> # Found 64.000 GiB available main-memory.
> # Copyright (c) 1993-July 2008 CWI.
> # Copyright (c) August 2008-2015 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:49700/
> # Start processing logs sql/sql_logs version 52200
> # Start reading the write-ahead log 'sql_logs\sql\log.211'
> # Finished reading the write-ahead log 'sql_logs\sql\log.211'
> !ERROR: log_sequence_: write failed
> # Finished processing logs sql/sql_logs
> # MonetDB/SQL module loaded
> >
> 
> 
> =========================
> 
> > pid <- monetdb.server.start( batfile )
> > dbname <- "marketscan"
> > dbport <- 49700
> > monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname )
> > db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
> Server not ready(cannot open the connection), retrying (ESC or CTRL+C to abort)
> > dbListTables(db)
> Error in .local(conn, statement, ...) : 
>   Unable to execute statement 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=sc...'.
> Server says 'ERROR: BBPdir_subcommit: Syncing BBP.dir file failed' [#GDKerror:].
> > dbListTables(db)
> Error in .local(conn, statement, ...) : 
>   Unable to execute statement 'select schemas.name as sn, tables.name as tn from sys.tables join sys.schemas on tables.schema_id=sc...'.
> Server says 'ERROR: GDKsave: error on: name=06\651, ext=timprints, mode=0' [#GDKerror:].
> > dbListTables(db)
>  [1] "ccaea"              "ccaed"              "ccaef"              "ccaei"              "ccaeo"             
>  [6] "ccaep"              "ccaes"              "ccaet"              "redbook"            "state"             
> [11] "wgt"                "ccaea_st_wt"        "ccaet_st_wt"        "ccaes_monthly"      "ccaes_annual"      
> [16] "ccaeo_monthly"      "ccaeo_annual"       "ccaed_monthly"      "ccaed_annual"       "ccaes_admmon_xwalk"
> [21] "ccaes_monthly_wxw"  "ccaed_svcmon_xwalk" "ccaed_monthly_wxw"  "ccaeo_svcmon_xwalk" "ccaeo_monthly_wxw" 
> [26] "acons_pre"          "mcons_pre"          "ccs"                "acons_diag"         "mcons_diag"        
> [31] "readm"              "acons_readm"        "mcons_readm"        "mcons"              "acons"             
> > 
> > 
> > # create a temporary person-year table
> > dbSendQuery( 
> + db , 
> + 'CREATE TABLE temp AS 
> + SELECT 
> + datatyp , 
> + yr , 
> + enrolid ,
> + SUM( wgt ) AS sum_wgt ,
> + SUM( CAST( ( rx_pay ) > 250 AS INTEGER ) ) AS rx_pay_above_250 ,
> + SUM( CAST( ( rx_copay + rx_coins + rx_deduct ) > 250 AS INTEGER ) ) AS rx_copay_coins_deduct_above_250
> + FROM
> + mcons
> + WHERE
> + datatyp = 1
> + GROUP BY
> + datatyp , yr , enrolid
> + ORDER BY
> + datatyp , yr , enrolid
> + WITH DATA' 
> + )
> Error in readBin(con, "integer", n = 1, size = 2, signed = FALSE, endian = "little") : 
>   error reading from the connection
> > 
> 
> # # # # mserver is dead
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list