Skip to content

Instantly share code, notes, and snippets.

@iperdomo
Last active August 29, 2015 14:24
Show Gist options
  • Save iperdomo/20c2c3942e4c92fcd62b to your computer and use it in GitHub Desktop.
Save iperdomo/20c2c3942e4c92fcd62b to your computer and use it in GitHub Desktop.
CartoDB troubleshooting
=== DataImport["a0c970a2-b932-42d1-ac02-0d923c3d72e1"].log.entries
2015-07-07 09:53:22 UTC: Running on server cartodb.akvotest.org with PID: 25427
2015-07-07 09:53:22 UTC: new_importer()
2015-07-07 09:53:22 UTC: Fetching datasource public_url metadata for item id /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: File will be downloaded from /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Before importer run
2015-07-07 09:53:22 UTC: Starting import for /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Unpacking /home/cartodb/cartodb/public/uploads/0ab2cc5e5d4b0b72af5a/RAW_DATA-108172492.xls
2015-07-07 09:53:22 UTC: Filename: /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.xls Size (bytes): 273920
2015-07-07 09:53:22 UTC: Importing data from /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.xls
2015-07-07 09:53:22 UTC: File-based import load
2015-07-07 09:53:22 UTC: Converting XLS to CSV
2015-07-07 09:53:22 UTC: Orig file: /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.xls
Temp destination: /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.csv
2015-07-07 09:53:22 UTC: Errored importing data from /tmp/imports/20150707-25427-wlx3ax/raw_data-108172492.xls:
2015-07-07 09:53:22 UTC: NoMethodError: undefined method `close' for 0:Fixnum
2015-07-07 09:53:22 UTC: ----------------------------------------------------
2015-07-07 09:53:22 UTC: ["/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/csv.rb:1381:in `ensure in parse'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/csv.rb:1381:in `parse'"
"/home/cartodb/cartodb/services/importer/lib/importer/csv_normalizer.rb:178:in `single_column?'"
"/home/cartodb/cartodb/services/importer/lib/importer/csv_normalizer.rb:174:in `needs_normalization?'"
"/home/cartodb/cartodb/services/importer/lib/importer/csv_normalizer.rb:47:in `run'"
"/home/cartodb/cartodb/services/importer/lib/importer/excel2csv.rb:34:in `run'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:117:in `block (2 levels) in normalize'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:110:in `block in normalize'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:107:in `each'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:107:in `inject'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:107:in `normalize'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:55:in `block (2 levels) in run'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:54:in `block in run'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/loader.rb:50:in `run'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:226:in `file_based_loader_run'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:181:in `import'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:259:in `block (3 levels) in single_resource_import'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:252:in `each'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:252:in `block (2 levels) in single_resource_import'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:251:in `block in single_resource_import'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:230:in `single_resource_import'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:95:in `run_import'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:88:in `block in run'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:33:in `block in timing'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/statsd-client-0.0.7/lib/statsd.rb:26:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/importer_stats.rb:31:in `timing'"
"/home/cartodb/cartodb/services/importer/lib/importer/runner.rb:87:in `run'"
"/home/cartodb/cartodb/app/connectors/importer.rb:39:in `run'"
"/home/cartodb/cartodb/app/models/data_import.rb:599:in `new_importer'"
"/home/cartodb/cartodb/app/models/data_import.rb:342:in `dispatch'"
"/home/cartodb/cartodb/app/models/data_import.rb:159:in `run_import!'"
"/home/cartodb/cartodb/lib/resque/importer_jobs.rb:9:in `block in perform'"
"/home/cartodb/cartodb/lib/resque/base_job.rb:21:in `call'"
"/home/cartodb/cartodb/lib/resque/base_job.rb:21:in `run_action'"
"/home/cartodb/cartodb/lib/resque/importer_jobs.rb:9:in `perform'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/job.rb:240:in `block (3 levels) in perform'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-metrics-0.1.1/lib/resque/metrics.rb:353:in `around_perform_metrics'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/job.rb:239:in `block (2 levels) in perform'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/job.rb:247:in `call'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/job.rb:247:in `perform'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:250:in `perform'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:189:in `block in work'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:166:in `loop'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/worker.rb:166:in `work'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/gems/1.9.1/gems/resque-1.25.2/lib/resque/tasks.rb:41:in `block (2 levels) in <top (required)>'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:205:in `call'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:205:in `block in execute'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:200:in `each'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:200:in `execute'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:158:in `block in invoke_with_call_chain'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:151:in `invoke_with_call_chain'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/task.rb:144:in `invoke'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:116:in `invoke_task'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:94:in `block (2 levels) in top_level'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:94:in `each'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:94:in `block in top_level'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:88:in `top_level'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:66:in `block in run'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/lib/ruby/1.9.1/rake/application.rb:63:in `run'"
"/home/cartodb/.rbenv/versions/1.9.3-p551/bin/rake:32:in `<main>'"]
2015-07-07 09:53:22 UTC: ----------------------------------------------------
2015-07-07 09:53:22 UTC: Proceeding to register
2015-07-07 09:53:22 UTC: After importer run
2015-07-07 09:53:22 UTC: After dispatch
2015-07-07 09:53:22 UTC: ERROR!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment