Bootstrap Container Hangs on su discourse -c ‘bundle exec rake db:migrate’

Neo · February 11, 2021, 12:07pm

We are currently running this recent release:

It's still running in our production container (no issues).

I'm trying to bootstrap based on this release:

I've tried a number of times today, and each time it hangs here:

Checked the logs in the data and the standby app container (we are bootstrapping) and there are no errors, no issues.

Each time I bootstrap, it hangs on this line:

I, [2021-02-11T10:37:25.133098 #1]  INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate'

Any clues where to look to help debug this?

I've looked in all the logs I can think of (in all containers) and cannot find problems.

Thanks.

Additional Info:

Each time it hangs and I control C out of the bootstrap process, it seems to leave a postmaster process, which I can subsequently kill.

Here is an example:

Update:

Bootstrap rebuilds fine if I comment out the "db:migrate" line in the web template.

There is some strange issue with "rails db:migrate" hanging with zero errors I have never experienced before.

I wonder if there is an error (or some underlying issue) in this recent migration?

discourse/discourse/blob/f5b18e2a311abf503b21d996031d38286e71f74a/db/migrate/20210208022738_move_new_since_to_new_table.rb

# frozen_string_literal: true

class MoveNewSinceToNewTable < ActiveRecord::Migration[6.0]
  def up
    sql = <<~SQL
      INSERT INTO dismissed_topic_users (user_id, topic_id, created_at)
      SELECT users.id, topics.id, user_stats.new_since
      FROM user_stats
      JOIN users ON users.id = user_stats.user_id
      JOIN user_options ON user_options.user_id = users.id
      LEFT JOIN topics ON topics.created_at <= user_stats.new_since
      LEFT JOIN topic_users ON topics.id = topic_users.topic_id AND users.id = topic_users.user_id
      LEFT JOIN dismissed_topic_users ON dismissed_topic_users.topic_id = topics.id AND users.id = dismissed_topic_users.user_id
      WHERE user_stats.new_since IS NOT NULL
      AND topic_users.id IS NULL
      AND dismissed_topic_users.id IS NULL
      AND topics.archetype <> :private_message
      AND topics.created_at >= GREATEST(CASE
                  WHEN COALESCE(user_options.new_topic_duration_minutes, :default_duration) = :always THEN users.created_at
                  WHEN COALESCE(user_options.new_topic_duration_minutes, :default_duration) = :last_visit THEN COALESCE(users.previous_visit_at,users.created_at)

This file has been truncated. show original

Neo · February 11, 2021, 2:08pm

Just in case my bug report "disappears" (as they often do) over at meta....