2017-08-01 21:43:53 
2017-08-01 21:43:53 R version 3.4.0 (2017-04-21) -- "You Stupid Darkness"
2017-08-01 21:43:53 Copyright (C) 2017 The R Foundation for Statistical Computing
2017-08-01 21:43:53 Platform: x86_64-w64-mingw32/x64 (64-bit)
2017-08-01 21:43:53 
2017-08-01 21:43:53 R is free software and comes with ABSOLUTELY NO WARRANTY.
2017-08-01 21:43:53 You are welcome to redistribute it under certain conditions.
2017-08-01 21:43:53 Type 'license()' or 'licence()' for distribution details.
2017-08-01 21:43:53 
2017-08-01 21:43:53   Natural language support but running in an English locale
2017-08-01 21:43:53 
2017-08-01 21:43:53 R is a collaborative project with many contributors.
2017-08-01 21:43:53 Type 'contributors()' for more information and
2017-08-01 21:43:53 'citation()' on how to cite R or R packages in publications.
2017-08-01 21:43:53 
2017-08-01 21:43:53 Type 'demo()' for some demos, 'help()' for on-line help, or
2017-08-01 21:43:53 'help.start()' for an HTML browser interface to help.
2017-08-01 21:43:53 Type 'q()' to quit R.
2017-08-01 21:43:53 
2017-08-01 21:43:53 > setwd( Sys.getenv( "RWD" ) )
2017-08-01 21:43:53 > 
2017-08-01 21:43:53 > machine_specific_replacements <- 
2017-08-01 21:43:53 + 	list( 
2017-08-01 21:43:53 + 		
2017-08-01 21:43:53 + 		# replace the folder path on macnix
2017-08-01 21:43:53 + 		c( 'path.expand( \"~\" ) , \"ACS2\"' , paste0( '"' , getwd() , '"' ) ) ,
2017-08-01 21:43:53 + 		
2017-08-01 21:43:53 + 		# change other things in the script to be run
2017-08-01 21:43:53 + 		c( "hello" , "howdy" )
2017-08-01 21:43:53 + 		
2017-08-01 21:43:53 + 	)
2017-08-01 21:43:53 > 
2017-08-01 21:43:53 > source( lodown::syntaxtractor( "acs2" , replacements = machine_specific_replacements , setup_test = "setup" ) , echo = TRUE )
2017-08-01 21:43:55 
2017-08-01 21:43:55 > library(lodown)
2017-08-01 21:43:55 
2017-08-01 21:43:55 > acs_cat <- get_catalog("acs", , output_dir = file.path(path.expand("~"), 
2017-08-01 21:43:55 +     "ACS"))
2017-08-01 21:43:55 building catalog for acs
2017-08-01 21:43:55 
2017-08-01 21:43:57 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2005
2017-08-01 21:43:57 
2017-08-01 21:43:57 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2006
2017-08-01 21:43:57 
2017-08-01 21:43:57 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2007
2017-08-01 21:43:57 
2017-08-01 21:43:57 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2008
2017-08-01 21:43:57 
2017-08-01 21:43:58 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2009
2017-08-01 21:43:58 
2017-08-01 21:43:58 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2010
2017-08-01 21:43:58 
2017-08-01 21:43:58 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2011
2017-08-01 21:43:58 
2017-08-01 21:43:59 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2012
2017-08-01 21:43:59 
2017-08-01 21:43:59 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2013
2017-08-01 21:43:59 
2017-08-01 21:43:59 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2014
2017-08-01 21:43:59 
2017-08-01 21:43:59 loading acs catalog from https://www2.census.gov/programs-surveys/acs/data/pums/2015
2017-08-01 21:43:59 
2017-08-01 21:44:00 
2017-08-01 21:44:00 > lodown("acs", subset(acs_cat, year >= 2011))
2017-08-01 21:44:00 locally downloading acs
2017-08-01 21:44:00 
2017-08-01 21:44:08 'https://www2.census.gov/programs-surveys/acs/data/pums/2011/1-Year/unix_hwy.zip'
2017-08-01 21:44:08 cached in
2017-08-01 21:44:08 'E:/eanthony/r-tmp/acs2/327f56ca4cd0441e1bba5d66bef992b0.Rcache'
2017-08-01 21:44:08 copying to
2017-08-01 21:44:08 'E:\eanthony\r-tmp\acs2\RtmpC81muH\file67868797bd'
2017-08-01 21:44:08 
2017-08-01 21:44:09 'https://www2.census.gov/programs-surveys/acs/data/pums/2011/1-Year/csv_hus.zip'
2017-08-01 21:44:09 cached in
2017-08-01 21:44:09 'E:/eanthony/r-tmp/acs2/6f638a6e242d19ffe23c0516769e8315.Rcache'
2017-08-01 21:44:09 copying to
2017-08-01 21:44:09 'E:\eanthony\r-tmp\acs2\RtmpC81muH\file67868797bd'
2017-08-01 21:44:09 
2017-08-01 22:02:19 'https://www2.census.gov/programs-surveys/acs/data/pums/2011/1-Year/csv_hpr.zip'
2017-08-01 22:02:19 cached in
2017-08-01 22:02:19 'E:/eanthony/r-tmp/acs2/891ce7eb50d03b68467ca238f08a2ac4.Rcache'
2017-08-01 22:02:19 copying to
2017-08-01 22:02:19 'E:\eanthony\r-tmp\acs2\RtmpC81muH\file67868797bd'
2017-08-01 22:02:19 
2017-08-01 22:03:45 note: column name 'type' unacceptable in monetdb.  changing to 'type_'
2017-08-01 22:03:45 
2017-08-01 22:03:45 
2017-08-01 22:03:45 
2017-08-01 22:03:45 lodown is now exiting unexpectedly.
2017-08-01 22:03:45 websites that host publicly-downloadable microdata change often and sometimes those changes cause this software to break.
2017-08-01 22:03:45 if the error call stack below appears to be a hiccup in your internet connection, then please verify your connectivity and retry the download.
2017-08-01 22:03:45 otherwise, please open a new issue at `https://github.com/ajdamico/asdfree/issues` with the contents of this error call stack and also the output of your `sessionInfo()`.
2017-08-01 22:03:45 
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[1]]
2017-08-01 22:03:45 source(lodown::syntaxtractor("acs2", replacements = machine_specific_replacements, 
2017-08-01 22:03:45     setup_test = "setup"), echo = TRUE)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[2]]
2017-08-01 22:03:45 withVisible(eval(ei, envir))
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[3]]
2017-08-01 22:03:45 eval(ei, envir)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[4]]
2017-08-01 22:03:45 eval(ei, envir)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[5]]
2017-08-01 22:03:45 lodown("acs", subset(acs_cat, year >= 2011))
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[6]]
2017-08-01 22:03:45 withCallingHandlers(catalog <- load_fun(data_name = data_name, 
2017-08-01 22:03:45     catalog, ...), error = function(e) {
2017-08-01 22:03:45     if (grepl("cannot allocate vector of size", e)) 
2017-08-01 22:03:45         message(memory_note)
2017-08-01 22:03:45     else if (grepl("parameter must be specified", e)) 
2017-08-01 22:03:45         message(parameter_note)
2017-08-01 22:03:45     else if (grepl("to install", e)) 
2017-08-01 22:03:45         message(installation_note)
2017-08-01 22:03:45     else {
2017-08-01 22:03:45         message(unknown_error_note)
2017-08-01 22:03:45         print(sys.calls())
2017-08-01 22:03:45     }
2017-08-01 22:03:45 })
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[7]]
2017-08-01 22:03:45 load_fun(data_name = data_name, catalog, ...)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[8]]
2017-08-01 22:03:45 DBI::dbSendQuery(db, sql)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[9]]
2017-08-01 22:03:45 DBI::dbSendQuery(db, sql)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[10]]
2017-08-01 22:03:45 .local(conn, statement, ...)
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[11]]
2017-08-01 22:03:45 stop("Unable to execute statement '", statement, "'.\nServer says '", 
2017-08-01 22:03:45     env$message, "'.")
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[12]]
2017-08-01 22:03:45 .handleSimpleError(function (e) 
2017-08-01 22:03:45 {
2017-08-01 22:03:45     if (grepl("cannot allocate vector of size", e)) 
2017-08-01 22:03:45         message(memory_note)
2017-08-01 22:03:45     else if (grepl("parameter must be specified", e)) 
2017-08-01 22:03:45         message(parameter_note)
2017-08-01 22:03:45     else if (grepl("to install", e)) 
2017-08-01 22:03:45         message(installation_note)
2017-08-01 22:03:45     else {
2017-08-01 22:03:45         message(unknown_error_note)
2017-08-01 22:03:45         print(sys.calls())
2017-08-01 22:03:45     }
2017-08-01 22:03:45 }, "Unable to execute statement 'CREATE TABLE h (rt STRING, serialno DOUBLE PRECISION, division DOUBLE PRECISION, puma DOUBLE PRECISI...'.\nServer says 'ParseException:SQLparser:42S01!CREATE TABLE: name 'h' already in use'.", 
2017-08-01 22:03:45     quote(.local(conn, statement, ...)))
2017-08-01 22:03:45 
2017-08-01 22:03:45 [[13]]
2017-08-01 22:03:45 h(simpleError(msg, call))
2017-08-01 22:03:45 
2017-08-01 22:03:45 Error in .local(conn, statement, ...) : 
2017-08-01 22:03:45   Unable to execute statement 'CREATE TABLE h (rt STRING, serialno DOUBLE PRECISION, division DOUBLE PRECISION, puma DOUBLE PRECISI...'.
2017-08-01 22:03:45 Server says 'ParseException:SQLparser:42S01!CREATE TABLE: name 'h' already in use'.
2017-08-01 22:03:45 Calls: source ... withCallingHandlers -> load_fun -> <Anonymous> -> <Anonymous> -> .local
2017-08-01 22:03:45 Execution halted