ajc113 / currents

Currents Fishing Network Application
3 stars 3 forks source link

IntelsController#spotter (ActiveRecord::StatementInvalid) "PG::UndefinedTable: ERROR: relation "intels" does not exist LINE 5: WHERE a.attrelid = '"intels"'::regclass ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"intels"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum " #179

Closed ajc113 closed 6 years ago

ajc113 commented 6 years ago
ExceptionPG::UndefinedTable: ERROR: relation "intels" does not exist LINE 5: WHERE a.attrelid = '"intels"'::regclass ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = '"intels"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum
Last OccurrenceJanuary 29, 2018 23:37:27 +0000
Count1

Stack Trace

[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql_adapter.rb:733:in `column_definitions'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/postgresql/schema_statements.rb:197:in `columns'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/schema_cache.rb:43:in `columns'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:93:in `columns'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/cache.rb:37:in `columns'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/attributes.rb:98:in `columns_hash'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/delegation.rb:48:in `columns_hash'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:1067:in `block in arel_columns'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:1066:in `map'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:1066:in `arel_columns'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:1059:in `build_select'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:878:in `build_arel'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation/query_methods.rb:858:in `arel'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/relation.rb:548:in `to_sql'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/collection.rb:129:in `block in safe_to_sql'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract_adapter.rb:173:in `unprepared_statement'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/collection.rb:129:in `safe_to_sql'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/collection.rb:141:in `generate_tagging_scope_in_clause'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/collection.rb:120:in `all_tag_counts'
[bundle].../gems/acts-as-taggable-on-4.0.0/lib/acts_as_taggable_on/taggable/collection.rb:37:in `tag_counts_on'
[app].../app/controllers/intels_controller.rb:69:in `spotter'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
[bundle].../gems/actionpack-4.2.7.1/lib/abstract_controller/base.rb:198:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/rendering.rb:10:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:117:in `call'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:505:in `call'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:92:in `__run_callbacks__'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:778:in `_run_process_action_callbacks'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:81:in `run_callbacks'
[bundle].../gems/actionpack-4.2.7.1/lib/abstract_controller/callbacks.rb:19:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/rescue.rb:29:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/notifications.rb:164:in `block in instrument'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/notifications.rb:164:in `instrument'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/params_wrapper.rb:250:in `process_action'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
[bundle].../gems/actionpack-4.2.7.1/lib/abstract_controller/base.rb:137:in `process'
[bundle].../gems/actionview-4.2.7.1/lib/action_view/rendering.rb:30:in `process'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal.rb:196:in `dispatch'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal/rack_delegation.rb:13:in `dispatch'
[bundle].../gems/actionpack-4.2.7.1/lib/action_controller/metal.rb:237:in `block in action'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/routing/route_set.rb:74:in `dispatch'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/routing/route_set.rb:43:in `serve'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/journey/router.rb:43:in `block in serve'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/journey/router.rb:30:in `each'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/journey/router.rb:30:in `serve'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/routing/route_set.rb:817:in `call'
[bundle].../gems/party_foul-1.5.5/lib/party_foul/middleware.rb:8:in `call'
[bundle].../gems/warden-1.2.7/lib/warden/manager.rb:36:in `block in call'
[bundle].../gems/warden-1.2.7/lib/warden/manager.rb:35:in `catch'
[bundle].../gems/warden-1.2.7/lib/warden/manager.rb:35:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/etag.rb:24:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/conditionalget.rb:25:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/head.rb:13:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/params_parser.rb:27:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/flash.rb:260:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/session/abstract/id.rb:225:in `context'
[bundle].../gems/rack-1.6.8/lib/rack/session/abstract/id.rb:220:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/cookies.rb:560:in `call'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/query_cache.rb:36:in `call'
[bundle].../gems/activerecord-4.2.7.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:653:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:88:in `__run_callbacks__'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:778:in `_run_call_callbacks'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/callbacks.rb:81:in `run_callbacks'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/remote_ip.rb:78:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
[bundle].../gems/railties-4.2.7.1/lib/rails/rack/logger.rb:38:in `call_app'
[bundle].../gems/railties-4.2.7.1/lib/rails/rack/logger.rb:20:in `block in call'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/tagged_logging.rb:68:in `block in tagged'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/tagged_logging.rb:26:in `tagged'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/tagged_logging.rb:68:in `tagged'
[bundle].../gems/railties-4.2.7.1/lib/rails/rack/logger.rb:20:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/request_id.rb:21:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/methodoverride.rb:22:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/runtime.rb:18:in `call'
[bundle].../gems/activesupport-4.2.7.1/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'
[bundle].../gems/rack-cache-1.7.1/lib/rack/cache/context.rb:140:in `forward'
[bundle].../gems/rack-cache-1.7.1/lib/rack/cache/context.rb:249:in `fetch'
[bundle].../gems/rack-cache-1.7.1/lib/rack/cache/context.rb:189:in `lookup'
[bundle].../gems/rack-cache-1.7.1/lib/rack/cache/context.rb:66:in `call!'
[bundle].../gems/rack-cache-1.7.1/lib/rack/cache/context.rb:51:in `call'
[bundle].../gems/actionpack-4.2.7.1/lib/action_dispatch/middleware/static.rb:120:in `call'
[bundle].../gems/rack-1.6.8/lib/rack/sendfile.rb:113:in `call'
[bundle].../gems/railties-4.2.7.1/lib/rails/engine.rb:518:in `call'
[bundle].../gems/railties-4.2.7.1/lib/rails/application.rb:165:in `call'
[bundle].../gems/puma-3.11.2/lib/puma/configuration.rb:225:in `call'
[bundle].../gems/puma-3.11.2/lib/puma/server.rb:624:in `handle_request'
[bundle].../gems/puma-3.11.2/lib/puma/server.rb:438:in `process_client'
[bundle].../gems/puma-3.11.2/lib/puma/server.rb:302:in `block in run'
[bundle].../gems/puma-3.11.2/lib/puma/thread_pool.rb:120:in `block in spawn_thread'

Fingerprint: 0a6b45553e5dd7a5d04b1157212be7aec67fb1fb

ajc113 commented 6 years ago

@rultor deploy

rultor commented 6 years ago

@rultor deploy

@ajc113 OK, I'll try to deploy now. You can check the progress here

rultor commented 6 years ago

@rultor deploy

@ajc113 Oops, I failed. You can see the full log here (spent 24min)

     \u001b[31m  \u001b[0m\u001b[32m+            MyText\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          <!-- Post footer author and comment count -->\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+        </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+    </div>  \u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+    <!-- </section> -->\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+    <div class="col-lg-3 col-md-3 posts-sidebar">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      <!-- Search-->\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      <div class="panel widget bg-inverse-light">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+        <div class="panel-body">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+            <strong>Search Spots</strong><br>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+            <form class="form-horizontal">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <form action="/spots" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="&#x2713;" />\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <p><input type="text" name="q" id="q" class="form-control" /></p>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <input type="submit" value="Search" class="mb-sm btn btn-inverse btn-outline" />\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+</form>            </form>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+        </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          <!-- Categories-->\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      <div class="panel widget bg-inverse-light">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+        <div class="panel-body">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          <div class="text-md m0">\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+            <strong style="text-decoration: underline;">Fishing Locations</strong><br>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+            <ul class="list-unstyled" >\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                <li><a style="color: #FFFFFF" href="/ma_inshore">MA Inshore</a></li>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <li><a style="color: #FFFFFF" href="/gulf_of_maine">Gulf of Maine</a></li>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <li><a style="color: #FFFFFF" href="/south_of_vineyard">South of Vineyard</a></li>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+                  <li><a style="color: #FFFFFF" href="/east_of_chatham">East of Chatham</a></li>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+            </ul>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+        </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+      </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+          \u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+    </div> \u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+  </div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[32m+</div>\u001b[0m
     \u001b[31m  \u001b[0m\u001b[0m
     \u001b[36m# ./spec/views/spots/show.html.erb_spec.rb:16:in `block (2 levels) in <top (required)>'\u001b[0m

Finished in 53.72 seconds (files took 17.09 seconds to load)
\u001b[31m160 examples, 6 failures, 36 pending\u001b[0m

Failed examples:

\u001b[31mrspec ./spec/requests/intels_spec.rb:5\u001b[0m \u001b[36m# Intels GET /intels works! (now write some real specs)\u001b[0m
\u001b[31mrspec ./spec/views/intels/index.html.erb_spec.rb:17\u001b[0m \u001b[36m# intels/index renders a list of intels\u001b[0m
\u001b[31mrspec ./spec/controllers/intels_controller_spec.rb:61\u001b[0m \u001b[36m# IntelsController GET #new returns a success response\u001b[0m
\u001b[31mrspec ./spec/views/spots/index.html.erb_spec.rb:19\u001b[0m \u001b[36m# spots/index renders a list of spots\u001b[0m
\u001b[31mrspec ./spec/controllers/spots_controller_spec.rb:61\u001b[0m \u001b[36m# SpotsController GET #new returns a success response\u001b[0m
\u001b[31mrspec ./spec/views/spots/show.html.erb_spec.rb:12\u001b[0m \u001b[36m# spots/show renders attributes in <p>\u001b[0m

Randomized with seed 10920

Coverage report generated for RSpec to /home/r/repo/coverage. 714 / 1432 LOC (49.86%) covered.
/usr/local/rvm/rubies/ruby-2.3.4/bin/ruby -I/usr/local/rvm/gems/ruby-2.3.4/gems/rspec-core-3.6.0/lib:/usr/local/rvm/gems/ruby-2.3.4/gems/rspec-support-3.6.0/lib /usr/local/rvm/gems/ruby-2.3.4/gems/rspec-core-3.6.0/exe/rspec --pattern spec/\*\*\{,/\*/\*\*\}/\*_spec.rb failed
container a041e3ab93654fa120c7e46c4ce1e85ec3f2496e2ebfd7d2b8d4aaabb40a661d is dead
Mon Feb  5 20:19:03 CET 2018
ajc113 commented 6 years ago

@rultor deploy

rultor commented 6 years ago

@rultor deploy

@ajc113 OK, I'll try to deploy now. You can check the progress here

rultor commented 6 years ago

@rultor deploy

@ajc113 Done! FYI, the full log is here (took me 29min)