Skip to content

Missing url in geo_nodes table prevents Sidekiq from booting

17:02:13 rails-background-jobs.1 | 2017-12-02T01:02:13.217Z 84659 TID-owiu5u6lo INFO: Cron Jobs - add job with name: stuck_merge_jobs_worker
17:02:13 postgresql.1            | ERROR:  column geo_nodes.url does not exist at character 46
17:02:13 postgresql.1            | STATEMENT:  SELECT  "geo_nodes".* FROM "geo_nodes" WHERE "geo_nodes"."url" = 'http://localhost:3001/' LIMIT 1
17:02:13 rails-background-jobs.1 | PG::UndefinedColumn: ERROR:  column geo_nodes.url does not exist
17:02:13 rails-background-jobs.1 | LINE 1: SELECT  "geo_nodes".* FROM "geo_nodes" WHERE "geo_nodes"."ur...
17:02:13 rails-background-jobs.1 |                                                      ^
17:02:13 rails-background-jobs.1 | : SELECT  "geo_nodes".* FROM "geo_nodes" WHERE "geo_nodes"."url" = 'http://localhost:3001/' LIMIT 1
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in `async_exec'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/peek-pg-1.3.0/lib/peek/views/pg.rb:17:in `async_exec'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:478:in `log'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:356:in `select'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/querying.rb:39:in `find_by_sql'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation.rb:639:in `exec_queries'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation.rb:515:in `load'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation.rb:243:in `to_a'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation/finder_methods.rb:475:in `find_take'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation/finder_methods.rb:105:in `take'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/relation/finder_methods.rb:84:in `find_by'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/querying.rb:7:in `find_by'
17:02:13 rails-background-jobs.1 | /Users/stanhu/.rbenv/versions/2.3.5/lib/ruby/gems/2.3.0/gems/activerecord-4.2.8/lib/active_record/core.rb:173:in `find_by'
17:02:13 rails-background-jobs.1 | /Users/stanhu/gitlab/gdk-ee/gitlab/app/models/geo_node.rb:57:in `current_node'
17:02:13 rails-background-jobs.1 | /Users/stanhu/gitlab/gdk-ee/gitlab/lib/gitlab/geo.rb:21:in `block in current_node'
17:02:13 rails-background-jobs.1 | /Users/stanhu/gitlab/gdk-ee/gitlab/lib/gitlab/geo.rb:129:in `cache_value'
17:02:13 rails-background-jobs.1 | /Users/stanhu/gitlab/gdk-ee/gitlab/lib/gitlab/geo.rb:21:in `current_node'
17:02:13 rails-background-jobs.1 | /Users/stanhu/gitlab/gdk-ee/gitlab/lib/gitlab/geo.rb:45:in `secondary?'
<snip>
17:02:13 rails-background-jobs.1 | exited with code 1
17:02:13 system                  | sending SIGTERM to all processes

In my GDK, I had to run ./run db, run the migrations, and then my GDK was able to come up.

/cc: @nick.thomas