{"action":"created","issue":{"url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/422","repository_url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project","labels_url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/422/labels{/name}","comments_url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/422/comments","events_url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/422/events","html_url":"https://github.com/ga-wdi-boston/full-stack-project/issues/422","id":180721880,"number":422,"title":"[heroku] Not seeding my CSV file?","user":{"login":"tuckyeah","id":8702511,"avatar_url":"https://avatars.githubusercontent.com/u/8702511?v=3","gravatar_id":"","url":"https://api.github.com/users/tuckyeah","html_url":"https://github.com/tuckyeah","followers_url":"https://api.github.com/users/tuckyeah/followers","following_url":"https://api.github.com/users/tuckyeah/following{/other_user}","gists_url":"https://api.github.com/users/tuckyeah/gists{/gist_id}","starred_url":"https://api.github.com/users/tuckyeah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tuckyeah/subscriptions","organizations_url":"https://api.github.com/users/tuckyeah/orgs","repos_url":"https://api.github.com/users/tuckyeah/repos","events_url":"https://api.github.com/users/tuckyeah/events{/privacy}","received_events_url":"https://api.github.com/users/tuckyeah/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-03T19:14:49Z","updated_at":"2016-10-03T19:37:42Z","closed_at":null,"body":"So I have a large CSV file with all my Jeopardy questions in it (approx 200,000 lines long or so).\r\n\r\nI've got Heroku deployed, but when I try to run heroku run rake db:seed, it runs for awhile successfully (usually about 35-40 minutes or so)... but then it errors out saying something like:\r\n\r\n```\r\n  SQL (41.2ms)  INSERT INTO \"clues\" (\"question\", \"answer\", \"value\", \"category_id\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4, $5, $6) RETURNING \"id\"  [[\"question\", \"Aerosmith: \\\"Don't want to close my eyes, I don't want to fall asleep 'cause I'll miss you baby...\\\"\"], [\"answer\", \"\\\"I Don't Want To Miss A Thing\\\"\"], [\"value\", 400], [\"category_id\", 1510], [\"created_at\", \"2016-10-03 19:08:46.432611\"], [\"updated_at\", \"2016-10-03 19:08:46.432611\"]]\r\n   (1.6ms)  ROLLBACK\r\nrake aborted!\r\nSignalException: SIGTERM\r\n```\r\n\r\nThis is the second time this has happened - I'm not sure if it's happening at the exact same clue each time (I'll do that next) but in the interest of saving time, I thought I'd open an issue in case there was something else that's going on. \r\n\r\nThe full output, for what it's worth, looks like this:\r\n```\r\n  (0.7ms)  BEGIN\r\n  SQL (41.2ms)  INSERT INTO \"clues\" (\"question\", \"answer\", \"value\", \"category_id\", \"created_at\", \"updated_at\") VALUES ($1, $2, $3, $4, $5, $6) RETURNING \"id\"  [[\"question\", \"Aerosmith: \\\"Don't want to close my eyes, I don't want to fall asleep 'cause I'll miss you baby...\\\"\"], [\"answer\", \"\\\"I Don't Want To Miss A Thing\\\"\"], [\"value\", 400], [\"category_id\", 1510], [\"created_at\", \"2016-10-03 19:08:46.432611\"], [\"updated_at\", \"2016-10-03 19:08:46.432611\"]]\r\n   (1.6ms)  ROLLBACK\r\nrake aborted!\r\nSignalException: SIGTERM\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:602:in `exec_prepared'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:602:in `block in exec_cache'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:601:in `exec_cache'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:585:in `execute_and_clear'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:192:in `exec_insert'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/database_statements.rb:108:in `insert'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/relation.rb:64:in `insert'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:524:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/counter_cache.rb:139:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/locking/optimistic.rb:75:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attribute_methods/dirty.rb:133:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/callbacks.rb:306:in `block in _create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:88:in `__run_callbacks__'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:778:in `_run_create_callbacks'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/callbacks.rb:306:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/timestamp.rb:57:in `_create_record'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:504:in `create_or_update'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/callbacks.rb:302:in `block in create_or_update'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:117:in `call'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:505:in `call'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:92:in `__run_callbacks__'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:778:in `_run_save_callbacks'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/callbacks.rb:302:in `create_or_update'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:120:in `save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/validations.rb:37:in `save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/attribute_methods/dirty.rb:21:in `save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:286:in `block (2 levels) in save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:351:in `block in with_transaction_returning_status'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:220:in `transaction'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:348:in `with_transaction_returning_status'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:286:in `block in save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:301:in `rollback_active_record_state!'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/transactions.rb:285:in `save'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:34:in `create'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:31:in `block in create'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:31:in `collect'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/persistence.rb:31:in `create'\r\n/app/db/seeds.rb:41:in `block in populate_categories'\r\n/app/db/seeds.rb:37:in `each'\r\n/app/db/seeds.rb:37:in `populate_categories'\r\n/app/db/seeds.rb:50:in `<top (required)>'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:268:in `load'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:268:in `block in load'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:268:in `load'\r\n/app/vendor/bundle/ruby/2.3.0/gems/railties-4.2.7.1/lib/rails/engine.rb:547:in `load_seed'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/tasks/database_tasks.rb:251:in `load_seed'\r\n/app/vendor/bundle/ruby/2.3.0/gems/activerecord-4.2.7.1/lib/active_record/railties/databases.rake:183:in `block (2 levels) in <top (required)>'\r\n/app/vendor/bundle/ruby/2.3.0/gems/rake-11.2.2/exe/rake:27:in `<top (required)>'\r\nTasks: TOP => db:seed\r\n(See full trace by running task with --trace)\r\n```\r\n\r\nThank you!"},"comment":{"url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/comments/251204301","html_url":"https://github.com/ga-wdi-boston/full-stack-project/issues/422#issuecomment-251204301","issue_url":"https://api.github.com/repos/ga-wdi-boston/full-stack-project/issues/422","id":251204301,"user":{"login":"payne-chris-r","id":12667121,"avatar_url":"https://avatars.githubusercontent.com/u/12667121?v=3","gravatar_id":"","url":"https://api.github.com/users/payne-chris-r","html_url":"https://github.com/payne-chris-r","followers_url":"https://api.github.com/users/payne-chris-r/followers","following_url":"https://api.github.com/users/payne-chris-r/following{/other_user}","gists_url":"https://api.github.com/users/payne-chris-r/gists{/gist_id}","starred_url":"https://api.github.com/users/payne-chris-r/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/payne-chris-r/subscriptions","organizations_url":"https://api.github.com/users/payne-chris-r/orgs","repos_url":"https://api.github.com/users/payne-chris-r/repos","events_url":"https://api.github.com/users/payne-chris-r/events{/privacy}","received_events_url":"https://api.github.com/users/payne-chris-r/received_events","type":"User","site_admin":false},"created_at":"2016-10-03T19:37:41Z","updated_at":"2016-10-03T19:37:41Z","body":"Tucker is going to try uploading a csv with only 5 questions/clues but that still includes the one that it barfed on (Aerosmith's timeless classic, `I don't wanna miss a thing` from the Pearl Harbor soundtrack)."}}
{"actor":{"display_login":"payne-chris-r"}}